Recent content by bestfc01

Hi there, Thanks for you help, unfortantly, we need the serial number field to be the major link, this is due to creating build documents for each serial number, which has subforms attached. I have tried your method previously, but when pulling up results on a specific serial number i.e...

Hi There, Please could someone advise if this is possible. I have the following fields, 'Serial Number' (Primary Key from my table) 'Build Date' (MMYY) 'Sales Area' 'Serial Qty' (unbound text box in a form) If the user types the following into the form with the below fields 'Serial...

Hi All I am currently using the column history to log the history of inputs into a memo field. But i now need to swap how my database runs and now require a combo box to have the same history function, as this is for a status updates and i require users to only input certain status's. I no...

Thanks but have solved this last night after :banghead: over it for several hours. What i was after was a piece of code that allows me too output 6 different report, from 6 different tables (record sets). To complete this i had to use a combo box to be my search source. So when the combo box...

Hi there, Im creating a database for a server that has four nodes. We require to output all reports to a folder so we can send them to our customer prior to shipping the server out the door. I've tried so many codes, but these dont seem to work as i have 6 different tables as four table has...

Could i also add the send feature will be used by many users, so ideally it can be run without having to save the attachment first.

Hi All, I need to send 6 reports into one email in PDF format. I no i can do it through Macro, but the only coding i can find on here keeps saying i have an error. Below is what im hoping for. All these reports are linked to individual tables I need all 6 reports to be send on one...

Thanks, I am now creating single forms for each table, and when i need to send them to my customer link them all together to have 5 attachments rather than one.

Hi All, I been banging my head against a wall for the pass 2 weeks now and unable to solve getting passed this issue. I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each...

All set, up and running. Seems no issues also ensure other users dont edit the database as well which to be honest is a bonus Many thanks

Many thanks this now works perfect. Has a issue with the coding i used to password protect a form. Removed this and work instandly. Thanks

Thanks for prompt response. I am using access 2007 Insturction of MDE for 2007 is to do "Database Tools" > "Database Tools" > "Make ACCBE" When i attempt to do this i get an error saying unable to create. when i go into the "help" part it say its " This error is usually associated with...

Hi there, I was wondering if it was possible to be able to make changes to a form whilst others are accessing different forms. At the moment, if i am editing the database any user trying to access the database gets a error warning them, they the database is in admin. But if another user is...

Many thanks for your support. For some reason I had lost this website, and was unable to find this post. :confused: The subform was the most practical for me. Set the whole thing up in about 20minutes. :D This morning was great scanning 100 serial numbers took me 5 minutes rather than 30...

Hello there, I am currently updating a database within a working enviroment on one machine in our RMA department. The databases primary function will be allow the user to log each hard drive that goes into our testing station from WD and Seagate. I have made a full working database which to...