Search results

I've tried everything I can think of and can't figure this out. This works when RUN from SQL view: SELECT PartID FROM Inventory WHERE [Barcode]=#2014-02-13 02:20:42#; It returns the correct record. This returns a syntax error: SELECT PartID FROM Inventory WHERE...

Awesome! Robert

Will change TimeValue, but it's not working for Date either. I can get it into a string, but as soon as I start trying to change it into a date I get mismatch (of course, it's a string). That's why I had tried to convert to number (used longs), but then I had overflow errors. EDIT: Oh yeah...

I always prefix variables by type. This is whatI used: Dim strScanByte As String Dim strDate As String Dim strTime As String Dim lngDate As Long Dim lngTime As Long Dim dateBarcode As Date Dim timeBarcode As Date Robert

Saga details here starting at post #7: http://www.access-programmers.co.uk/forums/showthread.php?t=220916 Short version: Android phone, TEC-IT free barcode app, bluetooth dongle, Win XP, Serial Port Profile, Access 2002, MScomm32.ocx. Refer to line #1 previous post, received in strScanData...

I am having a similar problem getting my dates handled properly despite reading a bunch of threads here and other forums. The goal is to get txtScanPart (a string textbox containing a scanned DateTime barcode) into txtBarcode (a general date textbox to be used in query against DateTime field)...

I guess I might as well show this panel: I'm pretty sure you want an app that uses Serial Port Profile, enable it. The first app I had tried did not have this feature. And that's likely why it received a file manually in Bluetooth (RFCOMM), but not in MScomm32 (SPP). The protocol layers...

When you reboot the next day and nothing works, make sure to check this: LOL The ports had been rearranged by windows. You want to read the OUTGOING port from your Access form, not INCOMING - that will only cost you hours of frustration. It is read outgoing from phone. So in this case...

In case it helps someone. This is my code to trap incoming data from my android phone via bluetooth over SPP using COM2: Option Compare Database Option Explicit Private Sub Form_Load() MSComm1.PortOpen = True ' Open port End Sub Private Sub Form_Unload(Cancel As...

SOLVED! Turns out it was the app. I tried another one that mentionned bluetooth and SPP and it worked on the first shot. Now I know why that first app was feature rich and without ads. That payware SDK was for more than customizing the app to your liking, it probably was so you could...

SOLVED! Go to post #12 if you don't feel like reading this. I noticed something in Device Manager. COM2 is listed as a Standard Serial over Bluetooth Link. To me that would mean that the PC-side is standard serial communication and the device takes care of the bluetooth handling. I checked...

SOLVED! Go to post #12 if you don't feel like reading this. I think I figured out what's wrong. I'm missing a whole lot of "stuff" going on in the background to manage a bluetooth communication. That little Bluetooth icon on the task bar does a whole lot more than just listen on a COM port...

SOLVED! Go to post #12 if you don't feel like reading this. After finding this: http://www.access-programmers.co.uk/forums/showthread.php?t=143399 My code is now down to this: Option Compare Database Option Explicit Private Sub Form_Load() With MSComm1 .CommPort = 2 '...

SOLVED! Go to post #12 if you don't feel like reading this. I've been fiddling with modCOMM since yesterday so today I moved on to MScomm32.ocx from here: http://support.microsoft.com/kb/194922 I made a new form with TEXT1, added MScomm32.ocx and tweaked sample code without any of my other...

SOLVED! Go to post #12 if you don't feel like reading this. I'm also having problems receiving a file using modCOMM. The barcode scanning app on my android phone sends a fixed 150 bytes. I can receive these using the Receive File feature on the Bluetooth icon so I know the connection is good...

(see post #2) Don't you hate typing a reply at the same time as the other guy? Thanks anyways. I added the code later to help the next guy. Robert :)

SOLVED! http://superuser.com/questions/106848/batch-file-that-runs-cmd-exe-a-command-and-then-stays-open-at-prompt If only they all went like this one. Private Sub cmdListPorts_Click() On Error GoTo Err_cmdListPorts_Click Dim stAppName As String stAppName = "cmd.exe /c " & Chr(34)...

Hi, I need to execute a specific panel from the bluetooth icon on the Windows XP task bar. Tim Fisher over here: http://pcsupport.about.com/od/tipstricks/a/control-panel-command-line.htm shows how to use Command Prompt to open the Bluetooth panel: control bthprops.cpl I tried it from the...

I had started with a single Spec table 'cause that's how I learned too many moons ago, but I got lost along the way in Access. I relearn Access every time I use it every 5-10 years, never getting completely comfortable with it. This is the furthest I've been. I'm the only user and it's for...

SOLVED! After reading countless threads, trying a gazillion combinations, SQL...WHERE would filter properly, hardcoded FILTER on the form would not, so I knew I was on to something. It was a combination of syntax (needed brackets) and setting filter flag. Why I have to set the flag is...