Recent content by pawelch

ok, here is the thing. I have 3 references active for my database project: VBA, Ms Access 12.0 OL, OLE Automation. When I add Ms Access 12.0 OL, the opening time of every from extends massively. Thus, my question is - how come? Or rather, what can I do to eliminate it. The reason why I need...

Hi Bob Larson, I could not open the link, however I think I have done what you suggested. In other words, I have to have created a function that generated SQL query given the condition. It took me a while but it works a treat. Thank you for your response anyway. Cheers

Dear all, Suppose that there are 4 tables, Person, Company, PersonRoleInCompany, CompanyContacts. In PersonRoleInCompany, there are PersonId, CompanyId, RoleID, In CompanyContacts, PersonId, CompanyId, ContactTypeId, a person can be assigned to multiple companies and have multiple roles...

Hi all I have two tables: Person and CompanyContacts. There are multiple Person fk's stored in CompanyContacts. For selecting unique entries of PersonID in CompanyContacts I was trying to do it in the following way: Select * FROM CompanyContacts WHERE CompanyContacts.PersonID IN ( SELECT...

I am sorry for asking this silly question, but do you actually mean to set up a physical connection to a database with code ? In other words, to set up a startup procedure at front-end applications something like: CODE] Dim db As Database Set db = CurrentDb()[/CODE] and the operate on...

that is even a better solution. thank you every one for your commitment and responses.

I have added refresh method use for that form and it looks like it is working. I should thank RuralGuy whose post from I think 2005 helped me. I found it on the other forum In general because of Referential Integrity - the form had had to be refreshed first, before the imputed data were sent to...

UPDATE: I added db.Execute SQL_Text, dbFailOnError as suggested by RuralGuy and it helped me to understand what really happened. So I need to give a more detailed description. When I add a person to the database its details are stored in a table Person. Then there are options to assign it...

Hi all, you are right, maybe I should have explained it a bit better. So there is a table that stores company contacts. What I want to insert into it is a row of keys that will be composed of: the company id number, then person id, and a type of contact. By "sometimes works sometimes does not"...

Hi Boblarson, Come on, what I typed in is exactly what you meant. But presumably I did not use the correct code. I meant that I understood what you were saying but used a wrong code expression. Anyhow, thanks for letting me know there are other coding solutions :) I'll try to take advantage...

Hi all, Could you please tell me why this querry sometimes works and sometimes does not ? SQL_Text = "INSERT INTO [CompanyContacts]([CompanyId],[PersonId],[ContactTypeId]) " & _ "VALUES (" & [Forms]![formCompany]!CompanyID & "," & [Forms]![formCompanyAllContacts]!PersonID &...

I will look into it. I think you mean that I need to do something like "do.cmd run query" hopefully it works. Thank you for your help.

Dear All thank you for your response I found them really useful. My biggest concern is the efficiency of MS Access. I used to design simple databases for MySQL and it worked pretty fast even with multiple records. And as I was saying - I observed some decreased and slow performance of the MS...

Hi all, I think I have got a general questions - however, I prefer to ask experts rather than base my design on vague opinions. So, I want to design a simple database for contacts of a company. Of course the design and the company structure and activity requires some tables. However, I have a...

Hi Bob Larson, In general, it is a select query - I want to build a general-purpose export-data file that exports data from excel to access. Its purpose is to to ask where to upload data stored in an excel file. So, IMHO, the best bet would be to create a list of tables and then with a small...