Recent content by jim84

Yeh these are fine, unfortunately. The form has no trouble finding the correct child records its just when trying to add new ones via the subform. As i said before it doesn't link the records you type in to the TAG you've previously selected.

OK, problems! im right at the very end of my project and all of a sudden this little beauty pops up. Typical! I have 2 days to finish it so would really appreciate any advice or help!! :) ---------------------------------------------------------- Ill start with background info: # The 2 parent...

I've got a text box and have it set it so that it shows the record number the form is currently on. This is the code: =[Form].[CurrentRecord] in the ControlSource. I was wondering if it would be possible to allow the user to type in the record number they want in this text box? I dont mind...

Thank you, got it sorted now :)

Does anyone know the code for opening a specific notepad file from a button? I know there's a default button but it only opens a blank notepad page. I need to open some written instructions from a button you see. Thanks.

Thanks for the advice guys :) I've given up on it now, I found it a bit limited so created my own nav system by linking forms together so no problems now.

sorry, i thought every post attempt had failed. So, can anyone help with this ^ Thanks. Jim.

Hello, Im posting in need of some advice! I've used combo boxes as search tools on forms before with no problems. This being you select a record from the drop down (usually by the key) and subsequent text boxes and subforms update appropriately. THEN THE PROBLEMS BEGAN! :eek: I have a table...

Yes these labels are ones i've made myself and added onto it. The default labels change, as named within the switchboard manager, but my added ones dont. Can i set these to appear visible on specific switchboard pages only?

This is the first time ive used the switchboard so hopefully this will be just a quicky! Bascially i have a main switchboard which has 3 buttons. These buttons all link to different switchboard pages. THE PROBLEM :- I have labels on the main switchboard and these are all appearing on the...

yes Dennisk you are completely correct. I took another approach and it's got me a little further.. I copied and pasted the data into the 'many' table and it automatically created a "paste errors" table of all the dodgy records. I then made a query of this table. I then fixed some of this data...

ok ive tried doing it simply cut and paste and yay, its given me a paste errors table. lovely!

no luck. i forgot to mention that the data is being imported from an excel spreadsheet, not sure if that'll cause issues!

Yeh i was told this would happen but it hasn't. Is there an option somewhere i need to toggle? Thanks.

Basically, I want to use this ^ . I have a load of tables with primary key fields and then a table with just the appropriate foreign keys (we'll call this the f table). I have all the table links set up to Enforce Referential Integrity. When I import the data i need into the f table a warning...