Recent content by schweer

Thanks Modest, I'll do a search. Feel free to lock/delete this thread. If my question is not answered, I'll post a reply or a new thread. Thanks again. -Matt

Howdy: I know little-to-nothing regarding VBA, syntaxwise, so bear with me. Here's what I need to do. I'm running Access 2000, first off. I've got a file that's processed and needs to be exported to Excel for report purposes). In certain cases, the file may be larger than the 65535 record...

Both of my problems have been solved. I'm sure, after the trial next week, I'll be back with some more questions. Until then, my problems are solved. Thanks again! -Matt

Thanks so much Scott. The query worked flawlessly. I'm fully prepared to donate my first-born to you. I've been stuck on this damn query for 2 weeks. I can now finish my project. Thanks again, Scott. I appreciate it. -Matt

Thanks for your input, Scott. I'll post up my code; see if you can identify any errors in it. DELETE [MasterFileEdit].[OID], [MasterFileEdit].[SystemLoc], [MasterFileEdit].[SystemPN], [MasterFileEdit].[Location], [MasterFileEdit].[Part_Number], [MasterFileEdit].[Qty]...

In ??? Can a DELETE query utilize the IN keyword? I think the way to get this done is by using IN. If it works, it will simply delete all records from the Masterfile that are IN the TempTable. Since the TempTable is a linking table to a hand-held scanner, I believe that would work out. Or...

I'd like to learn VBA for use in both Excel (majority) and Access (a little). I'm familiar with SQL, took C++/C# a couple years back, and am currently learning SAS, so I don't need a 'Teach yourself in 24 hours' or 'Weekend Crash Course' type. Reference book series that I currently have that I...

Thanks Wazz Thanks Wazz. I guess you really need to do those steps in order. I kept trying to check Datasheet view (most of the time, that represents the query results) but that didn't work. After updating, it worked flawlessly. I added another query to remove that leading space. Btw, could...

With an update query, what do I use in the SET statement? Here's a rough sketch of the SQL: Update CompletedWork Set Part_Number = ?????????????????????????? Where ????????????????????????????????; Where does my logic go? Yeah, the parsing isn't 100% correct. I can't find a way to handle the...

Here are some sample part numbers: Part_Number 4D6742 8N1545 10R0969 4V9901 AAAAA -- 0R9910 XAAA.1411020 AA-- AAAAA --2376324 XAAA.1776113X AA00 1712215 6T6504 AAAAAM --2287609 1441451T Empty AAAAA -- 7N8139 2322415= XAAA.1243333 AA-- AAAAA --1862776 7G7678 1741098E...

The Meat & Potatoes data can stay the same; I'd prefer it to remain unchanged. Basically, I need to take the PNs found in a column of a table, run a query that takes off unneeded characters, and insert these new part numbers back into the table. I'd like to try and do this WITHOUT altering the...

Hello again. I've got a query that takes a part number, strips off the un-needed prefixes and suffixes, and gives me just the meat & potatoes of what I need. I'd like to insert these results into a particular column in an existing table. Say the column name is Part_Number and the table name is...

I appreciate your help. I'll give that a try.

Yes, as I mentioned earlier.

I can get the delete query to select based on Area, Aisle, Upperlower, Oddeven. That's not the problem. The problem is getting the correct section numbers, which is why a TempTable might just do the trick but I just can't quite get it to work out.