Recent content by MarcusAntonius

Of course, this only fails if you *ahem* have another validation rule on the control for the textbox and have forgotten to take it off... Oh, and thank you :-)

Unfortunately the Msgbox still pops up when I try to blank the field(CDate1)

I currently have a textbox on a form where on mousedown it launches a calendar and on click it allows me to select a date. It has a validation rule that controls what date can be selected. However, if I go to a record that has a date entered in the textbox and try to delete the value then the...

Thank you Allan! It worked a treat.

Morning All, In a table I have a text field (Meeting Date) which contains the date in the format: "Wednesday 22 March 2006" How do I convert this to a date of format dd/mm/yyyy? I have created another field of type date called MDate, in the same table, and have tried experimenting with an...

When I create this append query and run it, I get the message 'you are about to append 0 row(s)'. even though the file contains about 10 records. (I have attached a screenshot of the append design. The data table is the imported list of MAC addresses - 10 of them)

I think there's a limit to the number of fields you can have, so just try adding a few more each time and see where you get to. Not sure why it goes blank though, I didn't experience that problem since it just wouldn't let me create the form due to the excessive number of fields.

Sorry, but how do I link to the csv file?

Outlook 2003 and Access 2003. I want to set up a mailmerge such that the From address is not the account that I am logged in as, but a different one. i.e. not joe.bloggs but admin@help. How do I do this?

Basically I have a list of 40 MAC addresses in a csv file, and what I want to do is import them into the subform instead of entering each MAC address manually. I want to be able to do this with Form A open so that I can see which to which piece of software I am adding the list of MAC addresses.

I have a form, A, with a subform B. Form A contains details on software and subform B lists the machines the software is installed on. I currently add a machine manually to the subform B. If I had 40 machines, how can I do this automatically?

How do I recompile it? At the moment, it seems the best method is to export all the tables/queries/forms and then import them into 2002 and go from there.

I need to update a database from Access 2.0 to 2002; does anyone have any hints and tips? Is there a structured methodology to doing this? At least using the convert feature results in Access crashing (Access has encountered a problem and needs to close).

Michael, I found out how to do it. The two tables have a many to many relationship so there is a table called 'link' to break this up. (I foolishly forgot to mention this) Therefore, the Licence table remains as the basis for the main form, but the subform should not be based on the Machine...

They are linked with a relationship. (Sorry, this is a little difficult to explain... You see I don't want to add records to the Machine table since they are being imported from a csv file.) Let's try this, let's assume that both tables(Machine and Licence) are empty. You open the form and...