Search results

Here is a function that I got from this forum, if you search you can probably find more info about it but I use this in most of my databases. You can change the size you want it to run compact, for example this one compacts when a db gets larger than 5mb. Public Function AutoCompact() On Error...

When you design the form the first dialogue box that opens gives you a drop down box that lists all tables and queries in your database. Choose the table you wish to relate to the form you are designing and Access will create the "relation". As a newbee I would suggest you get hold of a book on...

BATman that worked thanks so much! Here is the code I used in case anyone is interested: Format([TotalScore]/(150-[TotalNAScore])*(100),"0") & "%"

Thanks BAT will give it a try!

I have a field in a query that contains numbers and text (text field). The numbers displayed come from a percent calculation and display with many decimals ie, .99898745987245. Is there a way to eliminate the decimals with code in the query field? For example .99898745987245 to equal 99%? I...

Just getting back to the bulletin board today and thanks Doc, you are absolutely correct. I will pass on your previous threads to my IT guy and go from there. Thanks again Doc for your persisitence in explaining this to a rather ignorant user!

KelSo Thanks but it is in landscape mode already... Doc: I am at my workplace on a server so don't think the disk is the problem...anyway, for now the problem seems to be solved (i hope!) thanks again for your replies!

I would strongly suggest that you split the database. Not only does it "hide" things you don't want the user messing with, it makes modifications/revisions in the future much easier. Pat Hartman has written loads about this subject and if you have time search for that because I believe it is...

Thanks for the advise, very interesting I will remember this. My report however is set to use only arial 10 pt. And interestingly enough, the wingdings not only appeared on the report but in the query results as well!! That really blew me mind~! I think the problem had to do with the query...

thanks but it did not help. I think I may have an idea in that the report depends on a query that looks at 8 tables. When I add one more field to the query, the Chinese (Wing Dings? ) appear on the report...not many, just one for each field. When I eliminate that field from the query, the...

I have a db with many reports and suddenly one of the reports, instead of printing text it comes out with characters that look like Chinese! I have tried deleting the report and then importing the same report from a back up copy to no avail. I have tried renaming the report - no good. I have...

Have you imported text files successfully before? If not it could mean not all features were installed on your MS Office installation. Try reinstalling and make sure all import/export features are installed for MSAccess. If it is only a problem with this particular text file, I don't have much...

Spacepro is an ACE-pro...that works perfect for me...always wondered how to do that. Thanks!

Thanks BL, that was what I was hoping to hear!!

I have developed a program in Access 2002 (with lots of great help and advice from you folks! thank you!) with forms to perform audits on physician's offices. I have to walk around the office/clinic and check of 150 or so items and would like to do this on a hand held tablet pc. Does...

Thanks for your reply Doc. I did a search on this site and came up with this link which looks like what I can use. http://www.access-programmers.co.uk...light=open+word

I have a database with data entry forms for doing audits on physician offices. Once the audit is completed and scored I need to issue a corrective action plan based on deficient items identified in the audit. Currently, this is done by using a hard copy 53 page MSWord document. Only the pages...

Thanks very much for your reply! Interesting information I did not have!

QUESTION: In MSAccess 2002, when you change the name of a field in a table, does that name change cascade to all other references? It seems in my trial that it did cascade to some querie & form fields, however not to everything though I can't recall what objects were not changed. Basically...

Is there anyway to link an existing table to one in another database? I have two tables with the same names in two different db;s. I want to link them. If I delete the table in db A an just link to the one in db B I have to first delete all the relationships, etc. WHat I am trying to do is...