Search results for query: *

Is there a way to make a counter in a query so that each record is numbered sequentially? 1,2,3,etc. There is no need to store these values. It is used as a reference to export data to a comma-delimited file that I have to upload to another piece of software. Thanks, Eric

I have a SQL Server table that I am linking to via ADO. I have to use ADO because the table has 500+ fields. I have a SQL string that selects the 162 fields that I need. What I now need to do is import the data into an Access table that I can use as the record source for a report. (Access...

I have a table in the back end of my database that is stored on the server. When trying to delete a large number of records I am getting the error "Could not update; Currently locked." The most records that I can delete at one time is 241. Any more than that and it will error out...

Is there a way to turn off the security setting that prompts you to verify if you want an external program to send an e-mail through Outlook 2002. The warning: A program is trying to automatically send email on your behalf. Do you want to allow this? Thanks for any help. Eric

Is there a way to trigger an event, using the built in navigation buttons, when previous or next is clicked. I am trying to make a field (TextBox) visible or invisible based on the value in another field (Yes/No). However, the field remains visible on every subsequent record until the Yes/No...

Does anyone have any experience using the xlDialogRun dialog box? When I run certain macros from this dialog box it runs them twice. Any help will be appreciated. Eric

Is there a way to return a character's position using VBA? For example, I need to find which position "}" is in the string "asdfasdf}asdf". Thanks, Eric

Is there a way to delete the active record in one form by clicking a button in another form (pop-up).

I have a data entry form with records that have some fields already populated. I was wondering if there was any way that I could check to see if any original data is in the record and deny deletion of that record. I want them to be able to delete records that they have added. I've tried the...

Has anyone written a check to a Customer? I can't get more than one distribution line on a check written to a customer (for a refund). I would appreciate any ideas on the subject. Thanks, Eric

Does anyone know where and how the current posting period is stored in the PeachTree tables? I can't seem to find table definitions for the General_GL table.

I can connect to every table but the Customer, JrnlHeader, and JrnlRow tables. I get an ODBC error when trying to link to the customer table. I can link to the jrnl tables but the data just shows #error in every field. Has anyone seen this before? Win2K OfficeXP

I have numbers in a column that are all divisible equally by 250. I need to convert these numbers into a number that is divisible equally by 400 but that is never lower than the original number. For example the numbers on the left should convert to the numbers on the right. 250 400 500 800...

I have a worksheet that imports data from our accounting system. The range is automatically named "GeneralLedger" and it grows ro shrinks as it is updated which is what I want. However, on a separate sheet I am using formulas with references to the "GeneralLedger" range...

Does anyone know how to selcect non adjacent rows depending what is in the first cell of that row. For example: if a1=0 then select the entire row then if a2 also equals 0 then select that row also. then if a3 does not equal 0 don't select that row, etc. What I was trying to do was create a...

I know there is a way to append tables in databases other than the one you are currently working in. But is there any way to append a table in the current database from data in a another database. Linking tables is not an option. Thanks, Eric

I have a database that copies a table before a delete query runs. What I would like to do is be able to reload using an append query to repopulate the table that was deleted. The problem that I am having is that the user needs to be able to choose which backup table to reload. For example: I...

Is there any way to change the status bar message while a query is running. I can use syscmd to set a message but when a query is running it doesn't work. I just want to change the words "Run Query" to something else. Using Access 2002

I have tried without success to create code to select all values in a list box but can't seem to get it to work. I can loop through selected items but don't know how to loop through all the items in the listbox.

How do you make an vb application close?