RecordsetClone Problem On Northwind's Customer Phone List
Feb 16, 2006
When attempting to select a letter in a form copied from the Northwind's Customer Phone List Form, I am now getting an error message that says "The object doesn't contain the Automation object "RecordsetClone'".
I never had that problem before.
Appears to be something in the Option Group that has gone awry, but I cannot access the Visual Basics behind the Macro.
Is there a way to suppress this message? It does not appear to be a problem in bringing up the sought after page.
:confused: :confused: Please help!!
View Replies
ADVERTISEMENT
Mar 21, 2006
Hey guys, I have a question that I am hoping you can point me in the right direction on. Before I ask it, I am new to access. I have been looking at templates and reading and things on how to build a database. I have my tables setup, relationships I think are right and my form created. One of the things I am having trouble with is creating a drop down list to be able to pick a customer name for. I setup the combo box and have a customerID as the control source in the properties. I have the Row Source Type as table/query and the Row Source query setup so it takes the info from the customer table.
query:
field: customer.* name
table: customer customer
I think I am doing this the same way the templates have the properties but for some reason it won't allow me to pick from the list. It keeps saying "control can't be edited. It's bound to unknown field 'CustomerID'".
I attached my database. I hope it is clear enough that you might see what I have done wrong. Thanks in advance.
View 8 Replies
View Related
Apr 28, 2008
Hi all,
I have a data set such as:
CustomerIDCompanyNameSiteNameStrataIDRUID
4002Severn Trent Water LimitedFRANKLEY3~00074832
4003Severn Trent Water LimitedFRANKLEY3~00074831
I would like to only have 1 record of the Company name/ID with the RUIDs listed almost in one record something like...
CustomerIDCompanyNameSiteNameStrataIDRUID
4002Severn Trent Water LimitedFRANKLEY3~00074832, ~00074831
Can we do this in SQL? (Specifically and Append query)
Thanks for any suggestions.
View 3 Replies
View Related
Sep 11, 2013
Is there a way (via the form) to search for all the records that have the same customer name and have that list show up so the user can select the exact record s/he needs?
View 14 Replies
View Related
Jul 5, 2006
I need to keep a customer list and I need to update the email address of the existing customers in the customer list.
The customer list table called 'masterlist' and the table looks like this:
IDPhone CallerNameContactEmail
112345678Emily Office<blank>
287654321Emily Home<blank>
399536546Emily Mobile<blank>
4 75293924 Jack <j.k@mail.com>
The table contains email address of some of the existing customers, I have the same fields in this table, the table called 'Newemail'.
IDPhone CallerNameContact Email
112345678Emily Officec1@mail.com
287654321Emily Home<blank>
399536546Emily Mobilee1@mail.com
478954648Jenny <blank>
545454854Derek <blank>
645484542Kelvin k1@mail.com
How I can insert the email address from 'Newemail' into my existing customer list 'masterlist' i.e. contact email of ID 1 and 3 :confused: ? I would like to ignore ID 4-5 from the 'Newemail' table. And I would like to keep ID 4 from the 'masterlist' table.
Thanks!! :D
View 6 Replies
View Related
Sep 26, 2012
Let's say I have a list of customers. For each customer I have much more info on other lists (order list, personal info list, bank info list, and so on) - all are of course connected properly.
Now let's say a certain customer is no longer my customer, so I want to remove him from the customer-list. But, I want to move him to a different list - past-customers - so all the information that was related to that customer will remain so. In short, I want to remove from the customer-list without affecting the related data.
View 4 Replies
View Related
Jan 24, 2014
I am doing my project to create data base for Video Hire shop. Was allright so far; however hit the wall now.
I need to create query to list Hires(rentals) by customer age group. I have created query with the following fields: Customer ID, date (Date()), DOB field and calculating field: AgeGroup:Now()-[DOB]. When click to display data in AgeGroup field is displayed in days. How to set it up to display decades not number of days days?
View 1 Replies
View Related
Sep 7, 2012
create a check on a feild(customer id) of customer table in MS Access , as "Customer ID is of 8 characters, the first 4 are alphabets and the last 4 are digits"
View 6 Replies
View Related
Dec 11, 2013
I have a Table Sales - that lists customer and order information
Most of the customers are new - is there a way to populate Customer Name Table with a new entry each time a new customer is input into the Sales Tale
(Without having to add the custome to Customer Name Table - then going to Sales Order)
OR
Failing that - is there a way to use a list box that points to Customer Name Table (and if it doesn't find the one you want, will allow you toadd a new record) In the SAME form as you use to add to Sales Table.
So:
Date (textbox linking to form.Sales) Customer Name (List Box linking to form.CustomerName + adding the info to form.Sale)
View 6 Replies
View Related
Mar 25, 2005
Is Query of 'RecordsetClone' possible?
(.mdb database on desktop/laptop - single user - no servers)
I want to run an update query on a form's underlying query/filters in VB - i.e. the
RecordsetClone. I cannot use the query for the form as the fields used by the query have
been changed. Logically, what I need to do is below, in the code fragment.
Set rst = Me.RecordsetClone
Set qdf = dbs.CreateQueryDef("", "UPDATE rst SET rst.Checked = " & bool & " ;")
qdf.Execute
Microsoft Jet doesn't recognize 'rst' in the sql statement, and this fails.
Travis
View 4 Replies
View Related
Dec 24, 2011
I have a DB set up with a debtors table (Customers) and a Customer Contacts table, I was thinking of combining these two tables into one.Most of the Debtors are companies, but a few are actual people. With the current setup, i need to have both a debtor and a customer in two different tables, but with exactly the same data.
View 1 Replies
View Related
Feb 26, 2006
Having difficulty with executing the Recordsetclone property of my form.
Recordsource for 'frm_event' is based on a table, tbl_events.
On the Form's 'OnCurrent' event, I make a call to the function 'DisableEnable([Form])':
Public Function DisableEnable(frm As Form)
Dim rstClone As Recordset
Set rstClone = frm.RecordsetClone
Getting a 'Type mismatch' error when I try to create the RecordsetClone.
This is my first attempt at working with the RecordsetClone property.
Any help or guidance would be appreciated!
John
View 9 Replies
View Related
Aug 14, 2005
Hello
below is the code I am using to update multiple records on a sub form so that QtyReceived=QtyOrdered when you click the ReceiveButton, now my understanding of VBA is a little limited and the code I'm using won't work in my main form "frmReceiving" only in the subform "frmReceivingSubform" can anyone see what I'm doing wrong?
Private Sub ReceiveButton_Click()
Dim rs As DAO.Recordset
Set rs = Me.frmReceivingSubform.RecordsetClone
With rs
.MoveFirst
Do While Not .EOF
If rs("QtyReceived") = 0 Then
.Edit
rs("QtyReceived") = [QtyOrdered]
.Update
End If
.MoveNext
Loop
.Close
End With
Set rs = Nothing
End Sub
Thanks
View 3 Replies
View Related
Jun 24, 2007
I search a record with values that I am taken from form1 .
If i found the record i show it on the form2 else I add a new record to table with values that i am taken them form form.
this is my code:
Code: Dim stDocName As String Dim stLinkCriteria As String stDocName = "mainhazineh_m" DoCmd.OpenForm stDocName, , , stLinkCriteria Form_mainhazineh_m.mahp.Value = Form_mainform_m.Combo2.Value Form_mainhazineh_m.salp.Value = Form_mainform_m.Combo0.Value Form_mainhazineh_m.RecordsetClone.findfirst "[salp]= " & Form_mainform_m.Combo0.Value & " And [mahp]= " & Form_mainform_m.Combo2.Value & " And [shahrp]= '" & Form_mainform_m.Combo12.Value & "'" If Form_mainhazineh_m.RecordsetClone.RecordCount <> 0 And Form_mainhazineh_m.RecordsetClone.NoMatch = False Then Form_mainhazineh_m.RecordsetClone.edit Form_mainhazineh_m.RecordSelectors = True Form_mainhazineh_m.Bookmark = Form_mainhazineh_m.RecordsetClone.Bookmark Form_mainhazineh_m.RecordsetClone.Update Else Form_mainhazineh_m.RecordsetClone.AddNew Form_mainhazineh_m.mahp.Value = Form_mainform_m.Combo2.Value Form_mainhazineh_m.salp.Value = Form_mainform_m.Combo0.Value Form_mainhazineh_m.shahrp.Value = Form_mainform_m.Combo12.Value Form_mainhazineh_m.RecordsetClone.Update Form_mainhazineh_m.Bookmark = Form_mainhazineh_m.RecordsetClone.LastModified End If
my problem is that when i must add new record to db, it only change the first record of table with values that i make them red then add a new record that all fields of it is empty.
can anyone help me ?
View 1 Replies
View Related
Jul 3, 2005
A while back a colleague at work (who has since left my company) showed me an example of a graph within a Data Access Page in the Microsoft Northwind database. The Northwind database that I've downloaded doesn't contain such an example. Does anyone know of a Northwind DB with an exmaple of a graph embedded into a Data Access Page?
View 2 Replies
View Related
Oct 20, 2005
I am just wondering how good of an example Northwind is?
I have been playing with the database and noticed that the number of units in stock doesn't decrease after I have created an order. I am trying to build an inventory database and would like this feature.
Am I wasting my time with Northwind?
View 3 Replies
View Related
Nov 3, 2005
Hi
I am re-visiting access for the 1st time in a couple of years to develop a quotations system and I am just messing around at the moment with Northwind trying to work out how it all works.
I have come across a problem that is baffling me....
When displaying the order details table (referenced from products), the product ID is disoplayed in text form, not as a number. Whenever I try and do this with 2 similar tables using the query builder I always get just the other tables number. I have no idea what I'm doing wrong as every field, attribute, join etc seems to be just the same as the sample tables.
Please could someone help a duffer? :)
View 3 Replies
View Related
Aug 10, 2007
In the Northwind DB, there is a query of the "Ten Most Expensive Products"
After looking at it, I can't figure out where or how it knows to only pull the 10 highest price products. It's probably right in front of my nose...but it's making me crazy!
Thanks for any replies...
View 4 Replies
View Related
Feb 5, 2007
Wow! I just looked at the Access 2007 Northwind database sample and they have revamped it and given it some cool stuff. It is definitely not the "old" Northwind.
http://downloads.btlarson.com/AWF/screenshots/NW/NW1.png
http://downloads.btlarson.com/AWF/screenshots/NW/NW2.png
View 6 Replies
View Related
Sep 26, 2005
Hi There,
I want to synchronize 2 comboboxes (actually 3, but let's start with 2)
On a form I have 2 comboboxes:
- CompanyType (FK fkCompanyTypeID in table Contacts)
- Category (FK fkCompanyCategoryID in table Contacts)
Let's say we have companytype CT1 until CT10.
For CT1, CT2 & CT3 I want to choose a catagory, so the combobox must be 'enabled'.
For CT4 until CT10 the Catagory combobox must be disabled, so that I cannot choose a category value.
Actually I want to choose 2 catgories (2 comboboxes) for CT1 until CT3.
But I think that an explanation for the example above is sufficient for me.
Both comboboxes are filled by a Select Query, and the values are filled in a separate table. (Table CompanyType (PK pkCompanyTypeID) & Table CompanyCategory (PK pkCompanyCategoryID)).
Can someone please help me on this issue? :confused:
Thanks in advance for your reply,
Greets,
Quinten
View 7 Replies
View Related
Feb 5, 2008
Hi guys,
As you all know, in the Northwind sample database there are the Invoices and Invoices Filter query. The Invoices Filter query adds a criteria to select only items that belong to the current order. OrderID is integer.
However, if I change OrderID to Replication ID, it stops working.
Any idea how to make it work? Currently I work around this problem in my DB by adding a criteria to filter by Date and Customer ID, but IMO this is less than ideal.
View 8 Replies
View Related
Jan 9, 2006
Hi,
I have a problem with form design,
I want a form like in Northwind sample database: Summary of Sales by Year Report.
It use Sorting and Grouping for Footer that I can't find it in Form design.
Is it any other way to do it in Form design so I can get the same result like in Report design?.
The reason why I want it, because I want to control the size.
thankyou in advance for your help.
Gunawan.
View 2 Replies
View Related
Oct 23, 2006
hi Iam new to this can anyone help i want to be able to enter phone numbers the code that ive found only seems to allow me to enter first 3 numbers were actually the areA code has 4 can any one give me correct formula
View 5 Replies
View Related
Jul 2, 2005
What is the best way to setup a phone number field that will contain numbers from North America and Europe?
Is it just one field that is text and no input mask? :)
Any suggestions?
Thanks
View 1 Replies
View Related
Feb 17, 2008
Hi
I am trying to run some queries on a large customer file that has very poor data - particularly in the contact number fields.
If there are more than six "1"s, "9"s, or "0"s in the number, then we are planning to treat it as an invalid number and replace it with a null.
Any ideas about how to do this?
Noel
View 4 Replies
View Related
Mar 25, 2008
Hi
I am trying to work with a large table of customer data.
I know that there is a large number of invalid values.
I would like to run a make table query that would check the phone number against a table of known invalid numbers (e.g. 1234567, 11111111, 99999999, etc).
If the number exists on the invalid table, then I would like to replace it with a null value.
Regards
Noel
View 1 Replies
View Related
