Search results

I have two tables with one field name all that is one should be in the other. When this is not true, i want the query to crash, abend not run to a smooth end. Reason being to stop the processing of a report that is based on the query. Any idea of how I can do this. I have attached a picture...

Solved - At Last... It was ok even at 8 inches.. Problem had do to with Page set-up options. http://support.microsoft.com/kb/314580 : In the Database window, select the form, and then click Design View to open the form in Design view. On the View menu, click Properties, and then click the...

I brought the width down below 7 and one half the error presists..

I lower my width to less than 7 1/2 inches still too wide??

Re: "The section is greater than page width..." still What view do you do the drag in? Design? I have the page in design view down to 7 inches. The page is 8 1/2 x 11. I am going to External Data - PDF and get a 6 page document with every other page blank, yuck. I still keep getting the...

Re: "The section is greater than page width..." v2007 This is frustrating! I have changed my margins to narrow. I do not have anything out there on the left side. My data is all printed two inches in. How do I move the width of the design over so it will be within the length of the...

You were Right On. My problem was in another part of the query. I have checking for a date field not be nulls. I had it coded like > "nulls". That was causing the error message of data mismatch. Once I word it right all worked good. Is NullIs Not Null Thx for direction and help...

I do not want to get into the actual SQL code. I much rather do it through the panels. I have tried both function val and clng without success and still get that nasty message: "Data type mismatch.." Attached is a screen print. Russ

I have two tables, I need to link up. One table has the field define as text and another has the field define as numeric. I can really change the definition of the fields. Reason being they are dumped there monthly in SQL format and we link up to them in Access. I think there is a numeric...

Much closer I am to the solution. THX. That code is not catching with = " ". The field must have some that are spaces and some are nulls. I need a either or catcher. This catches the spaces. NOTES2: IIf([Notes]=" ","None",[Notes]) and this catches the nulls NOTES3...

i am trying to get when the field is not loaded spaces or null to replace it with the word none. IIf([Notes]=" ","None",[Notes]) AS NOTES2, IIf([Notes]=Null,"None",[Notes]) AS NOTES3 I do not see data in the field. And sometimes NOTES2 gets the word "None" sometimes not?? Never the...

Good Job = Thx. Russ

How do you get more boxes to enter your data selections in a query I have a long one and ran out of boxes and see no option to add more?? I did attach a screen print for show and tell. Thx Russ

I need to switch values on a field; values 0 thru 5. 0 stays 0 1 goes to 5 2 goes to 4 3 stays 3 4 goes to 2 5 goes to 5 I have coded this for a started for the concept but syntaxly failing. Q12A: IIf([Q12]=1,5),Iff([Q12]=2,4) Thx Russ

Re: Can a report execute generate a file - macro?? all the blurb in the post - slipped in from a post on another forum. So, there is a way (macro - vba) code that can take the output of my report within Access and send it down to the PC hard-drive without me clicking the Export to PDF format...

#1 Today, 06:25 AM techexpressinc Windows XP Access 2007 (version 12.0) Advanced Beginner Join Date: Dec 2008 Location: indiana, usa Posts: 44 Can a report execute generate a file My users like to have a one click solution and not click the External Data words to get the...

That group of users been doing the table layout updates for years. I am not an regular employee to them, just called on when they want something, then for next to nothing allocated in time. They asked for when they select the school from the drop-down selection that the address be...

This group of people are not into forms. They like, insist on just view the tables in layout view, updating them in that view.

the form does not allow me to change the school on a student. if the address field on the student is just a query look-up behind the field to the SCHOOL table. the data is not being stored twice. There could be a problem if the entry was ever deleted from the SCHOOL table, thou. I...

The ID of the school is stored the student table. field "Child School" it is a number which is the id number on the SCHOOLS table the field definition is this drop-down: SELECT [Schools].MailingListID, [Schools].School FROM Schools ORDER BY [School]; So, once the user selects the right...