I have a column which is made up of two parts from the table as follows...
function area .... FINANCE
ID number ... 001, 002, 003 etc
combined together this will make my ID column which should look somehting likie this : FINANCE 001, MARKETING 002 etc
BUT
the problem is that now i need to import some existing data into the tables and it appears as though the existing data has repeating numbers for different function areas
I'm rather new to Access, and still learning. Right now, i have 2 tables:Employees (Firstname, Lastname, Dept, Start Date, Inactive (yes/no field), Inactive Date)MainData (tracks daily stats for each of the sales people in 3 depts)i have a form set up for each to input the required data. I also have 2 queries:Active Employees (filters out inactive employees; used for a dropdown menu of employees on the MainData form.MainDataTotals (totals the fields of MainData; Total Customers, Total Sold, etc)What I'd like to do is set up a form to generate a report of the overall totals of all the sales people, totals for the separate depts, and totals for the company. I have the form designed already, and it works, but i do not know how to set it up so i can filter by chosen date. I want to be able to choose which dates the report will cover off of a form. For example, a dropdown menu with the months listed, and have the report only show the totals for that month. I will only need monthly and yearly reports. I have searched extensively for this, even on these forums, i cannot find the answer to my question or enough info to figure it out.
hi guys. i am currently working on an human resources information system. i am currently using ms access 2003 and the report form looks like this:
the function of this form, is once a button is clicked, the appropriate report for that button will be generated and will automatically be viewed in ms excel. the problem is that i don't know the VBA code that will perform this function. i read books about access, but unfortunately i can't find the exact answer to my question. so, if anyone could give me some idea on where i can find sample codes for this function, i would very much appreciate it. thanks in advance.
As much as I would like to tell my boss he's insane I'd also like to keep my job. I know this is possible, but it sounds very complicated. Basically, I need a way to generate queries on the fly. This is geared towards someone who doesn't know SQL of course. I know basically what he's looking for, comparing sales over some period of time. However, he might want annual numbers, quarterly numbers, percentages, overages/shortages, and any kind of sales related query you can think of. The only way I figure I can do that is to have a form build the SQL statement, save the SQL statement as a query, then have him open the query. Is there another way I can do this without necessarily saving a query first?
Im trying to create a document register in Access 97 to create and track document numbers, for this i want to assign a 6 number unique id to each record starting at 000001 going up in order to 999999 which will form part of a unique docuement number ...i know this may be a really easy thing to do but can anyone tell me how?
I have this query: SELECT UNIT.Code, Rnd() AS Expr1 FROM UNIT;
The problem is that in the Expr1 field all the numbers are the same. I would like to have random numbers that are different for each record (generate new random number for each record)
hi guys. i am currently working on an human resources information system. i am currently using ms access 2003 and the report form looks like this:http://i114.photobucket.com/albums/n258/lushh_16/reports.jpgthe function of this form, is once a button is clicked, the appropriate report for that button will be generated and will automatically be viewed in ms excel. the problem is that i don't know the VBA code that will perform this function. i read books about access, but unfortunately i can't find the exact answer to my question. so, if anyone could give me some idea on where i can find sample codes for this function, i would very much appreciate it. thanks in advance.
Dont quite know if this is the right place to post this but here goes any way
Im creating a database where customers can submit a question, it centres around a form where a user enters various information such as initials, telephone number, and various selections from from down boxes.
I have placed a button at the bottom that saves the record, what i want is when that button is pressed for a box to pop up giving the user a unique reference number which is made up of the information they have entered, such as FIRSTINITIAL-LASTINITIAL-DATE-INCREMENTALNUMBER I want this number then to be stored along with the record so it can be searched for by this number.
I have done searches for similar questions but cant find one that matches what i want to do
my frist error message appears as soon as I create a new database. As soon as a I create the name and it opens the new database a message pops up that says "Error Loading DLL" does anyone know what this is? and will it create a problem for me?
Secondly, I have a database that will be used for employee Reviews so the fields I have are as follows: Key, Date, Time, Department, Employee, Topic, Explanation, and Supervisor. I want to be able to generate a report for each employee, however I am not sure how to use the wizard to create this. If anyone knows of some tutorials or report aids I'd love to get my hands on them!
I have a multi-layered question regarding setting up an access database for fluid samples sent in by a customer.
Ideal Setup: The database would prompt me for the Sample ID number which is a unique code we give to each sample. It would then prompt me for the customer name and if given an existing customer name it would pull up all the contact information for the customer. It would then prompt me for the machine ID# that the sample came from, from which it will pull up the data from 10 previous reports and place into the current report.
I would then input the current data for the sample after analyzing it. I then have an automated control to convert the report to a .pdf file and send it via outlook. It would also be nice if the report was uploaded onto a website that the customer could access, but this is a whole different issue.
Is this setup possible with Access 03 and if so is it even remotely possible for a newbie like me to create? Additionally, what would the time investment be for a project like this for a beginner? Are there any other more effecients ways or programs to accomplish this level of automation?
I have a database where my team will enter manual payment calculations into. Once entered, they will run and print the report for actual payment.
The report I have groups by payment type (see attached image of paymetn types) and then sub totals by group.
I need to somehow get these totals and use them to generate a gross payment. In the attached example, the gross would be the sum of worked hours + before tax allowance + after tax allowance. I'm not sure how I can do this in the group footer.
I am trying to automate the generation of a reference number incrementally by 1.
In my main table (tblBooking) I have my primary key field autBookingID which is an autonumber.
In another table (tblBookingStops) I have the primary key as autBookingStopsID as the autonumber and then numBookingID linked to the above table (tblBooking). I have another field called txtGPSID so this is the number I would like to automate.
So for example:
tblBooking: autBookingID: 1234 tblBookingStops:
[Code]....
I want to put the code that would populate the txtGPSID on a form in datasheet view and would like to put the code on the load event.
I want to input a number value in [field1], then i want [field2] to generate an auto number BUT i want it to increase based on [field1] THEN combine them into [field3] creating a unique SKU for every item I have.
EXAMPLE1: I will type in [field1]: "001234". [field2]will enter "000001" because it is the first occurrence of "001234" in [field1]. [Field3] will then have a value of "001234-00001" EXAMPLE2: I will type in [field1]: "002468". [field2]will enter "000001" because it is the first occurrence of "002468" in [field1]. [Field3] will then have a value of "002468-00001" EXAMPLE3: I will type in [field1]: "001234". [field2]will enter "000002" because it is the second occurrence of "001234" in [field1]. [Field3] will then have a value of "001234-00002"
I am in the process of development of a database and one of the functionality that I would like to achieve is a custom ID to become automatic on my 'ADD-CUSTOMER' form (e.g. CID0001 - CID0002) so on an so forth. From my research all I can see in access 2010 is a autonumber which cannot be altered (or at least i don't know how).
I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically. Iam doing this because the database has to be exported to a number of remote locations every after two weeks.
Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.
I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when entering the sub form, the main record gets saved automatically. First I added the following procedure
Private Sub Form_AfterInsert() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If
Private Sub cmdSave_Click() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If
However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen)
“DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert”
Now I moved the code to the “Form_BeforeUpdate” (still testing)
Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy
Our small newspaper needs to create a database of subscribers from which we can print labels in what the post office calls "Walk Sort" order, the order in which the mail carrier hand delivers the mail on his route. The number associated with a particular subscriber is not fixed because if another subscriber is added on that mail carriers route, it may fall between two existing entries. So the Walk Sort field needs to automatically renumber up or down when an entry is added or deleted. I will use that field to sort chronologically and print form feed labels. I've figured out a way to do this in Excel, but I think Access might be a better program to use for this database. My question is, can Access automatically renumber a Walk Sort field if I add or remove entries? If so, how do I set it up to do that? P.S. I haven't used Access for quite some time, and I wasn't very proficient with it then. :o
I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this?
i need to run a specific qry that runs from 5th to 5th of every month to show payments made between the dates. i dont want to fill anything in as these dates are set. can a qry be made to run and retrive the info between 5th of last month & 5th of current month automatically ( by the press of a button ) every month?
I am building an employee performance report database. Part of this report I need to integrate initial and midterm feedback dates. These dates are as such:
The initial is 30 days after supervision started or annual performance report completed The midterm is 120 after supervision started or annual performance report completed
I'd like to give the supervisor a set month for their feedback completions as a guidline. If they are a few days prior or after the "30 day or 120 day mark" it is not a big deal, so I am just wanting it to automatically calculate the month rather than a specific day. After a performance report is completed the intial and midterm feilds should automatically update to calculate the new feedback dates for the next year.
The most updated dates need to be available for supervisors to print on a master report on all their subordinates. No need to store older dates (unless the performance report has not been completed yet)
Pertinent Info:
Form: Perf_Report Table: Rater_tbl Field Name 1: Initial ::: (format = mmmm) Field Name 2: Midterm ::: (format = mmmm) Field Name 3: Date of Supervision ::: (format = dd mmm yyyy) Field Name 4: Report Completion ::: (format = dd mmm yyyy)
Please Could any one help out, i have this Database am building for students in a school, The attached WORLD file respresnt a query in the database. The Position in class and Position in level is suppose to grade the student automatically i.e 1st, 2nd, 3rd, 4th, 5th e.t.c. according to the score in a particular subject in their class and in the level.
I dont know how to go about this, am not even sure if this could be done using the query or i should do it using VBA on the report sheet that i generated from the query.
If any one has any idea on how to go about it please let me know it will be highly appreciated.
