Search results

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

do you mean you want the subform to populate or have you got text boxes that need to populate from the combo box as well?

All solved. I had picked the wrong type of combo box use in the wizard. D'oh!

Hello, Im pretty new to all this so apologies if this is very simple..! Basically, I have a form which simply has Username (in a combo box) Surname (in a text box) and First Name (in a text box). I used this code in the after update field of the combo box: Private Sub Combo6_AfterUpdate()...

Its all good, i got it working eventually, turns out i was putting the code in the wrong place.... haha whoops. Thanks for all the help mate, really appreciate it :)

I've typed in: =Me.Combo8.Column(1) for first name, in the control source. when i switch to view mode it just has #Name? despite whats being clicked on in the combo box.