Recent content by Mr Smin

Works correctly for me in Access 2007. I manually entered dates into the 'between' filter dialogue box in the format dd-mm-yyyy.

Have you tried setting print preferences for a single form or report rather than a whole database?

Do you mean you are restricting dates the user is allowed to enter, or filtering to show only records where date is between a and b ?

If the logo is pre-printed to the paper, you need a bigger top margin in the report to leave room for the logo, or you can add a page header in the report and leave the space it creates as blank.

I think pr2-eugin meant you can use the OutputTo command in a macro or VBA. If you follow the link you will see how the command is used. You can put the date into the file name a bit like DoCmd.OutputTo(ObjectType, ObjectName, OutputFormat, "C:\reports\" & Date(), AutoStart, TemplateFile...

Assuming your table structure is OK, yes you can do what you proposed. Are you sure this will be for adding new records irrespective of what already exists? Suppose you have table_Customers one-to-many with table_CustSites which in turn is one-to-many with table_CustSiteRooms (if you ran a...

First, you should take the Findmessage query and turn it into a make table query. This will reduce the work the database will have to do, assuming that the data the populates the msg column in the log table is not updated too frequently and that you will be running the subsequent query more than...

The best solution might be to stay on paper until the CRM is ready. Trying to version-control lots of databases is going to be fiddly and the only alternative I can think of is to build a web interface to the database using eg javascript to do the validation. This is not going to be easy either...

In Access 2003 I provided a text box and a button. User puts a few characters of the name in the text box, clicks the button and a list box gets populated with results of their entry with * automatically added. Then they click on the list box item they want. This is a bit inelegant and later...

A person in Production scans a barcode on an item that they want to order, then enters "500" in the Qty field and clicks "Send Order". That should be fine if your barcode scanner can be set to send a text string to wherever the cursor is, which I think is issue for the scanner driver and not for...

If the file names all follow the same pattern you can use the Right function to only show the last 8 characters of the path http://www.techonthenet.com/access/functions/string/right.php but this won't work if the files have names of different lengths, in which case you might use a Regular...

You are facing a headache there. First pitfall that comes to mind: Some email systems refuse Access attachments deeming them a security risk. You should check that won't affect you before going any further. edit to add that supporting this could end up taking far too much of your time to the...

Can you describe more about the situation in which the user makes the selection? You might want to try using the ComboBox wizard on a form as this walks you though a user selecting one option among many and storing an identifier based on the selection.

Did you consider either of the options posted by pr2-eugin or myself?

If you only want to do this once, just select and copy multiple rows in the table, then paste to Word. You will then have a table layout in Word which you can edit as you like. If you want to use Word as an interface to Access (change data in Word and reflect back to Access) you will need to do...