Recent content by Octagon6

The following code I have is in the click event of a list box. When the dispatch_num is found in this one table, it is supposed to send the info into another listbox. The problem is that it can only find the first record in the table. LOCATE FOR stopovers.dispatch_num = update_disp IF FOUND()...

How do I get a variable displayed in my messagebox text?

Whenever I use the following statement, a stupid window pops up with the query results. How access the record w/o having the window pop up? SELECT * FROM mileage WHERE mileage.ref_id = cur_ref_id WITH thisform .txtdr_miles.value= miles .txtpu_city.value= origin .txtdr_city.value=...

when I click on an object that requires info from a table, it comes up with an error [tablename] alias not found; however, when I click ignore, it brings me to a list of tables and I can choose the table from that list. After that, I don't get errors and the program has no trouble finding the...

I'm still a little confused on my delete button. Instead of it deleting the current record, it deletes all the records in the table. Can you review my code and tell me what I need to change? thanks in advance. lcchoice = "" lcchoice = MESSAGEBOX("Are you sure you want to...

thanks, homie

What is the inkey() value for the decimal key (or period)? It doesn't seem to be listed in the help menu.

Dumb question... How do I switch from one form to the next?

Wahoo! Thanks mike... I was wondering why that wasn't working.

ramani... that didn't work.. the records are still there. don't you have to specify the table name you are deleting the records from? also, is their a better way to do this?

what is the easiest way to delete all the records in a table? I'm thinking of just writing a sql statement in the command window. What would it look like? delete * from [tablename]????

nah... i don't think so, man. Thanks for your help anyways.

Yeah, I could do that, but then my tabs won't work. Is there a way to do both?

I know this question was asked already, but I can't find the thread anymore. When the program is is running, and someones keeps hitting backspace, it jumps to the previous textbox. How did you guys fix that?

I think I got it working now. My sql statements were a little messed up. I'll post again if I have anymore problems.