Search results for query: *

I went with gwinn7's recommendation. Thanks gwinn7.

Thanks all - I got it working!!!

I had a similar issue and found that I had to ensure that the computer in question had the "code references" set up correctly. If you go to the Visual Basic window (i.e. you are looking at code), under the tools menu you will see references. Check to ensure that all the references checked on...

I have a command button which sets up an email list based on names selected from a RSVP list. I had this working for awhile but now I get a "type mismatch" code error when I try to run it. The code is shown below and the type mismatch occurs on the following line: Set RS =...

Thank you REMOU. That solved the problem!!!

Let me try to explain form a different perspective: I have a main screen that is tracking purchase orders. Each purchase order has numerous line items which I am currently displaying in a subform, linked by the PO id. Each line item has numerous ammendments containing ammendment no, delivery...

This does not appear to work, I think because I don't have a control on the subform, therefore there is no control to reference in the code string.

The name of the unlinked subform is nfrm_ammendments, the name of its underlying query is nqry_ammendment. I tried various requery types like docmd.requery "nfrm_ammendments" or docmd.requery "nqry_ammendment" I tried Forms!Nfrm_ammendments.Requery and Nfrm_ammendments.requery which also does...

I have an unlinked subform on a main form whose data is defined by a query. The query has its criteria defined by a field on a 2nd subform on the main form. What I am trying to do is to have the data displayed in the unlinked subform change when I select the next record in the 2nd subform. This...

I would like to define the query to use when opening a form based on command buttons on the mainscreen form. I've tried using a public variable defined on the mainscreen form (under general declarations) which I set to the appropriate query name at the command button (which opens the form) but...

I found this on a search I just did for the same kind of problem. Hope it helps: There's probably other ways, but this should work. Create a query to gather the distinct equipment IDs and their most recent date: SELECT equipment, Max(datefield) AS MaxOfdatefield FROM Tablename GROUP BY...

Atxross This has happended to me on occasion and the only way I've been able to make the wizard work is to create a new form from scratch. It appears to be some hiccup with the underlying code of the form and once screwed up it won't allow you to use it regardless of what you do. As mentioned...