Search results

Ahhh... it all becomes clear-ish. I was looking for a subForm, not the actual form. In design mode, I'd deleted the subform and Access wouldn't let me drag it back in again, it said the name already existed... so I was looking for that name to delete. I didn't want to delete the actual source...

Aha! Paul - many thanks, you are indeed right! But I don't feel too much of a goof, somehow a "1" had been appended to the name without me realising. Now working nicely, and more logically. Thanks again :)

Thanks for all the advise. Sadly I still can't get requery to do anything but give an error. Here's the three syntaxes and the errors - Forms!frmLPWork.tblLPtsubform.Requery Run-time error '2465': Application-defined or object-defined error Forms![frmLPWork].[tblLPtsubform].[Form].Requery...

Aahh.. thanks Guys. I know what you mean (I see that in Excel) but my Access 97 has what I've come to know as the 'Database Window' with a Forms tab. Guess that's it's equivalent... BUT there's no subForms showing there. My problem was, after deleting a subForm, I couldn't replace it because...

Hi, A reply to one of my questions was "Deleting the subform control does not delete the form object. Look under the list of forms and you will find it. " Can someone please tell me where this 'list of forms' is found. I've been looking and...

Hi, I have two tables and want to Update Fields1 & 2 in Table1 to Fields1 & 2 in Table2 Field3 in both is the same and I intended to use this as WHERE table1.Field3 = Table2.Field3 But I don't understand the little arrows that connect 2 tables in the design grid, or how to control them. Any...

The command is, from help, DoCmd.Requery [controlname] The name of my 'control' is tblLPtsubform but the instruction - DoCmd.Requery ("tblLPtsubform") brings up error Run-time error '2109': There is no field named 'tblLPtsubform' in the current record. Should I use a Control Data type e.g...

Hope I can explain this properly! Please bear with me.. I have a SubForn based on a Table, which is empty. The main form lets me input a set of data. I then open a recordset to the aforementioned table, and populate it with .Addnew and .Update. My aim is to have the subForm show this data - as...

Nice there's an explanation - thanks. The 'List of Forms' - is that the list of Forms in The Forms tab of the database window ? I can see no other list anywhere, and it ain't there! I see no sunforms there, actually.

Hi, I'm new to this and this stuck me as strange. I created a Form, and dragged 2 tables onto it to make 2 subForms. I changed the Field names in one of them, subsequently these display as #Name? However the table itself was fine. So I deleted it from the Form and dragged it on again. In doing...

Thank you all for the replies. This was a further sort that was wrong within an already sorted set - because there were numbers in a text field not seen as numbers. Now fixed... I conclude an Update Query by itself couldn't do it.

Thanks for the welcome :) The answer, as best I can muster is, I have a number of records in a table which are in the wrong order. I can select them in a query and sort them into the 'right' order. But I want to update them, so they are always right when viewing the whole table. I must say...

Hi, I have a Select query sorted by a function. I'd like to use this as an Update query, but I lose the Sort option in the grid designer. What is the best way to get around this? Thanks