Recent content by Smack

How about just creating a new record by copying a record from an existing record, but aalowing for the next auto number?

Anyone??

Anyone??

I also show this under the Office 10 environment faults Event Application Failure Application msaccess.exe Version 10.0.2627.1 Module msjet40.dll Module Version 4.0.6218.0 Offset 00029fb2 Date 10/27/2003 9:14:28 AM

Good morning all, I have looked in the help menu and checked the FAQ's here but cannot find any info on the fetch defaults property listed under the data tab of a forms properties. Any idea what this is or what it does? Thanks, JRS

Over the past couple of months, one of my systems which has been very stable over a long period of time has been generating a lot of errors which require a compact/repair to fix. Easy enough done in 10 secs or so - big trouble is getting everyone off. (Mettings, breaks etc) I recently found a...

The problem I seem to have with this is that the id is an autonumber, intrying to automate this to copy over I ge a fault because it is trying to enter the id into the new records field thereby creating a duplicate value.

Just using a standard update query.

From ISO EXTRUSION MANUFACTURING PROCESS (REVISED) To Extrusion Manufacturing Process Results in an improper syntax error message because it sees the parenthesis as an access formula is my best guess.

ISO EXTRUSION MANUFACTURING PROCESS (REVISED) ISO Form FM20310 (boxed resin) Are a couple, I also found this one 1.0 New Hire "on floor" Orientation Don't know if the "" will make a difference or not. Thanks for the response -JRS

TSA 10/22/03 rcr02 iac-02 are just a few examples, after looking in the table, things are so inconsistent I don't think it will work. Thanks for the response.

Good morning, I am trying to straighten out a canned training mdb from the back end that got buggered from a lack standardization from the outset. There are 465 training records (training type) There are over 10,000 of the above in the employee training table. I have re-configured with the...

Hello again, I need to archive some old records, my only problem is that in the date field was set up as a text field and people have their initials next to the date. Any way I can run a query to still show dates prior to 12-31-2001?

Hello everyone, (I must preface this with my "I don't know how to write code or SQL" statement!) I have a form with 5 subtables that someone else developed. The Master Item Table has an auto number MasterID feild, with the others linked as child in the forms. I want to create a...

Parameter as in a select Q prompting you to enter info? Don't know anything about nesting. I am updating 4 fields at a pop and 2 tables. Example, training table has 425 records, 3 fields get updated. Employee training table has the training title in it, this has over 10,000 records. Updates =...