Reet, I have a problem i have been pondering over for the last hour or so and im not sure the best way to do this! Its slightly tricky to explain so bare with me!
So I've made a Software Licensing Database which tracks licenses etc.. Its based information provided by another company which handles all my companies data handling etc..
Ok so in this database it tracks all installs and compares them against licenses. But this 3rd party company doesnt make life easy and sporadically buy licenses thus there's are always licensing issues here and there.. hence wantign the db to keep track. However rather than having a simple 10 licenses, 10 intalls for abit of software, they have created an entity called a Delta which is hand-me-down licenses. i.e.
So as you can see the Delta is Licenses available for lower versions & editions of software. So where I get these reports on a figures basis my boss wants me to physically give each install a license. Thus thats me breaking down a number of License into a singular form and assigning it to a specific person. Which is all done thats easy enough my problem is Incorporating the delta for that piece of software. So above as you can see for Adobe Acrobat Pro 7 I can happily assign those 25 Licenses to 25 of the 93 people but I dont know how to reference the 50 Delta Licenses on Adobe Acrobat Pro 8 to the remaining 68 people.
Of course the example I have provided makes it seem not to difficult but you have to remember I have about 60 different versions of Adobe Acrobat, they have multiple editions (Pro, Standard, Corporate, blah blah...) Baisically I cannot see anyway of writing abit of VBA giving each bit of software a Hierachial order in which to refer to.
The best possible way of doing this I can see is creating an alternative table which I will have to manually go through the 23K bits of software and define which bits of software are higher up the foodchain & eligible for a 'Delta License'
I have a report with some text boxes on it. Sometimes the text in these boxes can be a very long string of characters (maybe a path to some folder). In this case I do not want the text box to grow. I just want the report to show me the right-hand side of this path and cut off the left. How do I do this when still aligning my text to the left?
I'm looking to build a product generator - so user will select from a series of combo box's (Bed, (could be 5000, 5100 etc) Plug,(could be A,B,C,D) Castor could be ZZ, AA, EE,etc) and a code will be generated. (i.e 5100CEE)
I can achieve this - but I've been thrown one of those balls that are curved. The end user also wants a picture of each part of the code to be outputed on the final order form - and here's where I'm struggling - as if I pull from my dumb form (with dumb combo box's) - I've nothing to link to - and if I link to a table, I get zillions of records.
Any advise, general direction, gratefully accepted.
Can someone take a look at the attached prgram and see where my error is:
From the control panel.....Click print invoice....enter 100 and then 1000.......for payment status I want to be able to either pull the "paid" invoices or "unpaid"..........I really dont understand why the tag request comment keeps poping up.......This is a program that I have taken and modified.....Tag rest number I do not beleive needs to be anymore.....
I have a database of equipment that is hired out. When the equipment is hired out the date is recorded and when it is returned the date is also recorded. That same piece of equipment may then be hired out again. What I want to be able to know is what equipment I still have in stock at the base. I have tried many different attempts of trying to get this to work but I don't seem to be having much success. Could someone please tell me how I can do this.
I am currently designing a stores management database similar to the Northwind database but alot less complicated. We dont need all stock price,sales price and order information. The objective of my database is to calculate stock on hand and have a alert if current stock levels are below a reorder level.
I have taken a begginers course on access and so far so good. Got my relationships sported and everything is working nicely apart from the stock on hand calculation.
What I have is a products form and inventory movement subform. I have a one to many relationship between the two and when you scroll through the products, the inventory movement is updated too. Great.
But now for the stock on hand calculation. I have inserted a formula into the header of the subform and it works fine, but when I do the same calculation on the form I either get a result that doesnt scroll over with each product or I get a #Error.
I'm stuck and have been working on this for a few weeks, if someone could help that would be great.
Thank you, Kerry. PS: see attached for description of relationships
I need a hand from your side with the following. The attached Excel workbook needs to be transformed into an Access 2003 database. It is a list of clients’cases represented by lawfirms and the amount of money that is involved. The case comes in under the ‘Aufstellung’ worksheet and can progress to a Claim or 2 different other Requests. Purpose of the database : 1.Fast entry of new cases 2.Easy look up of existing cases 3.Conform updating of existing cases (warning when a certain case number already exists) 4.Easy report running 5.Keep the entire history of updates, changes, deletions and processing to a Claim Tables : 1.Aufstellung 2.Claim Request 3.MB Request 4.MFA Request -Question 1 : In the tables you will see that several different appointment dates and hours for one case are listed in 1 cell. In order to keep the history of updates do I need to create a separate Appointments table ? How would I structure this then ? The unique identifier is the Case Number. But 5 columns (Columns E, F, G, H and K) are ellegible to be treated this way. Do I need to create 5 separate Appointments tables ? And how do link them ? -Question 2 : In order to split all the packed Appointments information in one cell I need to transfer the column to Word, replace the manual break by e.g. *, re-import the table in Excel and do text to columns ? So that each Case Number gets a number of columns accordingly to the number lines in the original cell ? Queries : 1.List all Failed cases per form 2.List all Open cases per form 3.List all Filed cases per form 4.List all New Date set by Authorities per form 5.List all No results per form 6.List all ABC per form
Forms : 1.Aufstellung 2.Claim Request 3.MB Request 4.MFA Request -Question 1 : How do I set up a check box in the Aufstellung form which, by checking off, will transfer the current record to the Claim Request form ? -Question 2 : How can I make a field to be a lookup field ? e.g. When typing a name, it will give a drop down list of existing names of the table and the possibility to type a new name which will be stored in the table ? -Question 3 : How do I make a pop-up warning message in the Austellung form when a certain case number exists already in the database ? And how do I block the case number field for duplicate entries ? Reports : 1.Aufstellung complete table 2.Claim request complete table 3.MB request complete table 4.MFA request complete table 5.List all Failed cases per Form and include count of Failed cases plus sum of the Main demand in Euro 6.List all Open cases per Form and include count of Failed cases plus sum of the Main demand in Euro 7.List all Filed cases per Form and include count of Failed cases plus sum of the Main demand in Euro 8.List all New Date set by Authorities per Form and include count of Failed cases plus sum of the Main demand in Euro 9.List all No results per Form (empties) and include count of Failed cases plus sum of the Main demand in Euro 10.List all ABC per Form and include count of Failed cases plus sum of the Main demand in Euro -Question 1 : How do I include a count of the records into the report ? -Question 2 : How do I include a sum of the Main demand in Euro into the report ?
Switchboard : 1.Make a new entry or update an existing one a.Aufstellung b.Claim request c.MB Request d.MFA request 2.Search a.Case Number b.Applicant’s Name c.Date d.Court record Number 3.Reports a.Failed case b.Open cases c.Filed cases d.New date set by Authorities cases e.ABC cases 4.History a.Export history table to Excel through e-mail b.Who updated the record and when ? -Question 1 : Do I need to create a switchboard at the very beginning of my database ? -Question 2 : A switchboard can only contain 8 buttons, how do I create a sub switchboard ? -Question 3 : How do I set up the user access tracking – who updated what when ?
2) table 'Issuance' (Part#,Qty issued, date issued)
How to calculate current stock on-hand?
*previously this report are using ms excel table. i just tried to convert into access since i will have a better view, will a separate form to fill up, will have a report to pull in(hopefully... current on hand )
You know how you get the form header/detail/footer sections on a form. Well, how can you make text appear down the side (ie so that it overlaps all of the header/detail/footer sections).
Take a look at my drawing, it will explain it better...
I have One table(and designed form from it) in which i have recording the daily transactions(it is like a daily book). Daily transactions took place like Purchase of items of Amount 45, sale=70, sold on account=100 etc.
What problem i am facing is: I would like to Add Cash In Hand amount and would like to show it on my form. When day end I would like to move remaining cash In Hand on separate column of that date. The next day i would like to take the previous Remaining Cash in Hand as Cash In Hand at Start for next date and so on.
I have been working on an Access Db for awhile and am very close to being ready to hand it over to the person who requested it. There will be one user and the db will reside on a desktop PC.
Here's my dillemma? How do I insure that the user will not have access to the tables? I'd hate for her to get curious and go in and "muck around" with the data. I have the db split and have logic to disable the "shiftkey bypass" on open. I plan to, also, convert the front-end mdb to a front-end mde. However, what do I do with the back-end (tables)? Is there a way to protect them?
I would like to keep the db split (front-end/back-end) so if modifications are required in the future (to the screens/reports/processing), I can just send her a new front-end (I have the 'relink' logic in place on initial launching of application).
If my make queries in the data base and the source data base is another .mdb and the table names in the other .mdb which would be used for the queries are the same as those in the data base where the queries would be made......does anyone see any problems with that in the area of corruption or similar.
The queries made would be indentical to their counterparts in the data base where they are made and would serve the same purpose.
It would be a toggle type of thing whereby the recordsources for the forms in question would be changed.
For what I want to do it works perfectly but I am not sure if there would be problems that would only surface with longer term use and varied conditions as opposed to some short term testing.
I have data from a survey with qualitative responses. For a single qualitative question, I moved the ID & responses into a new table and categorized the response according to a bucket/theme, where each column is a new bucket. I now have 10 columns. Each response is represented in 1 or more columns. I used an excel formula to copy the response data into the column itself.
Example:
A1 // B1// C1 // D1// E1//... L1 ID // Response // Cats // Dogs // Elephants //.... Column 10 1 // I like cats // I like cats //(null)//(null)// ... (null)// 2 // I like cats and dogs // I like cats and dogs // I like cats and dogs //(null)//..// 3 // etc.
However, now I'm realizing that Access always wants to show data for all records, or at most I can limit using a WHERE clause in my query.I want to use Access to generate this report:
1. Section 1: Show all responses from the Cats bucket where there is data 2. Section 2: Show all responses from the Dogs bucket where there is data 3. and so on
I know how to do summary values, and I know how to do filtering that apply across the whole report, but this seems like more advanced filtering, where I want to see selective details differently for each field.
First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.
So now I would like to add some more functionality to this existing project.
My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.
I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.
The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.
Second I haven’t figured out how to call up the customers information from just the account field.
I’ve googled this and haven’t found anything terribly helpful.
i would like in a form for a combo box to be able to select an item from a table and input relating information automatically into other boxes in the form..
I have 3 tables: Table 1 has product code and product description. Table 2 has invoice number company details, address etc. Table 3 has product code and product description qty and invoice number.. Table 3 relates to table 2 by the invoice number and table 3 product code looks up the product codes available in table 1 and also table 3 looks up the list of products descriptions in table 1 using the combo wizard. This means the wrong code can be put with wrong description. What i would like to know is how i select a product description and the product code in the form fills out automatically?? i hope this makes sense please helppppp!!
I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)
I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.
I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.
I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.
I would like to filter data from a table using a query (from an data input form). The objective is to output all results if input form field is empty and to output results higher or equal to the type in the field if field is not Null. The query code is as follows:
I am using Excel/VBA as a frontend and Access backend. The sheet2 stores the queue name and Queue number. We have to update the sheet1 from column L to column O by looking for the values from the Access table for the date selected from the comboboxes. Now In sheet 2 , it says Queue number and in actual in access table it is the combination of Type & Type1 & Type2. So we have to look for Type & Type1 & Type2 in the table and find out total Batches ,Total Envelopes,Total documents and total pages and then store the values in the ExcelSheet1 from column L to column O.
The following formulas will be used in the select statment:
Total Batches = count(BatchNo) for date selected Total Envelopes=sum(Envelopes) for date selected Total Documents=sum(Cases) for date selected Total Pages=sum(Pages) for date selected
I want a Text Box Query on my form to display the Status, Workshop, Time, Enrolled and Limit. The problem is these values come from two different tables and the Enrolled value comes from a single field that contains the different workshops.
What I mean is: In Table[Attendees] a row contains a customer's Number, First Name, Last Name, Workshop and Phone Number. The workshops vary for each customer so one row on the table could have John Doe attending Cover Letter Writing and the next row could have John Smith attending Resume Writing. What I want is to be able to count the different workshops within the Field[Workshop] and total them and then display the total in a Text Box Query. I have a Text Box Query set up displaying Status, Workshop, Time and Limit as these values all come from Table[Workshops].
So basically I need to Query to also display a result that is the Total for each workshop from Table[Attendees] and display the total for each workshop in a Query with data from Table[Workshops].
Here is a link to an Example Database [URL] ....
I'm trying to avoid putting things on different reports and the like because the people using this are basically computer illiterate and if they have to click a button (no matter how well labeled) they won't do it and the information might as well not exist.
And if there's a better way to do it, I'm all ears. The only thing is, I have to update these workshops month by month. Since they are dynamic, I want to avoid creating separate tables for each workshop.
i have a main form named(EMP) i have a subform named(SEMP)with EMPID i have an another form Named(SDetail) with EMPID i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field Subform SEMP in as datasheet view. i can open sdetail for selected records only
I have a database that I import data from an excel spreadsheet into multiple times daily. The table that this data is imported into has several key fields that if the data already exisits in the table, and I attempt to import data that is the same except for one or more of the key fields is different. At this time the database it creates a different record. I am trying to get the database to overwrite the data in the database.
My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.
My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....
As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.
My question is this: I have a table where I'm entering employees' hours worked. Basically, it's something like this:
ID WorkerNumberDateworkedTimeStartTimeEnded 121/2/201310:00:00 AM3:00:00 PM 221/3/20132:00:00 AM11:00:00 AM 321/4/201312:15:00 AM11:30:00 AM 421/5/201310:25:00 PM11:00:00 AM 531/2/201311:00:00 AM3:30:00 PM 631/3/201312:00:00 PM10:00:00 PM 731/10/20137:00:00 AM4:00:00 PM
I have a query that (easily) determines how many hours an employee has worked on any given day. What I can't figure out at all, is how to write a query that can figure out how much time an employee had off in between shifts.
Thus far I'm able to run a query that separates this main table into individual workers by their id numbers, but can't figure out how to determine time off between shifts - as the last hour worked one day, and the first hour worked the next day are on two different lines (they are two different table entries).