Search results

I am having trouble with this very same thing. I have a query called QrycboCounty. I have a form called frmReports. I have a combo box on frmReports called cboCounty. I have a command button on the frmReports from also. I am attempting to pull all relevant data about a particular person based...

Wow! Thanks for all of the advice. I think most of the sloppiness has to do with the fact that I have been up all night and not completely coherent. I usually do better with about sloppiness. It also had a lot of sensitive info that I tried to purge without ruining the idea of what I was...

I got that code from http://support.microsoft.com/kb/304302 the BuildCriteria is a method in VBA. I personally am not that familiar with it. I simply was trying to take the code provided at the site above and modify it to my needs. I have saved the database as a 2003 format file and included it...

Good day all, I have a database with several tables, forms, reports, and queries. I would like to create a form that include a textbox and a command button. What I want to query is all people with the Last Name of (whatever value is in the text box) from the table 'Spotters'. I have included...

Interestingly enough it was not quotes that seem to have made a difference. It was the apostrophe that you suggested. Any clues? Private Sub Login_Click() txtUserName.SetFocus 'Check to see if data is entered into UserName textbox If IsNull(Me.txtUserName) Or Me.txtUserName =...

Thanks for the quick reply! The line that is highlighted is the If Me.txtPassword.Value = DLookup("Passcode", "Users", "[User]=" & Me.txtUserName.Value) Then line. I tried your suggestion and it worked. Just out of curiosity what does the apostrophe do? What I mean is why is the apostrophe...

Good Morning, I have taken some of the code you have posted and tried to use it. I am having an error that is related to the DLookUp value. I have a table called Users. There are 3 columns in the Users table; ID, User, & Passcode. The Login form contains a textbox called...

:D I was finally able to stumble my way through the code posted. I have included my slight differences. Mostly deleting commented out code and added the code to launch explorer and subsequently google earth. Private Sub Command5_Click() 'export data to text file Dim MyDB As Database Dim...