Recent content by purple_chicken

to put where? in the report textbox properties or in a vb on open command as neither work.

I have a form where i input a date in a short date format. The data is saved in the table in short date format but when i want to print the selected record from a report I want the date to be in a long date format (which is no problem) but i also want it to be in uppercase. the standard long...

Not quite what I had in mind not quite what I had in mind, the database is pretty well tied up at the user end for computer eliterates, basically i wanted to make things as easy as possible for them ie, stick a blank floppy in, hit backup then pop the floppy in the post to myself. csv may be...

Probably a very simple solution but it's driving me mad as I can't get it to work I have a small database with about 500 or so records in it which are very rarely likely to change, basically what I want to do is create a command button that will backup all the records from the main table onto a...

Bingo yeh got it thx, played around with the code you sent in a parameter columm, thx again :)

no not quite, I have a selection form where you select thedate, the day the month and the year are selected from different drop down boxes and the date is used for referencing in a couple of different forms and querys, in the query that im having the problem, ive got the date field, then split...

hopefully someone can help, I have a database where all records have a date and a time stamp. I am trying to build a query where you enter a time parameter and the query will return all records with a timestamp of 20 mins either side of the time criteria entered. I have the date side of thigs...