Recent content by jeppe

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...

I have some problem whit MSComm-object. Run-time error '424': Object Required rs![BarCode] = MSComm1.Input

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

I have got a devices and tested these. They works well...I can monitor the virtual com port in PComm Lite. http://web4.moxa.com/support/download.asp#2_PComm2K_V1.3.zip So I am do the database in Access97. There will be a table including three fields. ID bar code date 1 12345...

okay, I learn how I can open and close the port. Next problem is... I have in the database three tables com1, com2 and com3. (The names are example). In com1 table are two fields, "serial code" and "savetime". Is in Access 97 some automatic object each saving automatic a datas to fields? The...

Does work MSComm in a VBA codes on Access 97? like.. ' Open the serial port MSComm1.CommPort = 2 MSComm1.Settings = "9600,N,8,1" MSComm1.PortOpen = True I am rookie yet...thanks for link.

http://www.datalogic.fi/_vti_g2_p_det.aspx?idp=ID20041211120045&rpstry=17_

Okay, thank you. I haven't VB so may I need it program? Does work MSComm Control in Access without VB...