Big Pain In The A??????
Dec 6, 2006
Hello,
I have been killing myself trying to make a simple invoice database. It only has four tables.... clients, products, invoice, invoice_details.... Well its been a while since I have used access and I wanted to make this simple database for my cousins small hardware store. All my relationships are fine all forms are great but the only thing that its driving me crazy is that when I create the invoice form with the invoice_details subform and make some little changes like convert to combo from text box ext, before on my 97office all I did was change the text boxes to combo select the product on the detail and I would get the price of the product, Now when I do it in office 2003, it does not work.....it always shows $0.00
So I converted a 97 file I had of a small database to 2003 and the invoice worked great, as soon as I deleted the forms and created newones the crap wont show the prices!!!!!...
Is this just me or is there something we have to trigger in office 2003 for this to work?!!!
View Replies
Jun 21, 2006
Ok, I'm setting up a new frontend for my DB, as it needs to give some different forms etc to a different person using it. I want to link a couple of the tables that are needed, and I get the message 'blah can't open the file. It is either located outside your local intranet or on an untrustworthy site.. blah blah blah.... won't open file because of possible security issues'
This file is located on a mapped network drive on the local network, and it used to open just fine.... any ideas what has happened and how I can turn off this 'feature'?
View 3 Replies
View Related
Nov 7, 2006
Hi Everyone,
I have posted this question twice but i did not get any promissing response that could made my day.
I have a Database with one table. The database has a two forms. One is called Header Form Having following fields:
ClassNo, RollNo, Grade, Name.
and the other form is DETAIL form having following fields:
Month, Year, Subjects, Percentage, Result
Now it works this way. The user first enters data to HEADER form and presses a button that saves the HEADER information to the table then it takes the user to DETAIL form which shows all the fields(Non Modified) from HEADER of the record entered most recently and DETAIL form fields. Basically the DETAIL form is comprised on main(HEADER) and subform(DETAIL).
Now my problem is that when i enter particulars to the HEADER Form and press the button to jump to DETAIL form it works fine. on DETAIL form when i add a record and move the cursor to the next record it also accepts all the data entered on DETAIL form. But when i look at the data stored in table it gives me duplicate entries. I have set the form DUPLICATE on a query which returns non duplicate values. If i enter one DETAIL Item it shows no duplication but when i add more that one record to DETAIL it shows min 2 records with same ClassNo.
Here how my table looks like
Record No 1: ClassNo, RollNo, Grade, Name.
01 10 9 john
Month, Year, Subjects, Percentage, Result
Nov 99 Maths 76 Pass
Record No 2: ClassNo, RollNo, Grade, Name.
01
Month, Year, Subjects, Percentage, Result
Mar 99 Chemistry 87 Pass
My form is not putting the Header data on any record after second. It only puts ClassNo field in each child record.
Please Help Me with this and thanks for your patience for reading my problem. I hope someone will give me a chance to say thanks.
Darno
View 1 Replies
View Related