Search results

  1. A

    Enable ActiveX Controls Problem?

    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...
  2. A

    Macro Tutorials?

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

    Update Query

    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
  4. A

    Northwind database's complete explaination

    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
  5. A

    Draw Relationship diagram with supertype-subtype entities

    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
  6. A

    Someone I met told me that MS Access and VBA are obsolete!!

    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...
  7. A

    Can Access application have multi-languages?

    Hi I want to create an application which can switch between languages. What should I learn to be capable of making it. Note: I will not create it now because I am learning the program (I am concentrating on VBA). But I would like to know the concept in advance. Thank you
  8. A

    Where is the complete list of Err.Number and Err.Description in VBA?

    Hi I have tried finding the list on Microsoft website but found some partial lists of Error from which sometimes don't have the value I need to get information. So Anyone who has it please posts a link to the complete list of Err Number and Description. Thank you
  9. A

    Should I use OLE Object or Attachment for a picture's field in a table?

    Please give me advice.
  10. A

    How to create a sophisticated report on access?

    Hi I have to create a manufacturing report which has many details in its sheet. For a long time, my company has used an Excel to create it. Since last year, I have been learning Access and wanted to integrate the report on my database. However, I have seen many sample reports on Access which...
  11. A

    Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

    Input " Like A* " in Validation Rule Property but it shows " ALike "A*" " Hello I've a problem that when I entered Like A* in the validation rule of an AgentID field (The purpose is to force the field to use A as the first character.), the rule, however, showed ALike "A*". And when I added a...
  12. A

    Hello friends!

    Hello friends, I have learnt Database theory and Access by myself for about 1 year. The purpose is to build an application for my company. I have found this website by chance while googling some access stuffs. I have seen that the website is very useful so I decided to join it! I hope that I...
Top Bottom