Search results

I am checking to see if a memo field and/or a text field has more than 1000 characters and if so then it calls a function that prints legal size paper vs. 8 X 11. It works fine except when the either field is empty. I have searched and searched the Forum and found many that are close but no...

I have 4 databases that share 3 tables. Each database is used for different purposes and other tables which do not relate to the other databases. My question is: how do I set up the back ends so each database can retrieve and enter data into the 3 shared tables without conflicts?? I know...

I am designing a form for users to write letters in which they give “reasons” for denying a particular service. It is a State-required form letter and there are 7 “reasons” to deny. The user usually chooses just one “reason” and then types in (free-style) the text for the specific rationale...

I have a report based on a query. There is a field "comments" that is a memo type however on the report it does not display all of the text. I have the property "Can Grow" set to "yes" however it still only shows partial text. Any ideas? thanks in advance!

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

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

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

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

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

Kind of a lame title for the thread but I'm feeling kind of lame..... :o I have a form with subforms. One of the subforms gets populated with a set of records that are questions for a survey. I have the main form's date field's AfterUpdate event coded to add the records but if you modify the...

MS Access Closes in print preview: Revisited I tried the solution of : new db, import all objects, however, for the one form referred to below, it still causes Access to close. Could it just be that the form has so many graphics that it can't handle the print job? I don't care whether I ever...

I have a command button on a main form that runs an append query that populates a subform. When I click the command button the form remains blank and I know it needs to be requeried however can't find where to put the requery code. I added "SendKeys "{F9}", True" to the command button...

I have a main form with sub forms on tab controls. The subforms are set to Continuous Forms. Each subform has a different number of records that appear and each record is just one line, but all of them, at the bottom, show a new blank record. If the user tabs to that new record and enters an...

I have a main form with a date field I want to be filled in before the user proceeds. I have searched the forum and found the following code which I have implemented however, no matter where I placed it it just keeps on allowing the cursor to move to the next field on the subform and allows...

Many thanks to those who continue to make my job more easier and help me learn new programming skills!!! :D I have a totals query that has calculated field which does not work if one of the fields it is based on is null. I created a work around (see below). My question is: is this a good...

Another Survey Question I am designing a database that stores results for medical record audits. Each record is scored using 52 criteria with possible answer: Yes, No, or Not Applicable. The final score is calculated on a formula that I will have in a calculated field in a query. I have...

I have a main form with a subform. The subform has 2 subforms that I am trying to put on a tab contol (2 tabs). I am able to add the tab control and then the two subforms and set up the child/master links but when I go to view the main form, I get parameter errors and when I go back to design...

This may be a dumb question but I ain't proud: ;) Can you calll a function from a module in a calculated field of a query? I have found a wonderful sample on this site that calculated business days but it is used in a form and I want the same function but in a calculated filed in a query. Is...

I need to know how to write the vb code for changing the Link Childs/Master properties for subforms. I have searched the Help files but not much "help"! I have a form with 2 subforms. I want the Link Childs Field & Link Master Field properties for both subforms to be triggered by what is...