Search results

When I am printing a report, I use the command “DoCmd.OpenReport xreportnamex, acViewNormal”. This works fine when there is only one tray in the printer. A problem exists where the user has two trays, one for letter and one for legal size. Access is always selecting the legal size (11x14)...

When I use the OutputTo command to generate and store a pdf, the system throws up a brief message regarding that activity. I would prefer to suppress this message. Using the set warnings code does not affect this display. i tried a set display option using the Application command but that is...

So, I decided to change the database for my wheels up and down times from date fields to 4 character fields. I am using the routine that arnelgp provided for time validation with some modifications. A statement is in there to determine if non numeric characters exist. The issue is that the...

Not really looking for a solution but thought I would share an experience. I develop my code using Access 2019 and it operates in production using the free RunTime version of Access. I have a routine in my financials generation process that calculates a base taxable amount and applies a 5% tax...

In my current setup for an aircraft flight, the user enters a wheels up time and a wheels down time. I currently use a 24 hour clock time in that the user enter 22:20 for 10:20 PM including the entry of the colon. A change has been requested that the system allow for the entry of military time...

Not sure there is an answer for this, but you guys have seen a lot more Access related scenarios than I have, My application is for a flying school. Instructor takes student up, keeps track of flight related data (I.e., engine operation times, wheels up and down time, airports visited) on a...

I dislike the shortcut menu pop ups in forms and reports. I removed them from my forms by setting the “Shortcut Menu” property to No. However, there does not appear to be an equivalent setting for reports. Any suggestions?

I have a multi line subform that I use for data entry; e.g., segments of a multi-airport flight. I use the base table as my data source. My dilemma Is that after the user enters data, I have a need to sort the displayed rows in a specific order (such as flight start time) after each new record...

Hopefully, I will get my thoughts down correctly. I have a database that will be placed in a multi-user environment. So, best practice is to split the database into software and database files. Then the software version gets saved as an executable/compiled version so that end users cannot use...

I have a form that sends PDFs and excel spreadsheets to a given directory path location. Currently, I have the path stored in a configuration field in the database. However, I would like to provide the user with the option of browsing through the directory until they find where they want the...

Common subroutine that displays, prints, and create PDF files For different reports gblReportSelection “rptEventInvoice” gblFilter = “EventPK = “ & Me!cmbInvoices Case 1 ‘print preview DoCmd.OpenReport gblReportSelection, acViewPreview Case 2 ‘send to printer DoCmd.OpenReport...

I have been using global variables and they worked in the spring but for some reason they are not working now. During my last visits here, people were talking about a different approach to declaring global variables but I can no longer remember what they were called. Please provide. Thanks

A user can select 1 to 4 airports that the pilot visited. Currently, I store “AirportID to AirportId to AirportId (xx nautical miles)” in the flight event notes field where xx is a calculated number based on lat/long of each airport. What I was wondering is whether an arrow symbol instead of...

I have a configuration field which identifies the path where pdf reports are to be stored. I join the path, a file name, and a pdf extension, use the OutputTo command and it works as expected behind the scene. However, when I try to do the same with Excel, it rejects the request. If I leave...

with MS Access 2007, I would split the database into data and the user interface (using and MDE file). With MS Access 2019, I see that the ability to split the database still exists but there does not appear to be an executable object (unless the database split creates one?). what I am looking...

I have an invoice report where I show all the merchandise/service charges, total it up, add tax, show the invoice charge and then show the client’s current account balance. This works just fine for the numbers and data retrieval except for two features that I thought were standard: 1)...

I have two sub forms that show records for the master event. I would like a simple way for the user to select a record and then press a Delete command button to remove it. i thought about having a Delete button in the form footer and a yes/no box for the record. However, when I select a non...

Until the 5th day of the current month when the tax calculations are generated for the prior month, the user is able to change or delete any invoice information for that period. Once the cutoff is reached, I would like to allow the users to view the information but not make any changes...

I have a form with a list box that has the key identifiers for a table and a subform for data entry/review. When the user clicks on an entry in the list box, the master key is set which changes the view in the child subform. In the subform, I have two combo boxes: a list of aircraft and the...

My understanding is that Microsoft products use bankers rounding on decimal places; i.e., the decimal is only rounding upwards if the decimal being rounded is 6 or higher. I looked at rounding in Microsoft documents and found Math.Round(value, MidpointRounding.AwayFromZero, decimal places)...