Recent content by brian7268

The database automatically emails the PDF after it is generated, so I have already received a copy of it. Unfortunately, it is the PDF itself that is messed up, not the viewer. The font size is off and the right and bottom of the form are cut off.

UPDATE: I just changed the resolution of my laptop to 800 x 600 and completed the form. The PDF looked fine, so I don't think the problem is the user's resolution. Any other ideas what might have caused it?

That is a very good point. Assuming, the "offender" is using a low screen resolution, is there any setting or code that can make the form export the same regardless of the user's resolution?

Thanks for the suggestion. I could look into that, but I would rather not. The form is very dynamic (different fields appear/disappear based on previous fields) and I'd rather not have to add the step in of generating a report.

After a user completes a form, they click a button at the end that uploads the information the back-end database and creates a PDF copy using the DoCmd.OutputTo function. It has been working fine, but one user just had an issue where the form was very zoomed in and cut off. So I have 2...

Pat - thank you for the reply. That solution would require me to run that query on every database (2,000+). I was hoping to find a solution from the excel end that would allow it to be imported from Access. I suppose I could write a macro to run that query on each database, but I feel like that...

Does anyone know a tool/way to combine/compile databases? I have over 2,000 databases with the same table structure and my end goal is to have 1 database with all the data. Thanks!

Hi, I have 2,000 access databases that are structured the same way. I want to import and compile 1 of the tables from the databases into excel. I have a macro written that does this no problem, but I just realized it is not importing Number fields with field size of "Replication ID". This is...

Perfect. Exactly what I was looking for - thanks!!

I have a form that the user first selects the Town and then selects the street. I would only like the Street combo box to be based on the Town combo box selection. For example, if the user selects Boston, I ONLY want the Boston streets to be available for selection in the Street combo box. My...

Thank you very much for the reply, lagbolt! I think I misrepresented my question. I was not so concerned the formula as how do you populate a column in a query with a formula? Do I need VBA for that or is that built into SQL?

I have a database that has 2 forms. After submitting the first form, the user should complete the second form within 24 hours. The first form stores the Date/Time the form was submitted. I want to be able to run a query and have a column in the query that is "Time Remaining". In non-technical...

Private Sub Form_Unload(Cancel As Integer) MsgBox ("Use the control buttons to upload or close the form.") Cancel = True End Sub

I have a form where I only want the user to be able to close the form and submit the form via buttons. I have disabled the menus, but I noticed a loop hole - some laptops will let the user close the form by pushing a quick button that I can't disable in access. I have everything set up, but I...

In my mind, the SQL wouldn't work if they are in the same record, but I could just not be thinking of it right. The data has a field for Date_Reported, Date_Confirmed, Date_Notified, and Date_Resolved. Each entry has a date in each column. I want the macro to find the Maximum Date (i.e. the...