Recent content by longestdrive

Great, This worked. Thank you

Aghhhh FOund one part of my problem - a bit more reading and googling. My docmd.save just saves the form not the record so I'm going to use RunCommand acCmdSaveRecord Which now works. YAY But...How can I pause code on one form while another form is open and then resume when that other form...

Hi I have an unbound form displaying record details, this has an underlying recordset and a combo control to enable the user to move through the records. This all works fine. I have a button on the form for the user to add new records, it pops up a form and the user enters the details, this...

Thank you. Using the code on that page I was able to find the folder in the root of the mailbox and get my move message to work. Yay!!! Thanks for the pointer

Hi I'm dabbling in outlook 2003 vba and I'm struggling with the folders which might be my biggest problem. I found some basic code to move selected items to a folder and thought I'd try this. However when I run my code I get an error '424 - object required' which I assume means it can't find...

Brilliant! Thank you both - it works a treat Thanks

Hi all I'm gradually getting through my project thanks to your help. I now have a working export from ms project to excel. I had trouble setting the range object and should have specified the sheet object before the range. but that's ok now. My problem now is setting range to equal two sets...

Hi Skip For a moment I didn't quite understand what you meant as I always thought I had posted a thank you within the message as I did with this one. In a panic I've scurried through the website looking for the forum rules because I've missed a function on he site and now I've just spotted it...

hi PHV THANK YOU! I typed the DIM statement incorrectly in my message - it was correct in the code. I've added in the sheetobject and it works a treat Thanks again LD

Hi I'm working on an export function from MS Project to Excel. The export function works great. I have dim xlrange = excel.range and used this object numerous times throughout the code as long as range only points to once cell. I want the xlrange object to select a number of cells and...

Hi All Thank you for your responses. I did as suggested and used the macro - I often overlook this solution so apologies. The solution is as anotherhiggins pointed out, the double quotes. Interestingly when I tried to type the code it didn't like it but a copy and paste from the recorded...

Hi All I'm stuck on a simple task. I can format a range of cells in excel to set a descriptor after the number. using the number format 0.0 "hrs". However I want to repeat the format using vba via numberformat. I'm referencing excel via MS Project i've used this code: .NumberFormat = "0.0...

Hi I have a main form with 2 connected subforms. When a user clicks in a record on subform1 the data in subform2 is updated using requery. Historical records have a field called locked which is either true or false. Depending on the value of this field I want stop the user editing the record...

Just by way of an update - it was all down to syntax - referencing my subforms - thank you for your help. I needed to use: Forms!MainFormName!subFormName.Form.requery Thanks again

Excellent Thanks for the references - I'll have a go today and check my references out Thanks again