Is this possible

**chris lynch** · Apr 22nd, 2005, 07:04 AM

VB Code:

.DoCmd.OpenQuery " SELECT " & TxtManual.Text & " FROM Time ", acViewNormal

I have this line of code saying object required as an error.

What i want to have happen is that when i open a query called time i only want the time and date entered in the text box to appear is this possible

**RobDog888** · Apr 23rd, 2005, 08:12 AM

You can set the ControlSource of the Textbox to ="SELECT " & TxtManual.Text & " FROM Time;".

**chris lynch** · Apr 25th, 2005, 04:27 AM

ControlSource???????? s that not what i have

**RobDog888** · Apr 25th, 2005, 10:59 AM

Oh, then you must be doing this from VB6 and not inside Access?

**chris lynch** · Apr 25th, 2005, 11:01 AM

Yes sorry i didn't mention this, its in VB6.....

**RobDog888** · Apr 25th, 2005, 01:38 PM

What I would suggest is to set the reportsource in access to a query or table that brings all the data you
need. Then in VB6 you can open the report and specify a Where condition limiting the records to just the ones
you need depending on the value of the TxtManual control.

For clarification, you create an access query to retireve all records and in the report you set a textbox's controlsource
to the field you want to display. Then when you open the report in vb6 you can pass the date/time criteria to
limit the records.

Thread: Is this possible

Thread Tools

Display

Is this possible

Re: Is this possible

Re: Is this possible

Re: Is this possible

Re: Is this possible

Re: Is this possible

Posting Permissions