Recent content by kdevitt

I think you might want to throw a trim statement in there as well-- trim([Field1]) & " " & trim([Field2]) Ken

Its not actually possible to pass a parameter in a pass-trhough query. The query is sent as a string direct to the SQL server, so that won't recognise any parameters you've placed in the query. You have to code the query in VBA to simulate parameters. Basically, create a query definition in...

if you turn off the warnings you won't get the message in the first place, so you won't have to answer it docmd.setwarnings false 'turn off warnings docmd.setwarnings true ' turn on warnings you should include all your code within the two statements above, leaving the warnings off could mess...

I have a report that displays a graph, and the source data for the graph. The source data is displayed in a Percentage format. While the report runs perfectly on my PC, other users see the report, but without the source data. My code is sound, but I think theres a problem with the other users...

If you don't want to use macros, set up a form, and apply an [On Timer] event to it. Then have the event check what time it is, and if the time is 4pm get it to print the report. EG If Format(Time(), "hh") = 16 Then docmd.openreport "ReportName",acNormal,"","" else exit sub You can also...

Hi Beverly, To dynamically create reports, I just do the following, I don't know if this is the way you want to go!! I'm assuming you have a form from which you click a button to output the report. Set the [On Click] event of this button to have a few case staements setup, or you can use...

You can ignore this now!! I finally got it working

HI, I'm having big problems getting a seemingly easy graph to work. It's the very last part of a fairly extensive db, so I want to get it out of the way ASAP! The recordsource for the graph a table like below: Grade: Q1 Q2.... Name Great 0 1 John B Ok 1 2 John B Bad...

Heres the link: http://office.microsoft.com/downloaddetails/Wzmapi.htm Hope you find it useful!

The Microsoft Access website has a free Outlook add-in that allows to to view your e-mail in access. I've found it very useful.

I use Dlookup all thetime, and even still it can take a while to figure out why it won;t return the results you want! If you are looking up the value of a field on a form, you might want to change the code as follows (assuming the form is called Form1, and the control is called MyValue): varX...