Search results

alex, your word is always trusted! i guess i am a 'heavyweight' Luddite! and i am nearly 'shoeless' (sans sabots?). but, it is due to my poverty keeping up with all the changes as i try to maintain Bill G.'s cash-flow and life-style! in a more perfect world, 'crap features and market hype'...

jerry, glad alex is still speaking to you :) don't know if these url's will make it through this post intact... bunches of A97 stuff: http://www.microsoft.com/downloads/searchdl.asp?Search=Product&LangIDCODE=20%3Ben-us&Value=3&OpSysID=1311&Show=Alpha neatcode97...

try: ="Title" & Chr$(34) & [title] & Chr$(34) hth, al

btw rich, what is your favourite color ?

there is an api here: http://www.freevbcode.com/ShowCode.Asp?ID=669 i experimented with it some time ago (for a really deranged client)... it works (w95 w98), but it's global to all forms, and slooooooowww. sometimes it's better to tell a client 'it can't be done'. :) al

cavern, -----you wrote----- I have a 'Contacts' table, which holds contact names and numbers for a bunch of companies and i'm brining this info over from a number of different tables. ------------------- i suspect this is related to your post here...

you can't use the Count function this way... to get a count in this way, look in help for DCount. hth al

publish to word seems to confuse easily. :( try increasing the size of the labels a bit. center alignment may help as well. most importantly, increase the distance of the labels to any other controls on your report. i don't recall seeing truncation problems, in my experience, the labels often...

yes and no....and it can depend on the PK. ---------------------------- from a97 Help: Table specifications Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 1,024. The actual number may be less because of...

ryan -----you wrote----- I've already created this report, however, it uses static DCount function similar to the one above. ------------------- not sure what you mean by 'static DCount'... think you might want to post more info, as i think your db design might need some work. there are a...

indyaries, well, a space is, in fact, an alpha character... check this thread for m. gurman's AllowOnly function: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=27062&highlight=allowonly you can use this function and then check for length. that is, if i read your...

karatelung, just a thought, i don't like a 'time-stamp' as part of a PK. it is not absolutely unique, as the server time can be re-set! (unless your server is running a time-base...) as i said, just a thought... as to your original question re: existing records if you created a table with...

check help for the DCount Function. al

sorry :( access will not export any graphic elements to word. (lines, boxes, images, etc.). if you need lines you can build them in your report using the underscore (_). hth, al

bob in indy, i had not seen a pic like that, i defer to Pat :) just consider 2025 as your retirement date, until then it is 'job security' :) al

bob in indy, in my book, you have already achieved 'elegance' :) i assume this is imported data. i just have to ask what is the data source? al

cosmos, -----you wrote----- This works in Access 2000. But I were to convert the Access 2000 database to an Access 97 database, would the conditional formatting still work for someone using Access 97? ------------------- sorry no... hth, al

chris, well, sometimes you just have to deal with the 'tech stuff'...we're not mowing lawns here :) what you are asking is not all that simple...if you have multiple users you will have to create a table that has an entry for each user and if or if not they have placed the 'tick'. if i...

rich, seems like a good idea. will have a go at it in the morning. also, i seem to recall a posting abt. print preview MDI problems caused by the much-loved AutoCorrect feature. while i'm not doing a preview, i am outputting a report to .rtf. think i'll check on that as well. lordy, if...

having an odd problem... running an uncoverted A97 db under A2K. everything fine except: i have a modal pop-up that allows a date range selection. after selection, i output a couple reports to .rtf files using outputto...False selected so the app doesn't open. after the output is complete i...