Search results

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-

Actually this is the Visual Basic code. I also tried it in VBA. I am just stummped. John-

hmmm then how do I pass a parameter to a macro? Cause the parameter is the 3rd message that gets poped up and then there is 2 more after that one. Set appAccess = New Access.Application appAccess.Visible = False appAccess.OpenCurrentDatabase App.Path & "\VBAccess.mdb", True...

In my visual basic application I am accessing my Access macro. I set the Warnings Off. But, there is this parameter that needs be to be passed. So when I run the macro, the parameter does not come up and errors occur. How do I over come this? John-

VB to Access - Password Protected DB. I am trying to connect to a Access 2000 DB from Visual Basic 6.0. Is there a way that I can pass in a password for the end user that would not have to type it in? This is how I am accessing it: Private appAccess As Access.Application Set appAccess =...

..... Well, I check out the reference and it is referenced. So I am not sure if that is the problem. John-