Search results

what is the code on your command button? are you using OutputTo or TransferText? do you have an export spec.? al

dlookup is probably your best shot. it is sometimes difficult to get the previous record depending on your table structure, ie is the table's PK an autonumber or what...so Dmax might also be an option. al

mugman17, sendkeys is kind of a 'last-ditch' effort...when nothing else works. happy to be of help... i learned something as well, i didn't think you could use sendkeys on a command button with setfocus to multiple controls! so thank you too :) al

don't want to be harsh...but, you have double-posted. :) just post a reply to your original message. you have an additional question at: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30992 we are here to help... :) al

mugman17, -----you wrote----- The client wants this automated. To fill in 3 fields if needed. So I would do it through a command button. ------------------- imho, to do this you will have to use the autofill... -----you wrote----- I tried to autofill to work properly, but could not...

the more robust approach would probably be using autofill. do a search for it on this board... you also might use the 'dreaded' sendkeys, however i don't think you can do this from a command button as the control in question probably has to have the focus. kinda ugly, but should work... :)...

are you trying to generate accented characters by any chance? al

richard, it's a very mixed blessing... :) these shortcuts can be a real pain when you are trying to prevent your users from 'mucking about' in your database. for some examples, click on the File and Edit menus in access. do you really want your users to create a new database by using Ctrl N...

bgcogen to get multiple lines on a command button try this: edit the command button text... terminate each line with Ctrl M. this will force a CR into the command button and preserve the centering... hth, al

edit - Oops i'm too slow today glad you got it sorted... :) i assume you mean the order detail form when you say: Form already has those properties set. what else happens when 'Place Order' is clicked, just the form close? al

suspect your form is allowing updates to the already entered record, instead of adding a new record... you can probably check this by setting your form properties to Allow Edits:No and Data Entry:Yes. hth, al

in A97 and earlier, at least, i don't think you can. you will need to create the round corner box in a graphics program and place it in your report as an image. probably way more trouble than it's worth... hth, al

check help for: TransferText Action -------------snip----------- If you click Import Delimited, Import Fixed Width, or Import HTML in the Transfer Type box, Microsoft Access appends the text data to this table if the table already exists. Otherwise, Microsoft Access creates a new table...

try, Dim MyFile ' Returns "test.txt" if file exists, Null if not. MyFile = Dir("C:\Myfolder\test.txt") hth, al

andy, hmmm... oddly enough, access can perform math on a text field... please post the SQL for the query your report is based on. al

what happens if you set the text properties on the report to : Format: Currency Decimal Places: 0 al

not sure what is amiss, but i recently did a project (in A97) that imported 52 fields and did it using the import wizard w/no problems. guess it's possible later versions of the import wizard have been 'improved'. :) does access give any errors when you do the import? al

sorry to mis-lead... :( in my case, i'm using contiuous subforms and the fields are locked and tab stop set to No. pretty sure that is the difference... al

jon, not sure what is different for you, but in A97 the down arrow will move to the next record if a control on the continuous form has the focus (page up/down works as well...) hth, al

pungent, to get right justification to a text file, you will need to add spaces to the left of your field to get the desired length. you could use the Lpad function (from NeatCode97) in your query. ---------- Function LPad(S, ByVal C As String, N As Integer) As String ' ' Adds character C to...