Search results

Yup, it was somehow tied to that printer. Its odd as everyone else usees the nice copier/printer just fine (same database and reports). I got her back on her older HP 5000 for now. thanks

I'll check. Thanks.

I'm in Houston, next to Katy.

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

On further experimenting, it seems the the graph is displaying 2 months less data per year (weekly data points) despite all data being there and the Design View looking fine. I'm just gonna stick in more weekly dates then it really needs. 8 weeks extra per year displayed seems to work fine...

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

Doh, well I got around it another way. Thanks all.

Since the error only occurs by looking at previous years data then switching to current year, I decided to just Null out the offending fields prior to Calculating which my error code handles. Still have no idea why my IIf didn't want to work.

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

Thanks for your thoughts. I'm not sure what I'm gonna do yet as I'm super busy till after the new year so I'll investigate it more then.

We have Google Apps doing our companies email so we just use their Calender. Its easy to share a calender between an entire company or departments. It would work great for what you are wanting and be in the cloud. Course you would have to move your domain email over to them but getting rid of...

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

Ahhhhh, an ADO issue. These are originally old Access 2000 databases with some ADO sprinkled in them. Now I have a direction to research at least. Thanks

To get my old ADO code to still work when I converted from 2000 to 2010 I had to add an ActiveX Reference. Get in a module, then Tools/References, then check "Microsoft ActiveX Data Objects 2.7 Library". Hopefully it will work for you also. I do not have Office 2010 SP1 installed as it...

I'm confused. Does this mean that I will not be able to have both 32 bit and 64 bit users use the same database in 2010 SP1? I currently have the databases reside in a 64 bit server, should I move them to a 32 bit computer? The KB Article said to simply recompile the database but on my test...

That is exactly the message. The databases do reside on a 64 bit machine but all users are on a 32 bit. During my Office upgrade to 2010 I probably did the Access conversion on the 64 bit machine since we were in transition from XP to Win 7 plus the Office 2010 upgrade at the same time. I do...

The database cannot be opened because the VBA project contained in it cannot be read. Theres more but it wants to delete all code. It may be because I am loading an older VBA library (my databases started life long ago as Access 2000 so some old stuff is in them) and the update did not reload...

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.

Totally work to live. I live modestly so am not worried about alot of materialistic things that other people worry about. Everything is paid for so even if I were to lose my job I could relax for quite a while before I got bored and found another. Work is about 10 miles away and while it is an...

The data is rarely suspect but an error does happen once a month or so and thankfully it is only the specific line that gets messed up not the entire csv. Your thoughts are what I figured I would have to do but I was hoping there was something out there I didn't know about. Thanks