Search results for query: *

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

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

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

I am trying to perform a check of an appointment date field in an access database to verify that the user does not enter an overlapping appointment date and time. the database is bound to vb. I lock the txtbox field and force the user to use a cmd button to change the appointment. I am not tha...

i want to check an access database fr overlapping appointment time on any given date. the database is set up with appointment time and appointment date fields. I need to check the textbox input the the user is entering to be sure a second appointment is not scheduled at the same time and send a...

I am trying to find a range of dates from a user input such as beg date and ending date. I get and error when trying to search the date. this happen when it tries to refresh the data. the database is connected through the databound controls in vb. Also I have two fields one with the appointment...

How would I search the database to avoid overlapping appointments if the appointment date was in one field and the time was in another?

I am trying to search an access database for a range of appointment date it gives me an error or it send the date back that are not within the range. Dim Searchbeg As String Dim searchend As String frmresults.Cls 'Orders Records by appointment Searchbeg = (InputBox("Enter beginning...