Search results for query: *

dBforums > PC based Database Applications > Microsoft Access > Compairing tables for duplicate records and increment LinkBack Thread Tools Search this Thread Display Modes #1 (permalink) Today, 00:40 osimini Registered User Join Date: Jun 2008 Posts: 23...

Please I need a help with issue reated to problem I am having with my report to have subreport to pull or report only data related to common providerId in main report. I have Main report called rptFacility with ProviderID identifying a particular facility. Also, I have 2 subreports in the main...

i have a table called tblLocation with LocationID as the primary Key and a query called qryLocationTotal with LocationID and TotalMembers.Both the table and the query has LocationID as linkage. I designed a form called frmLocation with tblLocation as the source table. In frmLocation I added an...

Please can somebody help or direct me on how to solve this problem with duplicate address A suitation where a provider_ID have two addresses in the same address, one with suite number and other without suite number. I want to issolate or remove the duplicate address without suite number. I have...

Please can somebody help or direct me on how to solve this problem with duplicate address A suitation where a provider_ID have two addresses in the same address, one with suite number and other without suite number. I want to issolate or remove the duplicate address without suite number. I have...

Please can some help to direct or point me to on how to solve this problem. This is probably a simple problem but some how i am lost. Pasted below are two tables. Table 1 is now the data is now and table 2 is the expected result. I want to group the fields T_Code and G_code by ID. All to be in...

Please can someone help or guide me to resolve this problem. I have an access DB called "Monthyly.accdb". Monthly.accdb resides in the directory "\\Camp\public\Provider Network Relations\". I do not want to be going to the user work place desktop to install the application any time there is a...

I want to use VBA to compare two tables and write out the field where there is no match. "Table A" is the main table and "Table B" is the varying table. Meaning to compare "Table B - fields" against "Table A - fields" to produce no match report. The reason that I want to use vba is because it is...

Please I need your help. Will it be possible to run multiple qction queries from a single button. For example: from open query -> make query -> query to group or sum data -> Report. I will appreciate any suggestion or help. Thanks

Headache I have been trying for 2 weeks now to to get this to work no success. I have tables for E, Cases, CaseEvents, Customers and Reminder. I have created a form frmCustomer as mainform.Then another form frmCases. Also created two sub forms called: sfrmCasesEvents, fsubReminder...

Is there any means or possibility of importing or converting word form to access form. Best yet using word form as a data entry form and access as a database. Thanks for your help.

How can I write a structured English Pseudocode for matching two – to extract matching data record from the table called “tblState” to update called tblCity. Below are the fields. I wan to extract NPI number from the tblState and update into tblCity. I am looking for Pseudocode for (a)...

I want to be able to disable groups of radio buttons on the MSAccess form if one of the “Upper Case” radio button in Fram_1 is checked both Frame_2 and Frame_3 disabled. The code I have seemed not to work. I must confess that I have done everything possible to get this working. Please I need...

How do I default userid or systemid to track who made changes to table or which employee data entered particular record or records. I am lost on how to do it, please

I have Combo box in a form as a search criteria to pull customer information from the tblCustomers and populate the form. The combo box populates the customer names and works as required. But my problems now is how to filter the combo box to populate only the customer assign to a particular...

I have Combo box in a form as a search criteria to pull customer information from the Customer information and populate the form. The combo box will populate with the customer name, but will not populate form with customer information, rather what will appear in the form is the first record in...