Search results

Just wanted to let you guys know. I created a fresh database, imported everything from the one I was having issues with and was able to save it as a 2007, 2003 and 2000 and it appears to be working ok now. On all machines, lol... The only thing I will need to do is go through every single...

ok... to VbaInet, I have questions about putting db in the forum. to RedDwarfs post. I will need to figure out why I couldn't get these file save options under the save database as option, but following the instructions you gave I got the following message. This was saving from 2007 to the...

The file extension is .accdb

That is one of my problems, I only have one Save As option, it won't allow me to save as another version. The database is saved as a 2007 DB. maybe I should try re-installing Access itself?

hee hee.. yes.. that was the first thing I tried. I also tried to a compact/repair and then re-copying it and it still doesn't want to cooperate. I will be picking up a patch cable when the store opens to see if I can open the file that way. But I have to turn the DB over to the PM before the...

It did not work. But if it was corrupt, why would it allow me to still open it on the other machine?

I am hoping someone can give me direction on how to fix this. I am creating an Access 2007 database. Every now and then I have to save the database to version 2003 in order for other people to use it. Today, when I went to do the File, Save As to select the older version, the option wasn't...

ty for your patience and helping me to see how tired I was. I should have known that.

I did that in the beginning, but the description never showed. I only went the direction I did because I couldn't figure out how else to get the description to show

I am trying to work miracles, lol Actually this query was working great until I seperated the tables and needed to put the join in. I only seperated the table because I am getting a code passed from an sap system, but the people want an explanation of what the code actually represents for the...

I have two tables I am trying to join and most of the records have null values in the field I am using to join. I am getting an error: Reserved Error(-5500);there is no message for this error. Here is the SQL for the query TRANSFORM Sum(tblCSLData.QTYOrdered) AS SumOfQTYOrdered SELECT...

Got it. Thank you so very much!

My brain is fried I think... I thought I could easily do this by using an if statment and referencing the field on the report, but I get an error 2424 "The expression you entered has a field, control, or property name that Microsoft Access can't find." I wont be able to do this will I? At...

phew.. thought I was missing something, lol. Thanks.

odd.. I don't see shapes in my object list. I'll take another look. What I would like to do is have an oval shape and attach an if statement to it to change the background color if a certain condition exists.

Is there an easy way to add a shape to an Access report without inserting an image?

Good news, lol. The structure of the tables is changing and that includes data changes also.

Saw this area and thought I would take a sec to introduce myself. My career background is in accounting, but I do have an AS Degree in computer programming because I found I have a natural skill in designing programs. Currently I am developing an Access database which will gather data from...

Ok. I looked that over, it helped. I got the record count down to 27400 now. Lots better than millions, lol. I am going to go back and look at the other queries and see if I need to do the same thing. I have never combined so many queries to make 1 single report. You guys are great...

Thank you for the welcome. I originally had the queries joined by the scode, and the month, but I got two different types of errors. One was an overflow and the other was something like you can't do this because it uses more than the allowed 2gig of temporary memory. And yes I get tons of...