Search results for query: *

Hi Skins64, Assuming your check boxes are called Subcribe and Unsubscribe If the user ticks Subscribe check box you can use the check box properties, events, after update as follows: Me![Unsubscribe].Enabled = False Likewise for the Unsubscribe after update: Me![Subscribe].Enabled = False...

Hi sazzas, You may want to follow up on this from the help file: You can use the CurrentY property (along with the CurrentX property) to specify the horizontal and vertical coordinates for the starting position of the next printing and drawing method on a report.

After a very hard landing at Toronto: "In case any of you failed to notice, we have landed at Toronto International Airport

Try Shoot the Messenger from Gibson Research http://www.grc.com/stm/shootthemessenger.htm

I remember reading somewhere that this can be caused by having two versions of MSJet.dll. Try file find MSJet* and see if the old version is still there. Sorry I can't be more specific.

Hi Hanss, As we helped you win the America's Cup then we will try to help you with this. I think the simple answer is no. The criteria being passed is "115 or 110" and that is what is being evaluated by the query. Possible solutions: Another text box which you evaluate with the iif...

Hi Nene75, If you format the date to include hh/mm (hours and minutes) then a group query with max for the date field will give you the last record. Regards, Dale

Hi Doug, I would suggest that if you want to track each mailing then you will need a table with the MailingID, CustomerID, and, possibly date unless you keep this in the MailingID table. What you are creating is a one to many relationship, ie one mailing too many customers. You could display...

Hi ghnat, You can place an invisible field on your form bound to Customername. On the after update event of the combo box CustID: me![Customername] = me![CustID].column(1) Just remember that the columns start at 0, ie if you set columns visible property to 2 it is not column 1 and 2 but 0 and 1.

Hi Cwoolley, Have you thought of using a continuous form and then you can use the on click or on dblclick event to go to the detail form.

Hi fredk, If the group by works then it could be the joins between your tables. Could be the sequence you are linking tables or check that they are only matching records, not all from one and only matching from the other.

Yes, Use the after update on the residential address field to update the postal address field. Me![PostalAddress] = Me![ResidentialAddress] Using of course your field names. This will populate the Postal fields but they can still be changed. Dale

Andre, I have created a table with all of the keycodes, 1,679,616. If you send me your email I can send it to you and you can run an unmatched, ie is null, of your table against it. caniwi@ihug.co.nz Cheers, Dale

Bull, A lot depends on wether or not you are using existing table or creating new ones. I would need to know a bit more about the tables you are using and whats in them to be of real assistance. If new ones you may want to set up a few lookup tables and use combo boxes when entering members...

Bull, Depending on how many depts, a form and subforms could work. Subform for each dept: Header Department Dept Head Leading NCO Detail continuous form sorted by code for PFC's Main form: Header CO XO SEL Detail Postion the subforms across the form. Dale

Andre, OK, another thought. Looking at a 2 character combination: 00 01 02 | ZX ZY ZZ A crosstab query with: the row grouped on the ist character the column the 2nd character the value the character should produce: 0 1 2 - X Y Z 0 00 01 02 0X 0Y 0Z 1 2 | X Y Y Y0 Y1 Y2 YX...

Andre, I was just geeting back to you to say scrub that post. Quick thoughts thought too quickly. Dale

Hi Calihiker, Part of the problem will be that because you have not used then they are not in the table. Some quick thoughts: In a group by query based on your table: field Select:left([keycode],1) sort acsending This will select only the ist digit/alpha of your keycode and show if you have...

Try setting the form's format properties: Navagation Buttons No Dale

If it's nice and orderly then it suits setting up a org chart. Requires setting up a table of that structure and then linking that back to your crew table.