Search results

Can anyone help? Thanks, Dave

I want to update a form field to 'No' if a query result is null. Help with the syntax, please? Thanks, Dave

I found this solution via the search feature... it is exactly what I was looking for and it worked flawlessly. Thanks, folks! Dave

We had that problem for three weeks, then learned that there was a problem with our antivirus running behind 2007. We updated the virus software and the problem was resolved. HTH Dave

Not sure why, but I went in to SQL view and tweaked it a little, and it now runs fine :) SQL+ SELECT tblEnrollment.[Name/Type], tblEnrollment.Cred, tblEnrollment.Specialty, tblEnrollment.Address, tblEnrollment.Phone, tblEnrollment.Sem, tblEnrollment.SemDate, tblEnrollment.SemYear...

Then I have something else the matter. That is the syntax I thought woukld work, too...

Getting an undefined function error with that code, too.

I am writing a query using a combo box on an open form as a parameter. the combo box is three fields, name, address, and phone. I am trying to use forms!ParticipantPicker!combo58.col(0) to select the name to use in the query and am getting a syntax error. This reference works to write a...

missinglinq, thank you! again. I used your code again today. It is exactly what I was looking for. Dave

Yup- a typo in my last post :)

Access sets up an IDM temp file when you open a database to prevent anyone else from changing any code while they have it open. It essentially 'locks' the code and protects it. The file is supposed to be deleted as users close the database. It is not doing that here at work- four different...

There are 4 folks having the same problem, all in different DBs- The IDB files will not go away. Can't delete them. Can't rename them. Can't move them. Any ideas? None of us has ever seen this with Access. Thanks, Dave

I am not going to bore you all to death, but this dbase was delivered three weeks ago and there were only happy campers :) The the question is asked- what about people who are not IN the system? So that is where this came up. The app as built has an autonumber field for PID. My answer was to...

Thanks, Bob. As always, it worked perfectly from the very first try. Off to the next war... :)

I have a form that is getting it's record number from a closed table, then adding 1 to it. Now I am trying to increment that table by 1 so I get a new number the next time. I have been fighting with this for a couple of hours. I have gotten several errors with various different tries- The...

I am trying to fill a form field with the largest value, plus 1, from a closed table. I cannot get anything other than a error message. the code in the unbound form field is: max(tables!CustomPID!ID)+1) Help, please? Thanks, Dave

you boys play nice :)

I am using 2007 but have several users using 2003 and a few using 2007. This problem started after I upgraded to 2007. I have only one user with this problem: When she opens the database it takes her to the form she uses most often, bypassing the menu... Is there a new 'hidden' yes/no box for...

I went back and double checked all the names- I deliberately did NOT use the standard frm for these two forms, and started oth names with the word 'choose' so I could keep them separate from similar forms. The form I created and used as the sub-form is listed under the forms as...

Same error message... Here is the entire code for after update: It is selecting the record that matched the choice in combo29 on the main for, closing the previous form, and then moving the focus to combo13 on the sub form... Private Sub Combo29_AfterUpdate() ' Find the record that matches...