Recent content by vbjohn

Thanks it works!

I am having this problem and I am thinking that I need to convert the data. Data: 7,300.00 600.50 400.40 What I am getting: 7,300.00600.50400.40 What I need is: 8,300.90 What I am doing is: [SessPDm] + [InterimPD] + [DistTravelAmount] I have Access 2000. Any help would be great.

but you know what i meant. when the macro is ran the query inside the macro is asking for a parameter. How could I pass that parameter for that query? john-

How can I run a macro in VB that the macro asks for a parameter. How could I pass along the parameter to the macro? This is how I am doing it... With appAccess.DoCmd .RunMacro "ApHistry" .RunSQL "UPDATE APHistory SET..... "...

what version of vb, access do you have? What refrence do you use in VB? "Microsoft Access 9.0 Object Library". John-

All I see is.. .OpenReport [Report Name], [View As AcView = acViewNormal],[Filtername],[WhereCondition] John-

This is how I am opening the report... ========================================= Private appAccess As Access.Application Set appAccess = New Access.Application strACCond = "((APHistory.POSTEDDT) Between #" & txtFDate.Text & "# And #" & txtTDate.Text & "#)" appAccess.Visible = False...

How can you add a variable from VB to an Access Reports Page Header? Any suggestions? John-

Man do I feel stupid....:( it works.. Sorry everyone.. john-

Date/Time

I am getting this error: Syntax Error in date in query expression '((APHistory.POSTEDDT Between #01/01/2003# AND #11/31/2003#))' Can anyone help me with this? John-:confused:

Yes.

Where would I put the parameter? John-

Here are the screen shots. Please ask any other questions. John-

Actually no it is not. I created 1 query in the Queries section. Then I created another query that calls the first query then I create a Create Table query which call the 2nd query to enter in that data into the new table. Does that make sense? John-