Search results

Welcome to the Forum. The secret often is to add things one at a time learning as you go

Welcome to the forum. Don't be afraid to ask any questions and we will try to help you

Welcome to the forum.

Not sure where you get this impression from. If you have a reference it could be helpful if you post it. It does not seem intuitively obvious to me that your supposition is correct so further elucidation would be helpful

If you travel at the speed of light it will take you 100 years to reach a planet 100 light years away. That's how long it takes a photon from that star to reach us

You have got a lot of good advice here which you should take to heart. Having looked at your proposed design I see you are going to have a lot of calculated fields. This is generally not a good idea. It is usually better to calculate the fields when you need them and not store the results. That...

Pedants corner. I have just checked in my Concise Oxford Dictionary (often regarded as being authoritive in UK usage. Boor is defined as a clumsy or ill-bred person. Bore among its many other meanings is defined as a tiresome or tedious person. So now we know the correct terms let's not use...

Welcome to the Forum. This link posted by Jdraw in another post may be helpful for you

Welcome to the Forum. Good link from Jdraw. If you have any questions then post them in the relevant section and we will do our best to help.

Welcome to the forum. I would recommend finding some online tutorials if you want to get to grips with VBA. There are some things where VBA provides a very neat solution. Good luck

Re: beginner - easier to have big table & subdivide it or have couple table sharing I By storing the data once then you obviously save a lot of storage space compared to flat files. That is why a properly normalised database is an efficient means of storing and processing data. It is always...

In general Access tables should be long and thin not short and wide. I would advise you to google database normalization and then check your design. In my experience if you have a properly normalised DB then it is much easier to write meaningful queries and to add extra functions later...

One way to resolve this would be to store the date and time of each transaction. You could just display the date but the records would sort in the correct order.

and his new

IIRC this sort of problem is due to conversion from Real to Integer. REal is stored as a floating point number and this can lead to small inaccuracies/rounding errors when it is displayed.

Happy Birthday Mile-O.

qupe, it is good manners not to nag people to reply every 12 hours. It just irritates the people who may help you. Remember all the answers come from people who do it out of the goodness of their hearts. From the bottom up your episode table should be linked to your season table and your...

This rings alarm bells for me. Calculated fields in a table should be a no-no because the calculation Isi lye performed once when the record is inserted. This means that if one of the fields used in the calculation changes the calculated field does not unless you take special steps to...

Welcome to the forum S

Welcome to the forum