Recent content by JpSkyPilot

Hi I am building a form that has three subforms 1. The first sub form lists individuals from Employees and then we can select the vehicles they usually drive and the days that they usually work (based on a query that selects all from the Standard Assignment Table) 2. the second subform I then...

thanks a million, I will look this over and appreciate you sharing it with me. JP

ok...thanks anyway.. :0)

Hi...if you're still there...I used the Application.followhyperlink...and it does open the program...but the program opens in a smaller window...I have the form set to docmd.maximize on Load...but the "container" that opens is only about 1/2 the size of the screen and almost centered...is there...

Thank you, John.... I'll look the article over and see if I can use it...I really do appreciate your time...

The problem for me is that I'm still developing it to be run on computers without Access 2010 installed. I made an accde file to have the executable...now I have to also use Access 2010 to open it...and want to avoid that to see if it is working before I put it on other machines. I have not...

OK...thank you for your help JP

Thanks for the reply...I could not get back sooner...I was out of the office yesterday. I have tried to use the "Shell" in this way: Dim RetVa RetVal = Shell("C:\Access 2010 Databases\Vehicles\Vehicles FE.accde", 1) And I keep getting an Invalide Procedure or Argument...

Hi: I've built a database in Access (Vehicles FE). Then I built a second database (Vehicle Startup). The Vehicle Startup is openned as the startup database. It checks the "build" of the current copy of Vehicles FE on the current machine and then compares it to the "build" in the database on...

Thanks to both... I just did a msgbox in the OnOpen and OnClose...and it works...thanks to all

Thank you...I'll try this to see if it works for me...it is the end of the day; so I'll do it tomorrow...thanks again

Hi. I've built a program in Access 2010 for vehicles. I am using the Navigation Form to switch between forms in the database. There is a form for editing a vehicle's information and I only want one operator at a time to be allowed to edit that info. When an operator one clicks on the form...

Hi: I was not referring to the windows correctly. I was putting: [Forms]![Navigation Form]![Vehicle]![subIssuesRepair].Form.RecordSource = repSQL [Forms]![Navigation Form]![Vehicle].[subIssuesRep].Requery It should have been: [Forms]![Navigation...

Hi.. Having all sorts of problems getting used to referencing forms when using the Navigation Form I have three forms: Navigation form -- "Navigation Form" Main Form --- "Vehicle Main" with a subform control SubForm --- "subVeh" as a continuous form I assign the recordset to the subform...

thanks anyway...I played with it until I found the answer. thanks