Recent content by coyote69

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...