Search results

subreport I would use a form with two text boxes on it, startdate and endate. Use this as the criteria for your query that your report runs off of and also set the date criteria of the subreport query to those two text boxes. Hope that helps.

subscription date Use the DateAdd function DateAdd("yyyy",1,[datetoincrease]) This will add one year to the [datetoincrease] field

reports Are these reports designed to go to a particular printer, say on the network? If these reports print out on just the local computer using it's default printer then I don't why the issues are occurring.

find number Assuming your product number field is in a combo box and it's record source uses a query with reason, description, etc.. ... If the product number is found then in the after update field of that combo box you could do something like this...

suppress I believe this is an API programming issue. Don't know of any way in MS Access

wait for compact This suggestion probably doesn't solve your problem but what if after your dim statements in your vbscript you had it wait, say 30 or 60 seconds, before firing off the vb script that does the replace. Like using something like sleep 60 or in vb.net...

records See if this helps http://www.experts-exchange.com/Databases/MS_Access/Q_21000942.html

usb copy Do you mean copy the db to a Jump Drive and then have the user plug the jump drive into their USB on their PC?

Lines, lines, lines, ya ya A bug in Microsoft? Say it ain't so. Just out of curiousity, does it show up when you actually print the report? Unfortunately I have not tried 2007...or fortunately..

squares In a query you could try this: expr1:Replace([thefieldwithsquares],Chr(12),"")

characters Did you try left([postcode],6) ?

a link See if this helps. http://www.thescripts.com/forum/thread208170.html Good night.

security GEMMA is corect. If (access 2003 or greater, or should I say newer....don't know about 2000 since it's been a while since I used it...) an Access db uses macros and the user has his/her macro security setting in Access set to medium a form will pop up asking if you want to enable...

Age I may be misundersatnding this but it sounds like your saying "show me everyone that will still be 25" by the end of the year. Use a query: expr1:datediff("yyyy",[birthdate],#12/31/2006#) in this criteria place 25 Hope this helps

words Use the Instr function. If the returned value is greater than zero then set the found field to "Yes".

vlookup Maybe this link will help you. http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

report Can you print it as a .pdf? This would preserve your image.

field error Are you able to post your db or is it sensitive info?

text date Darn, a little late...and I was hoping for that beer..... For anyone else needing one solution to this: if [textdate]=39101012345 Use a query expr1: Mid$([textdate],2,6) expr2: DateSerial(Left([expr1],2),Mid([expr1],3,2),Right([expr1],2)) expr3: Format([expr2],"yyyy\.mm\.dd")

font size I typically use Tahoma or Arial. Both allow size 6.