Table Now Showing ID Instead Of Text
Dec 31, 2013
I've created a "table" with all my cases which includes date, hospital, surgeon, etc. The hospital and surgeon column have always shown the actual name in text (dropdown) and now all of a sudden, it's just showing the ID only. Now when I go to add a new case, I have to know the number instead of the dropdown just working and being able to select a hospital name, etc. I'm not sure how to get it back to showing the actual name instead of the id number associated with it.
View Replies
ADVERTISEMENT
Jun 2, 2006
I apologise in advance for my newbish question - I'm very green at Access. I'm trying to build a contact database for our company that lists Jobs done by customer.
I'll confess I "borrowed" the sample database provided with Access to help me out - which has worked well up until this issue.
The problem I am having is when I am working on our "Client Service History" form. (Basically the Workorders by Customer from the template - I can take a screen grab or something if it helps).
This form includes a sub-table which lists the WorkOrder ID by customer, the Date Entered, the Job Type, the Engineer and whether it was chargeable. The latter three options are choices controlled by combo boxes from the Workorders Form/Table. Where the status for "Chargeable" always comes up correctly, the Job Type and Engineer always show a number - which I presume is the ID of the label of each type - I.e. "5" refers to "Warranty Repair".
There are separate Data Tables for Engineers (EmployeeID) and Job Types (JobTypes). How do I get it to display each item correctly; as a summary of jobs done for each customer?
Any help would be particularly appreciated!!! :D
View 2 Replies
View Related
Jan 13, 2014
I have a report that is based on a query I have made. It currently shows the values as kept in the table. It is for a MAR sheet. Here is how it looks...
Breakfast 0
Lunch 0
Teatime 2
Bedtime 1
I want it to show blank for each 0 that is shown. I have tried an Iif statement to do this but it doesn't seem to work.
View 9 Replies
View Related
Aug 28, 2015
I have an unbound listbox "Needs", and in the onclick event have the following code which works great if I have more than one item selected, but if I only have one item selected, it does not put it in the text box "ServiceText".
Code:
Private Sub Needs_BeforeUpdate(Cancel As Integer)
On Error GoTo errHandler
Dim ctl As Control
Dim strStart As String, strEnd As String
Dim aryList As String
Dim varSelected As Variant
[code]....
View 4 Replies
View Related
Dec 13, 2007
To cut a long story short, i've got a union query that is a full outer join of 2 tables.
Anyway, the results i have got back needed formatting to no decimal places.
How do i do that?
I've tried leaving it as it is and formatting it in the report, but it still doesn't format and i can't total it up.
It's like it is showing as a text and not number.
Is there a way of converting the result to a number, particularly in a sql query.
View 2 Replies
View Related
Jan 4, 2007
Hi,
I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes.
For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box.
Thanks a bunch!
View 5 Replies
View Related
Jun 26, 2015
I have a report which when I open it by clicking the button in the form shows what looks like Chinese text in the memo field. To open the report the following is in the event properties for the referencing button
Code:
Private Sub cmdPrintSumReg_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
[Code] ...
When I open the same report from the reports menu on the left of the database it is just fine. But obviously it is showing information for all contracts and not the any one contract.
I haven't changed anything in the table that contains the memo field and this only started happening yesterday afternoon after using this db for over a year.
I found an earlier post in this forum with a similar problem but the only difference I see is that the user changed the field from a text to a memo. I haven't.
View 5 Replies
View Related
Aug 13, 2015
I have a people table; Ethnicity Table; Program Type Table; Attendance Table.
I enter the people into the people table then enter people into the attendance table with lookup for name from the people table and a lookup for program type from program type table and enter date attended. I then run a query on the attendance table to remove duplicates. I created a form from the attendance query there are 3 headers Program, Ethnicity, Name. but the program type comes up as the ID number and not the text name.
The Ethnicity did the same thing but when I added the Ethnicity from the people table to the ethnicity header it show up as the name and I hide the box with the number but when I add the program type from the program type table to the program header is changes the source of the report to the program type table and then nothing shows up. It did not do that when I added the ethnicity type from the ethnicity table to the ethnicity header.
View 1 Replies
View Related
Mar 14, 2013
I have an Access 2010 database with a memo field formatted for Rich Text.
I created a simple form. It accepts and shows paragraphs, i.e. I press Return and a new paragraph appears (with a blank line in between paragraphs).
I then created a report based on the same fields. In the memo field it shows the text entered in the form, but not the paragraph breaks. It just shows one big block of text without any paragraph breaks. I have looked for a field property in the report design and layout views that might affect how the text is displayed in the report but I cannot find one.
It is not much use if you can input paragraph breaks in a form but not see them in a report.
View 2 Replies
View Related
Nov 21, 2013
I'm having trouble with a new project I'm working on. The application is mainly going to be used to display data, which comes from a linked table. It has to be a linked table (in my opinion) because it's replaced once per week from a fresh data dump. For each of those records, though, there will be notes made in a local table named "Custom-Data". My trouble is displaying a mix of information from the linked table, "Roster", and "Custom-Data" because linked tables can't be assigned a primary key.
Essentially, when a record is pulled up, a bunch of data from "Roster" will be shown in addition to the comments from "Custom-Data".
View 2 Replies
View Related
Feb 11, 2012
When I have a 3rd table looking at the row source of the 2nd table, which is looking at the row source of the 1st table. I only get numbers.
Everything I have read so far points to using a query as a solution. However, the query I made is not updating the information from the 2nd table.
I have attached a few examples.
Attachment 6247
this below shows. I changed "Bakersfield-test1" in the original table. However, the query I made does not update, still showing "Bakersfield-test". When you click on the drop down, it shows the updated "Bakersfield-test1", but it does not repopulate my column with the updated info from the table.
Attachment 6248
View 4 Replies
View Related
Feb 20, 2007
Hi, I hope someone can help me. I have a database as thus:
Several tables ->appended together using 'union select' into a query called 'sheet1'-> information that is coded converted via linked tables in a query called 'sheet2'
'Sheet 2' looks completely fine - it works dandy but when I try and run a pivot table not all of the values in one column that should show don't even come up as an option.
The values that are missing on the pivot report do actually exist in the query that it is running from.
There are no filters on and Pivot tables work okay on the origional tables.
Has anyone had anything similar?
Help would be most appreciated,
Thanks,
Erica
View 1 Replies
View Related
Oct 6, 2006
hi.
i was wondering if anyone can help me with my problem.
im using a linked table to populate a report. the table is linked to an SQR output in a text file. one of the fields in the text file is a date in the format 31-Dec-2006.
when i create the link and set the format of the date field to date/time, it shows up as #Num! when i open up the table in Access and it does not show up at all in the report. can anyone explain why this is happening?
on the other hand, when i format the field as text in the table, it will show up both on the table and the report properly. will i be able to make a report filter if the format of the date field is text?
thanks
View 1 Replies
View Related
Mar 12, 2013
My form, which is linked to my employee's table wont show all the records.
I know this is a basic thing. I've checked that it's not set to data entry in properties. I don't know what else to do.
the record source maybe? However, It was a tabbed form (cause it contains quite a lot of data capture fields).
this problem has occurred ever since I split my database.
View 1 Replies
View Related
Apr 19, 2014
I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
View 1 Replies
View Related
Sep 19, 2005
I have a database which has one main form linked to a table which has 325 records in it. The problem is when you open the form it says there are only 324 records :confused:
I have gone through the table comparing the records with the form records, I found what I thought was the 'missing' record. But when I did a find on the form I managed to retrieve the record.
Can anyone help as I'm a bit baffled.
Thanks
S
View 6 Replies
View Related
Aug 7, 2012
I have a split database, a front for data entry and of course the back end with all the tables. I have created several Append queries to move records from one table to another (from Applicants to Students, once they are Accepted). The queries work - when I go into the tables and look, there's the data right where I told it to go. But when I open the Students input form (which draws from the destination table), the new data doesn't show up. I double-checked the destination table, and yes, the appended data is all there.
I tried running the simply query that populates the input form, and it doesn't show up in the simple query, either. I've tried Refreshing everything numerous times, tried updating the Linked Table Manager numerous times, opened and closed the program, and no dice - the data is in the table but never shows up in the simple query that populates the data input form. There's no filters on the simple query, so everything in the table should show up - but doesn't.
View 5 Replies
View Related
Dec 12, 2013
I am trying to run a query and for some reason its not showing the data from the table (its blank), this is a monthly reporting I do - last months query works perfectly.
Table: log and list
Here is the SQL
SELECT log.*, UL.langue, UL.version
FROM log, (SELECT list.id, list.[langue], list.version, list.no_joueur FROM list GROUP BY list.id, list.[langue], list.version, list.no_joueur) AS UL
WHERE (((log.id)=[UL].[id]) AND ((UL.no_joueur)<90000000));
Table has all the columns.
View 1 Replies
View Related
Jun 19, 2013
I am working with a database and existing query from my predecessor. The field in the query appears in both the database table and the query.when I run the query it doesn't appear. Is there a limit to the number of columns in a query I easily added a new column and moved a column,
View 9 Replies
View Related
Mar 26, 2015
I have three tables.
The first is my table of pupils which is linked to the second table: a list of awards and a score 1-5
My third table is the list of 10 awards.
My problem is that (in my report) I want to show all 10 awards for each pupil regardless of if they have achieved them. I'm struggling with the underlying query to always show all 10 awards.
So, little Johnny has achieved a score of 5 in two of the awards, however the report card will show blanks for the remaining awards on his report.
View 4 Replies
View Related
Feb 26, 2014
I have a database with 2 tables: tbl_Client and tbl_Orders
I would like to sum the total from the sold products and show them in the form in a text field called 'Total sales" the data from the table orders appear as a sub form in the main form Client.
It would be great to have for each client appear the total sales in the form, but I'm not able to find the formula for this so the table tbl_Orders field "TotalPrice" will be sumed.
View 14 Replies
View Related
Jul 9, 2015
I have an employee table(parent) and family (child)members table. I have a field in the Family table called employee which i have created the one(employee) to many (family relationship). When I add a new family member why does the employee id not show automatically show in family table. I have to add it manually.
View 6 Replies
View Related
Aug 30, 2005
Hi,
I am looking for Idea's of how to create a report.
Basically the report is a league table showing Month and YTD, this is the easy bit.
The part I need suggestions and guidance on:
The report also needs to show peoples movements in the league table i.e: whether they have moved up, down or not moved at all from the previous months position.
I was thinking of creating 2 tables: Current Month + Previous Month, in each table the persons position is indicated (an ascending record number is created throughout the table - not sure how to do this yet)
Then using code, lookup each persons position in previous month and write that position number against the persons UID and current position in current months table.
Am I on the right tracks or does someone have an easier solution?
Thanks in advance.
Darrell....
View 7 Replies
View Related
Dec 21, 2004
In a table I have three fields 1. City - which is a combo box linked to a query, 2. State - a text box, 3. postal Code - a text box
When i put them on a form I use the info selected in the City box to populate the info in the State and Postcal Code boxes.
The Control source for the city is SELECT tblPostcodes.ID, tblPostcodes.Pcode, tblPostcodes.Locality, tblPostcodes.State FROM tblPostcodes;
Then on the form i put the control source of the state box as =City.column(1) and Postal code as =City.column(3)
This works fine on the form- and the information is retained - but the datasheet view of the table does not record either the State or the Postcode data that was entered. Is this because I put the control source on the form and the table is not recognising it? if this is the case how do enter it from the table?? really confused...
View 2 Replies
View Related
Jul 15, 2014
When I add new records to the form and close the form, the tables are updated with the new records, but the new records don't show in the form (navigation).
View 14 Replies
View Related
Apr 9, 2014
I am a novice to Access and in order to get some training in my workplace I need to show how access can be applied to my role.
I have a table of information consisting of 3 fields:
Motor manufacturer
Model
Attachment (picture of particular car)
I want to have someone able to select the manufacturer and Model from Combo boxes and this will pull up the image associated with this model.
There are more than 1 model for each Motor manufacturer so you may have:
manufacturer Model
Ford Fiesta
Ford Mondeo
VW Beetle
VW Golf
Fiat 500
You must not be able to select the wrong model for manufacturer, i.e.
Ford 500
The images are currently saved onto the table as an attachment,
This may be wrong as well,
This may be a simple task to do, but hopefully I can get it running smoothly and show this is the right tool for the job.
View 3 Replies
View Related
