Search results

Hiya, I really don't know how you could do that, but I guess you would be able to do it with Visual basic and I have no clue when it comes to visual basic. Sorry but go to this site: www.wopr.com and you could get help from them. Goodluck.

thank you but I've done it with three queries and it works so Im gonna leave it like that. Thanx a lot.

yes you can, What do you want to do? 1)Just display them? or 2)do you want to open them using the form as well as displaying them? To do 1) all you have to do is click on label on the toolbox and drag it down to the form and type the names of the table. to do no.2) Create macro Action...

Is it very hard to pull a value from a query into another query and use that value to pull records from a table? PLEASE PLEASE PLEASE tell me how I could do this? This is my situation; I have two tables, TBL1 containing original records, TBL2 containing the amended records. TBL1 & TBL2 are...

www.wopr.com has the answer for all question guys.

How can I retrive records which have been entered into the database today? Input-date has formatted as follows: dd-mmm-yy hh:nn:ss I've tried Now() and Date() functions in the criteria but it doesn't seem to work. Help you guy, PLEASE

Hey I've done it with help from jatfill. In the above code change the SELECT to SELECT TOP 1 and sort the query in desending and there you have it but if you press this key more than once you'll end up with more than one copy of the record. Does anyone know how to find out whether that record...

Ok, forget that code. What I want to do is: I want to add the current record on a form to a table other than the source table. The form saves the data to a table called “tblMainTrade”, two queries are used to calculate few field of this table. The data on the source table and the calculations...

PLEASE HELP!

Hiya, what I want to do is; Append the current record to a table from the form. Would someone help me code an SQL statement for a macro or for a query? I already have this code but its got errors in it, and I don't seem to know how to get it right as I've tried to correct it so many times...

Would this code work? This is a code to requery the two queries Im using to calculate Net Amount and settlement Date. This code is supposed to execute every time I enter or change data. The frmTrade(M) is a file name..

Create a form based on inventory item table and at the top of the table add a combo box, when creating the combo box select (Find a rec. based on the blah blah bla) when you select the item from this list it'll auto populate the feilds on the form. I hope this works. else go to www.viescas.com...

is the combo box feild a primary key? If it's not create a table just for that combo box and enter the values you want in the table. then you could use this table to select data to save in other tables.

Private Sub Trade_Date_AfterUpdate() On Error GoTo Err_Trade_Date_AfterUpdate Me.Refresh DoCmd.RunQuery CalcualteNetPrice DoCmd.RunQuery CalculateSettlementDate Me.frmTrade(M).Requery Exit_Trade_Date_AfterUpdate: Exit Sub Err_Trade_Date_AfterUpdate: MsgBox...

Could someone please tell me how I could save a calculated feild on the form in a table? I would appreciate all replies. Thanks....