Search results

I'm working with a fairly old financial application (converted from '97 to 2007). Unexpectedly, the application suddenly isn't loading and I'm getting a "Run-time error '-2147217838 (80040e52)': Data source object is already initialized." What is going on? This worked a week ago! Here is the...

I have a db with over 87,000 records. Each record has an Autonumber ID. I do not believe any records are missing from the db, but there are some "skipped" or missing Autonumbers. How can I query this table (the only table with Autonumbers) to identify the missing numbers? Thanks ahead of time.

Bob Larsen initially helped me with this report and I hope he is available to look at again. The Director's Report button opens a parameter form requiring a Begin date and an Ending date to query start and end times for employees. This application has run well for the past two months. However...

In previous posts, I have received tremendous assistance from the forum (especially Bob Larson) with respect to generating a report with parameters. Recently, the user imposed an additional requirement, requesting that the specified dates (from the parameters) be inserted into the report header...

I've worked on this with Bob Larson before and I really hope he's around to take another look at this. There is a parameter query for dates (XX/XX/XXXX) that select a fortnight range to generate a report. It has worked before... now it's not working. Also, the form that generates the data is not...

Something doesn't work anymore! Now, I've input correct data exactly as it will be entered daily, the report query isn't getting anything! If Bob is around, would he please look at this. Many thanks in advance.

I have built a very simple Clock In/Clock Out application for hourly employees which records the date and time (General Date format) that they arrive and leave. However, for a report of their time, I need to develop a parameter query that asks for just the beginning date and ending date for the...

How do you concatenate two zeros onto the end of a field, such as 345678 becoming 34567800. Thanks.

I’ve got a six-character text field with values like: 354, 7237, 10438, all values under six-characters long. I need to run an update query to place sufficient “zeros” in front of each value to make it a six-character value. There are 8398 records to change! Got an idea? Please lemme know. Thanks.

I’ve got a six-character text field with values like: 354, 7237, 10438, some three characters long, some four characters long, and some five characters long. I need to run an update query to place sufficient “zeros” in front of each value to make it a six-character value. There are 8398 records...

I’ve got a six-character length text field with values like: 354, 7237, 10438, some three-characters, some four-characters, and some five-characters. I need to run an update query to place sufficient “zeros” in front of each value to make it a six-character value. There are 8398 records to...

I have a table of Inventory items with a field called Status. The various conditions of Status are "Needs Inspection," "In Progress," and "Finished." I need to develop a form with three fields, one for each condition, with each field giving me the total of records for that condition. How should...

:confused: Here's the problem and I understand that a few folks have responded to this already and I appreciate their effort, but the problem is still unresolved. I have a text field in a table called [Address]with data like this: 234 Elm Street (ZIP 2345). In a query, I want to rename the field...

I have an Address field with data like "235 Elm Street (ZIP2345)." In a query, I want to trim off the nine right-most characters, the (ZIP2345). What's the trick with TRIM? I've tried New Address: RTrim([Address],9), but this isn't working. Sure appreciate any help. :mad:

I have an Acccess 97 database application that is uploaded with mainframe data, which in turn relies on LapLink software to upload the data into a hand-held device (6-year old tablet PC). We're going to purchase a new tablet PC which has an USB port on the docking station. Instead of relying on...

I've got an unbound combo control on a form to be used as a name drop-down listing. The "ID" is an autonumber type, the name is text, however, it blows up at use: "Compile error: Variable not defined" on the dbInteger. Any ideas? Thanks for your help. Private Sub cboFindIt_AfterUpdate() On...

I need some code to import a text file from the Desktop and create a table called Invent. How? Thanx

I need some code to import a text file from the Desktop and create a table called Invent. How? Thanx

I need a query to import a text file from the Desktop and create a table called Invent. How? Thanx

Is this the correct code to access and upload a text file from the desktop to the Inventory table in the NEW Inventory Scanner DB file in the Inventory folder on the J: drive? I keep getting a “this isn’t a valid path” violation. Whatsamatter? DoCmd.TransferText acImportDelim, "Invent Import...