Search results

I have designed CRM in access. Company, contacts, projects and related events input. For those data i designed certain reports. Detail list of reports presented in treeview. when you click on report name, form shows you different text boxes. Realized through select case report name and...

Heips, can you advice any new for me method to retrieve data from table to form. Now i am using dlookup() for every field, but i've read somewhere and do not rememeber where, that it's possible to use with the cycle. In this cases text box name and field name must be identical. And also what...

Hi, got a problem with mulltiple fields. When i have one record in contactid(see dlookup), works fine, but when i get more than 1. listbox returns first contact name and shows error "Characters found after end of SQL statement. (Error 3142)". In multiple fields, records delimiter is ;, which...

Hi, i would like to implement logging system to my database. For example when user changes status of the project, record with time, when project status changed, will be created. The problem is that i do not know how to realize it (database structure, relations ... ). Any advice or link to help...

Can please anyone suggest right syntax for criteria (marked red)? Second dlookup returns number. Thanks for help!!! Status = DLookup("[Company_Status]", "[tblCompanyStatus]", "[Company_StatusID] = DLookup("[Company_StatusID]", "[tblCompany]", "[Company] = '" & strSelected & "'") ")

Hey, got a problem with criteria which comes from combo box. Combo box values are taken from table. Well, problem is when combo is empty, query does not show anything. I used this expression in query criteria. [Forms]![frmReportManager]![cmbAgentName] or...

I got client register form. For modifying records I created another form. Problem is that second form shows me only first record but not current on first form. Could you please give an advice. Thanks for help and happy new year.