Search results

Hi anyone, some time ago i run into some module, sub, function..or class (don't remember now) which will insert the error handling code in every of the subs, function your database has..It was very handy...but i lost it somehow... So..I wonder if anyone is in possession of a such very handy...

hi anyone, have a question. I have a form. The form has a subform. The Subform has a subform. Form - Subform - SubSubform. Question1: How to add a new record to subform from subsubform? Question2: I have an ennoying #Error display for some field, when its value not calculated yet..how to...

Thanks! Ken..you are a genius.. It works..just had to modify it a little bit..thanks for the hint.. testdate = Forms(str1).Controls(str2).Controls(str3)

hi guys, I have a form, form has a subform, the subform has a control.. if i use the structure: a=Forms(strFormName).Controls(strControlName).value with the form and the control on it, where strFormName and strControlName - strings describing the form's and control's name - it works...

Answer To Dan-Cat first of all, thanks Mike for the praises, here is what i think about your questions: "1) How easy is to track how an order was generated? ie auto or manual. Is it easy to refer back to the original order without storing an order template within an extra table. What if a user...

Great ideas..guys.. One approach is clear here: 1. Take an order and copy it into OrdersTemplate table. 2. Three more fields in that table 3. Check every day if anyorder needs to be put into the OrdersTable... Ok, i promised to tell you how i did go about it..here you are... I have created a...

More explanations please... hmm.. so there is a macro that you run with windows scheduler.OK. Got that. Personally i think it is a bad idea, to make a user run a some macro from his/her desktop. isn't he already busy enough? :) then look after that shortcut.. The idea about two tables.... I...

Just a ScreenShot from my Repetitve Orders Form In case you think i am..you know... :rolleyes:

This is not a question about code or anything... I would like to open a discussion of the best code or algorithm for making an order repetitive one. I mean: - there is an order with order description; - company has to fullfill that order on repetitive basis, say every thursday for like 2...

Never mind, guys..it is done thanks, it is done, i just used recordsets to get to my field. thanks.

I have a query. I need to update one of the fields. I need to update it in the next order; 1 1 1 2 2 2 3 3 3 and so on... Meaning i need to write the same number for three records then increase it, then again to write three times and so on..until the end of the query. There is about 2'000...

Great Forum..Why not? Hi, Just placed your link on my site. Thank you for supporting this forum..One of the best there is.. thx.