Search results

Thanks EternalMyrtle and Mihail for the replies! I am in a location with really poor internet access so I will take a look at your suggestions and let you know if I run into any issues. Thank you for your help! Beem

Hi All I have a main and subform related to a training event with trainees. So the main form includes information relating to training date, location, training content etc while the subform contains a list of attendees. The attendees come from a table that contains a list of potential...

Namliam, you're a star! The issue WAS with me accessing the incorrect array element, it seems to be working now. Thanks a million! Beem,

Thanks Namliam, you were right, I had accessed the second array element instead of the first! The SQL code I actually copied and pasted from a query that works perfectly so I am really confused! Thanks for helping me with this, I appreciate the effort. Beem

Thanks Jdraw, yep I fixed the one in the code and not in the msgbox! I appreciate the attempt to help though.

Here we go: Private Sub cboID_Afterupdate() MsgBox "SELECT b01_Participants.* FROM b01_Participants WHERE (((b01_Participants.ParticipantID)= " & cboID.Column(0) & "));" Me.RecordSource = "SELECT b01_Participants.* FROM b01_Participants WHERE (((b01_Participants.ParticipantID)= " &...

Thanks Jdraw, I've corrected that, don't know how I missed it! However, I still get the error about the parentheses.

Hey Namliam, Thanks for replying! I am aware of that, thanks. The ID is a number, autoassigned and accessed from a dropdown. Beem

I'm smiling here, I have counted the parentheses but regardless of which combination I try, I still get an error, even if there are the same number on each side. What am I missing? Beem

Hi All I would like to populate form fields with records from a table/query so that they are bound to the recordsource and the record to be displayed can be selected from a combobox. I am hoping that in this way, any changes made are propagated to the original table. I have created a combobox...

Hi All I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin...

Thanks Nanscombe and Galaxiom, Nanscombe, you were right in that I had to use a list control and it worked fine. I wanted the control to be automatically updated based on the value of another dropdown field and I had read that using a query would be more efficient than Dlookup. Anyway, its...

Thanks Nigel. I am using an unbound textbox, is there any way to stick to this or does it have to be a combobox?

Hi All I am stumped! I have a combobox which looks up and stores the primary key for a school. I have another unbound field into which I have inserted the following SQL code (extracted from a query which works perfectly). SELECT a01_Corridor.CorridorID FROM a01_Corridor INNER JOIN a05_Schools...

Thanks for the reply Rabbie. I am just a little concerned since I can't fathom the reason for this phenomenon. I'll forge ahead and hope for the best! :-) Beem

Thanks for this. It was a brand new table into which I imported the data. Do you think it still makes sense to repeat the process?

Thanks for the tip but I need to import it as it is a ore assigned unique ID that cannot be auto generated.

Hello and thanks for the reply! This is a once-off import so I did it manually using the Excel import functionality instead of going the VBA route. The new value property is set to "Increment" for each of the 3 tables this is happening on. I have verified that the field which contains the...

Hi All I have imported a list from Excel into my database. The primary key is long integer (Indexed no duplicates). After the (successful) import, the next primary key assigned to a new record has jumped from (for example) 15 to 30024455. Why would this be? I have compacted and repaired the...

Thanks Cronk, that helps a lot! I'm starting to "get" it now.