Search results

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

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

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

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

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

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

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

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