Recent content by filo77

Thanks for your reply. The db is not always on, so the second suggested solutions is the one that fits my needs best. Now, how do I do all that???? :confused: filo77

Hi, I have created a macro that sends a database report to an email. Is there any way to "tell" Access to automatically run this macro, say, every Monday? filo

Thanks I found a way. It was easy. Thank you very much. filo

Hey, I have a problem with assigning a field value from one form to another form. I have a form called Orders. On this form I make selections such as Vendor ID, Order Date, etc. But since many items can be part of a particular order I have created another form that is called Invoice and this...

Thanks Thanks. I guess I can always hide the field from the user, ah? Thank you very much. filo

I have a couple of questons for you: How do I assign a value that comes from a form and is inputed by the user to a double variable. Let's say I have a field in a form called number and I have declared a variable dim sample as double. I need to assign the value of the field to the variable in...

Thanks Wayne! It is working perfectly. Thank you everyone. filo

Still need help ReAn, in fact my fields are text field. I tried what you suggested, but it is not working. It still continues to the second form regardless of selection. Any ideas. Thanks for the help. filo

Hello everybody. I have a form that has only two combo boxes and once the users selects their choices they get transfered to another form and data from the first form is already in the appropriate fields on the second form. Just a convinience think to advoid repetition. The problem is that I...

Thanks Thank you very much for this info. I finally managed to convince the guy to change the table structure. You are right, the table design was copied from a spreadsheet, which was creted from a paper form. :confused: I have no idea why they approached the problem this way. I was brought...

conditions in the select clause Thanks rockman. I had a problem yesterday: in the select clause I had an expression like the one you suggested and it was returning 0 if one of the fields was null. So if I had select (field1+field2) as Expr1, and if they were not null it would display the...

Sorry Unfortunately I can not share the tables, because the datbase is not mine and the owner is paranoid about the data in it. (the design is not mine either) :mad: Can you still help me????????? :( :(

Is it possible to create a sum/avg query on a row instead of a column? I have a table where records store test data per studentID, for example: ------------------------------------ field1 | field2 |field3 | field4 | field5 -----|-------|------|------|------- id5 | 80 | 60 | null...

I have a form with 10 fields and I need to store the data from those fields in a separate table. Is it possible to create a macro or a procedure that copies the data from the fields and stores the data in a table that is not directly linked, or not linked at all to the form in place?? Sounds...

Thank you WayneRyan. I think I am going to try the AfterUpdate DLookUp combo-box. It makes sense now that you said it. Thanks again.