Recent content by nonakag

I need help in preventing the Access Record Attachment object from creating multiple instances of the same record. If I upload three PDF documents to the record attachment object, the resulting record query lists three records of the same record. The Attachment object correctly displays the...

Isla, you are correct. When I added the Destinct, it pushed and error that the attachment field is not compatible. Is there a way to create a button to a popup form for attachments for each unique record so that way I could remove the direct attachement field from the query? Thank you.

Plog, thank you. What is the best way to break up the tables but still put all the information into one form? Would there need to be a Join Query in order to tie in all data on the one form? Thank you. Plog, thank you. Yes, if you see my form the gray upper area are the filters for records...

Isla, it says Distinct cannot be used with attachments.. any way around that? Isaac, could you please tell me how to make fix the join? Thank you.

I'm open to solutions. I'm a novice at access. Please show me a better way to join the tables and get the data into the form that I need. The Reservsations table is unique to the reservations number (primary key). The Left table is unique by CR# and the right table is for combo box values for...

Form and Switchboard

The small outer queries are information from other larger tables that was needed to display data in the form.

SELECT Reservations.[CR#_], Reservations.[Requestor Rank and Name], Reservations.Tell_No_, Reservations.Driver, Reservations.[Reporting Point], Reservations.Destination, Reservations.Purpose, Reservations.[No_of PAX], Reservations.[Date Required], Reservations.[Time Required], Reservations.[Date...

I have a form and query. The query is complex with in between date values, Primary Key (Unique vales), Non-Unique Vales, and with these values being sometimes null. The part that has me stumped are the unique values. When other search criteria are null and the one unique value is chosen, it...

Doc, Thanks for the advice. Yes, that is what I meant by the Dashboard using the Form Timer Event to update periodically. So, far, as long as I Access has the screen focus the Dashboard updates every ten-minutes with no issues. Thank you.

Doc, I leave my Dashboard (Switchboard) form open on my desktop. The form timer is set to requery and refresh every 4-minutes. However, it seems if I leave the access app, and work something else, the timer events seem to buffer if the form looses focus when I use another MS application on my...

Doc, I've been doing more experimenting. I turned off the Access Auto Refresh by setting it to zero. For some reason the other FEs with this set don't get updated. I also tried the Form Timer Event and Timer Interval Property with both a me.refresh and me.requery. and the other FEs still don't...

I was able to put the modules into my application and the code into my main Switchboard form onload event, and catch and solve compile errors until there were no issues. My applications runs over a VPN. Prior to using your application the form would take about 3-4 minutes to load. For some...