Getting Started
in [Access]
|
Create a query to merge records with two fields as criteria I've got 2 tables, one with company locations/addresses and another with contacts for the company. Table 1 has an ID field for the company name and and ID field for the location (for that specific company). Table 2 has each contact's name with the ID fields for company name and location. For instance, Ajax Co... 5 Mar 2010 15:06
Split Form with need to Provide Selection List We have an Access 2007 application that has a split form (built on Table-1). We now need to add some type of facility that will allow our users to view data from Table-2 (while working on the Split form based on Table-1). They will then select one row from Table-2 which will contain 6 fields which we need t... 3 Mar 2010 22:01
Can access work with multiple FX rates? I have to produce a monthly report that uses employees data. The yearly salary will be in local currency and I will need to create a query (and a report) to divide the salary by 12 so I get the monthly gross salary and each month I will need that monthly figure to be calculated in USD. But the FX will change on... 2 Mar 2010 13:34
Tab control within a tab control Hi I have created a Case Management Database which has 5 themed sections: Personal Information, Personal Assessment, Personal Plans, Case Notes, and Other. I also have created almost 30 forms dealing with different information that must be collected on each participant. Withing the Personal Information t... 25 Feb 2010 01:30
application help I am a new Access 2007 user. 15 years in auto repair and another 20 in fleet management. I am developing a fairly extenisve fleet management program. My question is how do I put the information useful to mechanic's in a file which can be accessed by F1 (helP) ... 25 Feb 2010 09:09
Font Colour Can I change just one row in a query depending on a check box. If the check box for a record is true Is it possible to change the font colour to red just for that one row/record Access 97 ... 24 Feb 2010 14:18
Importing from Excel When importing from excel into downloaded assets template from Microsoftgetting error message F16 doesn't exist in table assets - F16 in excel is a blank field - I've tried clearing the field and deleting the row but still get the same message. ... 24 Feb 2010 12:01
Need help sending mail! Can't send or receive mail due 'POP3' is not working for me. Glen... 22 Feb 2010 15:19
Query Problem Hi, I have this query but is not working. SELECT BKAR_INV_NUM, BKAR_INV_SONUM, BKAR_INV_INVCD, BKAR_INV_INVDTE, BKAR_INV_CUSCOD FROM BKARINV WHERE (((BKAR_INV_INVCD)=' ') AND ((BKAR_INV_CUSCOD)="SCOENE0100")) OR ((BKAR_INV_INVCD)="X")); I need it to show all records for SCOENE0100 that the BKAR_INV_INVC... 22 Feb 2010 15:19 |