Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Nacar
  • Order by date
  1. Nacar

    Can MS Access open a gate?

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

    I need MS Access to open a gate

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

    I need MS Access to open a gate

    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 =...
  4. Nacar

    I need MS Access to open a gate

    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?"...
  5. Nacar

    Can MS Access open a gate?

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

    I need MS Access to open a gate

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

    I need MS Access to open a gate

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

    Can MS Access open a gate?

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

    Criteria in Crosstab query

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

    Criteria in Crosstab query

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

    Criteria in Crosstab query

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

    Criteria in 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...
  13. Nacar

    Criteria in Crosstab query

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

    Criteria in Crosstab query

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

    Criteria in Crosstab query

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

    Criteria in Crosstab query

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

    Combo box shows only 65,335 rows

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

    Combo box shows only 65,335 rows

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

    need help with form opening form

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

    open subform filtered

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

Part and Inventory Search

Back
Top