Seeking Much Help With Generating A Card Number From Another Field
Hi guys,
I need some help here and any would be muchly apprieciated.
I am building a database for a theme park fast pass system where a customer can book themselves a place on a ride at three session times a day.
Now my problem is, that I need to generate a card number. 5555 1946 as the first 8 digits (this always stays the same) and then the last 8 digits is the customer ID number, which is in the same table. So there are 16 digits in total.
Let me give you an example:
A new customer registers and are assigned a customer ID of 1000 0001. Therefore the Card Number for that customer must be 5555 1946 1000 0001.
I have used auto number for customer ID so when a new customer signs up, there ID is 1 more that highest already in te database.
Simple question really...but how is this done?
A million marks for someone who breaks it! Hehe
Thanks
View Complete Forum Thread with Replies
Related Forum Messages:
Generating Invoice Number
I have a small .mdb for invoicing. Till now I had to put invoice number, which had two parts, manually for the first part, for example 001 or 002 and automatically for the second part as Date part. So I had, for example 2006 or 2007. The complete number was, for example 001/2006 etc. The problem was New Year. Now, all previous invoices from 2006 have 2007 extension and the first parts are not starting form 001 but they continue.
View Replies !
Generating A Service Number Using VBA
Hi, I'm trying to make a database where a Date and a Service Number is entered into a form. I have 2 buttons, one to automatically enter the Current Date and the second to automatically enter the Service Number. The service number is incrimented by 1 each time and reset for every day. eg. Date Service Number January 1, 2005 1 January 1, 2005 2 January 1, 2005 3 January 2, 2005 1 January 2, 2005 2 January 5, 2005 1 January 5, 2005 2 I already have the button that enters the Current Date. However, I am having trouble with the second button. How can I code the button so that it searches the table for the Current Date and finds the record with the greatest service number for that date? After this is done, I want to create code that will automatically enter the next service number into the Service Number Textbox on the form. eg. Using the Example Table Above The date January 5, 2005 is entered into the Date Text Box and the Search Next Service Number button is pressed. The number '3' should show up in the Service Number Textbox Sorry if its hard to understand, but thanks anyways. I just realized that I placed this in the wrong forum, Sorry for the inconvenience.
View Replies !
Generating An Auto-number In A Report?
First off, can it be done? I'm using Microsoft Access 2007, I'm wanting to generate an auto-number on the report. Basically I have an OrderTable, a PartTable, and a PackingListTable. I have a report that shows all orders ready to be shipped. But I need the shipping report to have a packing list number. I want this number to be auto-generated, and I was hoping I could do this when the report is opened. Right now the report is generated through a query of orders that are ready to be shipped. Yet I can't figure out how to put an auto-generated packing number on the report.
View Replies !
Number Fields In Text To Number Field, Formula For Fiscal Year
Date of Birth (DOB) field etc. in one program are text - how do I make another file with the same data into number fields for Date of Birth field etc? When I copy data to file that has number fields the 09252004 is changed to 9252004. Can I get reports with the correct Date of Birth in them by moving data from text file to number file? There is data entered monthly in file and formula has been set up for January, February etc as ---quarter: Int(([month]-1)/3)+1. I would like formula for the fiscal year for April to be counted as month 1, May - month 2, June as month 3, July as month 4, August as month 5, Sept as month 6, October as month 7, Nov as month 8, Dec as month 9, Jan as month 10, Feb as month 11 and March as month 12. Thank you
View Replies !
Find The Lowest Number And Place The Number And Column Name Into In Field
I have a access table with 32 columns and 42,000 rows of numbers. I need to find the MIN number in the row and if the MIN number has duplicates then I need them all placed into another column by column name. Example: Starting file DEST,ORIGIN1,ORIGIN2,ORIGIN3,ORIGIN4, ETC 05512,3,2,4,2 ENDING table needed DEST,ORIGIN1,ORIGIN2,ORIGIN3,ORIGIN4, NEWCOLUMNname 05512,3,2,4,2,2 ORIGIN2 ORIGIN4 Where the new column name contains the MIN number in the row and all of the associated duplicates column names.
View Replies !
Seeking Assistance
Hi all, I am new here, I am never one to ask for help, but I am desperate to get some assistance and hoping someone may be able to help me. I have just basic knowledge of MS Access, but no where near the skills needed to acheive what I am needing. To explain, I am involved with a national memorial of all the Truck drivers who have been killed on our roads. I have a database in access, (near 1000 individuals and sadly growing) but wanting to create it into a form style. I also need to add a photograph of each deceased person and a second photograph of the plaque which they are on. Years ago I saw a form which I was impressed with, it looked so professional but never had the oportunity to investigate or disect it :) I am hoping sks who will enjoy the challenge may be able to assist me. more about the memorial can be seen at www.tarcuttamemorial.com Thanks Dianne
View Replies !
Seeking Advice
I read about your different topics/discussions but still have issues. The group I work for needs to track Customs entries, compile them for payment and make reports. They used to track the entries in Excel but they wish to do this in a Form = INVOICE TRACKING, be able to query and make reports. My Access knowledge is limited but I have created two tables and the above mentioned Form The main table= Invoice Tracking (as per the group request) as 37 fields. Starting at the 8th field, data is updated by the users on a daily basis. The source table = XLS 1127 as 7 fields and is refreshed and updated 2-3 times weekly by a live report on the Internet. Up to now, when I need to update the main table, I run an APPEND QUERY. Once this is done, I run a FIND DUPLICATE QUERY and I delete the duplicates manually because some of the first 7 fields will get updated this time or some other time and therefore it will create duplicates Entry Nbr in the Main table. Meanwhile the other 30 fields are populated by users with the information supplied by the invoices. Is there a macro or an expression that could be created to avoid the Query from selecting the duplicates randomly? I have a very basic knowledge of macros and VB but would it be possible to write something that would be like In record #1, IF the field 2 or 3 is empty than look at field 9 and others and if Not Null then get the data in the duplicate record #2, merge the information from the two records?? When the Main table will grow bigger, it will be too much time consuming to delete XXX duplicates and can cause errors. Thanks
View Replies !
Seeking Help On Extracting Letters From Name
Hi all: MS Access 2003. I have two text fields family_name and given_name I need to extract 1st, 2nd & 5th letter of family_name along with 2nd & 3rd letter of given_name to form a link_key field. If either name has insufficient letters the missing letter is replaced by the numeral 2. Does anybody know how to help me acheive this please!
View Replies !
Seeking Structure Advise
I have attached a database structure of a project I did last year (when I know nothing about Access) and have been using. I would like to rebuild it from the ground up. Scope: This is a Marketing Conference database...I have three tables: 1. District (One of our companies Branches) 2. Organization (The entity that is holding the event like CHW or Kaizer) 3. Detail (The detailed expenses of event for our company) Each District starts out the year with a budget amount and has to assign an Organization a part of that budget and the Detail table tracks the amount spent vs amount budgeted for that Organization. The budget amount is a lump sum but we track in detail as it is spent. Goal: The database I have now works fine but as I have been learning as I'm learning I realize it will not meet our future needs. I think I need to break the tables up (Normalize to 3NF) and there are cases where many Districts can have a shared budget resposiblity for one Organization. with many districts (many to many relationship) I am just not sure quite yet of how to go about this and wanted to get some feedback if possible. My General Starting Point: In the previous design I had treated the Organization and the event as one because each organization held the event. I think that needs to change... TblOrg: OrgID (Pk) DistrictID (FK part of m2m with District joins at TblJunct) EventID (FK to EventID) OrgName Other Stuff about Organization TblEvent EventID (PK) OrgID (FK to OrgID) EventDate SpentLodging SpentGolf Other stuff about the event TblDistrict DistID (PK) DistrictName BudgetAmount (this is one I'm not sure about) It's pretty rough right now but that's kind of where I am at. I have learned so much here and it's just a matter of putting it all together now. Thank you.
View Replies !
Seeking Advice On Many-to-Many Relationships
Hello, I am working on a database of translators. Each of these translators can have multiple Source Languages, and multiple Target Languages. I understand that I must use a many-to-many relationship, but as the Language fields for both Source and Target Languages comes from one table (tblLanguages), I am having difficulty conceptualizing how I can get the table relationship to produce the desired effect; i.e. having a datasubsheet for each translator with fields for each their Source and Target languages. My current table structure: tblTrans TransID (name and contact data) tblLINK_Language_Trans TransID LanguageID tblLanguages LanguageID I thought that maybe if I create a separate LINK table for each Source and Target Language, I might get the desired effect, but this was futile, as only one datasubsheet was shown. Any advice for a humble Access beginner would be GREATLY appreciated!!! Thanks! Blair
View Replies !
Seeking Advice / Direction / Programmer
Hello, Does anyone know of an off the shelf application I can purchase to allow users access to my Access database over the web? I have select data I want to allow my customers access to dynamically via the web. I am familiar with ASP however I am not at a level to develop something from the ground up. I have access to a Windows Server, an established database and a great desire to get this done. My vision is to have a daily upload of my back-end (for the sake of current data)to the web server for access via the ASP front end or whatever the case may be. I am sure to all who read this you understand what I am looking for. I will definitely entertain hiring someone to work with me on this project if need be. Best case scenario is someone has already done the work and I can just buy it... Thanks. Fen How
View Replies !
Seeking Assistance Of Access Developer For A Small Project
Hi all, I've read this forum for quite a while, but just now registered and this is my first post. It's full of great information and I really appreciate all I've learned! I'm looking to contract / hire an Access Developer for a small project. Essentially, it's taking a CSV file, importing it into Access, then exporting the data within certain parameters into an Excel spreadsheet. There are a few other small details that pertain to how the data is handled in the actual db itself, but that is the overall picture of the project. It's rather small, but is above my Access knowledge level. My most important goal is getting the DB functional, but then taking the finished product and breaking it down to learn from it. Please PM me if you're available to assist on this project. Have a great weekend!
View Replies !
Convert Text Field To Number Field In Query
As the title says, i have an identifier field which combines two codes eg. AAAAAA/1234. I am using a query to extract the number part, however when i try to link to another query it says 'type mismatch'. I assume that this is because the main query is based on a table where [ShipID] is numeric and the extracted data is based upon a underlying table where [PackageID] is a text field. Is there any way to get round this? Many thanks
View Replies !
Seeking Help Creating Catalog Database (text Descriptions >255 Char.)
I am looking to create a catalog database. It is to serve as a finished product warehouse, as well as a product development tool. There are a number of fields, most of which are straight-forward. One large problem I have is that the product descriptions are roughly 700 characters. Is there a way to have this information entered into Access and stored either in this database or elsewhere? Any help would be GREATLY appreciated.
View Replies !
Seeking Advice! Populating Fields Based On Other Entries In Table
Last week some very altruistic folks here helped me solve a many-to-many relationships quandry, and I am hoping that there may some others out there who can help with another question. I have a feeling this is simple, but I can't quite get my head around it, and have not been able to find it in the past forum threads, but.... I want to create a tblJobs that has information about our clients' Companies, as well as Contact. As there can be many Contacts for each Company, my current setup looks like this: tblContacts ContactID (Pkey) Name Lookup_to_qryCompanies_to_Contact(shows Contact's company) tblComanies CompanyID (Pkey) Company Name (Client info is included as embedded table based on qryCompanies_to_Contact) qryCompanies_to_Contact Company (from tblCompanies) Contact (from tblContacts) (one-to-many) In my new tblJobs, I would like to have a combo box in which I can input the company name, and then the next field will have another combo containing ONLY names of the contacts affiliated with the chosen company. (I will also eventually like to make a form that allows the same function, but am assuming that the process will be the same for updating the table trhough a form as it would be updating it directly). Thank you for any advice!! Blair Sly
View Replies !
Using A * (Wild Card) In Pop Up Box?
Is it possible to use a * (Wild Card) in a pop up box for a query? I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field My criteria in my search fieled is a follows: 05-May 06-June 07-July 08-August etc... As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data. Any help would be appreciated. Thanks, Scott
View Replies !
Fried Graphics Card. What Do I Do?
Hi, I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use. In order to retrieve the information from the harddisk, I got a cable between this computer and another one. This is my plan: When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this? second question: If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer? Fuga.
View Replies !
|
TRACKER
