Search results

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

Hi: I am using Access 2010 and put a Navigation form in my program. I have already built a "Vehicle" form with a tab control and four tabs. Each tab has a different form on it as a subform. when the Vehicle form opens, data at the top of the page is entered with one specific vehicle's...

Thank you...I'll try this. JP

Hi: I have built a program in Access where the currentdb does not hold a specific table and this table is not appended to the database. I have connected to the access database that holds the table and want to run a report on that table. I can't use Me.recordsource = vehsql because I get an...

I need to fill or format a couple of the text boxes via Visual Basic. However, I try to put the Visual Basic in the "On Format" event and nothing happens. I've tried it in On Print, On Paint, etc...and it does not work. I put: Me.txtmytext = Admin Me.txtDateText =...

Hi: I have a report that is a letter to drivers. If the report is for those driving vehicles 1 through 99, then the "To" field will have one employee name, however, if the vehicle number is 100 to 199 there are two employees, and each needs to be listed in the "To" text box. I also have a...