Search results

I have a form that I am trying to setup to click on the button and it opens dialog box to select file, then it transfers/appends the data into an existing table. I got the button to open the dialog box and select the file, but nothing is being added to the table. Can someone please help?

I am trying to get a form to select records from what choice is selected. On my form "Log calls..." there are three choices. The first choice lets you select the "SIC" but the record briefly displays then is replaced by the 1st record. Also I want the drop-down to summarize the choices -...

I have been trying to figure this out and thought it would be a simple thing. I have a query that I need to sum all the fields preceding it. For example I have a calculated field 11/1/2004 that adds the previous fields from 12-31-2003 through 10-1-2004. The problem is when I try formula it...

I have a query with two tables that ends up with duplicates. I'm not sure how to explain, but one table will have multiple types of service for each account, but the other table only has one line for each account. How can I get the data to display all the data but only leave the duplicate lines...

All of my databases are saying I can't export because the object is "read only". I have checked and the database is "NOT" read only. I can add tables, make changes, etc. I just can't export. Has anyone experienced this and knows what the fix might be? HELP!!! texasalynn

I have a form that has a combo box that a user can select an item. What I want is after they make their selection I want it to show a name for what they selected. For example the combo box has a a list of account number, so if they select #14 a text box would show the customer name - ABC...

I have a form with a combo box which is from a table. The table is sorted by the field used in the combo box, but whenever I click on the combo box the data is not sorted. How can I make this sort? :( Thanks . . . texasalynn

I have a query that has a dialog box that opens for the user to enter the data criteria. It is not fancy or complicated just: [Enter CMS number] However now I need to be able if they want multiple choices. For example they want more than one number they would enter 850 or 820 in the dialog box...

Does any one know if there is an issue with Access 97 database created field lengths not converting in Access 2000? I have a field that I created in Access 97: Description: IIf(Left([Invoice History Detail]![HDCUNO],3)="001" And Left([Invoice History Detail]![HDSYCD],1)="1" Or (Left([Invoice...

I'm trying to create a form that will let the user select which query to run from the combo box? How do I do that? Whenever I select the combo box it wants me to pick only one. Do I have to do something else; maybe to put all the query names in a table? As you can tell this is new to me and...

We have a database that we are moving from access office 97 windows 98 to office 2000 on XP. But we keep getting an error trying to open the database that we don't have permission - or not a member of the group - or don't read/write permission and so forth (a list of about 8 things). We have...

I have a query that is using a form to get the user to fill in the blank. But how can I get the query/form to use like a lookup or a drop down box? I've tried making my form a combo box - but the query doesn't seem to incorporate that????? All help is greatly appreciated. Thanks . . . texasalynn

I have a query that sums the amounts by account and that's no problem. But how do I get the same query to give me the total of all the sums? Thanks . . . texasalynn

Forgive me if this is dumb! If there a way to get a join to give the results two tables without a commonality. For example - I have a tables with data for each month. If I bring into a query two tables and want to get all the data with all store numbers. So a store might only be in one table...

I have a field that has data S-TW--S Len=4 ---WTF- Len=3 --T-T-- Len=2 etc I need to query this to give me a "LEN" without the "-". I know how to do this in excel with the substitute function. How do I get this in access? texasalynn

I have a field that has data S-TW--S Len=4 ---WTF- Len=3 --T-T-- Len=2 etc I need to query this to give me a "LEN" without the "-". I know how to do this in excel with the substitute function. How do I get this in access? texasalynn

I need some help with a macro problem. I have a form that has a drop-down box that a user will select what query to run. There is a button on the form that will run the query based on the selection of the drop-down box. ????I'm lost here. I know how to write the macro to run a specific macro...

Registered: Jun 2002 online 06-17-2002 01:57 PM -------------------------------------------------------------------------------- I am trying to get a MAX on several fields in a query so thought I could use: result: Max(Array([CM=PM],[CM=PM w/inc],[CM>0 &...

I have a query with outstanding checks and there are some incorrect check numbers, so I need a way to find the matching amount and evaluate the date the check was written vs date cleared then tell me the check number. I think then I will know how to eliminate that item. Any ideas? Thanks. . . .