Search results

  1. W

    Access 2007 won't install on Win2k3

    Here is the error: Error 1713. Setup cnnot install one of the required products for Microsoft Office Access Setup Metadata MUI(English) 2007
  2. W

    Access 2007 won't install on Win2k3

    I have a windows 2003 server that is a terminal server. I need to install Access 2007 on the server so people can use it. However, I get an error when I try to do it. Has anyone done this and can you help me? Thanks
  3. W

    Add new record

    Thanks. I did that and it did not work so I started all over again and it is working now. I must have had something wrong in the code.
  4. W

    Add new record

    I need to be able to add a new record by having users type in their information and when they click the Save button the data will be saved and all of the data entry fields on the screen will go back to their default value. I have built a table that will hold the data. I have a form that is...
  5. W

    Join two tables

    The UNION worked great. Thanks.
  6. W

    Join two tables

    I have 2 queries that return similar sets of records. Each query contains records that the other query contains. And each query contains records that the other query does not contain. I need to be able to join the 2 queries and get a recordset that contain all of the information from both...
  7. W

    How to convert number to date

    WOW! that was fast. Thanks.
  8. W

    How to convert number to date

    I have a number, 20080101, that I need to convert to 01/01/2008. How do I do this? I am not familiar enough with access to know. Thanks.
  9. W

    Help with Count (2007)

    I need some help with a query. I usually work with MS SQL but I need to use ACCESS 2007 this time. I have one table. I query three fields in the table. I have to use at least 2 queries. Here are my queries: Query SELECT WGMAHIST_TIMEDTY.TDYEDT AS [Work End], (SELECT Count(*) FROM...
  10. W

    How to use a date range

    The exact message is: ODBC -- call failed. [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0401 - Comparison operator BETWEEN operands not compatible. (#-401) I have an ODBC connection to a DB2 database.
  11. W

    How to use a date range

    Thanks, but that didn't work. I still get the same error message.
  12. W

    How to use a date range

    I need to get records between two dates. Here is my query: SELECT WGMAHIST_TIMEDTY.TDYPT, WGMAHIST_TIMEDTY.TDYCO, WGMAHIST_TIMEDTY.TDYSSN, WGMAHIST_TIMEDTY.TDYFND FROM WGMAHIST_TIMEDTY WHERE WGMAHIST_TIMEDTY.TDYSSN = 464299266 AND WGMAHIST_TIMEDTY.TDYEDT >= #06/29/2007# AND...
Back
Top Bottom