Search results

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

sorry I put form but meant report. How do you change that with a report?

No, problem. Wouldn't know a solution to my probl. by any chance?

Ok, I found it: If DCount("*", "Proformas", "OrderId=" & Me![OrderId]) > 0 Then the problem is that strings cannot be null.

Thanks Shane, but it still does the same. although this time it shows another record and the msgBox 'exists'. Could it be that the stLinkCriteria is not good: stLinkCriteria = "[Proformas_OrderId] = " & Me![OrderId] As I said before I need to see if the OrderId is already in the Proformas...

Sorry for my prev. post I erased it because it was wrong. I'm a newbie too ^.^' Why don't you try this instead: DoCmd.OpenForm stDocName Forms!FormName!FormControlId.Value = Me.ctrlId Otherwise I guess it will be something like DoCmd.FindRecord. search for info there (and that code was for the...

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

I usually use this one, it's faster and simpler when you set up the msgbox on the same time I think: If MsgBox("Message here", vbYesNo) = vbYes Then ...

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

Hi, I don't know if this fits your requirements. I just hope it helps!: http://www.fontstuff.com/access/acctut09.htm

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