Search results

Thanks Doc Man-all set!! Toni

Probably a simple one... I have split my db to a FE and BE on a network drive, and implemented User Level Security successfully. I created a new user through Tools/Security/User and Group Accounts. When I open the db under the new user it will not accept my password-it opens without a...

My form will show 12 text boxes, one for each month, it is not a continuous form. I want the user to click on a command button, have that form pop-up to display all 12 months and the monthly savings amount. Toni

I have the code to figure out the calculation. What I need is to know how to tell access that I want to see an unbound text box for each month on a form with that monthly amount that is calculated. I will have a form that will have a text box for each month-Jan, Feb,Mar, etc. If the cut-in...

Thanks for the reply. The monthly amount in my example is basically $50K/6 (13-7=6). Each month has the same amount in it-the calculation is not done for each month, just once. My intention is to calculate this on the fly via a command button fon my form for each record involved and not to put...

Could someone please tell me what I should search on in the forum to find this type of query. I have a db that keeps track of cost savings. Each record "cuts in" in a different month. I have a calculated amount from two fields in my table. I need to take that total divide by 13 - the month...

Thanks for the help! I was making it more complicated than it really was. I did the subtotals in my query. Subtotals: qry>50%.Subtotal and qry<50%.Subtotal Grand Total: =Sum(Nz([qry>50%.Subtotal]+Nz([qry<50%.Subtotal]))) Thanks again, Toni

Thanks for the fast replies! My form is based on a query which contains calculated fields, but the form itself does not have any calculated fields. Thanks

I cannot get this to work. I've searched forums, NW db and others and cannot seem to find a solution. I am trying to get a subtotal of each of my two columns then a Grand Total of both subtotals at the bottom of the form. I have tried a Text box in the detail section and then in the form...

Thanks for the reply. I originally had a separate pop up form to add the details for a new record, but I had the issues I described in my earlier post on 3/22/04 "Open Args and Tabbed Subforms". I have used the pop up form successfully with just a main form and one subform, but when I imported...

I have looked at every post I can find and cannot seem to find code for the NotInList event where it will update more than one field in my table. Here is what I have used from the forum so far. I have tables named Documents and Combined. Combined shows each employee record and the Documents...

I am stumped. I have two subreports in a main report. I am just trying to get a grand total of the second subreport completely separate from any fields in the main or 1st sub. Grouped by "CCA" with subtotals for each group-I can get this grand total to work fine. Within each group at the...

Thank you! I've worked with subforms but this is my first report like this-didn't even think about two subreports, it worked perfectly! Toni

I have been using the below code successfully with a main form and one subform. Now I have made it a main form and 3 tabbed subforms (just the original Subform data split up into 3 categories) The form "NIL" just comes up blank after vbYes and I get the message "Cannot assign a value to this...

I cannot seem to find a solution to this. I have one table with a MonthID in the format of 104 for January, 2004 and so on. I need to create a report in which the left side shows data for the current month grouped by Supplier and the right side shows data for the entire project term, which...

Thanks so much Pat! The append query(s) worked great-you saved me from having to manually input 1584 records(again). I though the format of the db was a little weird when I saw it, but I'm still new and wasn't sure. And yes, I am trying to push this consultant out so I can take over! Thanks...

I am trying to think of a way to avoid doing this manually, but I don't think I can. We have a survey that was created by an outside person in Access. All I have access to is the table that the survey created and it is in this format for 30 questions: Col 1 Col 2 Col 3...

I have successfully run the following error trapping code for duplicate entries,but am having one problem that I can't figure out. First, all of the code I have found in forums has been placed in the On_Error event of the form, but the only way I could get it to work was to put it in the...

Thanks for the quick response! Yes, the batch file runs for them. It locks up when it tries to go into the shared folder and open the db. The batch file is located through a link on our intranet home page, which they do have access to. I would really appreciate help with the IF statement in...

I have my db on a shared drive with a link to my .bat file through our intranet home page. It works great for all who have permission to the folder I placed the db in, but when our auditing dept, which does not have access to this folder(and will not) tried to open the db through the link...