Search results

Ooop... I figured it out. You have to go into the first option and put the following: <code> If Option1 = True Then Option1 = False Option2 = True End If </code> And vise versa on the other option.

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

Well.... I'm trying to have my program pull in info from a table into a form. I have been able to have this work using the code: "DoCmd.GoToRecord , , acNext", but now I am trying to pull in one specific record, not just 1 of 3.

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

If you have a moment...How?

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

This appears to help... One more problem though. When I try to execute this, there is a pop up asking for me to input a Primary Key. Right now, I have the primary key as an autonumber format. The entire table has ID (AutoNumber), and and Location (Text). Code: DoCmd.RunSQL "Delete From...

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

If I'm looking for an answer for my problem, and it is touching 2 worlds of Access, I like to hear more than one idea of how to fix it.

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

OK, I think I've got the right idea, however still getting the same error message. When I run the query from the query, it works the way I intend it to, however when I select an option from the combo box on my form, It gives me the same error: "Too few parameters. Expected 1", and refers to my...

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

I only had a few options when going threw the wizard before it made me click finish. Where are all the other options you have listed? Someone also said something about useing the after update function of the combo box itself. Any ideas here?

I am essentially creating a program that starts by someone setting up locations to do a walk around a store. When they type in which location they are at , it will give them the list of locations so they can choose the corresponding location to that number. After this is set up, they wouldn't...

OK.... I haven't used queries too much.. how would I do that?

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

Nevermind, forgot the acPreview. Should have been: DoCmd.OpenReport "hazards", acPreview

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?