Search results

Is there a way to disable the return key on a form, or perhaps assign a function to it?

It has the path to the file name. The logo field is a simple text field of up to 200 charecters. records 1 is LOGO: c:\datashow\images\BT.gif COMPANY: British Telecom

I have been pulling my hair out over this one. Table One has 4 fields, 2 of which are called Logo, and company. I am trying to "connect" them both to gether, so that if the user selects "john's hotel" in a form then the corresponding logo will link. I beleive the i need to split the tables...

got it - it omitted the ", true" from the end of the code. DoCmd.TransferText acImportDelim, "song specification", "list", "\\disco\djpower\Songs Played.his", True

When manually doing a .txt import all is fine using my own import specification. when i use this code DoCmd.TransferText acImportDelim, "song specification", "list", "\\disco\djpower\Songs Played.his", True the first record in the text file to import is missing any suggestions??

I have the following code i would like to run every 5 minutes DoCmd.RunSQL "DELETE * FROM data;" DoCmd.RunSQL "DELETE [list].song1 FROM [list] WHERE (([list].song1 = ""!F:""))" DoCmd.RunSQL "UPDATE list SET list.song = Mid([song],2)" At the moment the code is on command "button19" Q. How...

this is what i have so far dbs.Execute "DELETE * FROM list WHERE DateDiff("n",[omit12],Now())>=50" and the code stops on the "n"

Because sendto is a text field that gets stripped with a "Iff" CLAUSE, AND HAS IT'S BRACKETS DELTED. Then after Copy the data to omit12, all the info is deleted from sendto. And i'm left with time data in a time formatted field.

I keep getting an error and the "n" is highlighted. parentenethess orror

I have a table called "list" The field "sendto" contains time data. I am trying to copy all the data in the "sendto" field to a nother field called "omit12" Both fields are in the same table - can this be done so far i have DoCmd.RunSQL "INSERT INTO list SELECT [list].sendto FROM list;"

try this DoCmd.RunCommand acCmdRemoveFilterSort

I have searched and searched. What i want to do mus be simple. I have a form with the calendar control set to mile-o-philes spec, which is triggered from my "diary" form. I am trying use the calendar to find a record on my "diary" form. The control on the diary form is called "Date of Func"...

I have a table with a a time/date field. Is it possiable to delete every record that is 10 minutes old?

thank you dcx693 for you help. However, your suggestion did not work out - and i posted again since it was now totally different question to the original title

Thank you works a treat

have a ")" at the end of a string of text which i need to omit, any ideas? i have this IIf(Left([time],10)=")","",([time]))) but the whole thing deletes

Not i need to omit a ")" which is at the end of the string. Any ideas? i have this IIf(Left([time],10)=")","",([time]))) but the whole thig deletes

Got it - Thanks very much for your hard work

i now have this IIf(Left([Song],1)=Mid([song],2),[Song]) and it just earses every thing in the song field

i am also trying to delete the first letter from the string, the letter varies. what i have so far: IIf(Left([Song],1)=Left([song],1),[Song]) but it does not work - nothing much in help