Search results for query: *

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...

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...

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 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 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...

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 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 trying to create a stock check form. I have a continuous sub form based on a query that lists all the products available and a text box for the user to enter the current stock levels in their stock check. I now want to create a new table entry in the stock level table that is based on...

Hi I'm attempting to learn by re-creating the adobe spry gallery demo in DW CS3. I can create the gallery - no problems there but I'm stuck trying to implement the thumbnail grow effect. When I use the code from the demo - copy and paste my page appears but with errors and the thumbnails do not...

Hi, I'm what is best described as a stumbler....from one issue to another. Most I resolve through other posts but I'm stuck on this one. I have a form which allows the user to specify criteria. After clicking a search button the search results are displayed. The query is created within the...

Hi all, I'm having trouble understanding what I'm sure is a very very very basic issue that I'm just not aware of. I have two excel workbooks open - not in the same session as the software that generates the second book starts a new instance of Excel. I want to copy some formulas from my first...