Recent content by Nacar

Michael, could you please give me some specifications of that I/O Card to exercise with? That is the kind of example I need to practice, one that turn a light on/off. I began to understand serial port with its 9 pins. Do you have some code to turn a light on/off? Thanks for your help. Nacar

Thanks pwise, I am reading and studyig your links. I will tell you something later. Nacar

pwise, I installed my VB 6.0 on my PC. After that the MSComm Control appeared in the MS Access toolbox. Then I could use your code and it worked fine. Now I begin to understand this issue. Private Sub Command1_Click() 'open port MSComm0.PortOpen = True 'send message to port MSComm0.Output =...

pwise, you are completely right. You said: "the issue here is how to get access to open the gate". When I called manufaturer they told me the reader can accept input through serial port (computers, laptops, and palm pilots!!) But they asked me: "Can MS Access communicate with the serial port?"...

Michael, sorry for the crossed post but I was not sure which forum was the correct. At this time I am not sure yet. I agree with you this project is beyond my current capability and I want to quit because I do not want to cause delays. I called the scanner manufacturer and they told me I need a...

Thank you pwise for your answer. I think your code will work but I need a little more info in VBA. Could you please write an complete example code. What does "msca" mean? Do I have to add some references? Or is it a module? Thanks for your help. Nacar

Hello, Again, I need your worthy help, please. I am working in a project in a condo. They have a vehicle barcode reader. When the car is near, the scanner (barcode reader) reads the barcode and open de gate. The reader can work alone, but they want to generate reports and keep some control on...

Hello, Again, I need your worthy help, please. I am working in a project in a condo. They have a vehicle barcode reader. When the car is near, the scanner (barcode reader) reads the barcode and open de gate. The reader can work alone, but they want to generate reports and keep some control on...

Duane, Thank you for your help. Because your great samples I could find out my mistakes. There were two mistakes. Both in the SQL statement. Here is my original statement: TRANSFORM First(tblShoeRef.IniQty) AS FirstOfIniQty SELECT tblShoeRef.ShoeID, tblShoeRef.ColorID, Sum(tblShoeRef.IniQty) AS...

Duane, your subreport is based on a select query.Then, you use it to generate the columns in your main report which is based on a crosstab query. Mine is the other way around. The subreport is based on a crosstab query and the main report is on a select query. The subreport looks like a matrix...

I visited it already last night. They are great!! The columns are from tblRuns. There are 20 runs but each shoe uses normally two runs and sometimes three. Because no more than three, let's put only three columns for simplicity. The actual problem is the message: "you can't use crosstab query...

Duane, let's start from the beginning. I have four tables. tblShoes (general info for each shoe + ShoeID), tblColors (Colors + ColorID), tblRuns (Runs + RunID), and tblShoeRef (with these fields: ShoeID, ColorID, RunID, Qty.) TblShoeRef is the “many” part of all others. I have a Master...

Duane, Really I need only three columns. Let's try to put three fixed-columns. Could you please tell me how to do this. I have tried but I get the column name without qty. Thanks.

Hello Duane, The Master report contains the general info for each shoe (Material, Style, Picture, etc.). It prints five shoes per page. No problem. But I need to insert a subreport with a matrix Color vs. Run, and Qty in the intersection. I created a Crosstab query for its record source and it...

The based crosstab report looks like this: ShoeID Color Run12 Run32 Run75 BBOOJJKK Red 10 5 15 BBOOJJKK White 5 8 BBOOJJKK Blue 3 6 ShoeID Color Run06 Run14 Run36...