Please, please help as I’ve got a really urgent project to complete. If I don’t get it finished I’ll be out in the cold. I’m really struggling for time myself so I hope people here can help. Here’s the rub:
I got a list of recipients (names & addresses) each requiring a list of items (we have all the lists currently on bits of paper). The number of addresses and hence the number of lists runs into the millions so I need a big database. Will Access be able to do this?
We have all the stock in our warehouse in stock ready to pick. We use to hand make the stuff but now we just buy it in. So at some point I’m going to need a buying schedule (future development).
Contrary to popular belief we the deliveries to the recipients are over several deliveries (not one). What I need is a database that allows me to produce a schedule of which go on which delivery (essentially I do this by postcode/zip code). I need the schedule so the pickers know how to assemble each load. Also there’s a claus in the contract that say we have to have a delivery schedule for the guy doing the deliveries (the same guy – my boss – does all the deliveries). His missus is funny, she keeps saying to him “Look out for the rain dear”. Thankfully we never have to deal with returns so no issues there.
I there also a way to monitor which picker picks what because in the past some of them have been a bit crap and they should give themselves a kick up the backside.
I also need to produce a run of labels so that I can stick a label on each item saying give the name of who the item is for. Is this possible? It’s now joke having to write them all by hand.
One more thing. Some of the delivery points have been known to leave gifts when the delivery is made. We use to just accept the gifts and say nothing about it but now we need to record this as the tax man says because of the sheer number of gifts then this becomes benefit in kind and has to be declared. Thankfully the company vehicle is except from tax (at least for now).
I can’t offer any money for this. We’re a kind of charity. My deadline is 4˝ days and counting. I really hope yule all help with this because it’s really important and if it’s not done I’ll lose my job.
I haven’t got very far with this and I really haven’t got time to do it myself. If someone could send a sample database of how I should start, that would be great.
I created a form using a text boxes by using the field list icon and dragging the field I wanted to make into the text box onto the form. In the properties of that text box, under the format tab I set the format for "short date". Under the data tab in the properties of the text box I put in the control source this forumla =DateSerial(Year([Date of Service]),Month([Date of Service])+10,Day([Date of Service])). "Date of Service" on my form is the name of the source field it calculates from. What the forumla does is calculates from the date entered into my Service Date field and whatever date is in that field it adds 10 months to it. This field with this formula in it caluclates the date of my contacting the customer to setup an annual service for them. I also have another field that calculates the annual service date using the same formula only changing the +10 to +12.
When the Date of Service it entered the Contact Date field automatically adds 10 months to the date entered into the Date of Service field. Same of the Date of Next Service field only instead of 10 months it adds 12. So my formulas are correct. However when I go to my table I can not see any of the caluculated dates entered into the table. I can see it in the datasheet view of my form. My question is how do I create a query to pull only contacts dates from this form for a specific time frame? When I attempt to create a query I can only see table fields which do not contain the formulas for calculating the dates. Or can the fields that calculate the dates on my form be linked so the calculated dates are linked into the table and updated on the table when I update the form?
Keep in mind I am new to access so please give very detailed and specific instructions on a solution for this issue.
This is probably an easy criteria but I'm getting close to COB and I have to have it in today.
I have a DOB as (DD Mon YY 04 Jul 79) in which I need to create a column for thier age. Then I have to show all the people who are over 60 years old. I can't even get thier age to show correct. Any help. Thanks
I need to enter a number in the Life Skills Credits. The Earned field should continue to add what I enter in the Life Skills Credits, but I need the life Skills Credits to revert back to 0 (zero)
I have a form with a subform. The form is the date field. The subform are all the stores delivered to on that date. I need to have a command button to open an email with the current date showing and list all the stores with their delivery numbers next to it inside the email.
Not really sure how to word this as I'm not sure if I even understand. Basically I have been asked to set up a database logging distubances and need to display on the form 3 different dates (action by, monitoring period and date to close case) from the date the data is entered, depending on the disturbance chosen.
So if there was noise nuisance the action date would be 7 days, the monitoring period would be 14 days and the closing date would be 90 days. This would be different from, say dog fouling. When the user chooses the disturbance from the combo box I need the dates to reflect the deadlines for that disturbance.
I have entered the number of days to add onto the table containing the disturbances (ie 7, 14 etc) and know how to add these days onto the original date.
How do I make this happen depending on the disturbance selecting.:confused:
I have a form that pulls data from a table. Basically the form is just a postcard. I have our company name, address, PO Box, city, state and zip in the upper left corner. My fields in the center of the postcard tie back to a table that contains the contact companies name, street address, PO Box, city, state and zip. My question is this: How do you format the contact company, address, PO Box, city, state and zip so that it appears uniform when printed? Some of the contact companies will have a street address but not a PO Box. How can I have the form print so the PO Box does not leave that field blank and pulls up the city, state and zip into that empty space? Also if one company's city is shorter than another how can it be formatted to pull over the state to make it uniform?
Any help on this would be greatly appreciated. I am under heavy deadline to have this form corrected and working by the end of the week.
Thanks in advance, cnut1
Attempted to add the database but it would not upload for some reason. Will try again tomorrow. I am sure the way I am doing some things are not necessarily the best or easiest way since I am still learning Access. The form I am looking for help on is frmpostcardJanfrt.
I am trying to get a module set-up that will add a number of workdays (no weekends, no holidays) to a date that is mentioned in a form and put the resulting deadline date in another field on the same form (date or remaining days to deadline would be even better).
Now it gets a little tricky, the module will need to select different amounts of workdays to be added to the date in the form depending on what status is selected (different statusses have different amounts of days).
I'll probably need: List of holidays List of days required per status Start date (to which the days can be added).
Example:
Status = "DQ" which has 2 days to work with. Start date in form = "21/03/2014". Result = 25/03/2014 or preferably "2 days remaining".
Thanks to all who have provided help on other threads. I have made some progress but I am still struggling with the last couple of relationships here. I am tracking projects and have normalized this data into the following tables:
tbl_customers (contains customer specific information)
Is on the "one" side of a 1:many relationship to tbl_workorders. (1 customer for multiple WO's) Is on the "one" side of a 1:many relationship to tbl_locations (up to 2 locations per customer). Is on the "one" side of a 1:many relationship to tbl_circuits (up to x number of circuit ID's for each customer)
tbl_workorders (contains order specific information)
Is on the "one" side of a 1:many relationship to tbl_costs (multiple costs for each WO). Is on the "one" side of a 1:1 relationship to tbl_services (each WO can only have one row on the services table. I suppose I could combine all fields onto 1 table, but logically they represent different information. The WO table is about the work order and the other table deals with the customer's services.) Is on the "one" side of a 1:many relationship to tbl_contacts (can be multiple internal contacts for each WO)
tbl_dates (contains as many as 33 possible dates for each project)
This table is one that I am having trouble with. Each work order can have any of the possible dates on tbl_dates. I have designed tbl_dates to be as normalized as possible. You select a date type and enter the date. I can't figure out where to relate this to tbl_workorders without using the WO field. Perhaps I am designing this table incorrectly.
I have a database of employees, sales, products(Sky and Mobile Phone Contracts) and customers(Need to be common and shared between all products). ( A door-to-door marketing company)
Since each product requires different inputting tables, I have inserted all the required fields into the tblSales and then I want to run a query in order to select the needed fields and create a new Sale of a specific product.
However at the same time I want to create a new customer, assign the sale to an employee, select the commission ID that he is going to receive for the job... etc. Well as you can see the problem is that it is not letting me do it due to the fact that an entry is missing in the other table for that client or a client is not yet created for the sale. (Only one autonumber is assigned.)
What am I doing wrong?
Just in case you want to look at my mess... I have attached the DB :P
Hello, I have the following "range" table. I have a "txtBoxA" (numeric) and "txtBoxPrice". I have to look in the table for the corresponding range of "txtBoxA" and retrieve the VALUE for that range and store it in "txtBoxPrice"
LOW HIGH VALUE 1 500 40 501 1,000 70 1,001 2,500 90
Example: "txtBoxA" = 200 then the corresponding VALUE would be 40 and I would have to store 40 in "txtBoxPrice"
How would I do this?? I'm doing this in ACCESS Thank you
My school coursework database is on my memory stick, and i have just opened it, and all my forms, reports and marcos have gone. The file has gone from 12000kb to 10000kb, and a table MSysCompactError automatically created itself. How can i get it all back????? The last time i accessed the memory stick was on the school PC.
I'm developing a small Access 2003 application for a purchase service that includes managing informations about Suppliers, Customers, Carriers, and Orders. With the Orders issue, I'v created a form to enter all the informations about the order; customer, supplier, carrier, orderID, and a subform to enter the items with their quantity and unit price... I want to:
1- Add a botton in the form that opens a Word document; a Purchase Order, that includes all the information entered in the form. 2- Add a botton to send this document as an attachement from Access via Outlook.
I need a guide step by step to understand how it works in Access with examples if is it possible.
the scenario..... is i have a column, let say fieldx some of them have 10 characters that is 00000000a0 others are 8 characters 000000ao and i want the 8 char to be also 10 by adding additional 00? is this possible?
hi my problem is i need query code for Concatenate Column Values from Multiple Rows into a Single row with Access like this Last First Code ------- --------- ---- Lesand Danny 1 Lesand Danny 2 Lesand Danny 3 Benedi Eric 7 Benedi Eric 14
Result should look like:
Last First Codes ------- --------- ----- Lesand Danny 1,2,3 Benedi Eric 7,14
urgent help needed with creating a query please...
I have a table with AutoNumber as primary key. The second column is called ClassID and the third column is called TeacherID. I want to run a select query that finds all records where the ClassID column and TeacherID column match. Basically I want to find records where the fields are duplicated.
How do I do this either through Access query builder or SQL view?
Assume that Price of P1 changed to $40 in Feb. Now I want to calculate amount earned by selling P1 from Jan to March. Remember (For Jan the rate will be $20 and from Feb to March it will be $40) If I calculate manually it will be - 4*$20 + 10*$20 + 20*$40 + 10*$40
Hi guys, im doing a project now, where i have to estimate the service due of cars. For this i need to put a count down timer in one of my FORMS and also REPORTS(sorry about posting about reports in this section but i ddnt want to post twice :rolleyes: but will do if necessary)... i searched a LOT on google but couldnt find anythng..... if some1 could come up with something reasonable, it would be VERY VERY helpful...
Please try to make it before this friday plz if you can...
Hi i have imported an excel sheet in form as an OLEUnbound. The form is for registering product details and the excel sheet iam using for price calculations. But when i register a new product the sheet doesnt clear it shows the same values enterd as in the previous product and when i change them the same thing happens with the previous products. I want to use the same sheet with the calculation differently for all product.B`cus the products doesnt have same price. Any help. I want to use that one sheet instead of making one own sheet for every products. Use the sheet as an mal or something like that.
Plz help.. :confused: i have included a picture of my form. when i should register a new product the sheet should be linked for that product only.
Hy, I’ve got problem that drives me crazy. i have form with two combo boxes and text field which shows value from table based on a criteria from those combo boxes.
Can i use Dlookup function with more than one criteria like
I also know how to make a querry in VBA that gives me correct value but i don't know how to put that value(which is currency) in textbox Or is there other way to solve this problem and get correct value Thanks for any help
i need help with a basic problem. Is it possible to link a listbox and a calander, My Main aim is to get a booking board for a hotel database, therefore i want it so that when you click on a particular date, the listbox displays all bookings on that date.
Also i need assistance with using queries for derived entities!! Please help
Hi i have a problem coming up with the ans to the last part of this text. Can anyone help me?
The information technology (IT) department in your school has asked you, a part-time employee at the department, to help create a database to track fundraising activities and donations in your school. In the past, the school’s fund-raising foundation has been manually maintaining detailed records of donors and fund-raising activities. The school’s president has recently asked the IT department to help computerize the foundation’s records. Your job is to design and implement the database for the foundation. The following information is captured in the manual records: 1. Individual_Donor name, address, email and phone number. 2. Company_Donor company name, company address, company email address company phone number, main contact, main contact phone number, main contact email and phone number 3. Amount of donation and date of donation 4. The donation can be a one-off donation or a monthly donation (interval of one month from the date of the first donation) 5. Name of fund-raising campaign (New building fund, President fund, Scholarship fund, Bursary fund, Star fund) 1. Draw the ERD and database schemas for the donor database that you will design for the foundation. Decompose the ERD where necessary. You can make any assumptions that are reasonable for the design. Make sure to suggest attributes that should be included but are currently not in the manual system. …………………………………………………………(5 marks) 2. Implement the ERD in Access. Design the tables for the donor database. If the NRIC number of the individual donor is not available right now, what is an appropriate primary key for the individual donor? Populate your database donor with records. ……………………………… ...................(3 marks) 3. Create an input form(s) for the donor database. In your design of the input form(s), create (a) an input mask for a control and (b) a validation rule for a control……………………………………………………(4 marks) 4. Create a report that lists the donations in the order of descending amount of donations. Put in the appropriate donation details. Separate individual donations from company donations. Aggregate the donations for each category………………………………………………………..(2 marks) 5. Perform the following queries on your database. a. What is the largest amount of total donations received over a single month period (first of the month till end of the month) for 2005? b. Which are the company donors that donated on a monthly basis and how much are the donations? c. List the details of individual donors that donated to the New Building and state how much they are donating to the fund and on what dates.
