Search results

i changed the syntax but now i am getting a run time error 3075 syntax error(missing operator) in query expression '[CompanyName]="Queen Core" or' I had selected the company name Queen Core in my combo box I am getting this pop up at the second last statement...

Thanks for all the patience. I am still getting a run time error 2465 at this line If Len(Me.cbocompany.Column(1) & "") > 0 Then strWHERE = [CompanyName] = " & Chr(34) & Me.cbocompany.column(1) & Chr(34) & " Or "" End If The name in the parenthesis refers to the table feild...

I think i am not referring to the form or sub form correctly. I dont know if i have a sub form. I have 3 combo boxes placed on a form and i dragged a form into the main form. I clicked the little black top square on the form and am checking the properties and there is no child form...

Thanks Bob for taking the time to reply I am getting a run time error 2465 Microsoft office access cant find ' | ' referred in your expression also what does Chr(34) mean in your code. what does if Right(strWHERE, 4) = " OR " Then strWHERE = Left(strWHERE, Len(strWHERE) - 4) mean...

:(I have 3 combo controls on my form. Each combo box row source has a select query eg. cbocompany rowsource = SELECT tblcompany.CompanyID, tblcompany.CompanyName FROM tblcompany; I have a form which has the values based on a query Recordsource is bound to a query When i click on company...

I am posting my sample db with the form and control to make better sense of the requirement. I would like create a dynamic search form with search values in a list . select first name , city, country job title from tblcontacts based on conditions. The idea is to create a single filter code...

I need to create a one resuable code to be used filter various forms in my database. I had selected all the searchable fields put it in a table and then search the forms using a query. Could anyone help me with the direction of how to go about doing it. My idea is to be able to populate the...

I have finally figured out my visio data org. charts and the output is saved as tabs. Basically they are company organization charts with each tab representing a company. I have created a combo box based on a query which shows all the companies. I want to be able to do the following. 1) when...

thanks for your prompt reply chris. this almost looks like mission impossible to me since i am not very good with coding but hats off to people who could desgin and bring to life the versatility of other applications by code. i will try to go through this and see if i can custom make it to my...

I have a table Org data attached as pdf. in visio when i run the wizard i get what i am looking for and based on the report to id i get my organizational chart. Can i automate this process in access. we run the access run time version for users and no one has visio software to work with. So...

you are right how to deal with this. The ultimate result is monthly projects of leads, tenders and projects in the form of a graph.

Thank you for replying back. Since lead data does not link in any way to project and tender data can i create a table and write the data down month wise and then run a cross tab query. is there any other way to do this thanks

tblAudit Feild Name Data Type Recordid Autonumber AuditTrailData Memo DateRecorded Date username Text These are the 4 feilds in my tblAudit. Thanks

i have a form has a text feild control which records all changes made to the form values. The form gets values based on the employee table. so if anyone changes the records it creates an audit trail of values. A code i got from this forum. I want to be able to copy these values into an audit...

I have 3 tables tblprojects projectid projectname tenderid value tbltender tenderid value tblleads leadid leadcategory value tblprojects and tbltender are linked with tenderid and i can create a query to extract the data tblleads is stand alone and not all leads convert into a...

Thanks for the reply but were in the VB code should I declare these variables. Dim objXL As Object Dim objWB As Object Set objXL = CreateObject("Excel.Application") should it be inside a procedure or before the form opens. Should it be after option compare database. also for word and...

Thanks for your prompt reply Bob, I am new to coding. From what i understand Dim objXL As ObjectDim objWB As ObjectSet objXL = CreateObject("Excel.Application") by creating this late binding reference can i by-pass the use of the library file reference. ie. since i run access 2007 with...

Could you let me know if there is a way we can by pass the version problem in Access. I have access 2007 running in office 2003 and so there is always a library incompatility issue were i go to the script and add references and select office 2003 library, word, outlook excel etc.. and the...