Search results

Working with a co-worker, we think we discovered what caused the problem. We receive the original Excel file used in this process from an outside agency. They used a different format than in the past. What is relevant to the problem is, they did not use a consistent format throughout the...

They look like they are wide enough. It seems like it rounds off usu. the first 7 digits of the number and changes it to scientific notation. So it ends up with, e.g. 1.87557e+006 . Most of the medical record numbers are only 7 digits to begin with, so this example was originally between 1875565...

The columns are defined as text in the table.

I am clicking a button to import an Excel spreadsheet into a new table in Access, using TransferSpreadsheet. This has not been used for about a year, but before that it was working perfectly numerous times. Now there are two columns which should be importing as text, but are coming out in...

Theprez, It did not look like I had any orphan records when I looked at the table. I could not run the find unmatched query wizard because it was not installed on my machine. I deleted all the relationships since they seemed to be causing more problems. Then there were problems with closing the...

The header table has been pre-populated with partial data for all records. The user clicks a button for data entry and gets a form based on the header table. There is a combobox from which the user selects the case (record) desired. She can then complete the entries in the header. After the...

Thanks for your response, prez. I will try the data integrity thing. I also want to clarify that it is not happening for every record. The user says it is happening for every other record or every third record that is entered.

I have a form which is based on a query which contains 5 tables in a one-to-one relationship (tblHeader, tblPartA, tblTrimester1, tblTrimester2, tblTrimester3). In the query there is a relationship from CaseNbr of tblHeader to CaseNbr in each of the other tables. The form contains a tab control...

I am not sure if I am allowed, although the db does not contain any real data yet. I did get this to work in another db, on the OnCurrent event of the main form. (It did not have tab controls). This time it didn't work on the OnCurrent event either. In the OnCurrent event, I tried to...

dan-cat, Thanks for your reply. It did not work, however. I need to click in the main form to get it to go to the new record. Is there perhaps a way to simulate a click?

I have the following code: Private Sub pgARVTherapy_Click() Forms![frmPartA]![sfrmARVTherapy].SetFocus DoCmd.GoToControl "DrugCode" DoCmd.GoToRecord , "", acNewRec End Sub When I click on the tab (pgARVTherapy), I want to go to a new record in the subform on that tab page, with the...

I have managed to mostly solve this. I have a form to select the Medicaid Nbr and Service Year. Then press a button on this form to get the data entry form. The data entry form is based on a query containing fields from tblInterPatients and tblInterPatientsEntries. (I removed a subquery that was...

I have an Access form which is supposed to look like an existing paper form. The paper form has a header. I have one table which is already populated and contains most of the fields for the header. The Access form is based on a query which enables me to display these values. (Actually the...

I have a combo box, cboFirstAdjTapeNbr. It is based on a field which is text but appears as a 7 digit number. Is there a way that I can enter the number without the leading zeroes and have it find the correct item? I want to do this so the users will have an alternative to picking from the combo...

Thanks Pat (and Jon). It works now.

Jon K, how do you force this to show all the columns with or without data? I got it to work for the rows.

Thanks EMP. It appears to work.

I have 4 status fields in one table. I was wondering if there is a way to list every different value from all 4 fields in one column. Thanks for your help.

Thanks Dugantrain and Pat. I got what I wanted with 2 more layers of queries. One had the count of the count of claims, the next the sum of the count of the count. (The >7 was added as criteria in the original query.)

I have a query that is as follows (all data is from one table): Claims ID - Count Provider Nbr - Group By Provider Name - Group By - Ascending Patient Nbr - Group By - Ascending This will give me the number of claims for each patient number for each provider. I need to get a listing by the...