Recent content by DeeDee

Hi all I really desperately need some assistance. I bought Office 2010 and had to create a database as part of my assignment for last semester. Some of us cant recall if the lecturer stipulated that she must be able to open it in 2007 or 2003. I submitted this beginning February and am...

Hi Dave Thanks again but I think I managed to fix the problem. Just done some more testing and this time around the updated time does appear. Thanks for looking at it anyway

Hi Dave Thanks for the reply, if you have a look at my second screen shot I do have the timer interval in there. So not sure what else could be wrong.

Hi All I am trying to follow a simple instruction adding a working clock on my Main Form of my database. For some reason the clock is just not displaying and would like to know if someone can have a look at it for me please? I am trying to follow this instructions: To put a simple text...

Hi Again thanks for all the responses, this look now so much more complicated than I thought. Hopefully I am following you correctly. To answer your questions. Regards to tracking products, they did not really go into too much specifics, the main purpose was just to have a database with all...

Hi, I think it might have been another error on my side because like I said I initially only had the Inventory table and that is linked to supplierID and maybe products table should be linked too? What would you suggest I do re: min and max values for some reason I cannot see what I could do...

Ok thanks for that. But in general do you think that the normalization is correct and obviously taken into account the new tables you provided and without adding any additional tables.

for tblTransaction would or can fkCompanyID just be a foreign key to SupplierID because as mentioned before I will only have tblSupplier and no Customer table at all. tblTransType - Can I have that witout the Sale. Because what the client would do is order stock in and when they stock take...

Hi, thanks for responding. I am currently on Allen Browne's site and will have a look some more. I initially had a stocktransaction table and was advised not to use it because it will just make the application more difficult. And maybe that is why I cannot seem to go any further because my...

Anyone please?

Hi All I am fairly new to database design (a student but currently taking a break due to new baby) but am trying to help a friend who owns a restaurant. I am trying to create an alcohol inventory database. Their will be no customer table. I have done a few tables but am sure before I can...

Hi Thanks for the replies Steve R I have decided to go with it being a calculated value based on an assumed conception date unless I can find a way to do it another way. This is something that for now must be done in MS Access but it is something that I will eventually do in MySQL and make it...

Hi All I am busy with a gynaecologist booking system for mums to be. I need to have the following. The date that they first visit. How far along they are and every time when they come for an appointment I would need to know how many weeks they are at. And lastly the due date or expected due...

Hi All Just want to say hi. I am a student working on a project and looks like will be using VB for a while and will be using this forum for advice.