Search results

Basicly its a dumb terminal. It connects to a Windows 200 Terminal server and runs all the apps from the server. Word, Excel, Access, Accounting software etc....

ok but one small problem, I have a few users that have thin clients that connect via RDP to our Terminal server, then I have 3 users that have pc's If I copied the FE to the 3 users pc, when ever I do an update I have to update each pc ? What about my thin client users

I have a small dabase shared by 4 users on the network. when someone opens the db, then someone else opens it there is no problem. when user 1 has a report open and user 2 tries to update a record, user 2 gets the following error You do not have exlcusive access to the database at this time. If...

I found my issue, yes it was the quotes. I know understand that is is not good pratice to sotre values. Lets move on and quit beating this horse to death. I understand this has to be done in query. Thanks for all the help

Plus I can not get the IFF statement to work the statement returns a blank value

Ok, Here is my SQL code. I am now not storing calculated data. All works fine except the last statement where my IFF statement is. Can anyone tell me what I am doing wrong to that makes it keep prompting for 4$PerTon & DueCom Thanks SELECT elementis_data.DateOrdered...

Oh so i can do as many as i need if I need to. Thaks BTW I change the field in the tlLookup for salesdate to T and it still did not work.

ok also Can I have 2 calculations run on the same field AfterUpdate: see code below Private Sub TOTSITES_AfterUpdate() Me!PPS = Nz(Me!Price, 0) / Nz(Me!TOTSITES, 0) End Sub I also need this: Private Sub TOTSITES_AfterUpdate() Me!GPS = Nz(Me!Gross, 0) / Nz(Me!TOTSITES, 0) End Sub Anotherwords...

BTW there no reason for everyone to get agrivated. Thats what fourms are for is helping heach other out........

I guess my question is now, Why is it not good to store the value for use later on ?

Saledate is set to N in the tlLookup table, but the field definition is set to text

Ok I think I have narrowed down my prob, Its with the Saledate, when I ask for a saledate > xx/xx/xxxx and saledate < xx/xx/xxxx It returns nothing. But if I leave the date out it works fine. BTW I have checked and DAO 3.6 is referenced

Ok I added the search to my DB, I changed the table name in the SELECT I also change the tbl name in the QsLookup When I select my criteria then search I get no results Here is my code Private Sub btnSearch_Click() 'Dim lsOne, lsTwo, lsThree, lsFour, lsFive As String Dim lvOne, lvTwo, lvThree...

this is the last piece I need to complete my project, I do appreciate the help

MS Access 2003

So how can I fix this and how do I add another calulation to the same afterUpdate Thanks

Dave if your still around, have another question..... This search looks great, but I have a possibility of having 13 different fields to use as a search criteria. maybe not all of them but... For ex.... I may want to search by saledate, price , gross, open then next time I may want to search...

These are the AfterUpdate codes I have. i have one more field called GPS which is gross/totsales.... as you can see from below I already have a totsites_AfterUpdate Can I have 2 formula's run on the same field afterUpdate ? Private Sub Comm_Amt_AfterUpdate() Me!Comm = Nz(Me!commamt, 0) /...

Or I can have the output goto a rpt then from the rpt I can export to excel Correct ?

This is great help, One last monkey wrench, Can I have the result of the search come out in a columnar format so it can be sent to excel so I can build pivot tables from that data ?