Recent content by kaisersose

I have a database set up with a main menu, and on the main menu have buttons that bring you to various forms. One of these is a button to an administrator section form. This admin section allows the person to go through all the records and make updates if they want. All the records are saved...

sorry i'm a novice at access :) I want to save the word file like this but nothing happens, is there something I should be doing differently? .SaveAs [me.OrderID], [.doc]

I have an access form set up and when the user fills out all the fields, I want it to write the values from the fields to a word file, print the word file and then save the word file with a particular name (the value of the OrderID). I have it exporting to a word file at the moment and printing...

I removed the date field altogether, in the design view of the table I set the default value of each item to "", this seems to work fine for all the items apart from the last one, which it just ignores. Theres something strange with this last field, I have it called descriptionofitem, it's no...

it says Me.Date = Null but if i try this If IsNull(Me.Date) Then MsgBox "Tell the user he must put data in a field" Me.Initiator.SetFocus Exit Sub End If and have the default value blank then it just ignores this field and doesnt prompt me to enter data.

thanks again, nearly there now It works fine with the code at the bottom when the defualt value is 0. However I want the default value to be blank, and so if the field is blank the user will be prompted. I've tried If Me.Date = "" Then MsgBox "Date is a required field"...

cheers I've added this In my case initiator is a drop down list with names. So this filed would be blank until the user selects a name from a drop down list. In this case what would I need to do here if the value isnt Null? If IsNull(Me.Initiator) Then MsgBox "Tell the user he must put...

I have a form where a user has to fill out a number of fields, and then click the print button. Which will then export the data they just entered into a word file, print the word file and then go on to a new record in the form. Now I want to make sure users fill out all fields. I want to...

Anyone have an idea what I need to do to get this working? And if a mod could fix the title of my thread with what I have in bold at the top of my first post, it would be appreciated

Oops: Should be Want to run macro when file is saved.... I want to run this macro when the file is saved ( at the moment I have it so that the macro runs when the file is closed) Have only started using macros recently so still learnign this stuff, can anybody tell me how I would go about...

yep it does, dont know why it didnt work the first couple of times, I must have had something wrong Anyways works fine now so thanks

thanks, have the working ok now, only one more thing I need to do though, when the data exported to the text file, I only want the latest record displayed. At the moment it just keeps on adding lines which will be no use for what I want to do. Is there any way of wiping the text file before...

Hopefully someone can help me with this. I'm trying to setup a simple form like in the example I have below: ID [ 1234567 ] Number of dvds [ 560 ] Number of blu-ray [ 100 ] Number of hd-dvd [ 50 ] Total Films [ 1000 ] Dvds % [ 56% ] this with be automatically calculated with the formula...