Recent content by Wannabeegeek

Hi, I have created a continuous form where one of the fields contains a user entered vaule in the format '0103','0203','0303','0104','0204','0304',etc. The first two digits are a serial number and the last two are the year in which that serial number was allocated. When the form displays it is...

Just out of interest to anyone else trying to do what I was trying, this is how I did it. It's might be worth noting that the best way I found to active the module was to click on the ... at the end of the on_click line in the properties window and use the expression builder to lead to the...

CODE Private Sub NUM_Click() End Sub Public Sub OpenDoc() Dim WordPath As String, DocPath As String Dim FileName As String, FullSpec As String WordPath = "C:\Documents and Settings\user1\Desktop\New Folder\WINWORD.EXE" DocPath = "C:\Documents and Settings\user1\Desktop\New Folder" FileName =...

Very many thanks but I must inform you that I know what VBA stands for and little else. I set the properties 'on click' to Event Procedure and entered the code exactly as you wrote it above but when I click the button I get the following error message: The expression on click you entered as...

Thanks for that but I've got that far. My problem is that I want the filename to be taken from a user entered value in one of the fields in a record. It's so the user, who can see a continuous form, can enter values in one of the fields. Then at the end of each record there is a button which...

I am trying to use the runapp command to open a MS Word document from MS Access. The word document name part of the command line to which needs to be speciefed by the user entered value in the field of a record. Any solutions would be greatly appreciated.

Is there any way in which I can use my MS Outlook for e-mails etc when my internet provider is AOL. Very many thanks.

I have a disk which contains lots of data on an old Microsoft Office database (wdb) but only have Microsoft Access 2002 to read it with. How do I convert a Microsoft Office database to Microsoft Access 2002.

I need to make a text box (date/time) display the date in one form that a check boc is ticked in another form.