Recent content by Raymas

Oh ok, cheers.. that makes so much more sense now. Many thanks, Raymas

Thanks for your replys. Sorry I've been so late getting back, I've just been assigned other tasks in the last few days that were more important. Ok, so bp, what you have decribed is basically what I have done, although mine is little more complicated, ie I have many suppliers for one material...

So just to make clear what i'm trying to achieve. Basically the database is made up of products, raw materials, and raw materials costs. The products each have a bill of materials (BOM) generated by the user. The database then from this BOM generates a total product cost (also including labour...

Thanks for the reply. I see what you are saying to an extent. And I do follow this in my database to with temporary tables, that only store data based on the current product being developed. But the results, ie the total costs, end pricing etc needs to be stored somewhere. As I have reports that...

Hi all, I have been working on product database since the start of the year. I had never used MS Access before, and I have leant a great deal. But this is where I begin to doubt my abilities, as I have taught myself mostly everything I know. I am just wondering will I the end user see...

Thanks for the input Jeanette! Yes my structure does already loosely follow your suggestion. I have found a solution, although it seems dodgy, it works nicely. I have made the subforms invisible, and linked them using vba to unbound controls on the main form. So the user does not directly use...

Hi all, I currently have a form which creates a parts list for products and it works great. It is basically a inputs one to many into a table between products and raw materials. I now wish to include on the same form (for simplisity) the ability to add patterns for each product similarly to...

Hi All, So after all my previous posts regarding images in databases (which were very helpful and I got working awesome), I have now realised through management that the database will be used internationally and therefore the way I have been referencing images to the database won't work, (I've...

Hi all, This is an unusual question. Currently on most of the forms in my database I allow the user to delete records by selecting records in a list box on the form and pressing a delete button, I have also allowed them to use the key "Delete" to achieve this. However, now my manager has...

No worries. Lucky I didn't dive too far into it, I spoke to the client and they made me aware that their servers will contain both high res and low res images for situations such as these. So it is now a non issue. Thanks for your help bob! Cheers, Raymas

Thanks for the reply Bob. I feel a bit stupid now, that I didn't see this as the solution, as I am an electrical and computer systems engineer, and have delt with sampling before. I guess my question now, as I am relatively novice with vba and to more an extent access, is how I would achieve...

Hi All, I've had a look around, and have not found a lot on this issue. So i'm wondering if it may be a printer problem rather than an access problem. I am currently attaching images to tables by storing their file path locations in text boxes and then linking them to image boxes when...

No worries. Yeah well the sample you sent me still works in 2010, so I think most of the commands (if not all) are still valid. But yeah I can still have a play. Thanks for your help, certainly made my life a lot easier. I did find the original sample code from microsoft based on this method...

Hi John, I've had a look through the code this morning, and I understand it enough to make my own version for my database. Just one thing.. I'm guessing this was created in an older version of Access, am I right? On my PC I am using 2007, but my company is using 2010 at the sight I am working...

Cheers dude.. that looks really good! Now i'll just have to get my head around all that code. Almost home time here, so i'll jump into it tomorrow.