Search results

Not if you store the date of the last compact and repair, then check the current date against the stored date before running it again. i.e. your AutoExec code would 1. Check the date to see if its the 1st of the month, if it isn't then it exits the procedure 2. If it is then it checks the...

Can you not use left and right trims, then perform a concatenation to enable you to add the "20" in??? EDIT - which is pretty much what namliam has suggested!!!

See my post (#10) in this thread:- http://www.access-programmers.co.uk/...411#post923411 To install CDO, go to Start>Settings>Control Panel>Add or Remove programs. With "Change or Remove Programs" selected, scroll down the list of currently installed programs, highlight Microsoft Office and...

No probs, it certainly is a great site!

No probs, let me know if you have any problems

Something along the lines of:- If Me.crit1 = "Ready" Then If Me.crit2 = "Ready" Then If Me.crit3 = "Ready" Then If Me.crit4 = "Ready" Then Me.status = "Ready" Else Me.status = "Not Ready" End If Else: Me.status = "Not Ready"...

In the AfterUpdate event of the combobox where the user selects the trade, change the rowsource of the combobox that lists the courses available e.g. If Me.YourTradeComboBoxNameHere = "1stTradeHere" Then Me.YourCourseComboBoxNameHere.RowSource = SELECT...

Thanks Poppa Smurf - have you also done the work for his first 2 questions? If not, I am on lunch now and will finish the job...

I use code that provides the user with a new front end every time they open the Database. Have a look at my posts in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=184544 If you don't want to use this then wiklendt provided some excellent code in this thread...

I know how you feel - I am looking forward to a couple of days off myself

Of course we can, just let me know when you're ready

Did you do a compact and repair? To resolve issue 1 I will need to look at your table structure - I have a feeling that your Date & Time controls in your form are unbound. For your mandatory fields, I will need to write some code in your forms BeforeUpdate event and also in your Save...

Can you post a zipped up copy of your Database here, minus any sensitive data and then we can look into it for you. I am at work for the next 2½ hours and have nothing else to do....

No problem

Try Public Sub RunExcelMacroOrSub() 'declare variables Dim xlApp As Object Dim xlBook As Object 'excel application stuff Set xlApp = CreateObject("Excel.Application") xlApp.Visible = False Set xlBook = xlApp.Workbooks.Open("C:/temp/book2.xls") 'run the macro xlApp.Run "Macro1" 'delete Sheet1...

Just make sure you add the following line of code after the validation and before the email is sent:- DoCmd.RunCommand acCmdSaveRecord

It takes the new filepath and puts it into the first available attachment field which in my sample is either Attachment1, Attachment2 or Attachment3. Obviously you would need to amend the code in my sample to suit your structure.

Thats exactly what my sample does, takes a copy of the original file and places it on a shared network drive then uses the new directory as the hyperlink. I was just wondering if yours did the same, and if so if it did so in a more efficient way.

So if a user were to attach a file from their hard drive, or a location that is not shared, nobody other than them would be able to follow the hyperlink and open the attachment?

I haven't looked at your sample ghudson, but do you create a copy of the original file on a shared network drive? If not, how does it cope when a file is attached from a users C:\ drive and another user attempts to view the attachment by clicking the hyperlink?