Search results

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...

Sorry I haven't gotten back to this, I had some meetings today. It looks like I have some heavily fragmented indexes. I need to run the rebuild but unfortunately, I have to do that offline as I don't have the enterprise version of SQL. i'll try that out tonight and see if that helps or not...

Gotcha. The tables get built from a snapshot of the database that lives in SQL Standard on the main server. It is a replica. So if you were to go into SQL Management Console on the client (I installed the SQL Express version that includes the Management studio), you will see the same data...

Yes, the database originated in SQL Standard (originally 2008, recently upgraded to 2014) and then was built into a SQL server Express on a client by using SQL Web replication (merge replication). If the client runs Express, its slow as molasses. If I install SQL Standard, runs like a champ...

Hey guys, Hopefully not a dumb question here but I'm having difficulty understanding something with an application setup I have going right now... I have an application that has a database behind it of roughly 500 MB in size. Not really big. I have a bunch of clients that I want to have this...

The problem with that is that as soon as you would've gotten that error and the silent property is set to true, the map becomes essentially useless. You can't scroll on it or zoom or add markers, etc.