Recent content by VBA-Dummy

:D :D Mine says "Access World Forums - Reply to Topic - Mozilla Firefox" :D

You guys are great, hands down! Paul, You are correct assuming rs.filename is what I'm after. I got a compile error with that, but with taht example, I FINALLY get the idea, Duh!! DLookup("[LOADER]", "querysystemstable", "systemid = '" & rs!FileName & "'") Wayne, You've outdone yourself. I...

Thanks for the fantastic lesson Paul. I suppose all of you feel like you're beating a dead horse by now. Thanks for your patience!! Here's a sample of the tables and query being called on from this Sub: I tried changing around the Criteria = and ended up with runtime errors. Uggg.

I guess I'm confused. "systemid" IS the value I want to lookup in "querysystemtable", field LOADER is the value to return. In that query, the text for systemid should be found in the first column, it's there. I'm old school Excel, maybe I'm rationalizing in the wrong terms? I'll go ahead...

Spoke too soon... Had to move around and rename some code to make sense. Sub RunLoader01() Dim cn As ADODB.Connection Dim rs As New ADODB.Recordset Set cn = CurrentProject.Connection rs.Open "SELECT * FROM LOADERTABLE01", cn, adOpenStatic, adLockReadOnly rs.MoveLast Dim systemid As...

:D :D Hey Wayne, Your solution works perfectly. Wound up using a slight variation with single quotes for text fields. U R da man!! Thanks again.

Thanks Wayne, I'll give that a shot Monday, California Time. I didn't realize a solution could look so simple. The Shell is working now, so I suppose the syntax is correct. I need to study that "Me. " usage, I'm seeing that alot in these posts.

This project is a firmware loader for a programmable speaker system. It calls an Exe, and a /parameter using System data scanned by barcode on a form, the form runs Sub RunLoader01() Sub RunLoader01() Dim cn As ADODB.Connection Dim rs As New ADODB.Recordset Set cn = CurrentProject.Connection...

That Sucks !! I don't get in here very often, but my first instinct is to "search" when I have a problem. Your older posts may have solved my current problem..... :rolleyes:

Holy Crap!!! It's that simple??? I've been dickin around with this thing for hours! Livin' up to my handle here :rolleyes: Thanks PB

I have the SKU/SERIAL# barcoded in code39 as well for an assembly operator to scan with a wand, into a database table. Some marketing genius came up with SKU/SERIAL# as one string seperated by a frontslash "/" however, some SKU's also include at least one frontslash. The SERIAL# is always the...

I did something simillar in Excel, but I couldn't begin to tell you how to make it applicable to Access. I'll paste it here regardless, maybe it'll give you some idea of how to proceed. Sub AddOmslinks() 'Operation Method Sheets Sheets("Index").Activate Range("A7").Select...

Thanks very much folks. i had to move the ) too. It works perfectly now!!! :)

Thanks GoldFinger. Dim Command_String works fine for "copying" the data in the fields. However, I can't seen to get the syntax correct for "pasting" the command_string into the Shell statement. If I set a breakpoint over the Shell statement, and run in the Immediate window: ?Command_String...

Lot's going on here, summary: Please excuse my ignorance.... Make table query concatenates three table fields to a new field. F1+F2+F2 = "F1F2F3" in a new field. I need to get that concatenated text string and pass it along as a parameter in an executable. I figure RecordSet is the correct...