in
All Tags » Microsoft » access » 2007 (RSS)

Browse by Tags

  • Object Required 424

    I am getting Run-time error on this line; If file <> "" Then Set objWkb = objApp.Workbooks.Open(DL & file) Else Set objWkb = objApp.Workbooks.Open(DL & "Audit2.xlsm") End If Either line that is used. I checked the location, filename, and extension. All are ok. It used...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-22-2010

  • need help with xor

    I'm trying to use XOR in an Access 2007 query and I'm not getting the behavior I expected. Given a table "Foo" with an ID field and text field "SomeText" where the recrods are: ID SomeText 1 a 2 a 3 4 If I query the "SomeText" field with: Like "a" I get...
    Posted to Access (Forum) by microsoft on 05-22-2010

  • Filter listbox using selection from option group

    I have a form in which i use a listbox to produce record information on the form. The list box is labeled list36. The row source for list36 is qry_AllEquipment. The query pulls all the equipment from the Equipment table. When a user selects a piece of equipment from the listbox the form populates itself...
    Posted to Access (Forum) by microsoft on 05-10-2010

  • Access 2007 - hide/unhide forms

    I feel silly even asking the question, but how do you hide and unhide forms from the user interface in Access 2007? In Access 2003 and earlier, when I had an open form I could go to Window --> Hide. Or to unhide a form, Window --> Unhide... I cannot find an equivalent command anywhere in the Access...
    Posted to Access (Forum) by microsoft on 05-04-2010

  • Microsoft, Access, 2007, creating a login form

    In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I have entered the coding where username and password is entered into the login form that is then compared against those logins stored in the Microsoft Access table. If a match is found...
    Posted to Access (Forum) by microsoft on 05-04-2010

  • Mail merge picture filepath from Access

    I have images' filepaths saved in a table in access. I'd like to be able to run a mail merge and bring those images into Word. When I've tried doing this, I will only get the filepath to show up in Word, not the actual image. Is this possible? Thank you.
    Posted to Access (Forum) by microsoft on 05-03-2010

  • Multiple Parameter selection prompt

    I'm looking for a way to allow the end users to enter multiple criteria in the Like Parameter in a query. In theory I thought this critieria would work, but instead it returns nothing. Criteria value: In ([Enter Item#(example: "5494","5506")]) If I hard code the item numbers like...
    Posted to Access (Forum) by microsoft on 05-01-2010

  • How to build an OLAP Cube from Access 2007?

    I have a database on my local computer that I'm running. One of the main outputs is a consolidated table which joins 10+ tables together to form one massive table with 1M lines. I have been querying the MDB using statistical software, JMP. However, the performance of the query is starting to suffer...
    Posted to Access (Forum) by microsoft on 04-15-2010

  • Why does MS Access 2007 ask for a password for any database I try to open?

    Experts! I have a issue with my Access install.... I'm not sure where to start, it may just be that its Friday at 4:15 :)...... but Access was working fine up until today. After that, every time he tries to open a database, its asking for a user ID and password. We ran the repair on Office, and we...
    Posted to Access (Forum) by microsoft on 03-12-2010

  • hide fields unless paticular option is selected in combo box

    What i have is a form filled out by a user and when they select a paticular option in a drop down box i want to have it display additional fields hidden otherwise. Almost like an if then kind of thing i just have no clue how to write that in VB.
    Posted to Access Forms (Forum) by microsoft on 02-21-2010
Page 1 of 50 (496 items) 1 2 3 4 5 Next > ... Last ยป