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

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

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

Hi there, Im just knocking up a quick Access thing for work - moving data from a field in a form to a table. Anybody got any ideas why I get this error? "Runtime error (13) - type mismatch" We're using Windows 2000 and Access 2002... Cheers Option Compare Database Option Explicit...