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
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...
Hello.
I have a report based on a crosstab query. It works fine.
I have other report based in a normal query.
Now I need to put the first one (based on crosstab query) inside the second one.
But I find two problems:
1. I cannot link the two reports (Link Child Field with Link Master field)
2...
Thanks for your answers, and I agree, the application is for make life easier.
What I am trying to do is to put a Find tool in the form, then the user only has to type the first letter in the combo box and then click the arrow to find a particular name.
Now I need more help on the syntax...
Hello everybody,
I need your help in this issue, please.
I have a combo box, based in a query, with 163,000 records. They are names. The form shows me all. I added a combo box but it shows me only until 65,335 records. Why?
And how can fix that?
Thanks a lot.
Hello, everybody,
I have almost the same problem. I need to open a form from a subform with On Click event. I want the new form to be opened shows the one complete invoice, matching the invoice number of the subform.
This is my code:
Private Sub Invoice_Click()
DoCmd.OpenForm...
Hi, Frink
The main form is bounded to tblMonths. The subform is bounded to some data with a link to tblMonths thru MonthID. They work well. The main form has only a combobox to choose the month. At open, it shows January and subform shows all January data. If you choose March, subform shows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.