Tables :: Possible To Give Written Answers A Number So They Can Be Graphed
Aug 12, 2013
At work I have been tasked with a few Access based problems and one of which is making one of their handwritten feedback forms be input on Access so then responses can be graphed and analysed.
Is it possible to give written answers a number so they can be graphed.
For example.
Question 1 - Give me an example questions?
Answers:
1. Yes
2. No
3. Unsure
So you can see how many have each one when you graph the results. As I have it created with foreign keys at the moment it is displaying the text when I do the queries.
Also... is it possible to make a button so an interactive pdf report can be sent to all the selected user's email addresses?
HI, this should be relatively simple, but for some reason I cannot figure it out.
I have a field titled "DEADLINE" - a user inputs a date in this field (the datatype for this filed id date/time)
What I want to do is, on the form create a text box which takes the deadline date - todays date to give me the number of days to the deadline date. Once the dealine date has passed I then want to turn the counter to Red to show it is overdue. If there is no dealine then I want the field to say something like "No Deadline Set"
I want to get remarks as like this i have a query which is showing the total of different fields suppose the total is 77 and I want to give a crietria field by name of net level which shall work like this ..
if the number is from 0 to 33 then then the result should be C-1 if from 33 to 40 then C-2 if from 41 to 50 then C-3 if from 51 to 60 then B-1 if from 61 to 70 then B-2 if from 71 to 80 then B-3 if from 81 to 90 then A-2 if from 91 to 100 the A-1
I have a program that brings in the upper and lower specs to a excel spreadsheet and then brings in the values from lab tests.
The program then uses the specs to determine if the value is in or out of spec and colors the value if it is out of spec.
My problem is that in one cell the upper spec that is brought in is 2.7 and it shows that on the spreadsheet but when you click the cell the true value stored there is something like "2.66990153". Since a test value of 2.7 is greater than that it colors it when it is in fact in spec.
I have stepped through the code and the spec value pulled from the table is coming in correctly at 2.7.
I have several forms that are set to open on a new record. I'm finding that while I'm working on the design of these forms I'm creating alot of blank records. This makes me think that when users start opening these forms, they may end up creating a lot of blank records as well. I think this is happening because there are controls on these forms that have default values set in them.
Is there a way that I can control how and when an actual new record is created from a form? I was considering using a particular field as a trigger, once it has a value, the record is created. If it is null, then the record is discarded. If I make a certain field a required field in the table, will that prevent a record from being created without an error message?
With the script in the form that is part of MS-Access. I wonder how do I access/call the written function that are in the DLL file I made. I appreciate your help on this one...
I have a form which displays some product details and a stock level. The subform below it allows entry of a quantity to issue and a control button to run a small macro, write a movement record to a stock movement table and then close the form. This works fine.
But the user can also cause the movement record to be written just by keying in a quantity and tabbing out. If this is done several times it writes several movement records and doesn't close the form. I want to ensure that record is only written when the command button is pressed.
Perhaps there is a more conventional or better way of achieving what I want but I can't think of it.
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.
My question is this: I am creating a database for a student survey. Some of the questions may have multiple answers. For instance, question 2 reads: "What location/time are you taking courses (select all that apply)"
and the possible answers are: 1)Daytime/Oakland 2)Evening/Oakland 3)Saturday College 4)BC
- Where a student could be taking classes at multiple locations or times. I am completely lost as to how to set this up. I have tried to set the properties for the field on the form to accept multiple responses, but of course, these do not save to the table and so it's completely useless.
I am in the process of creating a database in access to search for a persons name. However, the results will give many ansers. For example if I search for the srname 'jones' I get many names. I eed then to be able to select one of these jones's with the information relavent information.
It has many years since I have done this although i did have quite a good knowledge at the time. Plesae can you make any suggestions and answers as basic as possible !
Many thanks in advance http://forums.aspfree.com/newthread.php?do=newthread&f=18# Mad
I been trying to figure out how to do this for some time now. But nobody seems to be able to know the method. I have searched the message board and tried the techniques that were suggested but none of them seem to work effective. Here is the problem:
All I want is a 2 textboxes on a form that where a user can put in the parameters for a query. The users clicks on the generate report button and the report pulls the textboxes's data as the parameters data. Report opens and its done. Every time I try this I get the query still asking for the parameters. Is there a sample database that someone can point me to that is using this method for the parameters. The Microsoft website has nothing pertaining to this matter. Only reason I am trying to use this is to stop people from putting in the wrong parameter information and it would look better then that generic parameter box that pops up.
I just have a question, is there anyway to create a standalone ms access 2003 file. I want to be able to create a ms access db that has forms and certain reports.
I have a client who needs this ms access file to distributable to his clients (who can use it without having ms access file). Also he him self can make changes, to the forms, etc. Without any programming knowledge, change the look of the forms, add queries, etc. And be able to send the updated version of the ms access file to his cleint.
Can this be done? I have suggested using a vb frontend & and ms access as a backend, but he would have to pay someone to make changes, add reports, etc. And he wouldn't be able to do it him self becuase of lack of programming knowledge, he only has medium knowledgable of Ms Access.
I have an Access2007/SQL Server 2012 system with 20 users for an insurance company. The company does most of its business via a network of vehicle dealers around the country. If someone comes in to buy a motorcycle, boat, or recreational vehicle at a dealership they need insurance to take it home, and our dealers send the quotes to us.
The dealers, in turn, receive payment from us each month for their efforts. Some are paid a % commission on the premium, some are paid for each quote they send regardless of whether the policy actually sells or not, and some are paid a set amount per sold policy. (Yes, that is relevant information!)
We already have reports that tally the amounts due each dealer based on their payment scheme, but last month our bookkeeper had to write about 650 checks manually because the check writing is not automated. She'd look at the report, and then enter name, address, and amount (in digits and words) into Quick Books and print the checks from there, a horribly tedious process. I've been asked to print the checks from Access. Basically one click would print all 650 checks.
I've opted to use a Make Table query to move the commissioned dealers amounts to a single location, and then to run two append queries to add the records from those paid per quote and those paid per policy. At the end of the day, one table contains all the information necessary to print the checks...except one.
The check number.
I need a way to sequentially number each record in the new table with a user generated starting point, the first check number.
By the way, the check blanks are on standard letter sized paper, three to a page, with tear-off perforations to separate them, in case that information has any relevance.
I think the best way to accomplish this is from the report itself. I've created a blank field on each record for the check number, and what seems most logical is that the sequential number is generated on print and written back to the table, rather than just generating all the numbers at once. That way, should print ever be interrupted, it will be easy to take up where we left off.
I would like to know if there is any procedure to restrict/stop auto number increment for certain number of record count (say 50), then increment by 1 for next 50 records.
I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes answer in the fields it is looking at, it should separate each with a "," . This is a large text field, that could show as many as 10 Yes answers.
What is the best way to go about doing this? I use Access 2010
We sometimes make an error in entering a stock code and have to change the code.
Our main table is = Investments01_tbl Other tables that use the same stock codes from the above table are = Alerts_Stocks = Investments01_tbl_SubForm
The table = Investments01_tbl_SubForm = can contain the same stock code many times.How can we create a query that can be used to enable us to change the stock codes in the 3 tables at the same time?
I couldn't find a similar question already answered and I am stuck at home due to the blizzard here in Denver Colorado so I can't get any other resources to help. I am working on a select query where I am using two table's and another select query to pull information.
table HOLDINGS HASH CGAAP ADJUSTMENT TABLE: - BEGIN DATE - END DATE - SAP - ACCNTNUM - SUM VALUE
table SAP DETAIL TABLE: - Fiscal Year - Company Code - Account Number - SumofAmt CoCd currency - Cabinet
Currently the join properties include: from SAP DETAIL TABLE the Company Code and Account Number to the HOLDINGS HASH QUERY #3 SAP and ACCNTNUM, from HOLDINGS HASH QUERY #3 SAP and ACCNTNUM to the HOLDINGS HASH CGAAP ADJUSTMENT TABLE SAP and ACCNTNUM.
There are three things that I am trying to accomplish with this query. The first is pulling down the SAP and ACCNTNUM fields which works fine. The second is pulling down the SumOfAmt CoCd currency and SumOfSumOfAS_OF_BOOK_VALUE_4TH which matches the SAP and ACCNTNUM fields which works fine.
What I'm trying to do for the third is to only pull the SUM VALUE from the HOLDINGS HASH CGAAP ADJUSTMENT TABLE that matches the SAP and ACCNTNUM fields and also where the AS_OF_DATE from the HOLDINGS HASH QUERY #3 is between the BEGIN DATE and END DATE from the HOLDINGS HASH CGAAP ADJUSTMENT TABLE.
This query will then be the output for a report.
In order to accomplish the third task I have tried to complete a SELECT statement and a IIF statement that have not worked. I am sure the select statement would work but I just can't figure it out. Any help would be very very much appreciated.
I am using a template database that I downloaded from the Microsoft Access template website and have been modifying it and adding new forms and tables etc. I have used the forms wizard to create a number of new forms to edit a number of the tables. The forms are "split forms".I can't seem to get many of the forms to stay the size that I set them to! They seem to have a mind of their own and often when I think that I have sized them correctly, I then open the form and they display in full screen mode or larger!
I work at a Phamaceutical company in the US (based in London) and have a database that tracks atypical events. It has normally about 10 concurrent users and continually (once a week sometimes more sometimes less) corrupts. I have spent a lot of time validating the database writing the user requirements, functioanal and design specs as well as a 150 page IOPQ.
It is a split database with both front and back ends on a file server. I know this is not the best way to do it but the database is frequently updated with requests for new reports etc and I am not sure how to push down the front ends to all the use pcs. The database is about 40 mb.
I like the database. It is fully audit trailed and does what I need it to do, but the corruption thing is driving me batty. I have the jetutils with the viewer to see who is in the db (by pc name) and then I cross reference that to the person in the db and call them to get out. It is a real pain in the arse and I am just about ready to agree with the IT guys that Access is not a multi user database.
I am currently building a holiday planner for my employers and I would like to try and display the days of the year as rows and the staff as columns (Fields). When someone adds a new member of staff, I would like it to also add them to the calendar table as a new column and name the column the same as the individuals name. Is this possible using VBA or SQL string?
If anyone has a better idea as to how I can display the forthcoming holidays for a team I would really appreciate your comments.
Do i have to give a commit statement when i update tables in backend(insert, delete,update) from a form, say when user clicks submit, it takes the data in fields and inserts it into the table , but till now i never did that but i could see all data when i queried the table, but i am not sure if that would be right, if i have to give Commit, how do i do that using VBA?
