Search results

Access 97 working little slowly. I have windows 2000. The computer is old..processor is about 300 MHz and RAM- memory capasity is ~164 Mb. Hard disk is 3.0GB. I have only three tables which are similar. In a table is two fields "date" and "barcode". I am use MSComm - object, I receive the...

How can I delete fields which are older than 30 days and save these to backup?? I can delete all fields now.. Private Sub Command2_Click() Dim msg As String msg = MsgBox("Are you sure?", vbYesNo) If msg = vbYes Then Dim db As Database, rs As DAO.Recordset Set db = CurrentDb Set rs =...

I have little problem when I get the data(bar code) from Com-port to access 97. These looks like below: Why does a code will be sometime in two recordfiel boxs?? http://students.oamk.fi/~rajata01/example.JPG ... This is the code what is in VBA. Private Sub MSComm2_OnComm() Dim buffer As...

Private Sub MSComm1_OnComm() Dim Buffer As String Dim t1 As Single Buffer = MSComm1.CommEvent t1 = timer Do Until Buffer = 2 If timer - t1 > 2 Then Exit Sub Loop Call AddScanRecords End Sub I use the code whit barcode scanner...Idea is take a barcode from com-port buffer when all barcode is...

How much datas Access 97 can records to database? I have 6 tables and these are similar. In the table is three fields. These are ID, barcode and scandate. How much data records Access can save to per table? about...I will be about 1000-3000 data records to field per table in day. Is possible...

What I have to do that I can show a barcodes right in database.. When the scanner send a code I will see it in Access-database but there is little problem. A codes shows like below are... 011L 011L 011L 011L is right code. Terminal Type should be ANSI. But How I can do it in code?

I have problems open the MSComm and ADO-connection. I don't know what is wrong..below is the code. Option Compare Database Private Sub Form_Load() MSComm1.CommPort = 1 MSComm1.Handshaking = 0 MSComm1.Rthreshold = 0 MSComm1.Settings = "9600,N,8,1" MSComm1.InputLen = 0 MSComm1.PortOpen = True...

Private Sub Form_Load() MSComm1.CommPort = 1 MSComm1.Handshaking = 0 MSComm1.Rthreshold = 0 MSComm1.Settings = "9600,N,8,1" MSComm1.InputLen = 0 MSComm1.PortOpen = True End Sub Private Sub MSComm1_OnComm() AddScanRecords_Open End Sub Sub AddScanRecords() Dim cn As ADODB.Connection Dim rs...

Hia! I have talked about my problem other forum. Below is the link. Hopefully somebody knows and can help me.. thank! http://www.ozgrid.com/forum/showthread.php?p=267705#post267705

Hi, I have a problem whit datas collection. I have next devices, The NPort W2250/2150 Wireless Serial Device Server (http://www.moxa.com/product/NPort_W22502150.htm) and bar code rider which is connected to the Nport. I can communicate to Nport using virtual COM-port. Bar code rider sends a...