Search results

Hi, I have a weird margin error going on for a single user of a database which gets used by quite a few people all day. The error is that the margins specified for the report(s) are just a tad bit off for this user. They are fine for everyone else. The margin error user just recently had this...

This is on Access 2010 and graphing still sucks ... Just trying to do a line graph. My X Axis just will not auto space itself for the available data meaning it is showing most of the data (on the X axis, Y axis is fine). Theres tons of room as the space between X data points can be shortened a...

I know, I know, you cannot divide by 0. Its ok if you rolled your eyes at the title. I have this: Me![Mar_8] = IIf(Me![Mar_1] = 0, Null, Me![Mar_7] / Me![Mar_1]) It is still giving me a divide by 0 error. Mar_1 is indeed 0 but it seems to be skipping the Null and still trying to do the...

Hi all, Access Drivers - 32 bit and 64 bit Can they coexist on the same 64 bit computer? I have a ton of databases made in 32 bit, some pretty old. Now we have 2 new computers running a special CNC program that needs to be on a 64 bit. Not a problem except something in the program produces an...

Be careful, I installed this on my local machine to test and am getting some VBA errors immediately. I hope the uninstall works well. Not sure what has changed for us but time will tell. edit: Uninstall still gave me the VBA error but doing a System Restore seems to have got me functioning again.

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

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

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

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

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

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