Hi all, I’m trying to filter the records a subform shows based on the employee number (in a combo box) that the user selects in the main form. At the moment im getting the following message when I select an employee number in the combo box: “Compile error, method or data member not found”:confused:
Ive searched the forums on here and tried to make use of the information other people have posted but im still having trouble getting this to work
Below is the code I have on the combo box of the main form:
Private Sub Cbo_Emp_Filter_AfterUpdate()
Dim strSQl As String
strSQl = " Select * from DATA-EMPLOYEE_MASTER where DATA-EMPLOYEE_MASTER.EMPLOYEE_NUMBER=" & Form![SCREEN-ABSENCE_TRACKING_MAIN]![EMPLOYEE_NUMBER]
Me.SUBFORM_ABSENCE_TRACKING.RecordSource = strSQl
Me.SUBFORM_ABSENCE_TRACKING.Requery
End Sub
Ive also posted the database if any one is willing to have a look for me (ive removed irrelevant tables/forms/reports). Im using access 97
I'm a newbie trying to upgrade a 2003 database to 2010. When I compile this database an error pops up saying "Method or data member not found". This is the code below:
Private Sub CBPrintReq_Click() On Error GoTo SendPrintError Dim NewID As String, Notice As String, Temp Dim CRLF As String * 3 CRLF = Chr$(10) + Chr$(13) Notice = ""
I have a form (frmTimecardsDataEntry3*) that needs to requery combo boxes to narrow down the selections offered in the dropdown of each combo box.
It is a data entry form. I.e. Dataentry is set to yes.
The ClientName combo box has an after update event which requeries the matter combo box, so that the MatterName combo box dropdown only shows the matters relating to that client. This works just fine.
The MatterName combo box has an after update event which requeries the Rate combo box so that in the Rate combo box dropdown only the hourly charge rates relating to that matter are shown. That works too. So far so good.
I then tried adding another after update event to the MatterName combo box, so that another combo box, Application, was requeried too, so with the Private Sub it looked like:
Rate.Requery Application.Requery
But this resulted in the error in the title to this post and the debugger highlighted in red the word Requery in the phrase Application.Requery.
I thought maybe Access does not allow two requeries resulting from one after update event, so instead I took Application.Requery out and placed it as an after update event in another combo box which did not have any other after update events to run.
However, this resulted in the same error.So the error appears to have something to do with trying to requery the Application combo box but I cannot see what is causing the error.
The Application combo box SQL is:
SELECT Applications.ApplicationID, [ApplicationDate] & " " & [ApplicationName] AS ApplicationDisplay, Applications.ApplicationDate, Applications.ApplicationName, Applications.MatterName FROM Applications WHERE (((Applications.MatterName)=[Forms]![frmTimecardsDataEntry3*]![MatterName])) ORDER BY Applications.ApplicationDate, Applications.ApplicationName;
This is the same arrangement of SQL that I am using on the other requeried combo boxes that work. When I take the WHERE statement out of the Application SQL and run it the query returns all of the applications.
I am not sure what the error code is trying to tell me about the attempt to requery the Application combo box.
I have a yes/no box in the form and when the firm is first opened it has a small square dot in it, but as soon as any data is entered in the form the dot clears and leaves the usual empty tick box that you would expect to see.
Also, another possible symptom is that I had another version of this form previously working quite well except that when I did several data entries all at once, so I had several forms filled in with different data (before refreshing and thus entering the data in the table), when I scrolled between the forms I kept losing the MatterName data when I scrolled back, and then when I re-entered the ClientName data the correct MatterName data returned without me having to use the dropdown to select it.
I have had an earlier simpler version of this form working for some time, with ClientName requerying MatterName and MatterName requerying Rate, and I am using the same SQL structures in the new form but getting the error in the title to this post and the other isues just described.
i have the following code in a function but when i want to compile it i have the following code will be blue i have error in this line:
.NamedParameters = True
the error message is this :
method or data member not found
my code is as following:
Function Get_Bearbeiter_Detail(ByVal vBearbeiter_Code As String, Optional ByRef vBearbeiter_Name As String, Optional ByRef vReadOnly_Flag As Boolean, Optional ByRef vAnalyser_Flag As Boolean, Optional ByRef vAdmin_Flag As Boolean) As Boolean On Error GoTo Err DoCmd.Hourglass True Dim rst As ADODB.Recordset
I am receiving the Method or data member not found error message when I attempt to add a new record in form view. I have been working in an old 2002-2003 version of Access until last week when it was converted to 2007. The old version allowed for additions just fine but now after the conversion something is wrong. The code is below. I underlined the line throwing the error message (FindFirst). Code is not my strong suit.
'Open form to new record gstrCallingForm = Me.Name strDocName = "frmNewApplicant"
I am getting method of data member not found for the following code when inserting values to a table. Form has three frames. Add/Insert is on OnClick Event.
I have two similar forms with similar controls. I copy 20 pieces of controls to another forms certain tab. When I run code to update database table using the control box value, access can’t find the control box. I got this errors message.
For my text box, Text255, on the Subreport I have tried:
Code: Private Sub Report_Load() Me.Text255 = DLookup("[Along_line_spacing_%pass]", "Performance_Requirements_Defaults_Table")
The table Performance_Requirements_Defaults_Table has just one record for lookup. No value is returned when I run the main report.
I found this: [URL] .....
And tried adding the lookup code to the main report instead of the Subreport, but I think I am having trouble understanding what they mean here: "Subform1 is the name of the subform CONTROL on mainform" Are they inferring that I need to have a text box on the mainform as well?
I tried using this Me!Subform1.Form!ControlName like this:
I know this is not correct, and I have tried several variations, but I am totally stumped. Everything I have tried with the lookup code in the main report returns "Member Not Found" and Text255 is highlighted. I feel like this should not be such a big problem.
I have a search query that searches for different results based on 3 criterior. I have set up a form so that the user can input the text into the form and then once the Submit button (that i created) is clicked the query table will be shown.
My question is:
Is it possible to have an error message box appear when i click submit and no data is returned by the search query?
I'm hoping for the message box to say "No corresponding records to your search criteria. Do you want to try again?"
Then the options given in the message box are Yes (where they should be taken back to the search form) and No (Where they are taken to another form).
i have these code to auto generate member number but the highlighted line generate error 94 - invalid use of NULL:
Private Sub cmdGetNumb_Click() 'On click of button a new Member Number is generated and 'focus is moved to tFName field. Me![nMembNum] = NewMembNum() Me![tFName].SetFocus 'Prevent accidental click Me![cmdGetNumb].Enabled = False
I have a subform in a form that displays all members of staffs Name and employee no. I am trying to find a way to search the subform on the main form it's on using textboxes to filter data, here is the code I have that searches the employee no.
Code: Private Sub Command178_Click() Dim dbs As Database Dim qdf As QueryDef Dim sqlstr As String Dim sqlstrwhat As String Set dbs = CurrentDb
[code]....
I do not get any errors and I haver used the same code structure for other subform filters but when I search for an existing employee no. the subform only displays a blank record with the employee no. 1?
I have a form which is linked to a query. The main form which calls this form sets the filter for the query. This works fine and I can navigate all the filtered records.
The problem is when I go to add a new record the filter information goes away.
For backround this is DB for project information. The user clicks a button to view notes on the project. The notes are stored in a different table and the project_id is the common field which links the two together. I want this to function where the user can open the subform read the notes and add a new one if needed.
I'm in the midst of a database where a subform 'producttotal' textbox 'txttotal' would be automatically filled with a value from the mainform combobox 'product'. my code is Private Sub Level_AfterUpdate() Forms!sbfproducttotal![txttotal] = Me![product].Column(1) End Sub
However, on testing it, I get a runtime error 2450. MS Access can't find the 'sbfproducttotal' referred to.
Do you have any idea what the problem is? Any words of advice would be welcome. Thanks!
I am trying to provide the user a custom search feature. They want to enter a keyword or phrase and search 3 memo fields and filter the form base on the records found. they also want to be able to search the whole phrase or any part of the phrase.
I have a like expression for any part of the phrase but I when I set it up for whole phrase it doesn't work. Even if I run a simple query and use
For example: There's an acronym the user is looking for : ACA
If I set my query up like this: [field1] like "*ACA*" or [field2] like "*ACA*" or [field3] like "*ACA*"
it not only finds records with that acronym but it also finds records where that combination is found in a word, for instance vacate.
I have been using the below code for several months to export to excel. Lately I get a run-time error 53 - File not Found. I have not changed anything, so what could be causing this issue. The debugger stops on the line "FileCopy sTemplate, sOutput"
Public Function ExportRequest() As String On Error GoTo err_Handler
Dim dbs As Database Dim qdf As QueryDef Dim frm As Form ' Set database variable to current database. Set dbs = CurrentDb() Set frm = Forms!AOSummaryReportForm ' Open QueryDef object. Set qdf = dbs.QueryDefs("AOSummary") ' Set parameters for query based on values entered ' in AOSummaryReportForm. qdf.Parameters(0) = Forms!AOSummaryReportForm!StartDate qdf.Parameters(1) = Forms!AOSummaryReportForm!EndDate
' Excel object variables Dim appExcel As Excel.Application Dim wbk As Excel.Workbook Dim wks As Excel.Worksheet
Dim sTemplate As String Dim sTempFile As String Dim sOutput As String
Dim rst As DAO.Recordset Dim strSQL As String Dim lRecords As Long Dim iRow As Integer Dim iCol As Integer Dim iFld As Integer
Const cTabOne As Byte = 1 Const cStartRow As Byte = 2 Const cStartColumn As Byte = 1
I've created an application in Access 2010 with a back-end and user-level security via workgroup file. The application has 12 users, the back-end is on a network share, and everyone has the front-end installed locally. Everything has been working great until today, when I made a small change and installed it on users' machines. Suddenly, one and only one user is getting the File Not Found error (53) whenever he opens the database, and all form buttons produce the same result.
I have a pretty simple form that includes subform. Subform's table is linked to main form's table with parent/child relation. Connecting fields are main table's ID field and corresponding field in child table. Subform is in datasheet view. This is pretty basic stuff so there should not be any problems, but every time I apply a quick filter in main form it causes data in subform become invisible. There is single row in subform, but all it's fields are empty.
I have an MS Access application installed on a number of machines and it is running fine on all of them except one.
On one of the server when I am submitting a form to search the database I get the error message:
"Automation Error. Element not Found."
Same version of MS Access on all machines. We are thinking of reinstalling MS Access on the machine to see if this would resolve the problem but just want to check if anybody else has any other suggestions???
Has anyone come across this problem before?
Any ideas or suggestions about how I might resolve it would be appreciated.
I try to delete a record and i get this error message "The search key was not found in any record". The key of the table is an autonumber but for some reason in these two records i want to delete has value = 0 .
I have a fairly complex database which contains a company table and a staff table along with approx 30 other smaller tables.
The staff records have a field called company which is linked in a one to many relationship to the CompanyId field in the Company table. This is an auto-number field and is up to 5467 currently.
I have enforced data integrity when this relationship was created. The users enter new staff members using a sub-form in the Company form.
A user created a new record for a company and while completing the task the text in all field went a bit crazy and appeared in symbols rather than text. The user shut down the database and restarted it.
Now when you open the company form the staff member appears with the correct company but does not appear anywhere else in the database with this company. The correct company id is 3416 but when I looked in the table the staff members record has an id of 36097146 or something similar. There are only 5467 companies in the company table. I tried to amend this figure and got and error which said "The search keys could not be found in any records".
I tried to delete the record and the same error appeared. When I clicked on the Help button of the error I got a message telling me that the error occurs when an ISAM seek operation fails.
Anybody know what is going on here and how I can delete this record or more importantly why this may have happened in the first place.
