I have 2 tables that are linked: Proforma Invoice and Items Ordered. For one Proforma Invoice, there could be many items ordered. The challenge is that I need...

I have to create a database for transactions of school books. The Customer often pays by different combination of media, eg: Pay portion by cash and...

I created several tables differentiated by YEAR. They're pretty much the exact same fields (survey questions), just different years (there's no relationship)....

You can't query the fields directly with SQL. There are options such as the Documenter or snippets of code like this page on Allen Browne's web...

Firstly, my apologies for cross posting with Access.getting started. I found this group a little later and it seems more appropriate to post here. I have 5...

Hi all. Thanks in advance. Ive been putting together this database for the office. Luckily I've had time to experiment with quite a few suggestions and they...

How do I add field to a back-end table that already has existing data in it? Basically I am trying to add another field to make the record inacvtive so that...

I have database splitter errors (subscript out of range and invalid procedure call) and have found similar problems in the newsgroup, tried the solutions but...

I'm having problems setting up a database to calculate production averages. I want to be able to enter date of payroll ie. 3/4/2004 in field payroll ending. I...

Greetings to everybody, I am currently working on a insurance project. I use table tblPolicies with a triple primary key: BranchID, CompanyID and PolicyID....

I have tried using the current formula online ...namely... =DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format( , "mmdd") ) but the program ...

How do I programatically change the field type from Date/Time to "Short Date" using DAO code. Also, how do I assign "programatically" to a table date field an...

Hello, I have an MS-Access 97 database, that I am cleaning up. Are there examples of VBScripts or VBA code, I can use to delete duplicate files??? Better yet,...

Is there a way to hide a table from user view in an Access 2000 db? any advice is greatly appreciated. thanks, matt

I have a table upon which many queries & forms are based. I keep loosing records, and I suspect this is caused somewhere along the way by VISUAL BASIC CODE...

I want to use the Now() function, which returns both the current date and time. I need some sage advice on what to name the database field I store this value...

Hi all, I'll try to explain as much as I can what I want to do. I want an incoming notice paper to be in an access file along with some data... So we got one...

I want to specify elapsed time format that one can find in MS Excel. Specifically, I want to use :ss. The Access format did not allow me. Is there an...

My industry require results to be to a preciscion of 6 decimal places. Access handles 1.012345 but returns 1. if there is no moderator ie result is 1.000000...

I have a number field. I want to enter data into as a percentage of commission (2.25). I have tried every number combination and when I enter 2.25 it enters...