Recent content by martinrobson

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

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

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.

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

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

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

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

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

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