Search results

BACKGROUND: I have an external batch file that is called by MS Access. This backup file makes a copy of the calling MS Access file every time the database is opened. GOAL: What I want to do is now modify the batch file to delete old backups. NAMING CONVENTION: All bacup files are...

It's been more than 10 years since I last needed to solve a similar problem and at that time I did it with VBA. Since holiday dates often change every year, you might need to use a lookup table with pre-populated values. This approach uses 3 steps Step 1: (Here's the very inelegant part) (1)...

This is about as stripped down as I can get it. All records contain bogus information. ________ HOTELS IN MEXICO CITY

vbaInet, There are no linked tables in the DB ________ TOYOTA COROLLA E110

Bob, Thanks for your efforts. I've never been this stumped by an APPEND query before either... ________ Volvo v50 picture

1. DB is just over 10 MB in size - it contains only tables and 1 query 2. All tables are contained directly within a single MS Access file 3. Problem is able to be duplicated after importing the tables and query into a new (empty) MS Access DB ________ MEXICO CITY HOTEL

Can you re-post as an MS Access 2000 / 2003 file? We use MS Office 2000 here. ________ Vaporizer review

yes - when I manually create records in both the source table and destination table the autonumber primary key increments correctly. Just out of curiosity, I dropped the autonumber field from the the destination table to see if it would make any difference. The append query still fails. I've...

When I run the query below I get the following output Is the 00:00:00 result something you see in a query, a form control, or elsewhere? ________ R2

DateDiff(interval, StartDate, EndDate [, firstdayofweek] [, firstweekofyear] ) intervals may be set using the following arguments yyyy Year q Quarter m Month y Day of year d Day w Weekday ww Week h Hour n Minute s Second If you wanted to count days...

You might want to try the DateDiff function http://office.microsoft.com/en-us/access-help/datediff-function-HA001228811.aspx ________ Buy scale

Source table has an autonumber primary key. Destination table has an autonumber primary key. Neither field is called by my APPEND queries. ________ Extreme vaporizer review

I've reviewed a lot of posts about this problem, but haven't found anything that works for me. No matter what field I pick, I am unable to append values from the source table TBMain to the destination table t10_Person. All records intended to be appended are selected only once, and all 22K...

thanks for sharing your code *SMILE* ________ Weed vaporizers

review your code and see if you have error handling in all your code modules. I've noticed that if a function or procedure terminates abnormally, MS Access doesn't always release memory. I have no guarantees that this will help in yoru particular cirumstance. As an aside, I've never figured...

looks like you are missing the closing semicolin in your SQL Statement ________ Crime Insurance Dicussion

I would like to develop a MS Access utility that polls an external Oracle database for new records, extracts and processes information from new records in the Oracle environment. (1) I understand how to build a select statement that will look for records where the auto incrementing value in...

I would like to develop an MS Access utility that polls an 'input' directory for new files. When files are detected, I want MS Access to open the file, extract content, then move the file to either a 'processed' directory or 'error' directory. (1) I'm unsure how to have MS Access poll a...

Opening an MDB in "normal" mode I have some MS Access databases that are shared by several users. There is a need to keep thiese databases in MDB format, but the problem is that users will often open the databases in "Exclusive" mode, and then no one else will be able to use the DB...

Try type casting your string as a variant data type. ________ LIDO