I have 2 controls, a textbox and combo box. I want to prevent users from entering anything other than number integers on the textbox and only strings on the combo box.I want codes that will prevent users by customized msgbox instead of default access error message. I am using ms Access 2010.
View Repliescreate 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 RelatedI 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)
I am working on a database at the moment to try and find the customer that has spent the most money. At the moment i can only get the customers that have placed the most orders. I have a dispatch table that consists of all the orders and a customer table that are linked using a Customer Number. Each order has a dispatch number because one customer can buy more than one product per order. Like i said at the start I'm trying to find the customer that has spent the most money but the top 10 would be better.
View 7 Replies View RelatedI am using access 2010 and have the following question?
I have 2 tables, 1 called UKFile and the other Customers with the following fields
[UKFILE] THIS IS WHERE ADDRESS DETAILS ARE STORED
POSTCODEID
POSTCODE
STREET
TOWN
[CUSTOMERS]
CUSTOMERNAME
POSTCODE
STREET
TOWN
CONTACTNAME
TELEPHONE
How do I link these so that when I enter the customers postcode it grabs the data from the UKFile table.
Should I change structure at this early stage,
I am in the process of creating a DB for customer names, job numbers and document numbers, but have run into a problem right from the start.We are using a naming convention of the first 3 letters of the customer name, and 3 numbers after that. Eg. Customer names Allstar, Allpro would be All001 and All002 respectively.
The job numbers would then be sequential numbers, for each customer. So the first job for Allstar would be All001-001 and so on.How do I get Access to check/create the customer ID's? And then how do I get Access to check for the next job number for each customer?I was able to do this in Excel with the following;
=LEFT(B12,3)&COUNTIF($B$3:B12,LEFT(B12,3)&"*") in one cell
=IF(B12="","",LEFT(D12,3)&TEXT(RIGHT(D12,1),"00")) in another to add the preceding zero's.
Obviosuly , Excel is not the best way of tracking customers, jobs, documents etc.
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 RelatedLet'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.
"Dynamically search multiple fields" using my own customer data.
I'd like to add in additional searches as what he has will let you do one search but I'd like to, in his example, search on vintage and state, or the like. I assume Id need two multi-searches for this.
Right now the data is in excel so I have a completely blank page to fill.
My current database creates an invoice per order. Until now that worked wonderful. Now i want to create an invoice per month per customer with multiple orders on the same database. So i will have to create a new table/query on the existing order table.
View 1 Replies View RelatedI have a client table.
I have a client product table for ski's
Each Client has 1 or more products (skis)
I have a Service Order table and form that I use a drop down control in the Service order to select the customer.In the Service Order Form a I have a continuous Subform for detailed service.
This is where I'm having the problem.In the detail subform I want to select from a drop down box the customers particular ski that I want to service. how to have only that one customers ski's to show up.
I am using Access 2007 and 2010. I would like a text box (or label) on a report to autofil using fixed text from a label on a different (closed) form.
View 8 Replies View RelatedI have a form that is displaying a subform (of which source is a query). I have got the data from one of the columns in the subform going into a text box (entered in the control source) however when the field is empty it comes with a #Error in the textbox.I want the textbox is display some text is the subform value is null.
View 11 Replies View RelatedIs there a way of searching a rich text box for any text which is highlighted and then deleting that text? I cannot find an answer to this anywhere..
View 2 Replies View RelatedI have a text box in a form (unbound) and when I go to add text into it, the text carries over from one record to another but I want it to be exclusively for that record.
View 8 Replies View RelatedHi,
I'm creating a db for customers and each customer can have many service orders.
In the customer form I have two buttons, one to create a new service order and one to open existing service orders.
Both buttons work as they are supposed to although I am doing this with custid, so both the customer and serviceorder tables have a field called custid and when the button is clicked to show existing service orders it matches both custid's and shows the corresponding records. However it onlt works at the moment with me manually entering the custid in the field in the serviceorder table. When a new service order is created I need the custid to be entered in both tables.
I hope this makes some sense, any help is grately appreciated!!
Hi,
I currently have a "customer" form (which displays client details from a table - name, address etc) I would like to add history comments for each customer.
Does anyone know how i would go about doing this.
I image i could press a button on the current "customer" form that will open a history form which after typing a comment would be displayed on the main "customer" form, with date, time and comment.
I would obviously be able to add lots of comments to each record.
i would be greatful for any kind of help
Regards
Chris
Currently my design consists of a table for customers and a table for suppliers. At first it seems logical. Or so I thought!
As my design is evloving I have noticed a problem. What if a supplier calls and says "I want to purchase a..." they then also become a customer!
Obvoius I know but do I leave the design (attached) as is or disolve the supplier table and then just add one field called [CustSupp] and have three options to choose from "Customer", "Supplier" or "Both"
I could then base any other forms like the [FrmCustomers] on a query that looks at the [CustSupp] field and has a Like "Customer" criteria
Whst is the best method. Any advice greatly received.
i cant do this.. its too long..
basically i have a job table and a person table..
jobid, job date, job details....
personid, personname, person details...
the job table needs to store who BOOKED the job, and who was the PASSENGER in the job.
i want to use the person ids in the job table..
im having trouble here with the whole relationships and forms..
i need my user to be able to simultaneously add a booker and a customer to the person table and assign them both to a job and i dont know the best way to do it..
a few rules
job1 can be
booked by person 1
have passenger as person 1
job 1 can be
booked by person 1
have passenger as person 2
also the booker and/or passenger may be unknown.. which is why i want to create an unknown person in the person table.. with id 1 for example.. and anytime the booker or passenger isnt known my user can just type in id 1
someone help me.
hi all,
first time posting so please excuse the newbness.
i need to create a customer database, which i would like to be able to generate invoices from, nothing fancy or complicated, just name, address phone number etc. with a button to put this detail into a template word .doc file.
i would also like to be able to import all names and addresses at the end of the year to send a christmas card maybe or promotional e-mail.
how difficult is this to do? i kinda remember doing something similar at school years ago but can't remember how i did it.
any help/information would be greatly appreciated.
thanks in advance
Hi There,
I have created this query and i want to return the top 5 suppliers per LOB. It is returning something but it is not the top 5. I want to limit only to return the top 5. Pls. help and thanks. See attached file.
Thanks in advance for any help with this situation.
I have a table that contains all my customer information. Name, address, phone etc. The primary key for the table is an account number I assign to each customer. I am trying to make a section on my form where it displays a list of each interaction I have with my customer. A date and an interaction or case number. I made a second table with the same account number as a primary key to link them.
I have a tabbed form, on the first tab is all the information from my first table (name, account number, address phone etc.) and on the second tab I want to display the interactions for only the customer who's account number appears on the first tab of the form.
I tried putting a subform under the second tab, when I scroll through to records on the first tab, the interaction records for that account number do not appear on the second tab subform.
Any idea of how to do this?
Thanks very much,
Siirous
I currently have four tables:Customer, Timepurchased, Ideas, and Projects. Is it possible to have a form or something that would allow me to choose a customer by their email address(which is the unique identifier in each one) and delete them completly from the db. Thank.s
View 1 Replies View RelatedHi, I am new to access and have just started to build our first database. We are an engineering company who sells automotive components. I have set up the database to process customer orders. Some of the products we sell are remanufactured and sold on an exchange basis. So, once a unit has been sold at some point in the future the customers original unit comes back to us to be remanufactured - but this is not the case with all products we sell.
The exchange units are booked in using a tracking number and then given a unique reference number. I want to create a database that enables me to book an order and be able to enter a courier tracking number for the old unit when a return is required. The tracking number is given to us by our couriers. I want my staff to be able to enter the tracking number and the original customer order to then appear, they then need to enter the unique number given to the return unit.
The problem I have with this is that the exchange unit is normally returned weeks after the original order was sent, and that not every product requires an exchange. Is there a simple way of dealing with this?
Any help is much appreciated
Thanks
Rebecca
I checked the sample DB section, but could not find what I am looking for: a anonymous customer satisfaction database. Just a shell I can build upon. Does anyone here have anything similar I might be able to use?
View 1 Replies View RelatedHi
I am new to Access and would like to learn by taking on small projects.
Does any body know any good tutorials for beginners that could show how to start a database for a list of customers or something similar?
I have looked at the ones that can be created with the Wizards but obviously this doesn't help you understand the mechanics.
I would like to learn the 'nuts and bolts' so that I can expand the database and create new ones the more advanced I become.
Any good suggestions would be appreciated.
Thanks