Search results for query: *

The error i am getting is "case without select case." What have i done wrong? Select Case x Case "0": If Len(Trim$(Trip1(0).Text)) > 0 Then Data3.Recordset("origin") = Trip1(0).Text...

On my VB form I have text boxes. I need the data that the user puts in the text box to be saved in a table I have created in access called report1. I would like this to happen when the user clicks a command button named add. I have an ADO control on the page that is connected to the table...

I have a form with an ADO control on it that connects to a table in a database. I also have a number of dataCombo boxes on the form. The data source and the data field properties are the same for every combo box. The problem i am having is when i change one combo box the value in all the...

How can I import a form from access into visual basic. Is this possible?

When the user clicks the submit button on my form i want a message to popup that says the record has been added. I am not sure how to do this with the code i currently have for the submit button. This is a sample of some of the code. Private Sub CmdSubmit_Click() Dim db As Database...

on my form i have six microsoft date and time picker controls. On the form load I want one to contain the current date and the rest to add one day to the one before it so all the controls display a different date. I know debug.print date() prints the date and adding and subtracting from this...

I need an IF then else statement so if the origin value = 0 the record is not added to the table. This is the code I have. SourceSet.AddNew SourceSet!Employee_Name = Text137.Value SourceSet!Stop1 = Combo0.Value SourceSet!Origin = Combo8.Value SourceSet!Stop2 = Combo2.Value SourceSet!Stop3 =...

I need an IF then else statement so if the origin value = 0 the record is not added to the table. This is the code I have. SourceSet.AddNew SourceSet!Employee_Name = Text137.Value SourceSet!Stop1 = Combo0.Value SourceSet!Origin = Combo8.Value SourceSet!Stop2 = Combo2.Value SourceSet!Stop3 =...

I have a number of text boxes with values in them in the detail section of my report. How can I get a grand total of all the rows of the report at the bottom of the report?

I want a command button on my form to show the user a report. I put the code DoCmd.OpenReport "rpt_mileage" and for some reason it prints. How can I get the report up from the form without it printing?

I have about twenty different labels that return the value of a number of combo boxes. I need to create a table that records what the labels display after the user clicks on the combo boxes. The columns are Name,Date,Origin,Stop1,Stop2,Stop3, and Stop4.

I have a form that the user fills out and the values entered go into a report. I can figure out how to do this with everything except the date. On the form I used the Microsoft date and time picker control 6.0 and i do not know how to link the date the user picks from the form to the report.

Ive tried to enable a Windows Logon message as per the instructions on Microsofts website. I've followed instructions to the letter and it still doesn't come up. Any suggestions on what I might be doing wrong? TIA

I need to make a combo box on a form that has a weeks worth of dates that stays current every time the form is opened. I am not sure how to do this.

I am making a database that tracks the miles an employee puts on his car so he can be compensated for gas. I designed one big table with all the locations he travels to as the rows and also as the columns. On a form I want two combo boxes which he can input the locations he went to and from...