Search results

This Code although wonderful, can not tell the difference between a word and a proper name. To the Code "Mack" and "MacStooge" are just words. But in reallity "Mack" is the word, "MacStooge" is a proper name. I think folks would want thier name in proper text. For the Code to work you would...

This does not work with all surnames. MacStooge would show as Macstooge and O'Brien will show as O'brien You'll need to Create another Table (with these corrections) and some code to lookup and populate the Control. This site has a work around for that problem. Goto number 136...

Do you currently have a table in your dataBase that has the ZipCodes, CityName, and StateName. You'll have to think this out as how you want to do this. This will have to be done using a Form. If you Enter the City and want ZipCode and State, you'll need to know what State to get the ZipCode...

Yes sir you can create you own Value Box, it is called a Dialog Form Create a Form, on this Form place a Control (Field) that is not bound There are many examples of this North Wind database that comes with Access

You do not want to use a "Message Box" You Should use a Dialog Form. Try a Combo Box or a List Box on this Form

Put a control on you Report As the Data Source for this Control use =[Forms]![YourFormName].[Start Date]&" Through "&[Forms]![YourFormName].[End Date] YourFormName = the name of the Form that you used to Select the Dates. Hope this helps

The "35" I take it is something that you have entered into a textBox on a Form. You have to tell (so to speak) Append Query where the Field is. Somthing Like RoleAssignmentID, RoleprofileID (put this in the Criteria [Forms]![YourFormName].[RoleprofileID], ApplicationrightI D

Do you want to Link two Forms. What do you mean pass the FamilyID to another form.

Here a web site you may want to look at. There are a number database model you may find useful. www.databaseanswers.org/data_models/index.htm

Do you need to view this in a Form (on screen) or as a Report or in Query DataSheet?

When do you need the life Skills Credit to revert back to 0

Taking for granted that your using PDFCreater3, as your PDF convertor. You will have to go to thier web site for solution to do what you want to do.

You have told your Report to Group and sort by the first two charaters only. Try just Grouping and Sorting by the "Primary_Key" and your result will be. ZC-01 ZC-02 ZC-03 . . . ZC-08 ZC-10 ZC-11

Do you has your Sum textBox in the GroupFooter or the ReportFooter

Summerwind I've had this happen a number of time to me. I believe that the Report has some how gone corrupt. The only solution that I could find was to delete and than recreate the Report. As a note: I always duplecate databases. One is the working database that is used, the other is one that...

Has anyone here had to print continuous mailing labels on a dot matrix printer and actually got it to work? I use the label wizard to create the labels, and when they print, I’ll have one label print then 22 empty labels than another will print.

Neil where did you find this

Chester Apoligize for taking so long. I run your RepDialog and all worked fine, brought up every record called for. I even put the database on other computers, and still no problems, all filtered fine. At this time I have no idea, I am stumped. Maybe more Indexing. Sorry I could not be of...

Maybe its me But I guess it is now working

I may not be in complete understanding of your needs, but have you tried. >3400 and <3699 or Between 3400 and 3699 One of these is placed in the Criteria under Line or do I have this completely misunderstood.