Search results

I found the problem and slapped myself as soon as I saw it. I ended up putting a control source on the combo box in my form (this was the same control source as a text box on the same form) so when it tried to save the record I would get the error. Thanks anyways. (Im so glad there's a forum...

Hey guys (again :o) I've encountered another weird error when applying an append query through a button. Here's the code: Private Sub cmdSaveChanges_Click() On Error GoTo Err_cmdSaveChanges_Click 'Saves the new Inspector information into the information table. 'Adds the two references...

Ah, I figured out what was wrong, the error was very misleading. I forgot to put the quotations in the criteria field. I have another problem though that I've been working on, I have a list box where the user selects a record and clicks on a button which deletes a reference in a table. One...

Ah, your reccomendation for problem 1 worked! thanks :D As for problem 2, even if I open the query by itself from the database window it gives me the same error. I renamed it a few times, all giving the same error too. I then made another delete query and tried it and it gave me the same...

Alright, Problem #1 - Im attempting to append two values into a table when a button is pressed. There are two cases for this, for my first case it works fine. The second case involves choosing a pre-existing record to append into a reference table. Here is the code: DoCmd.RunSQL "INSERT...

Here is basically what I have and what I need to do: I have a form with several text boxes which are going to be filled in. Clicking on a button at the bottom of the form will save this information into a table (the table associated with the form). However, it also needs to fill in a junction...

Thanks alot - it worked! You know, the code that the button generated I mustve tried in a million different ways but it never worked. Sometimes the simplest solution is the best as it was in this case. Thanks Again.

Hey guys - I'm somewhat new to Access and I've been put in charge of developing a user interface for an already established database. Basically - all of the relationships and values are in place. I've already constructed a "Search" form where the user can sort all of the records presented in a...