Search results

If you want to repeat the header which shows on the first page, that is, it is part of the main report, set report header visible no, and transfer / copy the contents to Page Header. You will need to open / expand page header by dragging the bottom edge. Set this visible yes. Chris B

The creation date of the record is best done at the table level using Now() as mentioned above as the default value of the column you establish for the purpose. Chris B

Password is optional - just showing where it would go if required. This is not an access password, rather one which might be required to permit the drive to be mapped. You said users would map random drive letters, that's fine, but this would map the location of your check file so Access could...

Map the drive yourself first with your macro using RunApp. Just put the following in the command line - net use F: \\ServerName\SYS\ /user:someone password /persistent:no If it is already mapped, it does nothing. Chris B

There is a space in Brian's formula after the second Spellnumber which upsets it, remove that and it works as you asked. Chris B

I expressed it poorly. Which of the suggestions you might use would depend upon whether you wanted to capture just the creation date or any update. Ensure that no control / field is called Date. Chris B

Nextly (which isn't a word, but I like it) if you want to update the value when a record is changed, just add last_update = Now() to the after update event of the entry fields. Of course, the control needs to be on the form for this to work. Chris B

The way I show update is directly in the table. Create a date/time field called last_update with the default set to Now(). Now every new record added will be timestamped. You can of course view this on your form if required. No code required, simple. Chris B

I suspect you may have some corruption in the system. The best method to restore XP to health is via a repair install. This will replace most of the registry but retain installed progs and data, however do of course back up anything critical first. Uninstall any virtual drive software first...

Presumably clicking the switchboard opens the report which is based on the query which has the prompt criteria which is framed like this - Between [Enter start date] And [Enter end date]. If this is not the case, as Jean-Luc would say, make it so. Chris B

Bottom right corner of your taskbar. Hover mouse pointer over the date. Does the month have a capital? If it doesn't, the issue is in your regional settings. Chris B

Indeed. So to avoid this and other unexpected results, if working with numbers, don't set the field type to text. Chris B

That would be a printer setting (Scale A4->A3). Chris B

=MonthName(Month([Your Date field])) Chris B

Max(Column Of figures) will return the highest number. If the column contains 1 to 10, the result will be 10. Chris B

Try in inverted commas - "k:\data\someFile#ref02.doc" Chris B

OK. Moving right along - to produce a report, you must base it on a query or table. Have a look at this expanded version. I have based the report on the table but you should put a query in between. This will do for the demo though... Chris B

No idea. Create a db which exhibits this behaviour, then zip and post it. Chris B

Is this what you had in mind? (Sample attached). Chris B

Button one - On click event - Event procedure - [Textbox1] = "We regret that we ....." Button two - etc. Chris B