Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. martinrobson

    2 linked combo boxes, how do i reset the values in the second one?

    Thanks PaulF, I tried that but unfortunately it hasnt worked here is the code im using. Private Sub COMBO1_AfterUpdate() Dim Db as DAO.Database Dim qdf as DAO.QueryDef Set db = CurrentDb() Set qdf = db.QueryDefs("query1") Dim StrSQL as String Select Case COMBO1 Case Is...
  2. martinrobson

    2 linked combo boxes, how do i reset the values in the second one?

    Hi, I have 2 combo boxes, the second one displays the correct data, depending on what is selected in the first one. The problem is that if i click on one value in box 1, then box 2 shows the correct data, but if i then decided to change my mind about what i chose in box 1 and change the value...
  3. martinrobson

    List box doesnt display the selected data.

    Got it almost working now, i now have an error message when it gets to the DoCmd.OpenQuery "qryCampaignSelect". Saying that Run-time error '2501', The OpenForm action was cancelled. Anyone have any ideas, this is annoying because this worked fine a week ago, very weird.
  4. martinrobson

    List box selection problem.

    Hi, Thanks for the reply, i am having major problems with this listbox. It is displaying data from 5 tables and has the primary keys and foreign keys from each one on the list. One thing you said is that i can make columns invisible, how do i do this? Thanks
  5. martinrobson

    List box doesnt display the selected data.

    Hi, I have a listbox which is used as the first form in my vba application to display all the records that have been entered. I would like to build in some functionality which allows me to edit a specific record, so would like to be able to diplay a specific record in a new form. For some...
  6. martinrobson

    List box selection problem.

    Hello, I have a list box, which has 8 columns in which there are 5 unique id entries. Is it possible to add another column to the listbox, so that i can have a unique value for each entry in the listbox. The problem is that at the moment none of the id's are completely unique. Something as...
  7. martinrobson

    2 forms with 1 common text field, cant get form 2 to save data.

    Thanks guys, turns out that it was because the form was trying to add more data to the x_id table as well as the y_id table, which meant that it was trying to add another x_id to the table when there was allready one, and it is a unique
  8. martinrobson

    sql delete from 5 linked tables

    hi, could someone point me in the right direction. I have an sql statement which i would like to use to delete a selection from a dropdown vb list. The SQL i am using is DELETE FROM tablename A, tablename B, tablename C, tablename D, tablename E where A.ID = B.ID and B_ID = C_ID and C_ID =...
  9. martinrobson

    2 forms with 1 common text field, cant get form 2 to save data.

    Hi, Im having a problem with an application. I have a setup were data is added to a database. There are 2 tables in the database, each with unique id's, x_id and y_id they are linked with a foreign key on x_id. I am using 1 form that points to both tables, and this works great. I can add...
  10. martinrobson

    Deleting a Record from a List Box Selection

    Hi, please can you help? I currently have a form which contains a list box, listing all the records in my database tables. I would like to be able to delete a record from the table using the listbox to hughlight it and a delete button to delete it. I have tried a few different methods which i...
  11. martinrobson

    option buttons appear grey when selected rather than a black dot

    Cheers guys. The field is set as a text field and the default value is set to 0 so that when the buttons load they are white rather than grey. If i remove that then they both start grey and are also grey when selected. I do have some code behind the buttons, mainly to change the value entered...
  12. martinrobson

    option buttons appear grey when selected rather than a black dot

    Hi, I have an option button frame with 2 buttons in it. When i select either one, they grey out instead of showing the black dot. Apart from that they work fine. Does anyone have any ideas? Thanks Martin
  13. martinrobson

    How do i edit table data using a form?

    Hi, I am still fairly new to this, hence all the posts. I am trying to alter an existing application which is very messy and isnt helping. Im using Access 97 The problem is this: I would like to ammend data in my tables. I have a form which uses a list box to select the corresponding data...
  14. martinrobson

    Radio/Option Buttons Greyed Out on Form Load

    Hi, I have a form with 2 radio buttons on it. When the form loads the radio buttons are greyed out. I have enabled them and they work fine, but is there anyway of getting them to load transparent/white. I also have a problem when retrieving records for a form with radio buttons. The problem...
  15. martinrobson

    sql update command, will not take use t text box value from form

    Hi, I am trying to get an sql update command to take the value from a textbox and put it into a table. The syntax works if i replace the textbox name with a 1, but for some reason it cant get the value from it. The syntax is similar to: update table set column = textbox_name1 where...
  16. martinrobson

    Can you close more than one form with the DoCmd.close statement?

    Thanks mate thats worked a treat.
  17. martinrobson

    Can you close more than one form with the DoCmd.close statement?

    Hi, I have a strange problem. I have 2 forms. Form 1 contains an id field which i need to display on form 2, so i have to have form 1 open when i access form 2 so that it can reference the id. The problem i have is that some of the data which is entered on form 2 requires the data from...
  18. martinrobson

    copying a field between two forms

    Cheers Graham that worked a treat, fantastic, i can do away with the sql. Thanks again.
  19. martinrobson

    copying a field between two forms

    Hi. Please can someone help? I have 2 forms, i would like an ID from form 1 to be copied across to form 2 when it is opened. The ID is generated by an algorithm. At the moment i have some sql which will search the table to find the last id which was generated and populate the field with...

Part and Inventory Search

Back
Top