Search results

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

Thanks for the reply, but I've still got the problem... This is my code: Option Compare Database Private Sub cmdAddEmployee_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("select * from EmployeeDetails;") rst.AddNew rst!EmployeeDepartment = comboDepartment...

Hello there I've got a problem with some code that I'm trying to write behind a button. All it will eventually do is just transfer the values from some text fields into a table... Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("select * from tblProjects") When I click the...

Whey!!!! Cheers mate, it works now

Hmm that still doesnt work If I right-click on the CurrentDB text and go to definition, the CurrentDB object comes up in the definition window. However, if I then click on the Database link in the example, it says : "Cannot jump to Database because it is in the library 'DAO' which is not...

It gives me an error on the SET RST bit... Set rst = CurrentDb.OpenRecordset("select * from tblProjects") I haven't done VB for a couple of years now and cant really remember what Im doing!