I've competed my Access Application...Finally! I spent 3 months developing it!
Now I've finished it! I want to put it in work.
I need someone to guide me step by step (Sorry I'm really get tired from searching :( ) how can I do to make my application working in a small network (5 computers) ???
I want that only 1 user (master) get the entire data; for exemple all the Orders placed from other users...
I searched for Split but I did't figure out how to create backend frontend?? and how to make difference between Front End Master and BackEnd?
i have a form, in which two of the controls on the form, are unbound image controls, which display linked images. Now i have a button, which when both images have been displayed successfully, i would like to set the enabled property of this button to true.
How can i detect, that an image has ended up linking and is now fully displayed ?
Im nearly finished creating my first real production database, its pretty exciting! Theres a few things that I need to accomplish to consider it 100% working and im wondering if anyone has any input on the following matters:
1) Users import their data via an excel spreadsheet. Its all done behind the scenes. One routine pulls in information about servers from an excel spreadsheet and after formatting it via queries, puts it in the main table. The spreadsheet in question starts with the servername cell. On the spreadsheet, the first row contains the name of the server, but the second and subsequent rows contain blank space in the servername column, but imply that the rest of the information is for the various connections associated with that server listed above... IE:
Column "ServerName" Row1: Server1 IP address Switch Etc Row2: <blank> IP address Switch Etc Row3: Server2 IP address Switch Etc Row4: <blank> IP address Switch Etc Row5: <blank> IP address Switch Etc Row6: Server3 IP address Switch Etc and so on and so on...
What im wondering, is if its possible to fill in the blank spots with the cell above the records that start blank? (to populate the record with its respective server). Any input on methods to accomplish this would be appreciated.
2) Is there a way to attach code to the different buttons on the record selector? For tracking purposes, everything that my users do is stored in a seperate table. The only thing I cant seem to track is when users enter a record via the main data entry form. Automated tasks are no problem, but I cant seem to find a method to attach code to, say, the next record button on the default record selector.
3) I have a few queries that collectively import data from excel. When I do this, I remove confirmation messages so that users dont have to click through a sea of 'OK's. Im wondering if theres a way to count how many records get pulled in from an import, seperate which were good and which were bad, and simply pop up a message box stating that X records were imported succesfully, and X were not due to whatever reason.
4) Is there a way to sort text as if it were a number? I have a few fields that need to be text format, but contain numbers most of the time. The sorts always put 1 above 10, 9, 8, 7, etc, and id like to either find a way to make a query that changes all single digit numbers to double digit numbers or simply sort it in a numerical format.
5) What considerations should I take into account when it comes to the amount of data that access 2003 databases can effectively store and use? Ive heard that access can effectively handle 32000 records or something to that effect. Over that, what will I be dealing with? Slow performance? A complete roadblock?
I realize that there are a lot of questions here, and by no means wish to have my work done for me. Id very greatly appreciate any feedback that anyone wishes to give 8) Even if you dont want to code routines for me, thats fine.. I actually enjoy figuring this stuff out on my own, and a simple nudge in the right direction would suffice.
I'm new to Access (2002) and have been trying to learn by reading books, posts, forums and practicing with models. I've set up a database for inventory, primarily to track the cost of goods sold as raw material costs change from month to month. So far I have tables for raw materials, container sizes, suppliers, and finished products. But I have a problem - in some cases a finished product is also a raw material, so cannot appear in both tables. (Let's say we make cookies and we make ice cream, and we also make ice cream with cookies on top as a third/separate finished product!) Should cookies have two records ('CookieFinished' and 'CookieRM') and can they be linked together so cost is determined before it's part of another? Is there a better way? Thanks in advance!
I have completed a db and am satisfied with the structure and forms. The object window is hidden when the database is opened, and the main entry form automatically opens for the user. This db will be in a network folder and several users will have access to it. I want people to be able to enter data and run reports, but not make any changes to the database itself, or accidentally delete the database file or some other change to the structure. What is the proper way to set up the folder rights and anything else associated with the previous question?
I have created a small form that hold a cube of 9 boxes on it. The idea is that it will act as a small icon that indicates the system is loading. (Purely cosmetic)
I have triggered the boxes to change colour on a loop when the form loads but the problem is that the loop function is being carried out before the form actually loads. How do I get the form to display first and then carry out the loops to change the colour of the shapes?
I have a Subroutine that is using CutePDF writer to create a PDF from a report, then attach it to a new message in outlook. The problem is the code runs too fast and it's looking for the file to attach before the file is created.
I'm getting Run-time error '-2147024894 (80070002)': Cannot find this file. Verify the path and file name are correct.
Yes, I know why I am getting the error, and yes I could use a loop timer, except it may be 5 seconds before the person finally clicks OK in CutePDF dialogue box, it may be 5 minutes or it may be 5 hours.
If I had a textbox [txtTotalDay] which its days/Time was in decimals and a start textbox [txtStartDate] and a start time and number of shifts the product can run how can I accomplish this?
We are creating a simple database to maintain driver license information for faculty, staff, and students who use cars from the university’s motor pool.
To do this, I have created two tables: tblDRIVER and tblLICENSE.
The fields in tblDRIVER are: pkfDriverIndex strLastName strFirstName strInitial strAddress1 strAddress2 strCity strState strZIP datBirthDate
The fields in tblLICENSE are: pkfUpdateIndex fkfDriverIndex datDateUpdated strState strLicNumber datExpirationDate ynViolations ynActive
Information about the driver is stored in tblDRIVER and the driver’s license information is stored in tblLICENSE. Periodically, we run a report that identifies drivers whose licenses are due to expire within a certain number of days. All this works fine.
My problem is that I am trying to create a lookup form that will load from a data entry form that will permit the Motor Pool Clerk to look up a driver by name and review the licensing information (which appears as a subform).
All this sort of works- I am using a combo box (based on a query) to look up a driver’s last name (which it does) and to populate all the driver’s information on the look-up form (including license information in a subform). Currently, the combo box locates the driver (including the unique index, last, and first names), and populates the form with first and last name but the rest of the information is not displayed on the look up form. Worse still, sometimes one driver’s last name matches up with the first name of the next driver listed in the table! This seems to happen only if a look up is attempted more than once. What gives.
I have an expression in one column of my query and It keeps returning a negative result and there are no negative numbers in the source data. Can anyone help. I just want to sum the sums the two IIf expressions, but its not working. Thanks
Other Qty: Sum(IIf([QSum]![ACCOUNT]=2 And [QSum]![ICUNIT]=95 And [QSum]![UNITS]="ITEM(S)",[QSum]![QUANT],Null)) Or Sum(IIf([QSum]![ACCOUNT]=2 And [QSum]![ICUNIT]=100 And [QSum]![UNITS]="ITEM(S)",[QSum]![QUANT],Null))
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.
