Search results

Say I have two bubbles (options,buttons, whatever you know them as) I want the system to be set up so that only one of the two can be "true" at a time. Say they are titled Option1, and Option2. What code would I put on them so only one can be "true" at a time. If Option1 was true, and then...

I have the following code in my VB: DoCmd.GoToRecord , [Response Tasks], acGoTo = [Response_ID], "08" This is not working however.... The table name is Response Tasks, the Column name is Response_ID and I am trying to pull the info from the one named "08". What am I doing wrong in the...

I have a from which is pulling in a column (named "Loc_Desc") from a table named "Input". What I am wondering is, how can I set it up so that it is looking at a specific ROW in that column, instead of looking at the first row each time I load the form?

I current have the following code which works perfectly now: CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me.List12 & """)", dbFailOnError I would however like to add another field's information named (Lnd_Desc) as well in the same row of table (Input). What should my...

I have a list box (List0) which is pulling in information from a table. I would like it so when a command button is pressed, the selected option in the list is deleted out of the table, along with an autonumber with it. (This would be deleteing the entire row). I am working with the following...

I know the command "CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me.List12 & """)", dbFailOnError" works. I now need a way to delete a value from a table using a similar command. I am wandering if there is a "REMOVE FROM" or "DELETE" or something similar that will take an...

Hello again all... Today's problem is as follows.... I have an "after update" combo box that is coded as "CurrentDb.Execute "Uno", dbFailOnError". I have an update query which I am trying to have a combo box from a form input information, update a table with what the combo box was inputted with...

Hello again all... Today's problem is as follows.... I have an "after update" combo box that is coded as "CurrentDb.Execute "uno", dbFailOnError". I have an SQL Query named "uno" that is showing the following: "UPDATE [Input] SET [Input].Loc_Lng = [Loc-1L].Combo8, [Input].Loc_ID = "1"...

Here's a tricky little problem I am trying to figure out. I'm sure someone out there should be able to help me without breaking anything. Heres the problem.... I have a form that has an underlying table attached. I have a combo box pull in a pull down list of locations from that table. What...

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?

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?

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

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

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

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

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