Search results

Point taken many apologies, i will await the responses on the other thread now.

I only asked on here because if the pop up form cannot work with the EndDate being calculated on the fly then your suggestion would not work for me. However thank you for your advise.

Hi all, The kind of thing i am looking for is similar to the attached which was given to me a while ago. The coding is for if a field is empty then a form will open once i have opened the db however in this occasion i want it to open if the EndDate field is prior to 45 days the coding for this...

I need the a form to pop up from that date, if it is calculated on the fly can the form see the information once the database is opened?

Hi all, I have a form called "Network" and a field within called "EndDate" when it gets to 45 days prior to the EndDate i want a message box/form to appear (when i open the database not just the form) to state the name of the company and display the end date. Does anybody know how this can...

Hi All , Happy new year to you all. I have 3 fields called "startdate" "duration" and "enddate" If i enter 09/01/2012 into "startdate" and 12months into duration i want the "enddate" field to automatically add the end date into the field. Is there a way to do this? I understand i might...

Hi All, I have never experienced this before, i have a form and on there is a field called "address" the field type is memo, now all data is displayed on the form but if i view the table only one line is displayed. For example On my form is says 123 Test Street Test Town L11 CKY My...

I am trying to create a report to perform a mail merge however when i select the fields company_name, address and postcode to be included the address only appears with the first line. If i view the form it has the entire address displayed and goes back to address but the table only has the first...

hello, i have a split database with the back end on a server and the front end on the desktop of each user. I now need to move the db from one server to another but i am unsure of the best way to do this. I have tried to relink the tables however the path is still for the old server and not...

Apologies, i have it working now. Many thanks for your help.

If i enter that into the test db it works however if i then put it into my proper db it doesnt, i changed the names, my db has tabs in it so would that stop it from working? I entered Dim rNum As Long rNum = Int((999999 - 100000 + 1) * Rnd() + 100000) If Me.NewRecord Or Me.RandomNumber = 0...

No because i dont know anything about code so wouldnt have the first clue of how to work through it. I have attached a dummy db with the code in, i have been trying to get it to work in this before i tried in my other db.

I must be doing something completely wrong, i have entered your code and although it doesnt issue an error is doesnt get me a random number either, my field is blank.

Hi, I have entered the following into the before update event but it doesnt generate a number, anyone know what i am doing wrong? Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then RandomNumber = Int((999999 - 100000 + 1) * Rnd() + 100000) End If End Sub

Hi everyone, thanks for all your comments and suggestions, as you are probably aware i am learning this as i go and only figured out how to get random numbers generates by looking through the internet. I want a six figure random number hence why i used =Int((999999-100000+1)*Rnd()+100000) I...

Hi Everyone, I have =Int((999999-100000+1)*Rnd()+100000) as my control source so i can get a random number. Unfortunately everytime i reopen my db the random number changes. Is there a way that once that record has been given the random number that it saves it to that record?

Thanks for all your help and advise, i will look into the date issue that you have advised and i have worked out how to get the two characters from a postcode.

There is an Autonumber ID in the customer table and also a seperate customer account number.

If i have a customer i have an order, if i dont have a customer i dont have an order.

Hi, i would need to have the first two characters, L1 or LE is fine, i just need the first two. The business i am in a customer will place one order and that is it and will be billed monthly for that order alone, when i get their order i will enter their contact information and the order they...