Search results

  1. C

    Query in report not showing all records

    I understand now. Thanks
  2. C

    Query in report not showing all records

    It solved the problem. Thank you very much. But im having problems understanding the reason for the problem i had. Will try to think on what you said. Thanks again.
  3. C

    Query in report not showing all records

    Hi there, Im having a problem, and to be honest im complety lost to reason for this, so here I am. I have this four way query that has the following: A – Hardware table were i pick up some values B – User table were I pick up username C – HW/User table were I match the hardware...
  4. C

    Windows 7 + Access 2007 + MSFlexgrid possible

    Hi there, Im creating a form to do some calculations and i need to have a MSFlexGrid. The problem is i just can't use MSFlexGrid at all. I have the ocx. in Windows folder, but when i go to the form vb code, nothing. If i write in the code something like : Me.msflexgrid. after the done i...
  5. C

    How to connect a page to a database

    Hi I'm pretty much done on my database.. Just need to work on some reports, but it's about 90% ready. I have a couple questions: 1 - I want to create a single page, with the principal menu, with all the buttons that give you access to everything else, but i want it to be separeted from...
  6. C

    Can you create 1 form to save to 2 tables?

    I think i solved my problem with this.. sql = "SELECT idProduto FROM Stock WHERE idProduto= " & idProduto & ";" rec.Open sql, con If rec.EOF Then sql2 = "INSERT INTO Stock (idProduto) VALUES ('" & idProduto & "');" db.Execute (sql2) End if Hope it helps you..
  7. C

    How to create a form with DataGrid??

    Problem solved with this i hope :) sql = "SELECT idProduto FROM Stock WHERE idProduto= " & idProduto & ";" rec.Open sql, con If rec.EOF Then sql2 = "INSERT INTO Stock (idProduto) VALUES ('" & idProduto & "');" db.Execute (sql2) End if
  8. C

    Can you create 1 form to save to 2 tables?

    Im facing a similar problem to yours. In my case i have a form with a table and a save button and i need one of the fields of this form to be also added to another table and vice versa (if you delete the product here, delete it also on the other table) What i have right now is a normal form...
  9. C

    How to create a form with DataGrid??

    How to insert in 2 different tables I have found a way to go around this My idea is, everytime i create or update a product in the products form..once i press the button save it will do this: Private Sub updateStock() Dim con As Connection Dim rec As Recordset Dim db As DAO.Database Dim rs...
  10. C

    How to create a form with DataGrid??

    Anyone out there who has worked with this?? I just need a form with all current products without me doing anything..from there on i'll do the rest.. Best regards
  11. C

    How to create a form with DataGrid??

    I can do a form and put there all the current products and with a few querys do that. The thing is i don't wanna go that way.. i wanna open a form and i want it to show immediately all the products..as for the calculation of the stocks, i can do that just find.. It's the datagrid thing that...
  12. C

    How to create a form with DataGrid??

    Yes i do.. is to manage a stock system. I have one table with the products, then 2 others, onde for sails and another for purchases. And i have another named stock and that's were i need the data greed. It has this: idProduct stcPurchase (sum of all stock bought for product A) - 1...
  13. C

    How to create a form with DataGrid??

    I was refering to the code part.. Thanks
  14. C

    How to create a form with DataGrid??

    How to insert in 2 different tables Hi I'm working on a couple projects, and have a similar problem with the two of them. I have a table with X Products. I need to create a form that as soon as you enter, shows all the products currently existing in the table Products. The rest i think i...
  15. C

    Problem in query...

    I will look into what you said. Thanks a lot guys.
  16. C

    Real Calendar with Access calendar control

    That's too bad.. It amazes me how with excel or vb6 doing this is no problem but with access is.. I will try to this with excel.. best regards Mauro Fernandes
  17. C

    Problem in query...

    1. The nome for the fields are in Portuguese while i use Access 2003 in English so no problem there. 2. As any programmer i tried all i could think of..as for the date and hour currently i left them as String.
  18. C

    Problem in query...

    Yes they are.. This is for an agenda..like outlook calendar.. A Agenda with the 7 days of the week and one each day x hours seperated by 30 min 09:00 09:30 ... So to make an appointment i have one for the date and other for the hour.
  19. C

    Real Calendar with Access calendar control

    So did you find anything? I'm looking for the samething you were..and so far nothing..
  20. C

    Problem in query...

    I have tried what you said with the # # but no good. I use data as data type, and as string to see if it helped, but still no good. I resourche a lot before i ask you guys this, but i must be doing something wrong. I will continue the research. Thanks
Back
Top Bottom