Search results for query: *

HI, I am receiving an error message to the effect that access is not adding a single record due to a validation rule. My help system is non functional. I looked at the single record and cannot find a unique item causeing it to fail. I also checked the table field definitions and non of them...

I have the following table, where I am trying to select the last record of each ERO number. Obviously selecting Last in the Query by design isn't working. My Help system is dead and the install CD is cracked. Thanks in advance. ID ERO DEF1 DEF2 11506 UP686 410- 30 11507 UP686 TEDD ALGN...

Hi all, I need to insert the most recent instance of a record into another table. Please see below. Thanks. Fld1 Fld2 Fld3 AAA 10/1/01 Pending AAA 9/30/01 Received BBB 11/01/01 Sent CCC 12/1/01 Sent CCC 1/1/02 Lost CCC 7/1/02 Found I would need to insert the 1st...

Hi all, Here's a poser. I have a table that has either 1 or two records with the same info. If I have only 1, then fine. If I have two, then I want to keep the second. example Fld1 Fld2 Fld3 AAAA xxxx nnnn AAAA 1234 3456 BBBB uuuu jjjj CCCC oooo 9999 CCCC...

Hi, I am trying to figure out how to assign a value to a field from a text report. Here's how the table looks once the import is complete. ERO_No Job_Status Job_date XP001 INSHOP 8/1/02 BACKORDER 7/1/02 RECVD SHOP 6/30/02 XP002 RECVD...

Hi, I am trying to figure out how to assign a value to a field from a text report. Here's how it looks once the import is complete. ERO_No Job_Status Job_date XP001 INSHOP 8/1/02 BACKORDER 7/1/02 RECVD SHOP 6/30/02 XP002 RECVD SHOP...

Hi, I am trying to figure out how to assign a value to a field from a text report. Here's how it looks once the import is complete. ERO_No Job_Status Job_date XP001 INSHOP 8/1/02 BACKORDER 7/1/02 RECVD SHOP 6/30/02 XP002 RECVD SHOP...

Hi, I am getting a VBA syntax error on this line. Any ideas why. Please be nice I am a learn as I go kind of guy. :) TIA -- Rap DoCmd.RunSQL CREATE INDEX PrimaryKey ON ROOTCOPY (ero) WITH PRIMARY UPDATE DISTINCTROW root000 LEFT JOIN rootcopy ON root000.ero = rootcopy.ero SET...

Looking for advice / opinions. I am finishing up 22 years in the Military and have only a few hit-or-miss IT training. But, as a consequence of duties: I have learned to used MS OFFICE 97/00, program in Lotus Notes, MS ACCESS, HTML. I can whip out high class powerpoint like it's cool (and...

Howdy: My employer puts a julian date on all reports. I need to be able to convert the julian to normal date. In order to get an accurate day count between the Julians. For example 2102 = the 102nd day of 2002, 9102 = the 102nd day of 1999. Here's what I came up with, does anyone have a less...

Hi All. I have a real brain buster here. It's complicated so I am not looking for a solution, more like advice and iff possible internet resourses for learning. My database is for equipment serviceing. I receive a multi-line report from the mainframe daily in the form of a .txt file. It...

Hi All, Not sure if this posted the first time. If it did then I apologize in advance. -- Rap How do you break apart a big field. I have a text field that is 133 characters wide. What I'd like to do is run a query or code to take the contents of 1-10 and put them into another field in a...

HOW do you paste a crosstab query into code? I copied the SQL view and then pasted the following into an OnClick. VBA hated it. All other SQL pasted worked awesome. BTW I deliberatly mangled the docmd.SQL in order to prevent someones machine from calling it a suspect script. DoCmd.RanSQi...

Hi All, How do you break apart a big field. I have a text field that is 133 characters wide. What I'd like to do is run a query or code to take the contents of 1-10 and put them into another field in a different table. Then repeat with 11-25, etc. All help appreciated. Thanks. Rap

Hi All, A friend asked me how to import via code. I told him all about transfertext and the associated import spec. Then I got curious and tried it. But when I tried to find and print the import spec to copy to another .mdb I couldn't. Anyone know where access hides these things? Thanks...

Hello All, I have two tables (one is "Work", one is "parts"). The work table focuses on vehicles and the parts table tracks parts ordered for each vehicle. Each Work order has a priority assigned. Each part has a priority assigned. The priority of the part is always equal...