Recent content by VanRoekel.Clint

Unstable & Quirky Here is what the graphs look like....see attached jpg.....

We are using Access 2003 on a Windows XP Pro machine and graphs from the database are very unreliable. Can anyone explain why the first date along the x-axis would be displayed in "d-mmm" format and all the rest of the dates would be in the format "m/d"? "m/d" is what I use in the query...

End of week If your reporting period is always Saturday, don't use a variable. Just put the label "Saturday" in the header.

No Data Try to use the HasData variable in your report and print "NoData" rather than "#Error". =IIf(Not ([HasData]),"NoData")

Group ON Click on the "group on" icon in the report edit screen. Select the Field/Expression that contains the activity 1, 2 and 3 information. Select Yes for group footer. Insert a field in the group footer section that sums the hours. You will need to sort on this field. I hope that this...

Here is the text that I use in the page header on my report which contains a graph: =Forms![Get Dates]![Start Date] & " - " & Forms![Get Dates]![End Date] The form is named "Get Dates" and the fields in the form are "Start Date" and "End Date" You need the square brackets if the name of your...

Bak See if the security wizard created a backup of the database but with a BAK suffix instead of MDB.

Open your task manager It may not be an Access problem. Open the task manager and see if there is a process running that is the culprit. Do you have more than one virus protection application running in the background at the same time? They might be clobbering each other and the Access...

Compact on close Normally a compact creates a new smaller database but under Tools, Options, General tab you can set the database to compact on close and the database will be compacted to the same name. If you open and close the database frequently the time required to compact may be an issue.

Use a UNION query Would a UNION query work as the source for the form? Select 1 as Field1, Field2, Field3 from Table1 UNION Select 2 as Field1, Field2, Field3 from Table2; This will keep the tables separate but allow you to select 1 or 2 in Field1 and filter only the records from one of the...

Structured data None of us are avoiding properly structured data and we know & use the rules for normalizing the data, but we work with what is given to us. Much of the data from which I produce decision support items is in a flat table structure from other systems...and rapid response is...

Try the DLookup in Query2 without any coding I added a structure table to MStef's sample database with numbers 1 through 7 for items. Query2 will read the structure table which must match the number of items in the StudentASR and the Import tables. Using the DLookup may not be the fastest way...

Numbers separated by commas It might improve the design of your database if you put each of the numbers that are separated by commas into new records. So Case Number would have multiple rows; one for each Category of Need.

Chart problems "unstable and quirkey" are appropriate adjectives for charts and graphs created in Access. The problem is very random in our databases and I can't figure out why, either. Sometimes the data is the same for every graph in a report, but sometimes it is just the first graph on the...