Search results

yes you're right. The main problem that with every report i got 6-7 labels and textboxes. And for every textbox and label box i need to write visible= false and visible true.

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

thanks everyone. i will definitely use dao. Retrieving of information is pretty much fuster

You mean to use ADO???

well that is the question what are the ways retrieve information in an unbound control. For bound it s quite simple in access.

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

Seems good, but the multivalued field 'tblEvents.contactid' is not valid in the specified Join clause.

What is the DLookup returning? dlookup returns ContactID as 2;3;4 What is lstEvent returning as Value? lstEvent returns eventID What does your strSqlContactEvent look like? Is it proper SQL? What do you mean hear?

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

Finally problem is solved. Status = DLookup("[Company_Status]", "[tblCompanyStatus]", "[Company_StatusID] = val('" & DLookup("[Company_StatusID]", "[tblCompany]", "[Company] = '" & strSelected & "'") & "') ") Thanks to GalaxyAtHome for help!

doesn't work. :((((

hmmm, it's not working. Second level dlookup works fine. Second dlookup shows status id number on the form. First level dlookup searches for the status name in tblCompanyStatus by Company_Status ID. In original, access shows error "Data mismatch in criteria", as second level dlookup value is...

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 & "'") ")

Well if I remove the code, query does not show anything. Might it be connected with that combo is taking value directly from a table. When I put table - query - combo it is working. I do not have special code to run the query. i get combo(criteria) - query - report - On Click(show report)

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.