Search results

Oh my goodness! I followed your instructions and the error was so simple I am almost embarrassed to let you know. The project I am currently working on, since the start of the year, has a forward slash (/) in the project name. So I have been updating the data all month long and frustrating...

Hello. I have suddenly been getting a run-time error on a report I have been running for the past two years without issue. The code would create the report, save it to the specified file path and name the report based on a data entered in a particular field. This was working fine up until...

Thank you. Adding the date/time stamp column seems to be working. Took a few more steps as the report was not showing anything without the date/time stamp so no historical data was showing. This is what I did: 1) Added a calculated field named DateTimeEntered and entered =[DateIssued] in...

Thanks. I'll give it a shot and let you know

Good morning, I have a database for registering drawings for a construction company. The drawings are registered according to date received and revision letter/number. The query for the register report uses the MaxOf date and Last Rev letter and produces a summary report. This database has...

Thank you. I forgot to insert the second backsplash in the file path. It was corrected as follows FilePath = "J:\Tender Detail Forms\" & FileName & ".pdf"

Good afternoon, I tried combining two print events I had in two separate databases. The first one just gives a print preview of the current record. The second one prints the report to a pdf and saves it in the specified folder. However, when I try combining the two events, the pdf is not...

Found it!! :D I checked the queries yet again. So as Minty and you advised earlier it was the grouping. I checked the the design view of the report's source query and realized it referenced a query that the grouping was already applied to. So the source query was repeating the grouping...

Ok…this is what’s happening. Firstly, my DB is doing the opposite of what it should be. As per a previous suggestion, I removed the memo field from the grouped query, created a new query and added the memo field but it was still truncating. I then did a cleanup of the entire DB and...

No luck again. Before my previous response, I had actually copied and pasted in a word document and searched for both the word "parameters" as well as for the field name that the parameter box is requesting and neither were found. I have been going thru the database and doing some house...

Hi...No I don't see PARAMETERS in the SQL view

Hi again. I managed to fix the truncation error and now all information is showing in both the report and the source query. The only problem I am having now is a parameter box that keeps popping up when I run the report that keeps referencing the memo control I was having the issue with in the...

The query is grouped because drawings can have several revisions throughout the course of a project. The detailed drawing register lists each revision and what the changes were where as the summary only shows the most current changes. When I was building the database, the only way to show the...

Thanks...that I understand how to do! I really wasn't understanding how to correct the problem from the notes provided yesterday. Thank you so much for your help

Forgot to mention...I'm using Access 2010

Good morning...sorry for the delay in responding (5 hour time difference). I have edited the database as much as possible attach the compressed file. The issue is the Drawing Register. When the main menu comes up, go to drawing registers and select Contract Scotiabank. Then select Summary...

I've tried the different workarounds but none are working or are applicable. I was wondering if the database itself is getting too big or is becoming corrupt as I have noticed a few other quirks recently. I have been using this for 3 or 4 years now and this is the first time I have encountered...

The query is somewhat complex (for me at least) and is based on 2 or 3 other queries. It is a summary showing the last entries of a construction drawing register. The detailed drawing register which shows all drawing revisions to date is displaying correctly.

I've attached a screeshot of what the report is showing and circled the field that the text is incomplete. The full text should be as follows "ABM Room - revert to original position for table and overhead shelving. Manager (116) - indicated existing gypsum enclosure for AC line; relocated...

Hi..yes it is a memo field. The SQL is as follows (hope I'm doing this correctly) SELECT [Copy Of QRYSmryDwgRegRpt].ContractNo, [Copy Of QRYSmryDwgRegRpt].ContractName, [Copy Of QRYSmryDwgRegRpt].IssuedBy, [Copy Of QRYSmryDwgRegRpt].DrawingNo, [Copy Of QRYSmryDwgRegRpt].DwgNo, [Copy Of...