Search results

jack, when are you going to get shed of that cigar-smoking flower-sniffing hussy? she is only after your money... al

think your problem is the Between Date range...the tbl_Worked date can fall outside the the date range you select. could you add a LotNumber (probably an Autonumber field) to tbl_Received and tbl_Worked to tie the two together? think you could then create queries that will account for the...

jack made a small typo.... try: Right([yourURLFieldName],Len([yourURLFieldName]) - 3) (jack and I both get a bit unreliable on Saturdays, as our respective nursing homes let us go to town for an hour to get lemonade and chase women...) al

short answer is no... al

use a query as the source for a continuous subform on a popup form...that will allow you organize the product list in any order you choose. btw: you can also base a combo box on a query to get the desired order, and use headings... hth, al [This message has been edited by pcs (edited...

think i would consolidate the tables into a master table as Pat suggests, you would need to add one field to the master table: CompanyNumber. don't think there is any way change the table source of a stored query. you could, of course, generate SQL code in VBA to construct your query. but, i...

Ragalots, congrats on the new baby! 50 tables seems like a lot! i suspect there may be a design issue here. tell us more abt. what info you are placing in the 50 tables. al

ben, as usual, Pat H. is correct... DoCmd.RunCommand acCmdSaveRecord is much better, as it will have more longevity in newer access versions. i got lazy and posted code from the button wizard. i find it odd that while a97 Help details extensively the preferred method, the command button...

set the form property: Allow Additions to No... hth, al

when you say: click the print button---- if you mean a command button that you have placed on your form to print the report, try the following in the OnClick event of the print button,(before calling the report): DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 hth, al

i may be missing something here... but have you tried: Mid([YourField],4,Len([YourField])) hth, al

ok...i was talking about an MS Access form. you need an Excel expert to step up to the plate takers? (you might want to re-post your original question in the Excel forum) al [This message has been edited by pcs (edited 12-03-2001).]

if i read your question correctly... check in Help for: Partition Function hth, al

oh my...something just caught my eye! --------you wrote--------- I forgot to tell you. I am on NT 4.0 Xl 97 SR2. -------------------------- we're not by any chance talking about a dialogue box or form in an excel spreadsheet are we???? al

only other thing i can think of: do you have any other forms that are set to disabled (or hidden) when you problem form is active? you might also see if your db works ok another pc... otherwise, i give up! al

a long shot... are you using any (keyboard) language settings on the pc in question? al

i guess that it's possible that your form is corrupted in some mystery manner. you might try creating a new form and putting a command button on it and see if the behaviour persists. btw: what version of access are you using? al [This message has been edited by pcs (edited 11-30-2001).]

never heard of any problems like this... is the desired character underlined in form view? this. are the menu items shorcuts functional? (Atl+f activates the file dropdown). does the Tab key cycle thru the command buttons? al

hmmm, make sure that you don't have a space between the & and the desired activation character. hth, al

sometimes mud is pretty clear! keith, assuming your data always is as you described. jwindon has the easy and elegant solution... you could do it in one step with: Trim(Right([YourAddressField],8)) al