Search results

Thanks a lot X0reset!!! I tried to avoid that because it included a lot of changes with all my queries and filters but it was worth it. Now it works perfectly, thanks!

I know this might sound stupid but I really can't find it anywhere. How do you count how many times a query is run. I need to make a DoCmd.RunSQL stringname and count it so that I can loop it to match a certain number. Is that possible?

I tried catching the error on the subform on GotFocus and on LostFocus I added this: If Err = 3101 Then Err.Clear I already changed the relationships from one-to-many to normal for 'tblProducts' and 'tblBlowers' with 'tblOrderDetails'. But the error keeps appearing and doesn't let me do...

Yes, indeed. BlowerId and ProductId are primary keys from tables Products and Blowers. Although in OrderDetails they show the serial numbers with a normal table query.

...help, please?:(

Anyone that knows how to avoid filling in the second value? Pleeaaase

Anyone's got a clue on this error, please???

Thanks Neileg. I searched for it and made this one: Dim RecordNew As String RecordNew = 1 + Nz(DMax("[RecordNr]", "[TblRecords]"), 0) Me.RecordNr.Value = RecordNew

Hi I have a couple of tables that should have an automathed value. What I need is to get the last RecordId from the table from where we get the last RecordNr and insert the next value (RecordNr) in a new record. I tried to do this autom. in the table by making the RecordNr a numeric Value with a...

Hi, I got something similar. But my combo has to filter certain data with a query from which it feeds. I know my case is different but maybe it can be of some use to you: Private Sub cmdOpenRpt_Click() On Error GoTo Err_cmdOpenRpt_Click Dim strWhere As String If Not...

Ok, here you have it. You'll have to open form Products and click order this item (when the order checkbox is not marked), it will open NordersMaken with the productId in its subform. The problem comes when you don't pick a blowerId.

I have a for for making orders called NordersMaken with a subform NordersDetails. Here is some info on my tables: tblOrders (=form NordersMaken) OrderId OrderDate Seller Customer ... tblOrderDetails (= Form NordersDetails) OrderDetailId OrderId ProductId (from tblProducts) BlowerId (from...

I'm sorry Ice-9, but I'm a newbie too. I would try to help you but without knowing your queries or anything it's quite difficult. Do those combos feed on other tables and are joined by Ids? Are there queries for them? Is this datasheet a table or a form in datasheet view?...

Wow, Thanks a lot Seth. It works I forgot to put the query as the source for my subform in the first try but now it works perfectly. THAAANKS! P.S.: About the form for the new order (Products) I still have got problems with the fact that from Products I load the ProductId into the subform, but...

Ok. I had to erase a lot to be able to zip it with not to many Kbs.

Forget what I said before about the For Each I tried it and all it did was set and reset the first ProductId and BlowerId (from the first OrderDetailId). a bit more of useful info on my tables: tblOrders (=form Orders) OrderId OrderDate Seller Customer ... tblOrderDetails (= Form...

Have you tried queries? Here i have a link that could be useful: http://www.fontstuff.com/access/acctut10.htm

Thanks but I get an error message saying that the field is to little for pasting so much data. I tried your code like this: 'Set focus to subform [Forms]![Orders]![OrderDSubform].SetFocus 'Goto first record DoCmd.RunCommand acCmdRecordsGoToFirst 'Get the total number of records...

Sorry but could you, please, indicate me how to do that? I also was thinking that maybe it would be a good idea to count how many orderdetails there are and making the RunSql as many times as necessary. But I have no idea how to start a code for that. Do you know how to or where I could find...

Thaaanks!!! that did the trick! :D