Recent content by mikebrewer

Hey guys, Thanks for the replies. I probably should've clarified but I'm looking to be able to read the data from the barcode/qr code into the database. I have a few different uses but one of them is to scan the barcode of an inventory item and read the part #. another is to scan a qr code...

Hi all, I've been googling for this solution but to no avail at this point. I have a bunch of Windows tablets and some applications using MS Access. All of these tablets have cameras so I am looking to see if anyone has integrated a camera to scan QR or 2D or even regular bar codes into the...

Well... I've tried messing with the registry in about 1000 ways but regardless of how I set it, I can't get it to work. I try setting a key to force access to render the browser as a new version...

Hey Eric... have you found an answer to this by chance? I'm trying to do something similar and I continually get an error on google's side on onion.js and I'm beyond stumped. (nothing like being 2 years late to your original post)

Hi all, I'm trying to integrate google maps into my database through a WebBrowser activeX control on a form. I have the form built, I have the web browser object on the form. I then have a html file that I call to load the map into the browser control. Upon loading the map, I call a function...

I think you were right! I have to do some more testing and have a phone conference to attend but so far it looks good!! Thank you for your help!

ah, I'll give that a try. I'll get back to you!

and I'm afraid of writing this: SELECT table.* FROM table WHERE (((table.ApptStart)<=#4/14/2016#) AND ((table.ApptEnd)>=#4/14/2016#)) OR (((table.ApptStart)>=#4/14/2016#) AND ((table.ApptEnd)<=#4/15/2016#)); In this case, I don't think I'm going to get anything where the appointment starts...

The reason that doesn't work is for appointments that start and end on the same day. So using this: SELECT table.* FROM table WHERE (((table.ApptStart)<=#4/14/2016#) AND ((table.ApptEnd)>=#4/14/2016#)); yields a bunch of records, except ones where say the apptstart = 4/14/2016 11:00 AM and...

Okay guys, apparently I've just got stupid but I can't seem to solve this one... I'm trying to query a table that has an appointment start date and an appointment end date (ApptStart & ApptEnd, respectively). I'm trying to write a query that would select all the records that would fall on a...

it seems to be more prevalent on forms where I have drop-down menus. This means that the form has multiple tables it is referencing. the record source may be only one table but I may have 3 or 4 fields on that table that are keys on another table. The example is the Customer Order Form...

So I did all that and on some of the tables, it will still show fragmentation. I also noticed that the forms that are slow are forms where I've got drop down menus and such that are linking to other tables. For example, I have a form that loads that has a kind of complex query, but not...

Wow... that was pretty nice. Thanks for the info!

Hi all, I'm trying to start a mail merge from Access to a pre-defined template in Word. I have the template built. Here is my code: Set oWord = CreateObject("Word.Application") Set oWdoc = oWord.Documents.Open(wdInputName) ' Start mail merge...

Hey guys, I have a form that loads with a list box of names. The names have an associated ID number that is not shown in the list box but when the user chooses one of the names, I'm saving the list of their selections (ID #s) to their user profile so that I can reload the form with the same...