Need An Opinion For Best Way To Display Data

Jul 9, 2006

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?

View Replies

Opinion On Job Description

Apr 2, 2008

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.

View 7 Replies View Related

Best Methods- Need Opinion Or Two

Nov 10, 2006

hi,

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.

Thank you !!!

View 2 Replies View Related

Opinion On Design Idea/possibility

Aug 23, 2007

Hello Everyone

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?

I look forward to hearing from everyone on this.

Thank You

Jaz

View 2 Replies View Related

Opinion Needed On Table Structure

Nov 16, 2004

Hi everyone,

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 appreciate your effort for reading this.

Kind Regards,

Jean

View 2 Replies View Related

Need Opinion On Table Structure For Bowling Db

Apr 20, 2006

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.

D.J.

View 6 Replies View Related

Opinion Poll ~ Compact/Repair On Server

Aug 9, 2005

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?

Thank you all!

Andrew

View 2 Replies View Related

Need Your Opinion - Store/retrieve Word And Excel Files In Access 2003

Sep 4, 2007

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?

Your input is highly appreciated.

Shan.

View 10 Replies View Related

Forms :: Display Data In Form As Select Record In Subform In Data Sheet View

Nov 11, 2013

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

View 14 Replies View Related

Queries :: How To Retrieve Only Numeric Data From F1 And Display That Data In A Field

Oct 1, 2013

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?

View 3 Replies View Related

Forms :: Display Existing Data On Data Entry Form

Sep 28, 2014

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.

View 7 Replies View Related

Display Data

Nov 13, 2006

Hi,

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:

Customer----------------------Products
cust1--------------------------------apple------------------cereal-------------------salad
cust2--------------------------------photos-----------------bananas

I can change my tables to reflect product1...productn, but that will break database rules.

Any suggestions please?

Regards,
B

View 7 Replies View Related

Display Data

Dec 28, 2007

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

Thank you!

View 6 Replies View Related

Best Method To Display Data.

Jan 28, 2007

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. :)

Rob

View 2 Replies View Related

Display Rows With No Data

Aug 22, 2005

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.

View 5 Replies View Related

Altering Data Display

Mar 12, 2008

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.

View 6 Replies View Related

Display Data In A Control

Dec 5, 2005

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?

Thanks

View 1 Replies View Related

Combo Data Display

Feb 2, 2006

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.

View 6 Replies View Related

Display Tbl Data In A Form Using VBA

Feb 27, 2008

I want to display table data in an MS Access form (using a Text box or a grid) using VBA?

Any ideas or examples?

Kind Regards
Richard

View 1 Replies View Related

Display Message When No Data Is Found

Apr 11, 2006

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.

Any and all assistance is appreciated.

View 5 Replies View Related

Using PivotChart To Display Survey Data

Oct 31, 2007

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.

View 1 Replies View Related

Display A Message To Add Data To Corresponding Table Name

Aug 5, 2005

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

Please help?

View 2 Replies View Related

Query To Display Data That Does Not Match

Jun 12, 2006

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 hope that makes sense?

Any help would be fantastic!

Cheers
Phill

View 9 Replies View Related

Display Data From Two Tables In Query

Dec 19, 2006

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?!

Thanks in advance,

Gary

View 2 Replies View Related

How To Display Data From 3 Queries In A Form?

Aug 10, 2005

Hi all,

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!!!

Thanks in advance.

G.

View 1 Replies View Related

Change Display Data In Column

Dec 7, 2006

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

I want my form to show "CAT" or "DOG" not 92435.

How do I do that? thanks.

View 2 Replies View Related