Search results for query: *

I've been upgraded to Office 2003. I also made sure I have the usual references in VBA. My report puts the year in the title (in header) using the formula shown in the subject line of this message. For some reason it is now not working. When I open the report it asks for Format? and then...

I have a mailmerge word document that when launched opens up and retrieves data from an MS Access query. The query has two parameters that must be completed, customer name and date. I then manually merge to a new document. On the new document I have a Send Mail button which when launched asks...

Why doesn't CDec work in my report? I have 2 subreports with numbers in them. I need to have the frequency between those 2 numbers. For example: No. of Claims / No. of Vehicles Shipped. 5/1138 = 0.43% With my code all of the fields provide the correct output with the exception of the numbers...

Why doesn't CDec work in my report? I have 2 subreports with numbers in them. I need to have the frequency between those 2 numbers. For example: No. of Claims / No. of Vehicles Shipped. 5/1138 = 0.43% With my code all of the fields provide the correct output with the exception of the numbers...

My main report lists damage exceptions in the following format: RF Door Dent LF Door Dent F Bumper Dent The data comes from Report Number 5 I have a claim for damages which is linked to this report. The claim (subreport) contains the following: F Bumper Dent Towing The Main Report is linked...

I have a table where some fields do not have any data. I guess they are considered to be null? Anyway, I would like to update these empty fields in this table with n.a. but I haven't a clue how to do this. Can anyone help in plain english. I am as green as they come. Jim

I have 4 crosstab queries that count different types of registrations. The results are: Name Total 04/01 04/02 04/04 etc. I would like to put all 4 query results into 1 report. I guess there would be 1 master report and 3 subreports which I haven't tackled and not quite sure how to go...

I have an Oracle SQL that is sent from Access through an SQL Pass Thru. In this SQL my WHERE statement has a date field which I must change to a certain date. Is there any way that I can set this up as a parameter so that when I run the query it asks for the date before sending the SQL through...

I am using a function which counts business days and takes holidays into consideration. I am using Access 2000 in Canada if that means anything re dates. When I get the error message I select debug and it takes me to this line "dteTemp = dteTemp +1" when I point my mouse pointer...