beautiful, that did the trick. that is ridiculous that the other ways do not work. Thanks ... design ... subreport ... order ... (set by ... query. ... field...
Actually, this makes sense. Many reports can be configured to use one query and the sort order may need to be different for each report. So, instead of...
Because you *can* group a subreport, and when you define any grouping, the report engine must override any sort specified in the query and do its own sorting. ...
I've looked into Click Yes. It's a great little program for personal use, but I think the dll would be a better solution for distributing to a group of users....
Okay, I have a few Access questions. First off, I'm using Access 2000. I'm also not well versed in Access for I am a lowly receptionist. I only know the...
... Do you know how to access the database window? (You may be working with a compiled database that won't allow design changes) If you can get to the list...
Megan- Do you ever need to edit anything in this form or add new records? If not, then you can open the form in Design view, open the Properties window, and ...
I don't think it's a good idea to have a receptionist edit any forms or reports; unless permission is given by the programmer or department head. Just plain...
Thanks for your help. I'll give this a try and see if I can get it to work. If not, I'll be back. Megan ... working ... can get to ... your ... properties...
I would like to set up the Margins on my report, by code. Not File/Page Setup/Margin Top margin 1" Left margin 3" I'll open this report with a command button. ...
I would like to have the information from the left portion of the string Like the street address Can you please finish this function? Public Function...
... Dim objAccess As Object Set objAcess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase "C:\MyDb\MyDB.mdb" objAccess.DoCmd.OpenReport...
First of all, when you dimension variables as you did, only the last one is dimensioned as a string. All the others are dimensioned as Variants...not good. It...
Hi all I'm have found that when I put a list box in a field that it will repeat, or renew or be there if you will, with each new record made. but the cells...
Mike- What is the Record Source of this form? What is the Row Source of the list boxes? Are the list boxes bound to fields in the Record Source (have a field...
Bill, Thanks for your help I just realized that I also need to have filter the street name Currant information 14 Broadway rd #14b 1 Place pl #6j 556 Park av...
I have several Fonts that don't work properly when using it in Access report. All the labels or text boxes that have numbers, the text & number will not be...
If you just want the first text string after the number, you can use Mid and Instr, but I suspect you want "Broadway rd" not just "Broadway". Also, you might...
Good day. Thank you for starting up such a great group. I have just joined and I'm really looking forward to learning new stuff. I'm working in a small...
Welcome to our group! One of the big rules of relation databases is DO NOT STORE CALCULATIONS. There are rare exceptions, but this is a case where the rule...
Hmmm... I have never seem Access change fonts so I can't help you there, but as to the alignment, if you do not specify left, center or right align, all...
Oh my! Creating a "real" inventory control application in a database is a daunting task. Northwind has UnitsInStock and UnitsOnOrder fields in the Products...
Hi John; Thank for your help, but could you help me a little more. I don't know how to tie my old pieces of codes to your. OR BETTER YET you could show me a...
... * this is not a form this is a table the list boxes in the table are working. When I start a new record the list box appears in all the answer fields. but...
Ah, a secured database. I found this code snippit on www.mvps.org/access: Dim db As DAO.Database Dim oAcc As Access.Application Const TMP = "fooz.mdb" Set...
Michael- You should be doing this in a form, not a table. Where are the questions stored? If you have a separate table with all the valid questions, you can...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
