Search results for query: *

Does not help, if you leave out the single qute you get a syntax error. The problem is that this works fine if I leave it as a double click event. It only get an error at the datzipcode.refresh if I try to make it a single click.

Did not help I get and error on the datzipcode refresh

The following is the datbound syntax used to update two text boxes on a form, they are connected to a dbcombo box with a list of zipcodes when the user selects the zipcode the city and state are automatically suppose to update well the do only after the user selects the zipcode and it get placed...

Thank for the help!!

I tried that also and now i am getting a type mismatch error

what is the name of your database? type in dat infront of the name of your database then .recordset.findfirst

If only it was that easy. that did not help it any I still get a syntax error. Thanks for the good observation though.

Are you searching a database? Alittle more info or this might help database.Recordset.FindFirst [field] = "criteria"

I was actually trying to do it with out using ado. If that is possible

this has probably been answered before but, I have a combo box on a form with the zipcode it is populates by a zicode field on a table I want the textbox for the city and state to update based off the zipcode selection. the for is also bound to the database

Still getting the same message.

Still the same problem. Syntax problems give me a headache

I now get an error that I am trying to execute a query that does not include the specified expression apptdate as part of an aggregrate expression

I get a syntax error what am i missing table is contactmanager field to count is apptdates Private Sub apptcheck2() Dim db As Database Dim rs As Recordset Dim sqlstring As String Set db =OpenDatabase("c:\data\op\pos405\contact2\contactmanager.mdb") searchfor =...

need to count number of sale base on a date the user inputs Private Sub datesrch() Dim searchfor As String Dim db As Database Dim rs As Recordset Dim sqlstring As String Set db = OpenDatabase("c:\data\op\pos405\contact2\contactmanager.mdb") searchfor = InputBox("enter new...

I have an access database bound to vbforms textboxes I want to check the date that the user inputs into the textbox or input box to make sure that time and date are not taken. the date and time are in the same field. the syntax displays the msgbox if the user inputs a date this is in use but if...

I want to be able to check an appointment date in a field in an access dbase. If that date is taken then I wnat ot display a message. If it is not taken I want to update the record that i am view in the form. this attached works except it updates the first record in the table and not the one i...

I just want to update the current record. The data base is bound to VB this check for matching date and time in the field but update the first record in the field and not the one that I have selected. Private Sub apptcheck() Dim upDateAppt As String upDateAppt = InputBox("Enter new...

Thanks, I know I could do it in access buyt wanted to get it to function using code.

Yes I changed all of that and still have the same issues.