I have a table that contains 4 columns: index (w/ auto generating number), timestamp, current user, and notes. The notes column is a Memo data type and is used to capture free-form notes typed into a text box.
I would like to display all notes typed by a specific user and do it in a single control, preferably a text box. This way someone can look back over time and review all the notes they typed / added to this table. Is it possible to display multiple rows from a table in a single text box or do I need to use a list box?
I was contacted today by a staffing agency and was told that I looked like a good fit for a Data Analyst position. The agency and wanted some more information about my resume and wanted me to email them my references. Next step I would assume would be an interview.
I did want to post the responsibilities of the job and see if other DBAs thought it looked like entry level work. The only thing I know about the company is that they are automotive and pay is under 40K. I have been trying to break into IT for the past few months and this looks like a great opportunity. :) I appreciate your comments. -Jon
Scope of Work:
Provide analysis support for the following: reduction of engine warranty costs, improvement of field reliability, identification of root causes, and development of new data systems. Position also monitors and reports effectiveness of actions taken.
Perform data analyses in support of problem-solving teams and management decisions, to include identification of root causes, determination of population(s) affected, failure rate estimates and projections, and estimated warranty impact.
Play a supporting role in the development of new custom-built data systems aimed at informational support of warranty analysis and reducing the time and cost of doing business.
Maintain SQL Server and Access databases of supporting information for reliability analysis to include: warranty claim information, failure modes, product improvements.
Support maintenance of custom warranty analysis software (RAS); includes troubleshooting data issues, updating information tables, and checking validity of system data. Other Projects as assigned.
If I just want to display a relationship between two tables or more with a form and a subform, and I don't want the users to edit/delete/add the data - just view it. What is the best way - queries, bound forms etc? I created a form with a subform, but then ran into problems because I don't want them to be updated, only viewed.
I am looking to build and Overtime tracking form and have been pondering on the design of it. Here is my idea and not sure how I should go about doing it (straight forms and tables or queries). I would like to select my employees in a combobox and have their information autofill the remaining fields and/or add new ones. Additionally have fields that I can input any overtime occurred which would be stored in a seperate table but displayed in a sub-form in datasheet view. These fields that were just filled out with the overtime information would clear everytime the add record button is hit.
I know that sounds like alot and sure I can muddle my way through that part of it, the big question I have is do I need a seperate table for every employees overtime? Or is there code/query that can select the records of the selected employee and display the information that pertains just to them?
Has anyone come across or posess a sample database similar to this? If not can someone point me in the right direction for example code and tutorials?
Could someone please share their opinion with me on the following:
I have a database with a Table which stores People's details, e.g. ID, Name, Surname, ...., etc (e.g. tblPeople) .
Now I have people filling out a questionnaire, of which the results I want to save in an Access table. Each person will fill out this questionnaire only once. The number of fields I will need to accomodate the answers to questions asked, is around 120. For example, an answer to Question1 will appear in a field called Q1. I know that the limit for fields in a table are 255, and my total fields in tblPeople so far are about 20.
Should I keep Q1 and all other fields in the same table as tblPeople, or create another table to hold all answers and create a one-to-one relationship between tblPeople and tblQuestions&Answers ?
Can someone give me a tip, in particular if this will cause performance problems?
I have attached a word doc showing my table relationships. I would like an opinion on as to whether it is normalized correctly. It is for a bowling league that has 10 teams and 50 bowlers. The team names, lane assignments will change every year and the bowlers will be on a different team from season to season. Also the tblScores is set the way it is because some bowlers will show up late or injure themselves so because of the awards that are handed out at the end of the year for high scores, perfect attendance etc. this is how I thought it would work best. I wanted to make sure before I put all the bells and whistles in. Thanks in advance.
I realize that this issue has likely been beaten to death in past threads; my recent participation in one brought this issue to light.
Can I get a general feeling from participants concerning the dangers involved in the practice of compacting and repairing databases on a server? I greatly respect the advice I get from these forums, and those who give it, however there seems to be some disagreement between people on this issue.
If there is a danger of loosing records, why does this occur? Are there versions of Access where these problems are solved? Do you think that frequency of use, or volume of data have anything to do with the risks?
Folks I need your help; just wanted to get your opinions here.
I work in a small engineering group and we have lots of reference documents in word and excel which we typically use for any projects. Currently, all these files are stored in Lotus Notes database. Unfortunately, they are pulling the plug on Notes license starting this fall. Therefore, I have been asked to see if there is a way we can store these files in Access as a repository and query the database whenever we need some information.
In order to avoid the database size getting too big, my thought was to store the .xls/.doc files as an “OLE object” data type, keep the files in local hard drive and create a link in a form to give the user to retrieve the information.
Do any of you have any suggestion on what is the best way to handle this?
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
Background I have a query (Q1) that retrives data from a table (Table 1). One of the fields in Table (F1) contains both text and numeric data (ie: 24 eggs). I want to separate these values in Q1.
Questions How can i in Q1 retrive only numeric data from F1 and display that data i a field? How can i in Q1 retrive only text from F1 and display that data i a field?
My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.
i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.
What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.
I am using a query to print information about customers and products on a report; the query is returning something like this:
Customer---------------------Products cust1-------------------------------apple cust1-------------------------------cereal cust1-------------------------------salad cust2-------------------------------photos cust2-------------------------------bananas However, my client is wanting all the info about each customer displayed in list like this:
I have a table with 2 columns : ID Code 70010000220002A 70010000220002B 70010000220002C 70010000220019A 70010000220019B 70010000220045AAA 70010000220045BBB 70010000220045CC 70010000220045D 70010000220045E I need to present this info in this format. Can you help?
ID Code1 Code2 Code3 Code4 Code5 70010000220002ABC 70010000220019AB 70010000220045AAABBBCCDE
Hello. I am quite new to Access and even newer to this forum. So please be gentle...
My question is quite simple i think. I want to display one particular record.
I have a keyboard wedge barcode scanner.. so basically a quicker and easier way to input digits or letters into a field. I also have lots and lots of CD's DVD's which i want to track and list the contents of, by simply entering the cd/dvd's barcode number istead of having to insert into my pc and browse manually.. if possible searching within results would be good too.~ think of it as a supermarket style.. input number - output entire contents... there could be hundreds or even thousands of programs or music titles,images, videos or documents.. along with any associated data, (where it is stored, who borrowed it last etc)
Can anbody outline the basics for me to implement this? remember i am quite new to Access and databases in general.
Thanks in advance, and keep up the good work on/in this forum. :)
I have a query which is grouped by year, facility name, and billing type and needs to display several columns of aggregate values for each of these, e.g. count of cases, sum of cases reviewed, average length of stay, etc. It would look like this:
2003 ABC Hospital Billed DRG 123 22 6.5 2003 ABC Hospital Billed Per Diem 23 0 4.2 2003 DEF Hospital Billed DRG 456 120 12.3 2003 DEF Hospital Billed Per Diem 56 10 2.1
However, if a facility does not have any Per Diem billings for example, how can I generate a row for it anyway? I cannot use a crosstab since I have multiple different values to display. I tried the following union query:
SELECT YR,FacilityName,BilledDRG,NumberOfCases,AverageLen gthOfStay,CasesReviewed,CasesDenied,AvgOflos,[Billing Eligibility] FROM qryDistHIVCasesStatsDAC UNION SELECT YR,FacilityName,BilledDRG,0,0,0,0,0,null FROM qryDistHIVCasesStatsDACDRG UNION SELECT YR,FacilityName,BilledDRG,0,0,0,0,0,null FROM qryDistHIVCasesStatsDACPD ORDER BY YR, FacilityName, BilledDRG;
where qryDistHIVCasesStatsDAC is the original query,
qryDistHIVCasesStatsDACDRG shows the year, facility name, and "Billed DRG" qryDistHIVCasesStatsDACPD shows the year, facility name, and "Billed Per Diem"
but then I would get e.g. 2003 ABC Hospital Billed DRG 123 22 6.5 2003 ABC Hospital Billed DRG 0 0 0 2003 ABC Hospital Billed Per Diem 23 0 4.2 2003 ABC Hospital Billed Per Diem 0 0 0 2003 GHI Hospital Billed DRG 456 120 12.3 2003 GHI Hospital Billed DRG 0 0 0 2003 GHI Hospital Billed Per Diem 0 0 0
what I want is: 2003 ABC Hospital Billed DRG 123 22 6.5 2003 ABC Hospital Billed Per Diem 23 0 4.2 2003 GHI Hospital Billed DRG 456 120 12.3 2003 GHI Hospital Billed Per Diem 0 0 0
In other words, for each year, each facility should have a row "Billed DRG" and a row "Billed Per Diem" and only one row of each.
Thanks for your assistance. I hope I have explained this adequately.
I tried to revive an old post in the "General" section with this question, but it doesn't look like many people are looking at it. I figured it wouldn't upset the posting gods too much if I posted it here, since the the question is concerning queries.
I'm starting out with an excel sheet that looks like this:
Company Name..........Employee Jones Electric............Kyle Brown Jones Electric............Chris Ford Jones Electric............Matt Daniels
Is there a way for access to make it look like this?
Company Name..........Employee..........Employee 2..........Employee 3 Jones Electric............Kyle Brown........Chris Ford............Matt Daniels
Thanks a lot, guys. I'll be sure to link the old post to this one.
Hopefully a simple one that is eluding me at the moment. I have a control on a sub form that refers to a value on another subform. When I enter data in the controls subform it will display the correct answer. However, when I close the form and return to it later the control is blank and will only display the answer if I go into another field on the form and make a modification to the data. It seems that the control will only calculate on an after update event but I need it to be visible at all times when the form is open. I have tried requery on open and on load with no effect. Any thoughts out there?
I am fairly new to VBA, having done no fromal training. I have taught myself quite alot and I am pleased with how i am progressing. I am stuck though!
I am building a booking system for a friends business, all free of charge as I believe it's a good project to get experience in VBA.
The booking form has a 'Date' Combo box, 'Name' Combo box and a 'Time' Combo box. The 'Time' Combo box displays times in 10min intervals from 0600 to 2100, and this data is stored in a table called 'tblTimes'. I need to build a query that checks the main table 'tblBooking', for a selected date chosen in the 'Date' Combo box by the user, to see what times have been used up and thus only display, in the 'Time' Combo box, those times not yet used for that particular datedate.
I am sure, to some of you experts out there, that this is quite a simple query. I looki forward to your input.
I have a macro in the On No Data event of a report that displays a message when the item number a user requests does not exist in the table being queried.
Now I need to get the same functionality in a form. The form is based on a parameter query with only one criteria [Please enter item number]. The form opens in Edit mode when a valid item number is entered.
I see that there is no On No Data event for either forms or queries, so I'm stumped on how to proceed.
I have this pivot chart (please see attached screenshot) that I was hoping to use to display results of a survey that was conducted by our nonprofit organization. I have it filtering by a few demographics (age, gender, parental status), and then the results of a few other questions below it. My problem is that I'm not sure what results I'm looking at -- whether they're totals of all the responses, just the "true" responses, or...?
The survey asked questions similar to what you see in the field list. Each question is a column header in my table. Then the row headers are each respondent. The choices for answers were "true", "false", or nothing. So in all the cells, i entered t, f, or nothing accordingly.
I'm not sure if I'm not using the pivot chart correctly, or if I didn't design the table for the data correctly.
Hi, does anyone know how to create a query/or form that promts the user with a message box that says "enter table name", from this if the user types "A" then table A will be opened for the user to add data into or if the user types in "B" then table B will be opened for the user to add data into. Ideally I would like a form that opens (either form a or form b) that allows the user to enter the details into the corresponding table (a or b)
Tables A & B are both emty to start of with. The field names in both tables are: user_id, firstname, lastname, date
Hi, I have two tables of data, one is a customer information (membersdata) table and the other is information recived from a bank (bankdata). Each customer has a 'bank description' field in its membersdata table and the bankdata table also has field 'bank description'. The query I have at the moment gives me back the data that both tables have a matching 'bank description'. The query I want is one that will give me the data from the bankdata table that does not exist in the membersdata table. So simply put the query I want is the opposite of the one I made with the wizard.
I have a database which contains details of groups of students. Groups are assigned tutor(s) using a link table between the Groups table and a Tutors Table.
I want to create a query which shows each group with their tutor. If I add the three tables to the query I can correctly generate a list of groups with their tutors, but any group which hasn't got a tutor (i.e. where the Tutor column would be blank) doesn't feature in the results.
I want all groups to be listed, even if they haven't got a tutor. Is this possible? How?!
Wondering if anyone can help here? I am currently working on a form that needs to display data from 3 unique queries - a crosstab query and two standard queries (one has line by line data and another summary data) that do not have a common link.
What is the best way to do this? Would it be possible to display the results of each of these queries in a single form by creating 2 subforms from 2 of the queries and placing them in the form of the 3rd?
Any suggestions on how to combine the data from the 3 queries into the 1 form would be much appreciated!!!
i have a form that will have a column called [animalID] which is a 5 digit number. Only the first numer really matters. If the five digit code starts with a:
1,2,3,4 = cat. 5,6,7,8,9 = dog
example
animalID 29878 - cat 67424 - dog 47812 - cat 92435 - dog
