Recent content by AlexB

How do I open a record on the primary key, rather than having to open it on the row number using the docmd.gotorecord command?? On another note, how would I go about interacting with a query using code? Is it in the SET RST command? Thanks... :confused: :confused: :confused: :confused: :eek:

Is this possible? I just need to be able to use a publicVariable as a criteria in a query.... how do I do this? Cheers

I am creating a Project Management database for the company that I work with, and I am having problems trying to run a query off a few tables. I think it is to do with the relationships that I am using to link the tables together. The idea is to bring together a couple of fields from each of...

Hi there, me again Im trying to create a form that has several list boxes: the first looks up values from a table, the 2nd will look up values from a query using an ID number from the first, the 3rd will look up values from the same query based on another ID key that is selected from the 2nd...

Ok, thanks again! PS - do you get paid for this? ;)

Sorry, your first suggestion has just gone over my head. The 2nd one I could use... how do I declare public variables?

I need to be able to pass a variable (or several) from one form to another - is it possible to do this? I want to be able for someone to enter data into a form, and transfer an ID number when they click a button to open the next form. I could bodge it and store it in a table at the end of one...

It suddenly worked earlier, but I posted a reply in the wrong thread.. oops Cheers again for your help, Im actually making progress now

Crap,wrong thread!!

HUZZAHHHHH! It worked!! I don't know why, but it did! Maybe its because I inadvertantly had the table already open in the background? Ah well, Im chuffed. :D

I've just figured out why I can't use the RST.AddNew command thing. I'm using Combo Boxes on my form to allow the users of the form to select people from a table, and these are based on a query of the table. I noticed that when I open the form, and then look at the table, I cant add anything...

I've just figured out why I can't use the RST.AddNew command thing. I'm using Combo Boxes on my form to allow the users of the form to select people from a table, and these are based on a query of the table. I noticed that when I open the form, and then look at the table, I cant add anything...

Sorry, me again... Is there any reason, when using the code from my previous message, that I should get a "Cannot update. Database or object is read-only. (Error 3027)" error? I've read the help and it says about using the OpenDatabase method (which I haven't... have I?), Using the data...

Ahhhh.. ah.. ahaha... Yes it works now, it just gets stuck on the next bit! Cheers Mile-o-Phile

Ok, the references I have checked at the moment are: - Visual Basic for Applications - Microsoft Access 10.0 Object Library - OLE Automation - Microsfot ActiveX Data Objects 2.1 Library - Microsoft ActiveX Data Objects Recordset 2.5 Library - Microsoft DAO 3.6 Object Library Is there anything...