Recent content by whiterower

Hi Jon, Here I am again..you know what the user tested the program and found a problem that i need to resolve..they enter todays date and the corresponding meters works fine but sometimes they enter dates before..such as: 1st Entry:01/22/04 meter1:200 meter2:300 2nd Entry:01/20/04 meter1:200...

Thanks Pat for making it clear...i appreciate it

Thanks Pat...I did just that i use parameters on my queries..my question is..is it okay if i convert the mdb into mde and don't have to split the db since all my tables is in my sql server? and i dont have tables in my access db its just queries,modules,reports and forms. I convert the mdb to...

Hi, I'm assigned to develop a system that will scan a batch(10 to 100) of coupons.Each coupon have barcode. We used a cannon 3060 Scanner connected to a SCSI port. First I'll gonna have a form with command button that when click it will start scanning the batch then stores all the barcode in...

I can't since I have queries that use parameters and I already deployed my app..Yes all my tables resides n my SQL server. What I did was i convert the mdb file to mde and install a copy on each machine..is there any effect that will slow down the apps?

hi, I just wanna ask if i need to split my application into a be/fe. Right I'm thinking that I don't need to spli the database since most of my table resides on our SQL Server. What I did ii convert my db to mde wihtout splitting.Is this the right thing?

Hi richard I tried to add the code "Login=user" & Chr(0) & _ "Password=user" & Chr(0) & _ the user has select,update,delete on the database but I was prompted that it couldn't create the DSN but win I use trusted connection it could create a DSN but i dont want the user enter the username...

Thanks Jon, i appreciate your help..

Jon I need help again..what if i edit the first record, the next record should update the previous readings automatically..On your sample database try to edit the 1st record,change meter1 to 250, the previous readings on record3 should change meter1 to 250 also..How will I do this..This is the...

Hi Jon K, I tried your example and works great thank you so much I really appreciate your help.

Thanks Jon K, I'll gonna try it Cheers:D

Thanks Jon K for your reply, I will querying from a large table..i tried your example and it works great. How could I update the previous date and previous meter to the table whenever i have a new record?Thats a good idea..also there's another table that hold the electonic readings for each...

Thanks Jon K for your reply, I will querying from a large table..i tried your example and it works great. How could I update the previous date and previous meter to the table whenever i have a new record?Thats a good idea..also there's another table that hold the electonic readings for each...

Hi, I have a problem getting the current date and previous date on my report my table looks like this: tblmeter: MeterID-autonumber primary key MachineNo Dateentered Meter1 Meter2 Sample Records: MeterID MachineNo Dateentered Meter1 Meter2 1 123...

I wanna show records that didnt matched from List A compared to List B..ex machine 3 list A didnt matched with machine 3 in list B then will show the records. Also im using access project i dont have Query object instead i have stored procedures