Search results

Btw, I just tried out the first sample code to reselect a backend database and it worked great. The only thing I changed was to get the user to select the backend database first using a file finder dialog. you guys are really helpful.

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?

Hmmm. I thought that if I save the database as accde (file saved into an executable only file) then no one would be able to view the code. Is this not correct. Delivery of new versions will be somewhat remote with installation instructions. I am developing the app in Pennsylvania and send it...

Thank you

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

Thanks. I will try these out

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

That did the trick. Thanks a bunch

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

Btw, thanks for the responses. I use global variables to: - set up configuration fields that are loaded at app startup (e.g., federal tax rate) - define generic varIables that have limited life and I do not want to define in each procedure such as gblErr, gblInt, gblTxt, gblKey - sometimes to...

Thanks for the reply.

My mistake was setting the report filter in the OnLoad event rather than the OnOpen event. Works fine now. Thanks.

The filter is not being set properly. Will need to work on it further

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

Pat, yes, I agree with the standard practice re distinct data items. In this case, it happens probably one in 30-40 flight events where the student is doing a cross country flight and there is no need to ever interrogate based on an airport. I would have put the starting and ending airports at...

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

Never heard of TempVars. Will have to look that up. Always learning something new.

Ah, thanks

My prior response seems to have dropped into the ether. Oh well. I had a similar problem with a continuous form where I wanted to click on a sub form record to cause a form to be opened. I thought of check boxes and buttons but they did not work. The simplest solution for me was to switch the...