Recent content by add1989

What do you think? (attachment) I can't figure out how I would output this into 1 long CSV line. e.g. 5700302etc,790333,J08238438etc,Charm,Charm,Silver,Blue,Silver Hedgehog Charm,30.00,60.00 I don't know if the audit stuff is what I'm looking for? It seems to be more of a logging tool than...

In your example... can't 'curPrice' and 'effectivedate' simply be added to tblArticlePrice ? I don't see why there are three tables there... Well each text field would have it's equivalent in a different language... So a Category of 'Jewellery' in language 'EN' would have 'Schmuck' as a...

Thanks very much for your help so far jzwp22. It is very much appreciated! Attached is a PNG of what I've got at the moment (from what you've said and some stuff I've thought of)... I have to be able to reproduce each released price list. And if anything has changed (such as a category from...

I started another thread to get help with restructuring... http://www.access-programmers.co.uk/forums/showthread.php?t=209837

I want to store a CURRENT description in different languages (DE, EN, etc). Material is only one item. Size and weight of the article (e.g. ring size). No dimensions, just a text field. Category: Jewellery, Sub-Category: Charms The articles are generally jewellery and/or accessories. I...

The tables aren't per article, they're per article field. For each article I want to know: Barcode, Reference Number & PH Code Description, Category & Sub-Category Material, Weight, Size & Colour + other similar info. There could be 5000 articles per supplier. Currently 12 suppliers. Every...

Can you tell I've had a rough day? Sorry, I zipped the wrong damn file. I'll upload it anyway, incase anyone else finds it useful.

Thanks for your suggestions jzwp22. Attached is a 2003 and translated to English version of my database. What do you think now? Also, in your example... How do you tell which is the current ID of each type? In my version I was just checking when the 'NewUID' field was empty. I should note...

I was wondering if anybody would be kind enough/have the time to help me with a database I'm currently designing. The details, including an attachment can be found here: http://www.access-programmers.co.uk/forums/showthread.php?t=209826 I am trying to achieve this: Each supplier (DB_Lief)...

Had a fresh look at normal form. I don't understand how else I can Store each value with the ability to say when it was changed and what it was previously. My plan was that an ArticleList table would list all the 'UID' fields of each 'field table', so that when an offical article list is...

Windows 7 Pro Access 2007 (Multiple machines tested, with same configuration) I am designing a database to hold current and previous data about a large number of products. I have a main table called 'Article' which has an AutoNumber (ArticleUID) and a 'IsDeleted' boolean field. There are then...

Hi all, Got a small problem with my text box. There is enough text in the text box that a vertical scroll bar has appeared. My mouse wheel will scroll other parts of access, but not the text box in form view. I know that Microsoft disabled Mouse Wheel in form view for record changing, but it's...

What does this do? It seems to be working without it?

This seems to have worked perfectly! Thank you very very much! :)

I still get the data type mismatch error with this code change. I have checked that all fields are the correct data type, and I have messed around with the code a little, particularly the select statement, but I still get the error? :(