Search results

t.j. only guessing here... Access may be choking on the Trim function in a concatenation. try something like: control source =Trim([BegBates]) & " " & Trim([EndBates]) hth, al

this might be of some help: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308633 al

cosmos75, why are you adding a poll to all your posts? al

i'm amazed... so sorry that this forum is such a pain for you...most users find it a great resource. yes, it would, no doubt, be easier for you if you could get answers to your questions via e-mail. that, however, would be a disservice to other users of this forum. keep in mind that a...

i always just use the database documenter...when it gets to the Print Preview, click on File and select Save as table...you have to be sure to set the options to get just a form list. hth, al

rich, no big deal...but, i can't seem to replicate this. someday when you have time, 'flesh out' this procedure a bit. al

nry, probably not what you want to hear... i don't think access has any clue abt. transparency (at leaest a97). happy background color changing! hth, al

there may be an easier way...but you can make the detail section of your report a subreport. then you can place the headers over the subreport columns in the detail section of your main report. be sure to do a page setup and click on columns to get the 'snaking' style you want. hth, al

you need to change your table design to include an AutoNumber field to be used as the primary key or composite primary key. hth, al [This message has been edited by pcs (edited 03-23-2002).]

if i understand your question, i think you need to look in Help for Dropdown method. you can fire it from the event of your choice..(Gotfocus,etc.) hth, al [This message has been edited by pcs (edited 03-20-2002).]

joe, yes, i have encountered this before... i don't claim that this is the 'ultimate best solution', but it is a solution and easy to implement. access has a very large range of tools. you can accomplish a given task in many ways. other members may want to offer other solutions. al

i usually handle this by making the subform bound to a temporary table on the user's f/e. when entry is complete, i use an append query to update the master b/e table and then a delete query to clear the temp... hth, al

from neatcode97... Function Hex2Dec(strValue As String) As Long On Error GoTo CnvrtErr ' ' Converts a string of hexadecimal digits into a decimal number. ' Valid input range '0' to '7FFFFFFF' ' ' Check to see if string already begins with &H. If Left(strValue, 2) <> "&H" Then strValue = "&h" &...

a thought... instead of using a make-table query, could you run a delete query followed by an append query? hth, al

rajput, are you in the business of creating passports? if not, there are many other better/cheaper ways of creating 'machine' readable data.. ie, barcodes. hth, al

are you talking about OCR (optical character recognition)...? al

something like: Open "c:\yourPath\yourFile.txt" For Append As #1 Write #1, YourString Close #1 (check help on append/output) hth, al

start here: http://www.access-programmers.co.uk/ubb/Forum1/HTML/004785.html hth, al

ok i got it! thanks again...this one made a little brain-dead al

alex, try here for starters... http://support.microsoft.com/default.aspx?scid=kb;EN-US;q148553 it will, at least, maybe give you some keywords. hth, al