Search results

Sorry. I forgot the last bit. This should do it. Chris B

Even easier. The functions can pull the required values from the combined field just as well. In reality all date/time fields are the same, it is just the displayed part which changes. See the updated sample. Chris B

Sample attached. See the full data in the table and the query to produce the day and hour periods. Good Luck Chris B

I don't think you can, however this might solve the problem. http://www.supershareware.com/info/access-form-resizer.html Chris B

You can do it. Day numbers are 1 for Sunday through 7 for Saturday, so Weekday(DateField) will give you the day number, and you can limit it to the required days with a criteria of Between 3 And 5. Restrict the time using Hour and it should be OK. Chris B

Place the items side by side in the detail section and ensure there is no page break in or at the end of the section, and the records should print as a list. How did you create the report? Try it again, just using the wizard and don't change anything initially. Does this work OK? Chris B

There are group policy settings for this. Microsoft article here - http://support.microsoft.com/kb/891158 Chris B

Solution is here - http://dan.hersam.com/2006/09/18/tooltips-hidden-behind-taskbar-in-xp/ Chris B

Everybody has to be out of the db to compact anyway, so scheduling a compact for say 4.a.m. should be OK? Can't see why 145MB should be an issue, once it gets to 1.5GB, then would be a good time to sort it. Schedule it via a macro shortcut with Windows scheduler. DoCmd.RunCommand...

Query or text box on a form. Field "Places_Taken". Calculation as the control source of a text box called say Places_Available = 20 - Places_Taken or as a column in a query Places_Available:20 - Places_Taken. Of course NEVER store the results of a calculation in a table, as a change to one value...

To carry data from one form to another, a simple method is to write the data to a table and have the new form look it up when opened. Chris B

To close it, use the forms On Close Event. Select Event procedure and enter DoCmd.Quit. Now the app will exit when the form is closed. Chris B

=DateAdd("m",-6,Date()) gives the date 6 months ago. Chris B

Good result. I agree that unnecessary messing in registry is ill advised, however this particular restriction is an old setting which has not kept pace with available memory and regularly causes issues which need not occur. I always make this change. Chris B

IT may be a maximum lock limitation issue. By default Jet4 (and earlier) are set to 9500 max locks per file (to save allocating too much memory, but you have plenty, so it is not a problem). This causes issues when trying to update large files/tables. I generally run 100,000. To adjust the...

This works fine - DoCmd.RunSQL "INSERT INTO [Time Sheet] (SFirstName, SLastName, Department_No, Status, subject_taken) VALUES ('Mike','Fraser','01','FullTime',3);", -1 Examine the differences. Chris B

The password will be living in the workgroup file. If you didn't specifically create a new one, it will be called System.mdw.If you are running 2003 it lives here - C:\Documents and Settings\User Name\Application Data\Microsoft\Access\System.mdw. Rename it to something else and use the attached...

Why 3rd party? You can have an mdb which is linked to the others and run your report there. The linked tables don't need to be related, you can run a bunch of sub reports within one report to assemble the data from all. Chris B

You are really describing a pivot table which you would build in Excel linked to the Access data. Pivots are designed for just this type of scenario. In Access to restrict the dataset to just one line, you need to specify additional parameters which will remove the extra data. You can specify...

Importing into a new db is a tried and true method of repairing corruption. It will work pretty well in many cases. You are correct re the relationships, my mistake. Chris B