Search results

The form is based on a single table. Maybe I'm not understanding what a subform is or how to make one.

Little Johnny is sitting on the sidewalk smashing ants with his thumb. A priest walks by as Johnny says "Goddamn ants". The priest says "Johnny you shouldn't talk like that. God put everything on this planet for a reason, and everything he put here has a purpose. If you can come up with three...

Subforms won't work. They must all be displayed at once. Subforms would too much of a hassle. Essentially the form is laid out with two combo boxes in the form header that are used to select the tool group then the type. The way the database was initially set up there was a field in the record...

None of it makes any sense anyhow.

I have a form that displays the quantity of tools on each truck. there are a little over 500 tools and some 40 trucks. the table is set up with every tool listed for every truck (500x40 records). I filter the form by the tool I am looking for and I want to display the quantity of that tool for...

Add both tables to your query and don't join them. Add the desired fields from both tables and then make a field that pulls the contract number from the vender/contract number field in the second table. In the criteria of this field set it equal to the contract number field of the first table...

When a macro runs, does it wait for the previous step to finish before beginning the next? In one macro I have it runs a query that takes a little time to run due to the large number of records. I want to close the database when the macro is finished running (this is an automated task that runs...

Where is this option in Access 2007?

Ok, that got it. I see now. How would I code Me.Text8 if I wanted it to be like strField? I know it isn't necessary because this example is so simple, just curious.

You mean put this in VB code as an [Event Procedure] in On Open? I thought you had meant to put it in as an expression, which seemed very odd to me. I tried that code earlier without luck, but I was trying to make Me.Text8.ControlSource a Dim as well.

=[Me].[Text8].[ControlSource]="Forms!Turtle_Meter_Form!Multiplier" I placed the above directly into the on open event of the report and it gave me the error "The object doesn't contain the Automation object 'Me.' So I tried it without the Me. and it didn't recognize...

I understand that, but now I am trying to learn more about VB. I know there is a simpler way of doing it but that doesn't help me in the long run.

Private Sub Report_Open(Cancel As Integer) On Error GoTo err_Report_Open Dim controlbox 'Box that controls which control source gets used Dim controlledbox 'Box that gets its control source changed per user request Dim Field5...

I thought the quotes made it a string and it would put F3 literally into the control source as a string. I see now why it was giving me a type mismatch; little syntax qwerk. Thanks Keith

That is what I am attempting to do unless I am not understanding you correctly. I want to select a field in a control box, Form_Turtle_Meter_Form!Multiplier, on the form and run the report. When the report opens the control source of an unbound text boxt, Text8, in the report should get set to...

Explain how it would change from record to record. Form_Turtle_Meter_Form!Multiplier is a control box on a form, unless this changes the control source won't change. For every record in the report, this box should have the field F3 for Text8 if thats the field that was chosen or F4 if that's...

That would be fine if those were the only two fields to choose from. I am must testing code using the two fields. The final application will have about 15 fields or so. The control source wouldn't change from record to record anyhow. It would merely change from report instance to report instance.

It says you cannot assign a value to this object Anyway, I don't want the box to say "F3" or "F4". These are two fields in the table that the report is based on. I want to be able to specify which field goes into this spot in the detail section of the report. I've tried using the On Format...

What is wrong with this code Private Sub Report_Open(Cancel As Integer) On Error GoTo err_Report_Open If Form_Turtle_Meter_Form!Multiplier = "F3" Then Me!Text8.ControlSource = F3 ElseIf Form_Turtle_Meter_Form!Multiplier = "F4" Then Me!Text8.ControlSource = F4 End...

That didn't work either. I tried just opening access without the database and it wouldn't do that either. It just said file not found. I'm new with VB so I really don't know what all capabilities I have with it. I figured this would be a good learning experience but it has become more of a...