Search results

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?

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

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 have a form orders with a subform orderdetails where we can order more than one product. When the order is finished you save it with a save button where it will also automathically mark the products ordered as not available. Now, this code works, the problem is that it only marks one...

I have a tbl Orders and its form Orders from where I open/make Proformas (tbl Proformas, form Proformas) in tbl Proformas I have OrderId that comes from tbl Orders, of course. Now when I try to open/make a proforma with this: Dim stDocName As String Dim stLinkCriteria As String...

Hi I have a simple order report with a subreport that filters the details (an order can have more than one product ordered (=orderdetail in subreport). I usually open it with a filter on orderId =Me.OrderId, but other times I open it without the filter. The problem when I do this is that the...

I have a table products product id - autonum, key ref - txt serial - txt typeId - num (gets type from types table) and a table types typeId - autonum, key type - txt I want a query to allow my form in a choicelist to pick one of the types and display all available products on that type. I got...