Search results

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...

Does VBA really not have an easy built in function for maximum value? I know in excel you can use the worksheet function, but that doesn't apply to Access. I have 4 dates in a record and I want VBA to find the maximum date. I would think that would be very easy, but I can't find anything. Any...

Thanks for the reply! 2 Questions: 1) Can you easily create a report to look exactly like the form without starting from scratch? 2) More of a general question - I am using Access 2010, but saving to MDB file format so it is compatible with software that will be linking to it. Does it go by...

I have a form that a user fills out and the record is not uploaded to the database until the user hits the submit button. In other words, if the user closes the form without saving, the record is not inserted. My end goal is to have the user click the button and have 3 things happen: 1) Record...

Thanks for the reply! As luck would have it, I found exactly what I was looking for shortly after posting. I figured I would share. Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Do you want to save this Bypass Report?", vbQuestion + vbYesNo) = vbNo Then Cancel = True...

I am working on a form and I only want the information to be inserted into the database if the user clicks the button at the bottom. In other words, if the user is filling out the form and then closes the form, I do not want that record saved. I would have thought this would be an easy thing to...