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


ADVERTISEMENT

Access Security Being A Pain In The...

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

Duplication Pain In The Neck... Do U Have The Remedy

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







Copyrights 2005-15 www.BigResource.com, All rights reserved