Search results

  1. J

    Table Currently In Use ?

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

    Open Access from VBA

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

    Open Access from VBA

    ok...thanks anyway.. :0)
  4. J

    Open Access from VBA

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

    Open Access from VBA

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

    Open Access from VBA

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

    Open Access from VBA

    OK...thank you for your help JP
  8. J

    Open Access from VBA

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

    Open Access from VBA

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

    Navigation Form and limiting Access to Form

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

    Navigation Form and limiting Access to Form

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

    Navigation Form and limiting Access to Form

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

    Navigation Form and SubForm

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

    Calling Actions on Navigation Page SubForms

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

    Navigation Form and SubForm

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

    Navigation Form and SubForm

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

    Report and Set Recordset

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

    Report and Set Recordset

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

    Conditional Formatting in Access 2010

    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 =...
  20. J

    Conditional Formatting in Access 2010

    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...
Back
Top Bottom