Replies

How about the speed of copying documents from the network to your PC? I have trouble with Word/Excel/Access for files located on our network. But, if I first copy the files to my C drive, then my own local copy opens quickly and there are no “speed issues”. But copying a file off the network can take minutes, even though copying the same file from one folder located on my C drive to another folder located on my C drive is basically instantaneous.

Thanks Hans, you’ve really made my day!

I really want to do this in a query if possible. I’ll restate this again: Can you number records in a query by a group? Example:
______Black: 1. Fred
___________2. Mary
______White: 1. Joe
___________2. Sue
___________3. Bob
___Hispanic: 1. Sarah
___________2. Ralf

Can you clarify some things? Are you saying you want the user to select a state from combo “A”, which will then dynamically populate combo “B” with the appropriate cities? Seems like, for one thing, you need a “where” clause in your sql. Something like : Select city from tablex where state = ComboA (the value in ComboA that the user has selected)

The table name is the middle argument, so try this:
DLookup(“City”,”Affiliates”,afid=1)

Another possible solution: If you are just trying to get the query results to a text file, try exporting as type “Microsoft Word Merge(*.txt)” instead of as type “Text Files”. This does not bring up the export wizard. The results will be a text file with your query fields delimited by tab spacing. In your case, this may be all that you need, but you’ll learn more about exporting, if you use Gary’s suggestion.

You CAN have these symbols in your text/memo field, and it is no problem at all. Don’t change the font you currently are using for your text/memo field (unless you just want to). You can select and copy the characters you need from the character map feature of Windows and paste them into your Access text/memo field. As an example, if the text field uses the Arial font and you paste the character theta into it, you will see that symbol. Instead of debating this, just go ahead and try it. Open your table or query and type your name in one of your text fields. Now open character map and select, then copy one (or more) of the characters you are interested in using. Next right click in the Access text field right after your name and choose paste. This text field will now contain your name followed by the special characters you just pasted into the field. This will display correctly in the table, query and reports.

I would not add any labels in this case, but add three unbound text boxes in the detail section. The first will count the detail records (Control Source =1
Running Sum Over Group
Visible = No).
Name this first box “CounterBox”. The next two textboxes use an if statement as the control source. Second textbox: Control Source =IIF([CounterBox] = 1, “Facility”, “”). Third textbox: Control Source =IIF([CounterBox] = 1, “question 1”, “”). The second and third textboxes will now be your labels, and will only show up for the first detail on each page. Note: in the if statements above, the second argument is quotequote(no spaces). Set the font on textbox two and three, anyway you like, to get the desired visual results.

You just need to add a little more code to the function telling Access what to do when Jordan’s code is true, and what to do when it is false. In your case you could simply exit the function when it is true, but, if it’s false, send your msgbox, which will warn the user.

These symbols are available as fonts in Word, WordPad, Excel, PowerPoint, and Access (and probably more). They are also available in the character map feature under “System tools”, although not all applications recognize these characters (the major Microsoft office apps do).

Repairing or reinstalling Access will not delete the database files you have created (the “Apps running under Access” that you refer to). But to be safe always backup important files before attempting anything major to your computer. If you’re going to reinstall Microsoft Office, and you’re worried about files that you have created; you can backup any letters (.doc), spreadsheets (.xls), and Access databases (*.mdb, and maybe *.mde), and any other files that you have created, just so you’ll feel a little better about the reinstallation. If you already regularly backup these type of files, then go ahead and try what Charlotte has suggested.

Use the query wizard to create a second query that uses your crosstab as input. Place all fields from the crosstab into the new query. Now, add a field that simply combines the three count fields.
Totals: [CountfieldA]+[CountfieldB]+[CountfieldC]
Let this new query be the basis for your report or form instead of your crosstab query.

Charts normally combine like dates on the X axis and then summarize Y axis values. In other words if you had dates for the X axis, and currency values for the Y axis, a chart would normally combine like dates into one date and then add, count, min, max, etc… on the Y axis values. For example, say you have two records that both have the date 01/01/2001. One record has a currency value of $5.00 and the other has $10.00. Your chart would (if sum) show only one date and value: 01/01/2001 $15.00. I think if you change the query the chart is based on, so that it does not “Group By” (thus eliminating any type of summarization), then your chart just might work. Try these steps (backup your chart first):
Change the values for the Y axis from numbers back to date (as you originally had them).
Open your chart form in Design view.
Right-click the chart, and then click Properties if they are not already visible.
Click the Row Source box, and then click the Build (…) button to open the Query Builder.
On the View menu, click Totals to remove the GROUP BY clause from the SQL statement of the query.
On the File menu, click Close . When you are prompted to update the property, click Yes .
Now view the chart in Form view. Did this help?

Try this two lines of code:

DoCmd.SelectObject acReport, “ReportName”, True
DoCmd.PrintOut acPages, 1, 1

Edited original reply.
Long and complicated answer: see Microsoft Knowledgebase for page “Q231808”

Edited to activate link — Charlotte