Search results

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.

Thanks for your reply John. That seems like a very simple method, I like it! However, I want to make it as simple as possible for the user of the system. Is there a way similar to your method that allows the user to input the location, with a similar pop-up like you would say if you were opening...

Hi All, I am just wondering what is the best way to attach images to a database? I more asking for people's opinions and experiences. I have looked around and have not being able to come to a definitive conclusion. I am weighing between emedding images, which I fear could become an issue...

Hi All, This question seems like it should be a rather easy and obvious one, but I'm yet to find a solution. How do enable a list box to display picture attachments? I want the user to be able to view a list of products and in one field see a picture of that product. Thank you in advance...

Hi all, I'm creating a database and I'm having trouble with composite primary keys. I've read on a few forums that good databases should use composite primary keys over say an autonumber. And it does neaten up the database a bit, i.e. if a record is deleted there is no messy skipped numbers in...

Thanks for your speeding responses. My main concern was the size of the table, as I'm new to access and unsure of its contraints. But I have looked around, and thinking that maybe 30,000 entries really isn't that much. So I have gone with the straight forward many-many table. Everything just...