Help Needed By A New Member
Sep 30, 2005
Lets start by saying I am not a programmer but by modifying examples found in books I have over the past few years built an order processing data base for our business. An expert would think what a mess but it works for ME. The problem being I would like my staff to be able to use it.There is one problem which I can get around but they would not be able to.
The database has two tables (well more than that but its two I am talking about here) One which holds details of 3000 + Roads. The other has House or Firms names and directions. On the order form I have two Combo boxes one to enter the Location (House Name) another for the Road Name. When you enter a House name the Not In List event looks to see if we have delivered to
that location before, if so displays the full address. name,number,road,town in the combo box fed from a query which uses an EXPr to re join the data fields to display as one. If the location has not been used before a yes/no box comes up. If yes a new form opens to enter the details and choose the road/town from the road list.Then you are returned to the order form.
The problem is let say you start to enter "Orchard Cottage" up comes Orchard Cottage,London Rd,Larkfield. Want you want to enter is another Orchard Cottage in say Ditton.
Because you already have one in the list the combo box will not ask if you want to enter a new one. I can get around it by putting an extra letter in the name, then once the order had been finished go to the location table and take the letter out. No good for the Staff as you can see. Shame the rest works fine.
Anyone have an answer ?
Kevin.
View Replies
ADVERTISEMENT
May 6, 2006
I have several queries to find expired members, current members etc, however I can't get new members this year. Iv'e tried the unmatched query wizard using these two queries, also several other queries and tables but I either end up with all records or none. I'm going round in circles. I don't want a parameter query to ask the date, just some code to get the new records for this year and when the query is run next year it will show the new records for that year etc. Any help would be appreciated. My year date starts August 1st and ends following July 31st.
View 3 Replies
View Related
Aug 8, 2007
ok
here it is
i have a database for members.
i have a table with the general info for the members like name, date of birth, that kind of stuff.
i want to know how i can make sure that there are no duplicate members.
when in the form.. how can i validate that the member isn't already there?
the problem is i can't validate the name for duplicates because there isn't only one John in the world. or the name might match all together but the birthdate isn't the same.. things like that
i'm sure this is a very common problem so there might be an established solution
i made a search for duplicate reord. but not sure what to do with it
i was thinking of creating a special value using firstname-lastname-birthdate so they'd be unique... but even after doing that. how can i make sure the record isn't added to the table until it is validated?
hope i was clear with my question.. thanks for the help
View 3 Replies
View Related
Jan 4, 2005
I am new to Access and have made a databse using Access 2000. This is used for a dart league.
In one of the Tables called Members each "record" is made up of the persons details
(Name,address, etc). Included in the Row record I have "fields" (columns) that keep track of
the points each person hits on a nightly basis. I also have a Total Field.
Exampleof fields)
ID#,First Name, Last Name, Address, Phone #, Week 1, week 2, week 3, Total
How do I get the Total Field in the record to add up the nightly points in Week 1 + Week 2 + Week 3.?
In Excel it would be a simple calculation (e.g =sum(a1+b1+c1) etc.
As I said I am new to this database and it is very frustrating at the moment. I have used the help function
but it mostly double dutch to me.
ANY HELP in plain english would be appreciated
View 1 Replies
View Related
Jul 11, 2007
Hi
I am a member of a local tennis club and they have asked me to help them to build a database that will cover membership details and annual fees. Does anybody have a template that would be useful to get me started with this? Obviosly, it could be for any type of club.
Regards
Noel
View 1 Replies
View Related
Nov 3, 2004
I have a database that I took over for a small group (it has about 400 records), and they want to add a field for "Member ID", to use for member badges and whatnot.
A friend tried to help me by suggesting the "Change the starting value of an incrementing AutoNumber field" from the Access Help File, but I don't necessarily want incremental numbers, I just want a string of perhaps 8 numbers in no particular order, and obviously, unique to each record. I also don't understand how I can get that to work in pre-existing records...
So, what I'm wanting, in a snapshot, is:
83928475 John Smith 123 Any St
93827221 Mary Jones 678 Market St
19182734 Elvis Presley Graceland
etc...
I was thinking that perhaps a formula could be created in a query? Heck I don't know!
I only know enough about Access to be dangerous, so I appreciate anyone's help!
THANKS!
Matt
View 4 Replies
View Related
Jan 14, 2008
I need to create a form in Access which allows member registration, once the member has entered all their details and clicks on the enter button a pop screen/form of some sort should display their member no. this member number would be the next one down in the list, and should be a 16 digit number.. and it always has to start with the numbers 5555 1946 (the remaining 8 digits must be generated by access in sequence each time a member joins.)
How do i do this?
thanks in advance.
View 13 Replies
View Related
Aug 11, 2015
I created a text box on a form to show the member's first and last name. Works great! I now want to add it to show if they are a Jr. or a Sr. I thought I knew enough to make it work, but now instead of the name it just shows "-1". Here's the expression in the box...(if possible I'd like to keep it as an expression, since I'm still new to the "behind the scenes stuff" and don't know VBA)
=[GoesBy] & " " & [LName] & " " & IIf([IsJr]=True,"Jr",0) Or IIf([IsSr]=True,"Sr",0)
View 1 Replies
View Related
Nov 27, 2005
Hi,
Trying to run a template on a new computer.. it works on other computers, but in this case it gives me this compile error.. kind of strange.
It comes up here-
End With
Selection.PasteAndFormat (wdPasteDefault)
Selection.MoveUp Unit:=wdParagraph, Count:=1, Extend:=wdExtend
(.PasteAndFormat) gets highlighted... I'm not that computer savvy... please help!!
Thanks heaps
Ross
View 7 Replies
View Related
Aug 10, 2007
I am setting up a call log for an application. Once a message has been entered, I need to restrict access to the person who created it AND to managers (who have admin privelages to the database). Since the user who created a message needs to be able to go back in and edit it if necessary, I can NOT simply restrict access to the edit form to admins.
The command that opens this form looks like this so far:Code:If ((Me.[Transaction] = "Status Call") And _ (Me.[TransactionBy] = CurrentUser())) THEN DoCmd.OpenForm "frmEditMessage" ...Else MsgBox("Blah blah blah, etc etc.")End IfI need to add something to the initial If statement like this:Code:Or (CurrentUser.isMemberOfGroup("Admins"))but I don't know the correct Access syntax for it.
Any help anyone can give me would be appreciated!
View 1 Replies
View Related
Jul 3, 2014
I need to add a DLookup to my Subreport.
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:
Code:
Me.Text255.QC_Along_Line_Processing_Subreport!Text255 = DLookup("[Along_line_spacing_%pass]", "Performance_Requirements_Defaults_Table")
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.
View 1 Replies
View Related
Oct 10, 2012
I have table with companies (accounts) and a table contacts (people working for the specific company.
Then among this contacts there are contacts - individuals not linked to any account.
How to relate tables contacts with accounts if some are linked and some not ?
View 4 Replies
View Related
Jan 19, 2015
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
[code].....
View 1 Replies
View Related
Jun 11, 2013
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"
[Code].....
View 14 Replies
View Related
Sep 27, 2013
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 = ""
[Code] ....
View 1 Replies
View Related
May 18, 2006
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
Thanks
Jim
View 3 Replies
View Related
Jan 5, 2014
I have a race league, I want to select the top 10 point scores for each member.
I have read the Allen Browne article (and many others) and tried many variations on his code but cannot get this working.
I face two issues
- The ORDER by clause has no effect, points are not sorted with largest first
- Access being unable to differentiate between scores with the same value and returning additional records. I have added an "Event" field to make the record unique, but this does not seem to work.
Query code is
SELECT qLeague.Member, qLeague.Event, qLeague.Points
FROM qLeague
WHERE qLeague.Points IN
(SELECT TOP 10 Points
FROM qLeague AS Dupe
WHERE Dupe.Points= qLeague.Points
ORDER BY Dupe.Member, Dupe.Points DESC
)
ORDER BY qLeague.Member ASC, qLeague.Points;
This returns more than 10 results per member:
Member Event Points
Alex Peters SDMC North Weald Sprint 3
Alex Peters HCAAC Debden May 3
Alex Peters GB/Harrow TAMS NW Sprint 4
Alex Peters HCAAC Debden Sprint 5
Alex Peters Llys y Fran Hillclimb 6
etc ....
View 10 Replies
View Related
Jun 8, 2012
Error: Compile error: Method or data member not found when create Update button
View 7 Replies
View Related
Sep 2, 2013
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
[Code] ....
View 2 Replies
View Related
Mar 12, 2014
Compile error: Method or data member not found
Code:
Option Compare Database
Option Explicit
Dim intItems As Integer
Dim strName() As String, datBirthDate() As Date, intAge() As Integer
Private Sub Form_Load()
intItems = Val(InputBox("How many names do you have?", "Name List"))
[Code] .....
View 8 Replies
View Related
Sep 19, 2014
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.
View 2 Replies
View Related
May 13, 2013
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.
MsgBox "First Value, " & Me.txt_FSNo
CurrentDb.Execute "INSERT INTO BackchargeLog (BC_FSNo, BC_FContract, BC_FPurchaseOrder, BC_FProjectArea, " & _
" BC_FTitle, BC_FDetailDescription, BC_FSupplierToBeCharged, BC_FSupToBeChargedNumber, BC_FSTBCContactName, BC_FSTBCContactNumber, " & _
" BC_FSTBCContactEmail, BC_FIncidentReportedDate, BC_FInitiatedDate, BC_FEstimateAvailable,
[Code] .....
View 7 Replies
View Related
Aug 11, 2006
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.
Do you guys know why I got this error?
Thanks
View 1 Replies
View Related
Oct 1, 2004
I am creating an form in a database and whenever one of my procedure's run it creates this error message:
The expression ON Load you entered as the event property setting produced the following error:
Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [event Procedure].
*There may have been an error evaluating the function, event, or macro.
An ideas?
View 7 Replies
View Related
Apr 29, 2005
I need some help on a database that is set up for work use.
It's rather large and I have no technicial knowledge of access whatsoever so an answer in plain english would be appreciated.
I have attached a picture of the screen that i am having the problem with. The blank fields contain peoples names and addresses. On this page i have to click on "update service user" on the first user, the database opens a seperate page and i enter a few details, then i click to go back to this screen.
When I return back to the screen, the scroll bar is at the top of the list. This is OK when I am doing the first few letters of the alphabet (the users are listed alphabetically) but when i have too use the scroll bar and choose the letters later down the list, then click to update then return to the screen and the scroll barr is not where i left it...ie: it's at the top.
So what I am asking is, is there a way of freezing this scroll bar so it will stay there even when i have navigated away from the screen to update each user?
If someone could answer me this query then I would be most grateful as it's quite time consuming for me to use the scroll bar and find the next person that i need to update.
View 2 Replies
View Related
Mar 15, 2006
Hi, looking for help big time!! I am a novice at using MS Access and struggling like hell. I have been set a project at University that requires me to import data from Excel, sort the data (i.e the data imported will be for a whole year and I am only interested in looking at single months), use calculations on the data imported and display this graphically. Is this possible with Access?? Any help will be gladly received as Im desperate.:(
View 1 Replies
View Related
