Search results

Hi...Just giving you an update. So I made the changes to the code and added a couple lines to minimize the Job Set-Up form (see below in red). The report opens and saves to the specified folder. On closing the report I created a simple dialog box that asks the user if they would like to view...

Ok thanks. Really appreciate your help.

I don't know how to toggle the visibility...sorry. I tried the minimize window and that seems to be working (sort of). No error messages and the file saved in the specified folder. Is there a way to add a hyperlink to the folder in the message box?

Oh...I think I understand. So I should keep the form open but maybe minimize it, let the report run and save to the folder and on closing the report, maximize/restore the form?

The database is 8MB even after the compress and repair. I will email it to you shortly. Thanks.

The db won't upload...it is exceeding the max. file size and I am getting the below message Your submission could not be processed because a security token was missing. If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this...

Yes...definitely the textbox name and not a caption. I thought I was misspelling it and even copied it from the properties box and pasted into the code and still got an error

Hi. The error description is Run-Time Error 2467: The expression you entered refers to an object that is closed or doesn't exist The ContractName text box is a required field and primary key so there is always info in that field

I am trying to run a code that will print a report to pdf and save in the specified folder, however I keep getting an error with the file name. Where am I going wrong? Also, is there a way of adding a hyperlink to the folder in the message box? Private Sub CmdPrintJob_Click() Dim strWhere As...

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