Search results

I understand now. Thanks

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.

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

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

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

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

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

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

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

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

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

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

I was refering to the code part.. Thanks

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

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

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

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.

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.

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

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