I have developed a db in Access2007 - it was used to generate and print barcodes for our library system.
I have recently upgraded my MS Offcie to 2010 and need to add another component that manages loans of our hardware.
So I thought I'd upgrade the front-end of the original db for use on a sharepoint server. So . . .
On the old version, I had 3 forms related to barcode generation.
A. Add Barcodes and
B. RePrint a Box Set and
C. Reprint a range of barcodes.
So when investigating the new features of 2010, I thought that I would create a navigation form (called Frm_Switchboard) with two Navigation buttons on the left. (Barcodes and HardwareLoans) - See the attached image
When the user selects Barcodes, then a subform (which is another navigation form) displays.
Now this is where I get stuck.
When the user clicks the "Print this Range" button, the report sources data from a query that refered to the form. On the old db, it was the only one open, so it was easy to reference the "Start" and "End" range.
How do I reference this field in 2010?
I have tried the following;
[Forms]![Frm_Switchboard]![NavigationButton11].
[Forms]![Frm_Switchboard]![NavigationSubform].
In both these cases, the intellisense(?) popup doesnt offer me an option that makes sense.
Similarly, I am trying to insert a record in the loans field and have this query which also does not work - for the same reason.
INSERT INTO tbl_Loans ( MachineID )
SELECT [Forms]![Frm_Switchboard]![Forms]![Frm_HardwareLoans]![Forms]![Frm_Loans]![MachineID] AS MachName;
Thanks
I have recently upgraded my MS Offcie to 2010 and need to add another component that manages loans of our hardware.
So I thought I'd upgrade the front-end of the original db for use on a sharepoint server. So . . .
On the old version, I had 3 forms related to barcode generation.
A. Add Barcodes and
B. RePrint a Box Set and
C. Reprint a range of barcodes.
So when investigating the new features of 2010, I thought that I would create a navigation form (called Frm_Switchboard) with two Navigation buttons on the left. (Barcodes and HardwareLoans) - See the attached image
When the user selects Barcodes, then a subform (which is another navigation form) displays.
Now this is where I get stuck.
When the user clicks the "Print this Range" button, the report sources data from a query that refered to the form. On the old db, it was the only one open, so it was easy to reference the "Start" and "End" range.
How do I reference this field in 2010?
I have tried the following;
[Forms]![Frm_Switchboard]![NavigationButton11].
[Forms]![Frm_Switchboard]![NavigationSubform].
In both these cases, the intellisense(?) popup doesnt offer me an option that makes sense.
Similarly, I am trying to insert a record in the loans field and have this query which also does not work - for the same reason.
INSERT INTO tbl_Loans ( MachineID )
SELECT [Forms]![Frm_Switchboard]![Forms]![Frm_HardwareLoans]![Forms]![Frm_Loans]![MachineID] AS MachName;
Thanks
Attachments
Last edited: