Hi zmbd
That has worked perfectly! Thank you so much. I will now go away and read all the links you have given me.
Once again, thanks.
Viv
VivDenham
Last Activity: Feb 16 '13, 06:28 PM
Joined: Dec 12 '08
Location:
-
How to show Autonumber in a Combobox with no decimal places?
Hi there
I have a table - Projects - with 2 fields: Project ID (autonumber) and Project Name.
I then have a 2nd table - Decorations Used - which contains 3 fields - Decorations Used Id; Project ID, and Decorations Name. The Project ID in this 2nd table is a Lookup field back to the table Projects.
However, in the 2nd table, when I drop down the Combo list, the IDs have 2 decimal places, even though it... -
Thanks, dsatino. I realise I'm doing things very much in a "Belt and Braces" fashion - just can't trust myself to rely on the Tables to work correctly for my purposes.
So, it's back to the drawing board. Thanks again.
VivLeave a comment:
-
Hi dsatino
Before I go too far down the Normalisation road, I wonder if you would have a quick look at what I've done so far. My brain works in such a way that I have to have tables, queries, etc listed in the correct order that the process takes, so I am just checking that I am understanding things before I do too much work which may be incorrect.
Many thanks, once again for all your help.
Viv...Leave a comment:
-
Hi dsatino
Thanks for the example db - I shall spend the weekend going over it and sorting out how I can use the format myself.
Thanks again.
VivLeave a comment:
-
Hi dsatino
Thanks for all your efforts - the cogs in my brain are whizzing round just now.
I can see the logic of having a table for attributes of Tops (i.e. component parts of a jumper) and that leads me to think that I have a stage of the logic (and hence, a table) missing - perhaps I should have a table called Tops - Component Parts, and these component parts would be things like Welt Type, Waist Type, Armhole Type, Neck...Leave a comment:
-
Hi
I've re-read both the above (and many other items found by Googling). However, as far as I understand it, the main requirements of Normalization are a) to only record 1 item in a table, b) not to duplicate data, and c) not to have redundant data not linked to that ID.
In my database, T-01 - Style - Tops - Arm records all the different types of Arms that a Jumper could have. This table contains the ID, Arm name, a picture,...Leave a comment:
-
Hi dsatino
Thanks for the comments. Could you give me an example of where the DB is not normalised please.
Thanks
VivLeave a comment:
-
Hi twinnyfo
Thanks for all that info - I'll take a look and see if I can use your tips to save space. I have in the past, tried to use various methods to reduce the size of the pictures and photos. For the Photos, I resample to 5% or 10%, depending which Form it appears in. For the Pictures, these are created in Coreldraw. I experimented with inserting them as bitmaps, jpegs, attachments etc, but the least space was taken by leaving...Leave a comment:
-
Hi there
Yippee! I've finally managed to upload my database for you to look at.
To reduce its size, I've removed all Products except Tops (button on the Welcome Screen). I've also reduced the number of Tops to 6. And I've removed all the Make Tables.
Therefore, to get the queries to work for Knitting Instructions onwards, you will need to go to Step 5 on the menu - Items Knitted - Add New. In that...Leave a comment:
-
Hi - I think this problem may well have been me! I'm not at all up with the various meanings of Kb, Mb, and Gb, so although I was aware of the 5Mb size limit, I thought that my zipped file of 26,748 was under the 5Mb (thinking that 5Mb was 50,000kb). However, when my son returned from a trip away, he told me that I need to get the DB to under 5,000kb.
So I will try deleting more stuff to see if I can get it below the 5Mb (5,000kb)...Leave a comment:
-
Hi NeoPa
Thanks for that - I have been doing exactly what I should. However, the problem seems to be this "Security Tokens" issue. I have just tried uploading using IE9, Google Chrome and Mozilla Firefox browsers - and all give me the same message about Security Tokens being missing.
So it looks like I am in the hands of Bytes Support team for them to come up with a solution to this bug.
Many thanks...Leave a comment:
-
Hi there
Deleted the Make Tables and this reduced the zipped file size from 78,452kb to 26,748kb. Tried to upload, but again got the Error Message that the Security Token is missing. Am still awaiting an update from Bytes Support team. I will keep trying.
Many thanks for your continued interest.
VivLeave a comment:
-
Hi there
It has occurred to me that the reason my upload is failing is because the size of the zipped file is 78,452kb - is this too big? If so, would it help if I deleted the contents of the Make Tables and then uploaded it? Would you be able to then run the MTQs yourselves? (You need the contents of the Make Tables for the later queries to work as they pick up their data from the MTs).
Let me know if this would help...Leave a comment:
-
Hi -z
I did try to upload the database, but got an error message that a Security Token was missing. I'm awaiting an update from Bytes Support team. Then I'll try again. If any of you would have any time to look at the database, it will be interesting to know what you feel.
I know I've built in lots of "Catch-Outs" (e.g. I've put a "Locked" field on every form, linked to a Module for every form. I...Leave a comment:
-
Hi Zmbd - thanks for your reply - gosh, 3.00 a.m. and you are still awake enough to think properly!!!
I have read the article on Normalisation, and I'm pretty confident that my tables comply with this. In the past, I've tried to get over using MTQs by using SQL Server, but had to give up with that when it came to the calculations.
By calculations I mean that I have an item of knitting, say a Jumper. Before I start knitting,...Leave a comment:
-
Hi dsatino
Thank you so much for your extremely kind offer to look at my database. I have zipped it, but can't for the life of me see how to insert it into my reply to you. I'll keep trying to find out and will send it to you asap.
Thanks again
VivLeave a comment:
-
Hi - Just as I thought I'd got it sussed.....
The solution provided by DSATINO works perfectly. However, I have noticed that every time it requires the database to be Compacted, it then unchecks the checkbox for Compact On Close in the Access Options.
This means that when the database is NOT too big to require a Compact, it does not get Compacted on closing the database.
I've got mixed feelings about this....Leave a comment:
-
Tee Hee!!! Thanks for that - made me laugh out loud. My husband says "Too Late! Things have been tricky for years with this database!" I originally had the brainwave in 2001 with the intention of automating my knitting calculations using Excell - but then my son suggested Access - and then the trouble began. I had dark hair then, now it's white!!!
Best regards to you all, and thanks for all your help.
VivLeave a comment:
-
Hi dsatino
Once again, thanks for such a speedy reply. For my purposes, I really want the Compact to happen so that the file size does not get too big and Access crash altogether, resulting in corrupt data. So I guess having Access close is the better of the 2 evils.
And yes, again, I agree with you that I need to split the database. This has been a steep learning curve for me - I am making a database for all the Machine...Leave a comment:
No activity results to display
Leave a comment: