Search results

I recently went thru this with my users. The database will never be as fast as they want. Go through your tables and update your indexes. This helped me a ton but I still get a little pausing now and then. If any tables have thousands upon thousands of records, make sure you have filters on all...

Hi there, I an doing a TransferText that is working well. The problem that arises sometimes is when the file I am grabbing has delimiter errors in it. Access is still importing the file but it is not producing an error. I have error trapping in it but it is not coming up with anything...

Ray, I'm totally stealing your avatar.

Any way to turn it off for moving it as well?

Perfect! Thanks a ton.

My question is about Access 2010 and I am coming from Access 2000. In 2000, I could resize a field by tiny little increments. I use Shift+Arrow Keys quite a bit. In 2010 there are no tiny little increments any more for me. It increases or decreases the field size by the grid dots (both...

Ahhhh, Developer Reference is useful. Thanks a ton, at least its better than the online option. I may have never found where to change that by myself.

Finally got the company to spring for Office 2010 for everyone. Coming from MANY years stuck at Office 2000. Upgrading all the databases went better than I expected BUT what is up with help now? Can I no longer longer highlight a word and hit F1 to get a definition of it? Does help just suck in...

I wrote a nice barcode scanning database where I work. I used this font (http://www.free-barcode-font.com/). Install it like a normal font. I have some very old scanning wands but they work well. Theres some nice wireless scanning devices out now. To print out the barcodes I use an old Zebra...

Thanks Bob. I should have thought of that.

I have a 2000 database that just will not convert over. Nothing is open. No one is in it besides me. No linked tables or anything fancy. I'm doing: Save and Publish Save Database As Access Database (*.accdb) I then hit Save As and it asks me if I would like to close all objects. I say yes...

I finally had time to get back on this issue. No clue as to why it is happening as it is not consistent. I think its a bug inherent to Access 2000 and perhaps other versions (I haven't tested other versions for it). As a fix, on the Close Event: I did the following. Me! [listbox1].RowSource =...

Doh! I knew that ... once upon a time ... thankee

Hi, I am creating a text file for importing into the accounting system. I need to combine a few access fields together (else this would be easy) and I will need to limit the total length of the combined Access fields to 100 characters which is all the accounting program will import. The...

Thanks for the offer to help. I need to continue on other parts of the database at the moment but will return to this bug (annoying but not show stopping) when it comes time to fine tune it all.

FYI: This is a workaround. I narrow the cbo so only the right side dropdown box is showing then put a text box next to it so it looks like a normal cbo. Then I do this as referenced in http://allenbrowne.com/bug-06.html You can sometimes work around this problem by placing a text box behind...

Nope. I've had this happen in the past years ago and never could figure out why then either.

Hi, I have a form with multiple listboxes on it. There are 4 listboxes and what you choose in the first one filters the second, choose the second and then it filters the third and so forth. It works perfectly and fast. I like it and the users love it. The problem I am having is when you exit...

Yup, thats the page I found long ago. Couldn't find it this time. Thanks as it gives me some hints at least.

Hi, I am working in a Access 2000 database and I have a few combo boxes where the text is almost always invisible. The text is there if you highlight over it, just invisible. The Control Source is empty as I am using these cbo's in the form header to populate the body of the form via a query...