Thanks Marcus,
I was thinking the same.. the macro hotkey in Access that will put the form value into a temp table which MS can easily read.. all called from MS... easiest solution to implement and as you say 'simple' .. awesome!
Search found 6 matches
- Thu Feb 14, 2013 6:45 am
- Forum: Technical / Scripting
- Topic: Accessing a Form field from Microsoft Access via SQL
- Replies: 5
- Views: 9296
- Mon Feb 11, 2013 1:40 am
- Forum: Technical / Scripting
- Topic: Accessing a Form field from Microsoft Access via SQL
- Replies: 5
- Views: 9296
I tried to open the Microsoft Access Macro, but I really need to be able to open the macro from within an already open database, since the form needs to be open... the challenge is that running macros from the command line opens a new instance of Microsoft Access which defeats the purpose. The alter...
- Sun Feb 10, 2013 6:12 pm
- Forum: Technical / Scripting
- Topic: Accessing a Form field from Microsoft Access via SQL
- Replies: 5
- Views: 9296
Thanks Marcus! There are several scenarios. 1. A user uses a hand held barcode scanner to scan in a barcode - which is the ID that searches for an item. I'd like to capture that ID at some point and paste it into another program ( a photo program called NKRemote) and put it in their comments field a...
- Sun Feb 10, 2013 8:18 am
- Forum: Technical / Scripting
- Topic: Accessing a Form field from Microsoft Access via SQL
- Replies: 5
- Views: 9296
Accessing a Form field from Microsoft Access via SQL
So far so good with ‘basic’ connections to my Microsoft Access database and SQL statements, but I could use some help in referencing an active form field from Microsoft Access. The queries/SQL returns the correct values within a query in Microsoft Access but not when done within MS, not at least...
- Sun Feb 03, 2013 2:44 am
- Forum: General Discussion
- Topic: Windows 8 Shortcuts Utility [105 Useful System Shortcuts]
- Replies: 9
- Views: 14657
- Wed Jan 30, 2013 6:54 am
- Forum: The Water Cooler
- Topic: Anyone tried Windows 8 yet?
- Replies: 9
- Views: 15791
Anyone tried Windows 8 yet?
Sorry Marcus, Been on Win 8 for a couple of weeks now, loving it. Start Menu = Start Screen. Organised a clear. I like it a lot. Performance - Great. MSched - Working as expected. :) I agree with Phil.. it is by far the best operating system I have worked with along with Windows Server 2012 ( amazi...