Search results for query: *

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

Hi Just tried your method and unfortuantely similar error. I think the reason is that the script, which sits in the update form, is not referencing the project form correctly. How can I refer to a subform in another form from a dialog box which is closing? I get in a mess with the referencing...

Hi I thought I had worked all this out. I'm trying to do a straightforward requery of subforms in a main form. I've used this method in the past but I just can't get it to work this time. The process so far is the user adds a new record from a pop up form. When the user clicks a button on the...

Hi I changed the alias of one of them but still a crash. Here's the sql for the underlying query: SELECT qry__monthlyData.Month AS RptMonth, Sum(qry_monthlyData.[Planned in Month]) AS Planned, Sum(qry__monthlyData.[Delivered in Month]) AS Actual FROM qry_monthlyData WHERE...

Hi All As usual I've run into a brick wall... I'm trying to get a running total column in a query, using references found here, but each time I try and execute the query it crashes Access (version 2003). No error messages produced. The query is based on another query that totals monthly records...

Hi I'm progressing my project - I've referred to the recordset of the subform nut because my stocklevels is an unbound control in the continuous form it does not appear in the record set. So, I then added an expression in the underlying query for the stock level and bound the control to that...