Search results

Hi O great wise ones, I have tried and tried to sort this out but continually fail. I have a table with the following fields: Primary Key - This is hidden and not used as such Type - This is a drop down text field with the following options: Universal, Custom Stocked, Stocked, Accessory and...

Hello Vinay Welcome to the club

Thank you for all your suggestions and help so far but I am now even more confused. The fields I have are my primary key FileID (this is autocalculated and hidden) TYPE is a text field with a validation rule that only Universal, Custom Stocked, Custom, ect can be entered. I then have numeric...

Hi jdraw Yes this is my first database other than excel spreadsheet types The business is embedding minerals, pure elements and compounds into differnet types of mounts (blocks) polishing them to 1/4 micron finish and used for electron microscopy. The database is a list of different types of...

Hi Moke123 That is exactly what I require. Thank you. I have my files stored in a table similar to yours except all my fields are in a single table and the form that is displayed with the smaller image does not show the file names as it is a read only type form however I think I can now work...

Hi draw and thank you for your reply. I think I may have made things over confused by trying to keep them simple. My idea was that if I had a different number set of each type, the part number would act as an easy reference as to where that part falls - for example these are all small parts...

Hi moke123 and thank you for replying I have every way I can think of except obviously the right one. I have tried creating a new image box on the popup form and in record source referring to image box in the original form. I have tried making a macro but every time I get a blank box. I...

Hi I have a table with 5 product types Universal, Custom Stocked, Stocked, Accessory and Other In an input form I am trying to get the field Part Number to automatically enter the next number in the sequence based upon type selected i.e Universal starts at 100000, Custom Stocked 200000 and so...

(Solved)Make image popup in a new form Hi I have created a form that along with other data shows two jpeg images relevant to that record and if the next record is selected the images change. The images are not stored in the DB but stored as a file path as recommended by all. I need to expand...

Hi My name is Rob and I work for a very small company (three of us). I am currently dragging our systems into the modern era as we still use paper copies of everything. I have very little experience with access and am better with Excel. Access makes me stressed and I end up shouting at the...