Search results

i have been promising myself for years to learn how to use mod(). someday, i going to do it! to alex..... i think i follow your code, but in: WrapBaseN(base10tobasen(452,26)) what does the 452 represent? ------------- so damn much to learn; so damn little time to learn it thanks again...

alex, elegant solution...will file it in case i need to ever do this again! i couldn't see ian's excel formula as it was in a later version than i have. but i was able to copy his sheet1 in xlview and paste it and create my update query. all's well that ends well this board is a GREAT...

ian, ---you wrote--- Does that help? --------------- are you jesting? i was just looking for a place to 'get my shovel in the ground' ! lovely,indeed! thank you so much! i owe you one... al

no sure i can even explain this...which is probably why i can't figure it out i have a group of numbers that basically range from 1 to 600, but not all-inclusive. ie, there are gaps. i need find a way to represent each number with a unique 2 digit alpha field. ie, convert 001 to AA, and...

wow, think i burnt out my PageDown key! you might check Help for: Partition Function not sure that is what you are looking for. hth, al

long day here too... you are missing a closing paren...but the problem is probably with [Total Amount]. if [Total Amount] is based on something like [field1] + [field2] + [field3], replace the IIf field [Total Amount], with [field1] + [field2] +[field3]. in other words repeat the calc in the...

Haytham, honestly, i don't have a clue. the code you posted actually is meant to generate a barcode. i didn't really try to analyze it very much, but it appears to be generating the barcode based on the size of the control. i was talking about barcode fonts where all you have to do is create a...

Haytham, you could have any of a number of problems. what symbology is your barcode? al

the code you posted will only create a new excel sheet (or shit...Freudian?). you probably can use a hyperlink to open your desired sheet. check Help for hyperlink... hth, al [This message has been edited by pcs (edited 01-20-2002).]

the only one i have on any of my dev. units is an old code39 from Altsys...not sure they are around anymore, but their stuff was pretty good. most of the fonts i have used for clients came from the DevKit for an industrial lable printer. suggest you do some experimenting, it's pretty simple as...

the easiest way is to use a barcode font... you can then create a report that you call from your form with the font for your field set to the desired barcode font. do a search for: +barcode +font +download you will find lots available, be aware that the quality varies and do some testing to...

it depends...do you want to open it in excel or import it to access, or what? al

i'd try reducing the bottom margin setting, and see if a row or two appears. you might also look here: http://bizforums.itrc.hp.com/cm/QuestionAnswer/1,,0xeb82972194d6d5118ff40090279cd0f9,00.html hth, al

in addition to the good advice already given...develop a style that you use for all your forms, etc. consider using formatting options as 'visual clues' to the actions available to the user, and make them consistent throughout your db. for example, i use 'sunken' for only those textboxes that...

another long shot... delete any .tmp files on the pc in question and run scandisk... hth al

damn, i've missed another deadline! al

based on the examples you gave: you might try using the InStr function in the OnFormat event of your report and change the visible property of the 2nd control. my suspicion, however, is that what you are trying to achieve, is probably more complicated than the examples given. hth, al

sounds like you might have a couple of 'artifact' fields in you query. it might be helpful if you post the query SQL. al

rickyc, well, you have posted the same question to several forums. in which one would you like the answer? al

while i haven't tested specifically for it, i don't think the order of the fields in a stored query makes any difference... making sure that you have indexes set up in your table design for appropriate fields, does, however, have a major impact on speed. hth, al