Recent content by northy

I need to perform a query which to copies the SomeField field between Project Details and Project Details Copy for the project which is equal to the GetID() - just returns an integer - however, there are multiple versions of each project and I need to return the SomeField field for the latest...

Don't worry guys... This site is a great resource and sometimes it is just a bit too tempting to ask a question without having fully researched its answer first. I'm only dabbling in this stuff for a quick project so don't be alarmed when I disappear never to be seen again...it's certainly not...

Fair enough... I'm sure you'll be pleased to know that this foray into the world of Access and VBA is only temporary and I would imagine that this is the last stupid question (from me at least) you'll have to answer. Thanks for all the help

Sorry I have not be clear about this... I don't want to change the name of the field, I want to search a specific field (eg Field1) for my condition and then change the actual entry in a different field of the same record (eg Field2). How can I do this? Thanks

What is the best way to search a table for a record and change one of the values in its fields? [This message has been edited by northy (edited 09-05-2001).]

I am trying to append data to a table, however...i need to append data from multiple records into the same record in the other table. IE. each project has an entry for each milestone in the source table but i want to take all this seperate data and write it to the same record in the table...

Your not missing anything...i just didn't read your post properly...thanks that works great. Sorry about that.

Thanks...but I have previously managed to locate the record using your first method. What I need to know is how to get data from another field in this record (ie not the field used in the search) to a variable in my vba code. Any ideas? [This message has been edited by northy (edited...

How can I get a value from a database record into a VBA variable? I need to get the value from a different field from the one used intially to search the table to find the matching record. For example: I search the table "Project Details" for a record with a Project ID = 3 and want to capture...

Sorry, that last question was a result of a long day. Thanks for all the help...it's working just as I wanted it to now.

Thanks...that's done it! One thing though...the variable which stores the value I need is still in the function with the sql statement in it, so what's the best way to set the output of GetID() to be equal to this value?

When you do that...it brings up a message box prompting you to enter the value for the variable name you entered. The variable is definitely defined and working because it is used elsewhere in my code. I have done something similar in Excel queries which required this format: `" & Variable &...

I have the following code as part of an SQL statement in VBA: ([PRS Project Details].[Project Ref])= 3 Can anyone tell me the syntax to replace the 3 with a variable eg. and integer called ID? Thanks

Thanks for the help but I don't think I explained what I am trying to do properly... I need to call an Access macro from a completely seperate VB application (not a VBA module or another macro associated with the database). I have already managed to call an Excel macro so I assume there is...

I have managed to get a VB application to run an Excel macro using this code: Dim oXL As Object Set oXL = CreateObject("Excel.Application") oXL.Workbooks.Open FileName:="Test.xls" oXL.Application.Run "Test.xls!Module1.Macro1" oXL.Quit Set oXL = Nothing Does anyone know the appropriate syntax...