Search results for query: *

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...

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...

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...

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 =...

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...

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...

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

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...

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...

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...

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...

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...