Search results

Hmm.. I have a command button on a form have the following code: "DoCmd.OpenReport "Hazards"". When I press the button, instead of Opening the report, it prints it! I'm confused... any ideas?

I found the answer after playing around. In case anyone was wandering an answer, or having the problem themselves, here's what you do. Open a Query in design view, and then select to open an SQL View. For my particular problem the answer ended up being: "UPDATE [Input] SET [Input].Refrig =...

When I put this in "UPDATE InputH-1 SET InputH-1.Refrigeration = False;" I am getting an error message that states "expected end of statement" and it highlights the word SET. Am I doing something wrong?

Is there a way to have a command button on a form, when pressed change all fields in a Table to show unchecked? I am using a Table that has nothing but Yes/No fields in it. If this is possible, what might the code look like? Table name is "InputH-1". You guys/girls are awesome! Thanks in...

AHHH I got it now.... you have to use the table create a form with and then when updated, that information gets put directly to the form... MANY thanks! :D

That makes sense in theory... How would that be done?

Thanks for your time to look at this... I am working a project that has some checkboxes on a form. I would like to have it so when a checkbox (Check1) is clicked and then the "Submit" button is pressed, it updates a form ("InputH"). I currently have the table set up with Yes/No data types. I...

Let me give some backround here. I am creating a product that a user will set up ONE time for different locations. The order in which they put in the locations is what I would like the order to come up as the program proceeds. The autonumber was just put in place so that when a location is...

This may be a bit detailed, so stick with me. Is there a way to have a form which you can pull tabel information into, but look at a specific line? I am trying to create a database that will pull up the first line of a specific tabel's information, then when a command button is pressed, it will...

Frustration! Working on the same issue now for over 2 hours :mad: lol... Everything I have tried has failed terribly. I know I'm a noob, but any ideas?

The tabel I am trying to pull from has an autonumber format and is sorted in that manor from a-z. Is there a certain type of logic that I should use however? As of now, each time I have a form come up, it starts at the first record, which is not what I want it to do. I want it to come up with...

This may be a bit detailed, so stick with me. Is there a way to have a form which you can pull tabel information into, but look at a specific line? I am trying to create a database that will pull up the first line of a specific tabel's information, then when a command button is pressed, it...

MANY thanks!

Exactly. I am trying to have it open the form that I choose from a list. Example: List shows options: A, B, C If A is selected, and then Submit is pressed, I want Form 1 to open; If B is selected, and then Submit is pressed, I want Form 2 to open; If C is selected, and then Submit is pressed...

I am trying to create a simple working program in Access. I have a List which has pulled information from a tabel. I am trying to set up a command button to understand which option I chose in my list and open a corresponding form. :eek: I tried to enter: DoCmd.OpenForm "Store Walk", , ...