Search results

Hi All, I have a bit of a challenge for you :) My workplace requires me to process large amounts of quality assurance documents. They need to be printed out, usually using a mail merge each with its own unique document number. Sent to site, filled in, signed off by several different people then...

I am trying to fix a problem with a purchase order form. I need to have auto numbers in the item number field (which is in a sub form) but i need it to start again for each purchase order. Currently i am using: Nz(Dmax(expression,domain),0)+1 In the Default value field. The domain is a select...

Hi all, We have a convention in our company for naming documents that are saved in a "controlled format". I am building a database to keep track of these documents, authors, dates, revisions etc... The naming convention looks like this: ####-123-**** #### being a four digit Project Number 1...

I am working on a form called frmPurchaseBase for entering incoming invoice data. I have a field called VendorID which is linked to a table called tblVendorInfo where all the details such as the vendor name, account details etc. VendorID is controlled by a combo box allowing the user to select...

This is probs an easy question... How do i make a form open on a particular part of the screen and then be unmovable? I know about the Movable property, but how do i specify where the form is opens in the first place? Cheers.

Hi, I have been posting on here for a couple weeks now and i am really happy with the info i am getting from this site! it is helping me out heaps. I thought since you guys take the time to help me out its only fair that i take the time to introduce myself. I am a 19 yr old lad from South...

Hi all, First i would like to thank every one for the help they have given me so far, i have solved quite a few bugs in my design with the help of this site, cheers every one! Now my next problem has to do with asset tracking. The company i work for does alot of construction and looks after...

Hi All, I am designing an asset management db. In my db i have a general table with information that is relevant to any type of asset. I also have several tables that contain data that is only relevant to certain types of asset, for example i have a table that stores test data for electrical...

Hi All, I am Currently in the process of designing an asset database for work. One of the features i am trying to design is a tracking feature whereby a history of the location of an asset is recorded and displayed in a form. i have been using the column history function in access 2007. the way...