Search results

I have multiple text files I link with an import specification. Is there a way to include the file creation date in the data if I link or import these text files. I currently import this data using sql in vba. The data from the linked text files is imported into another temporary table for...

There's no way to determine the original order after it has been scrambled. I hadn't thought of importing it 1st into excel. I'll try that next week. Thanks for the help

How do I add sequence numbers to the text file? VBA? The text file is the output from an application. The format of the file is fixed without a programming change to the application.

I use a macro to import a text file into a table. Each line of the text file contains 1 record. The type of record is identified by the 1st 3 characters (MR#). Multiple records contain related data but the only way to define the relationship is by the sequence of records in the original text...

I have multiple MDB files located on one computer which are used on that computer and others on our network. Until recently I was able to compact any of the MDBs as long as it was only open on one computer. There seems to be a problem with the file locking recently. If I close all open...

I can't think of any way to do this in a query. I think I need to do this in code so I can store a variable from the previous record. I want to create Field2. Field2 in the first record will always be 1. In each successive record if Field1 is "57" I want to use the same Fields2 value in the...

Thanks I don't know if I'll be able to try this unil after Thanksgiving, but I really appreciate the help.

I have a table of every reading of every electric meter. This history goes back a couple of years. Field1 = date Field2 = Meter# Field3 = Single digit code identifying method of reading The same meter is read multiple times in a year. The number of readings in the database is 1 or more (no...

I have an application that creates a backup file of data in an Oracle db as a comma delimited text file. I’m basically trying to reverse the process and take the comma delimited file and turn it into multiple tables in Access with the same field names and data contained in the Oracle DB. I’ve...

Can a function be written to create a field name reference using a variable(s) as part of the name? Example: A=1 B=2 Adding A+B should give the numeric at the end of the field name. I would like to refer to [Field3]. Something like [Field(A+B)].

I think I've narrowed it down to a conflict between access and the printer driver. I remember having the same problem a couple of years ago when updating from NT to Win2K with Office 2000. We were never able to resolve the problem but deleted the networked printer that caused it and used...

Has anyone heard of this before? I have a new XP computer with Office 2003. I can't seem to get reports in Access to work at all. I click on Reports then either design or wizard and nothing happens. I copied an mdb from another computer where everything works and can't run or open reports...

There is only 1 user. The form is normally only opened twice a day. Once when new data is imported form an outside application, and then again when data is exported. Reports are run on both import and export data using the defaults. Occasionally the defaults will have to be overridden to...

I have a form the runs reports based on a 2 values entered manually into text boxes. I would like to set default values for these boxes, but the values change twice daily. I've written a make table query that creates a table with the values I would like (only 1 record). I've inserted a macro...

Unmatched Query Thanks Jon, that seems to work in this situation. I have another question though. What if the value of the linked field matches? It seems that the query is selecting records based on Field1 mismatching and then testing all the other fields for mismatches. Is this right...

Table1 (New Data, Purged Periodically) Table2 (Archived Unique Records from Table1 not Purged) I'm trying to write an Unmatched Append query to populate Table2 from Table1 with records that don't already exist in Table2 Query (Doesn't work) SELECT Table1.Field1, Table1.Field2, Table1.Field3...

Thanks

I’m trying to write an unmatched select query and can’t seem to get it to work. I want to select data from Query1 that doesn’t already exist in Table1. There can be duplicate values in any field, but it should only be selected if the combination of values in all fields doesn’t exist in Table1...

Thanks, that worked. I thought it was probably easy. I looked under Date/Time in the Control Panel, but didn't think about the Regional Settings.

I've written a query that compares a date field in a database to the current date. It works fine on one computer but not on another. The problem is that one computer returns the date with a 4 digit year and the other 2. The date field in the database is YYYYMMDD I've written this to convert...