Search results

Hi! (SKIP - this part if your not into 'the story') It has been a while since I last posted. Thanks to the help of the forum members I've been successful in implementing a supplier invoice management database AND an operation management system. Both have been in play for well over a year now...

Hi, I'm hitting that never ending brick wall again! :banghead: So my database is coming along nicely. Until a credit controller threw a spanner in the works and asked that i include partial credits into a remittance (using a report). Now this wouldnt be a problem if i knew exactly what im...

Hi, I recently created a database to be used to store incoming invoices. We have 4 suppliers which supply the same material and wanted each supplier to have its own database. I began by making a database which included all the key tables, forms, queries and functions I would need to then save 4...

Hi, I'm currently working on a short project to create a database for accounts payable. The main use of this database will be collecting all details from invoices and credits from a particular supplier and print reports of invoices due etc. It shouldn't take me too long but I wouldn't mind...

Hi, Just after a point in the right direction. Im looking to design and create a user interface for my database. Preferably hiding the standard access interface and upon opening the database have a pop up form with buttons to direct users to forms queries and the nice helpful stuff I made the...

Hi, My database is slowly coming together. For the final part of this phase i would like to create a shortcut on each users desktop which runs a summary report of information within my database. I have criteria set so upon opening the report the user is asked for which address they wish to...

In my form (source tblJobs) i input a contract number from tblContracts. but i would also like it to show the contract address when the contract number is entered. Both fields belong to tblContracts but i only wish to enter the contract number, the address will just be used as a reference as it...

So in my database i have a field for Tonnage (quantity) I need for example to input 38.60 or 37.89 so my values must have 2 decimal places, ive searched and found changing my field type to double or decimal should solve the 'numbers rounding up/down' but access will not let me change the data...

I have an order table. Each Job has 1-3 types of material ordered. Can i used a multivalue look up box or would i have to create 2 additional fields: Material1 Material2 Material3 Each material could be ordered from a different supplier also so the same rule would have to spply to...

Hi, Looking for a push in the right direction :banghead: Objective: To create a Scheduled Work table to show when we work on a specified site and to include materials used/who supplied them I currently have a few tables; Customers, Jobs, Materials, Suppliers. What happens is we have...

Hi, New to the forum, I've used access in the past but drawing a blank at the first stage. :banghead: I'm currently trying to build a database to store information of customers, suppliers, products, Jobs (address of job, company who have contracted the works, job ID which has already been...

Hi, ive recently started working for a company and im currently attempting to build an access database, hence being on here. Ive had past experience but seem to have forgot some of it or need a kick to get me going again.....that's about it Thanks for reading and see you around...