Search results

Access 2003 I would like to use the same form for two different tasks (say... form B). 1) I would like to use a button on a form (form A) to access a second related form (B). I would like to know if there is any VBA that will ensure that the second form only opens the sub record of interest...

Solved Managed to get this working. I was over complicating the issue! You can put a button on a form and reference the sub form using the standard referencing format for sub forms from a master form. When using a field within a sub form in datasheet view, to open another form, access will...

Thanks for this. Not quite sure if this is the right solution, I may be missing the point though! I am looking to open a new form, based on an ID in an embedded datasheet - there are numerous IDs displayed in this sheet - I only want to use the ID in the row that has the record selector...

Access 2003 --------------------- I am having a problem with opening a form from a sub form. I don't know how to access the subform record selector property on my master form. I have a master form (A) built on a table (table A) . The master form has a sub form(B), built on a table (table B)...

Oh! see! Just a standard shortcut pointing to both openable front end and security file. I have this working now - thank you!

Yes please!

Set-up ------- I have an Access 2003 database - front end and backend. front end sits on dept desktops back end sits on an accessible network with security file/workgroup Problem: --------- Sometimes the network goes down and subsequently the front end on colleagues desktops can no longer...

Tried entering data directly into table. Access is providing an already used autonumber, about 10 records prior to working last record. Can anyone advise?

Image Attached. All seems fine with the table index, any suggestions welcome!

I have built a database in Access 2003, it has been robust up until now. We noticed that some records were being added and some weren't through a form. I had a look at the ID numbers that Access was automatically assigning (primary keys) and realised that Access was sometimes assigning keys...

Thanks for this, I haven't had any success with this - any other suggestions?

I have a rather bizarre SQL issue. I am taking data from two tables and copying it across to a third table, before deleting it. This works perfectly well until I reach the number (a key ID number) 22401 and beyond. I have checked the casts (long) for the recipient table and in the code I have...

Is there no other way? Perhaps some kind of current record method that allows VBA to work with the current selected record in datasheet view?

I have a problem with combo boxes set up on subforms I have 4 tables. Table 1 (tblContacts) & 3(tblSession) are linked by an index table, table 2 (tblContactSession). Table 4 (tblCourse - can have many sessions) is a parent/lookup table to table 3. I have a form with table 1 as the main...

Edited Records.

Thanks for the reply RG. Right, so the form filter is only accessing one record from the tables, locking depenndant upon setting the correct proprty, and leaving the remaining records in the tables unlocked for other users who may need to access and edit them? Appreciated.

Hi, I am opening a form, from another form, that is based on a table of 20000 records. I am using the WHERE criteria to do this, code is included below. I need to provide database access to several users on a network (and only want to lock the record that the user has searched for), and was...