Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PGAC
  • Order by date
  1. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    The problem has been solved. Please see http://tek-tips.com/viewthread.cfm?qid=1709967 for solution.
  2. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    The PC was reimaged and said problem has not occured since.
  3. PGAC

    Using Excel and VBA to clean up data

    How about creating a macro that sorts the data on the column in question?
  4. PGAC

    Configure an email account (exchange server) in Outlook 2003 using VBA

    Hi, Thanks for the reply. Sorry, I don't know anything about roaming profiles. The situation is that the IT department setup/maintain the system and although I am not technically IT, the fact I have more knowledge than most I have become a bit of a de facto IT person, which is why I am looking...
  5. PGAC

    Configure an email account (exchange server) in Outlook 2003 using VBA

    Hi, Where I work we have a number of people who do not have their own PC. Instead they just grab which ever PC happens to be free in the office at the time. The problem is that Outlook has to be configured per person per PC and this can be a tiresome task for me to do. When you first open...
  6. PGAC

    Configure an email account (exchange server) in Outlook 2003 using VBA

    Hi, Where I work we have a number of people who do not have their own PC. Instead they just grab which ever PC happens to be free in the office at the time. The problem is that Outlook has to be configured per person per PC and this can be a tiresome task for me to do. When you first open...
  7. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    It doesn't seem to be the MSXML version either as I have tried versions 3 and 6 too. What happens at line 310 is the string variable strName is updated with the value from .ChildNodes(enmUserXMLName).Text. Any attempts to then use this variable produce run time error 5. For example, 400 If...
  8. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    That's the problem - there are no references marked as missing. Many time I have created a new database, imported all objects (on some occasions, used the SaveAsText / LoadAsText for VBA modules in case one of them is corrupt) and added all the references again. When I run compile, no errors are...
  9. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    After some trial on error on several PCs, I suspect my version of Office (2010) is corrupting the VBA when I compile the code. Once compiled, any string variables throw run time error 5. I tried importing all objects into a new database on a different PC and no problems. Thanks for your help.
  10. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    Dear all, I have been advised that my post http://www.tek-tips.com/viewthread.cfm?qid=1709889 may get a better response if posted here. Apologies for double-posting.
  11. PGAC

    Problem with transferring values from an XML file to VBA variables in an Access database.

    Dear all, Recently I have re-written some VBA code in a split Access database to make it more efficient and eliminate some redundant functions/subs. Basically, an XML file is opened through VBA and certain data from it is transferred to variables created within the frontend database. The...
  12. PGAC

    SubForm Pass Value to check if Record Exists then Create New Record

    Hi adwyer, Why not link the external table into you local database and create an append query to copy all external records into the local table? You could just copy the Primary key field. You can then run the append query before you start any work on your local database. For this to work, the...
  13. PGAC

    Query Trouble

    Hi Carkick, Shouldn't there be three tables? One for jobs, one for materials and one to link the two together? The Materials table would contain all info on each unique type of material, the Job table would contain all info on each uniquie job and the third table would be a junction table...
  14. PGAC

    Select max

    Hi grchang, I think you might get the results from a query. Create a new query and select the table where your data is held. Select fields Contract then in manually create the following calculated field: PriceA: Iif([Tier] = -1, 0, [Price]) If the Tier is -1 then the Iif returns 0...
  15. PGAC

    Access 2010 Web Required Field NUll Value does not generate error message on Record Save

    Hi Dyer01, What is the macro command you are using? In the past I've made the mistake of saving the form (which does not save the record).
  16. PGAC

    Start up Form error 3304

    Hi boardgamer, 3304: You must enter a personal identifier (PID) consisting of at least 4 and no more than 20 characters and digits. Is this the message you are getting? Sounds like could be a missing workgroup file (.mdw). You can set the workgroup file by going into Tools then Options...
  17. PGAC

    I have form with a combobox to pull

    Can you post the code that does this?
  18. PGAC

    Filtering across Combo Boxes on a Form

    Carkick, I don't think this can be done as a datasheet because if you requery a combo, all records having some other value than the previous combo will seem to disappear. You could probably do this on a single form which only displays one record at a time and requery all combos everytime you...
  19. PGAC

    Best Way to Write Function

    Hi LouieGrandie, You could simplify using a WITH statement: With Me !SelectionsOwner.Enabled = !SelectionsYesNo !SelectionsEstimatedTime.Enabled = !SelectionsYesNo !SelectionsEDC.Enabled = !SelectionsYesNo !SelectionsCompletedDate.Enabled = !SelectionsYesNo...
  20. PGAC

    Using a VBA sub to close DAO recordsets as part of end-of-job clean-up

    Dear all, As part of Access (2003) VBA (Win XP), I am aware it is good practice to close any objects to explicitly open in any sub/function so that these objects don’t end up “floating around” in memory. The current way I do this is: ============================================== Public Sub...

Part and Inventory Search

Back
Top