Search results

Thanks for pointing that out. It was an issue with the field being named CompanyID but the object being named CompamyId. However it still does not work. I keep getting runtime error 2162

I have tried to get this working for two days now and I am pulling my hair out. Here is the scenario. I have a form called frm_MainMenu which has a subform called sfrm_Company There is a search section on that subform that displayes its results in a popup continuous form called pfrm_CompanyList...

Yeah, I missed that. Many thanks

The subformcontrolname and the name of the subfor are the same. Saves confusion cboSelectJobs is a conbo box so I used If Forms!frm_MainMenu!sfrm_Reports.Form!cboSelectJobs.ListIndex = -1 Then This worked perfect for the if part of the statement but the else part of the statement still...

Hi I am having some trouble with the following code. The if statement generates a Runtime error 424 Object Required error. I have shecked this forum for references to Runtim error 424 and have not found anything relevent Private Sub cmdViewReport_Click() If...

Thankyou very much That worked

I am at a loss on this one. I have a form called frm_MainMenu On this form is a Tab Control call tabMainMenu On the second tab there is a button that opens pop up form with a list of companies This is a continuos form and it has a button that is supposed to set the filtre on a subform of...

Ok lets hope I can explain this well. I have a form called frm_MainMenu On that form there is a Tab Control called tabMainMenu On the tabs are several sub forms The Second Tab is called Employers Onthe second tab there is a sub form called sfrm_Employers The third tab is called Reporting When...

Hello Everyone I have a form that has close to 75 fields on it. These fields are spread out between several Tab controls and a few subforms. Here is my delima I need to control the state of the Locked and Enabled properties based on a security level when the form is opened. I do know how to do...

I am pulling my hair out. I am trying to get a Browse Button to populate a hyperlink field with a path and file name that can later simply be clicked on to open the file that was selected. I have downloaded and looked at the sample database in this post Sample Database and it works sorta. I...

Thanks I will try that at a later date. I really appreciate your help. I was able to resolve the issue buy using a different field (UserName) which is unique to each logged on user. These validates exactly what you are saying because this is a text field and it worked perfectly.

Ok now I know what is going on. Thanks for that tip it showed me that the following code is entering the UserID in the frm_LogonStorage as a text value rather than a number. The value in frm_Logon in control cboEmployee.Column(0) is in fact numeric. It is the primary key of the underlying table...

I am self and forum taught in vba and I have no idea how to do that. Would you be so kind as to enlighten me??

Yes the form is opening a previously created record

Yes. That field is populated when the record is created

Ok. This is a little complex so I hope that I explain myself correctly. I use a customized log in system that I found on these forums. Iw works flawlessy. When a the database is opened frm_Logon opens. In the on open event of that form frm_LogonStorage is opened. This is a hidden form. On...

The sql is as follows INSERT INTO tbl_ProgramInvoiceLineItemStep4 ( ProgramID, ServiceType, Service, ServiceCost, ServiceMaxCost, InvoiceNumber, Quantity, Total, TotalToDate ) SELECT tbl_ProgramInvoiceLineItemStep3.ProgramID, tbl_ProgramInvoiceLineItemStep3.ServiceType...

I have a query with a field called TotalToDate I have placed the following DMax function in that field DMax("nz([TotalToDate])","tbl_ProgramInvoiceLineItem","[Service]=????")+[ServiceCost]) The question Marks represent the criteria part I can not figure out Basically i want the function to...

I am trying to set the focus to a text boxt (txtSearch) when the second tab (Clients) in a tab control is clicked. The tab control is on a form called frm_MainMenu I have tried several suggestions I found in these forums on the onClick event of the Clients tab These include...

That worked perfectly. Thank you, Thank you, Thank you. I have been ripping what little hair I have left out.