in
All Tags » VBA » Microsoft Access (RSS)

Browse by Tags

  • Crosstab query question

    Is there any way to exclude records from the below cross tab query where AmountChange = 0 Attached is a db with sample data that shows the problem. The query is called 001-QCT-AllCollateral-Change. The expected results of the query are in another query called QS-Expected Outcome from QCT. I don't...
    Posted to Access (Forum) by microsoft on 05-25-2010

  • Access Tables and Queries

    Howdy, I have two access tables. The first has customer data (names, addresses, creditcards, etc). The second is a menu of items that may be shipped to the customers, based upon what the customer prefers. For example, lets say that the menu items are beer (everyone's favorite) and that out of fourteen...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-23-2010

  • Export an MS Access 2003 query directly to MS Excel 2003

    I am a novice in MS Access 2003, and I’m sure I have a very simple question, but I’ve searched the knowledge base for a couple of hours and can’t find what I’m looking for. I have a couple of parameter queries which run when you click on a button on a switchboard. They work fine. However, I want the...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-20-2010

  • highlight if data between 2 fields are not the same

    Hi, I have table called MyTable and in this table i have the following fields: Name ID1 Locatoin ID2 BAS 2 NE 4 OED 4 CA 6 SOM 2 NC 4 All what i want to do is that if the values in ID1 is not the same as the values in ID2, then i want to highlight both cells in a yellow color. Is there a way to do this...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-08-2010

  • change the color of a label on a form if certain query is run

    Hi, I have several labels on a form and would like to change the background color of the label if certain queries are run. For instance, if query1 runs then I want label1 to be yellow and if query 2 runs then I want label2 to be red and so on. Is there a way to do this? thanks Abdi
    Posted to Access Forms (Forum) by microsoft on 05-07-2010

  • Access lookup query

    I have two tables. Table A contains customer data (memberId, name, address, etc). Table B contains order information (orderId, description, cost). The two tables are linked with the One to Many relationship memberID to orderId. I would like to display a label on the member's form that displays the...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-05-2010

  • Remove records from Cross Tab Query

    I have a cross tab query (SQL attached) that I want to remove any records where AmountChange = 0. I tried setting the criteria on the field to <>0, but I get the "Cannot have aggregate function in Where clause" message. I need to have the Sum of the AmountChange, because I need the difference...
    Posted to Access (Forum) by microsoft on 05-02-2010

  • Corrupt Database - OK to copy code?

    I have a database that is corrupt. My last backup does not include a component that I need to recreate. I can get into the design view of the forms that I need to recreate. Is it OK to copy all the code out of them, and paste that code into my new database? Or can that corrupt the new database?
    Posted to Access Coding/Macros (Forum) by microsoft on 05-01-2010

  • Splitting a single row of data into multiple based on a delimeter

    I have a set of data in Access (table 1) and I need to split it into multiple rows based on a delimeter (table 2). I'm not sure how to do this efficiently in VBA. In the end I need exactly what's shown in the table 2. Help if you can! Table 1: Row 1: Bob, Cow|Frog Row 2: Mark, Swan|Dove Row 3...
    Posted to Visual Interdev (Forum) by microsoft on 04-25-2010

  • Import CSV file to Access - Doesn't import Negative Numbers

    I'm using this to import a CSV file into a table in Access 2003: DoCmd.TransferText acImportDelim, "LOC2010", "T-LOC Current Import", strRPTLoc, True, "" It works for everything except when there is a negative number in the Amount field. Another table gets created with...
    Posted to Access (Forum) by microsoft on 04-14-2010
Page 1 of 8 (78 items) 1 2 3 4 5 Next > ... Last »