Search results

nah, 1 picked up a job a a part-time lorry driver

hey rich, can't believe you responded to a question addressed to: 'Hello access2000 fans' have you changed your opinion about a2k? al

Hassan, short answer for A97 is no....a2k has conditional formatting that would allow this (i think...) if you really want to do this in A97 (and I mean you REALLY want to do it!) Mike Gurman has posted some code that will do it... see if this link helps...

---you wrote------ In my test table, I have a field for checkbox set as number in the datatype. ------------------ i could be missing something here...but a checkbox is boolean, not a number. if you want a checkbox, change the field type in your table to Yes/No. hth, al

-------you wrote----- Will old versions of Office become collectors items --------------------- like most things collectable, i think some versions will be more sought after. ver. 1.0, 7.0 and 2000 will likely have no current or future market value. al -------------- rich, on further...

glad it worked... we won't go into the reason why...another A2000 'improvement' from MS al

this will sound stupid...but try changing the extension of the output file to .txt instead of .doc. and see if that changes anything... al

not sure i'm reading your question correctly...but think you want to place the Like operator at the beginning of your criteria expression. something like: Like (IIf(IsNull(Forms![Form1]![Field1]),"Member","*") that may point you in the right direction. hth, al

assuming that the phone/fax numbers are ALWAYS exactly 10 characters... create 2 unbound text boxes on your report with the control source set as: ="("+Left([YourPhoneField],3)+")"+Mid([YourPhoneField],4,3)+"-"+Right([YourPhoneField],4)...

hey RDH, that's pretty slick! al

you have a problem with the design of your tables. you need to have a primary key that is unique to do this, so that previously appended records are not duplicated. why don't you post the design of your tables. hth, al

assuming your form is indeed bound to a table or query, it would appear that the version makes a difference. but you need to verify that your form has a RecordSsource, if the form is "unbound" (no RecordSource) you won't see option 3 in the wizard! pretty certain that is the problem. i don't...

hmmm, well a subform is arguably part of the main form. and unlike, a combo box, it will display all records when the main form opens. further, you can put the command button right on the subform at the end of the records to open your other form. when you look at the 'Solutions' sample, you...

well, the developer could have done several things. try the easy one first, hold the shift key down while you open the application. hth, al

think you missed the correct option when you used the cbo wizard. the wizard should offer 3 options: I want the combo box to look up values... I will type in the values... Find a record on my form based on the value i selected... you want the last one: Find a record.... delete your existing...

rdh, that was i was going to suggest... it just seemed too simple al

you may be asking a question that is way beyond my expertise as i don't create wizards, builders, activex controls, etc. are you talking about custom public functions that you have written and placed in a module? al

create a text field with its control source set to: [yourSubFormName]![TOTALAMOUNT]-[AMOUNT] hth, al

have you considered using a continuous subform to do this? hth, al

there might be easier solutions...but think you are going to have to provide more details of what you are trying to achieve. al