Recent content by AccessPractice

Hi I searched for how to solve it and found one in the Microsoft office website. https://support.office.com/en-us/article/Enable-or-disable-ActiveX-settings-in-Office-files-f1303e08-a3f8-41c5-a17e-b0b8898743ed However, it didn't work. When I clicked on ActiveX controls in the design tab, it...

She just built an application for the largest oil company in my country so she is not inexperienced of course. I think she means if the project is not complicated enough, one can build it without using VBA.

The reason I asked is that my Access teacher told me that if one is very skillful in using the Access Interface itself e.g. queries, expression builder, macros, many times one doesn't need to use VBA or even doesn't use VBA in the whole project. So I started being interested in deeply learning them.

Sure. Hope it helps.

Hi I have come to the solution. I took an Access course last week. The teacher told me to put all types of accessories in one table i.e. tblItems and just query the specific type I want. There are some attributes that are gap blank (one that tape has but not button) but it does not matter...

Does anyone have books or links focusing on Macro? If so, please suggest. Thank you

Hi I edited drawing the relationship of Items as in an attached file. Is it correct to draw it like this?

I have two tables which relate in one-to-many relationship. In one-side table I have an autonumber field (PK). And many-side table with a number field (FK). I want to use update query to fill in FK with PK. (there are about 600 records to fill in.) How can I do it? Thank you

Dear The_Doc_Man Do you have sample ER-diagrams or databases as a whole which are similar to my project? I know I am not ready or exactly competent to do it But I have read both database theory and how to use Access for about a year. Yes a year! But just reading and practising exercises in...

Hi jdraw First of all I would like to tell my background, I work with my family business which is a garment factory. My mother who is the head of the company assigns a project to me My project is to build an application which systematically collects stocks. There are many stocks' records which...

Hi My project has a database quite similar to Northwind's. So I would like to deeply learn about the Northwind's for all aspects. e.g. tables, queries, forms, its relationship diagram, Modules If anyone has links about it, please paste them for me. Thank you

Hi Minty I have edited the relationship using your advice. It is in the attached file. However, I have a problem that in the attributes table, in the attributeValue's field, there are many data types in it. For example : Color-->ShortText Picture-->Attachment Size-->Number (I may use ShortText...

Hello guys! Thank you for your replies. The reason I think I have to use supertype-subtype is that Tapes and Buttons don't have the same number of attributes and don't have the same units. For example, Tapes has Color, Type, YarnComposition, Size, etc. whereas Buttons also has Color, Type(not...

Hi I cannot draw the supertype-subtype entities. I want to have Accessories' table as a supertype and Tapes' and Buttons and more(in the future) as subtypes. When I drew it, it showed error as in the attached file. Please help Thank you

Hi Today I sat and learned MS Access focusing on VBA at Starbucks.A man who works as a programmer stared at me and said to me that I shouldn't use Access to create a database because it is obsolete. And he suggested I should use ruby language with sublime editor combined with mySQL or...