I have a form that displays minutes. When the minutes are 9 or less it displays as, e.g. 9 instead of 09.
How do I get that leading zero to display?
I read in previous posts that one way was to format as text or date, but I don't want to do that bc the minutes are added up on form save/close. :confused:
How do I display only the largest or smallest value in the query result?
Thanks
HELP
I have a point system. What I want it to do is, when the points field reaches 55 I need for the Congrats field to display “Congratulations you are now eligible to advance to the next peer group”
I have a Yes/No field in my table - I would like to display the words in a report instead of the checkmark. How would I display this in a query or report?
View 1 Replies View RelatedHi I really have a problem in MS access.
I created a combo box which as 2 columns, eg Plant ID and Plant name
I need to have the Plant ID on the left and Plant Name on the right which it is at them moment, however....
When I choose an option inthe combo box, it will display the Plant ID number in the textbox because it is on left (its the 1st column in the drop down box)
.... I want it to show the plant name instead, but still have the plant id colun on the left and plant name onthe right when i click the arrow of the drop down box,
sry if its confusing, i need an anwser ASAP, thanks!
Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.
Ta
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
Hello All,
I have set up security my users. What I am wanting to do is when the record has been modified or changed it displays the user that is signed in as making the change. I have Time and Date set up this way. How can I have the user displayed as well.
Thanks,:D
I would like to eventually creat a chart report with information I have in a query. My problem is that I cannt get the correct information in my query. I want a user to input three begin and end dates and I want the appropriate information displayed in my query.
View 5 Replies View RelatedHi,
I have a field in my query that displays the occupation of an employee. I have another field with an "if" expression, which displays the occupation if certain criteria is met. However, it displays the occupation ID and not the name.
The occupation ID is an autonumber, but I just want to see the name.
Is there an easy way to do this
Hi I was just wondering whether there was a way to display results of a query in a listbox form or similar.
Thanks
I have a query which based on some fields on a form should display a set of records. In case when the user doesn't specify anything in the combobox on the form (value=NULL) I want the query to display all the records (like "*"). For some reason when i put the following in the criteria of the query it returns 0 records instead of displaying all:
IIf(IsNull([Forms]![frmClassReport].[ClassName]),(([tblClassesOffered].[Course]) Like "*"),[Forms]![frmClassReport].[ClassName])
I tried: IIf(IsNull([Forms]![frmClassReport].[ClassName]),"class_name",[Forms]![frmClassReport].[ClassName])
... and that works properly. I tried several scenarios and pretty much narrowed the problem down to the use of "LIKE" which when used as specified in the first SQL statement doesn't return any records. What am I doing wrong?
Hi, I am doing a project at school and need to run a query that displays everyone that has a date of birth within 7 days using a date in the format 01/01/2001. I really have no idea how to do this and would really appreciate any help.
Thank you very much
Kris
Dear friends
How could I get top 50 records from a table?
have a nice day
JB
Afternoon All,
Right then.....i have a query which I use to search the database, users click a command button to open up the query and then are prompted to enter the parameter value. The results are then displayed in a form - what I want to do is to display the search term used at the top of the form.
I'm not sure that this is possible and if not, would my best bet be to use a text box on the form and refer to that in the search query?
rgds,
I have just taken over an access database written by someone else. I am being asked to write some customized reports that will be extracted to excel and passed around to the team.
The database is used to track employee assignments and show us who is available and what percentage they are assigned to a task. The current report shows their percentage of assignments by month. The current column headers in the table are Month1, Month2, Month3, etc.
In the report I am creating, I would like to write it so that it pulls data based on criteria I give, but I want the columns to show Month1 as the current month, and Month2 as next month, etc. So instead of Month1, Month2, Month3... I will have September, October, November.
I cant seem to figure out how to calculate the "display as" part. When I put the formula Format(Now(),"mmmm"), the formula appears as the column name, not the expected value.
Your help is most certainly appreciated.
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!
Hi All
My sub form appears to work fine most of the time.
But the records in the sub form (which is a datasheet) don't display when I apply a "filter by form" on the main form ?
Any clues as to what is wrong ?
I am a beginner - it could be something quite fundamental !
NoVoiceLeft
I am going to show some images
I have stored the links of photo in a table
how can I show the different pictures in a form at the same time?
I am using Microsoft Access 2000, I dont have very much knowledge with the program. I need to Seach By a Combo box, Contact name... Through the database and then Display only the information for that customer in the list box. I have been researching this for weeks now and I need Help. :confused: :confused: :confused: If anyone could help it would be great. Thanks. :)
View 5 Replies View RelatedHello eveyone.. I have a slight problem which goes way over my knowledge of the subject!
I have to make a form saying "ISLAND HORSE RACING CLUB" appear for 5 seconds before loading up the main form to add records but I cannot for the life of me figure out how to do it!!
anyone got any pointers? had a look at "timed events" on this forum but dont know how to implement it to help me
Any help would be appreciated
Regards
AaRrGgHh
i have a form and it always displays the first record as it opens.
i dont want it to display any records and be just blank.
i have tried the code on Form_load
for i = 1 to col.count
col.item(i)=""
next
i dont know whats wrong with this code.
please help
Sorry for apearing thick.
Ive only just started using access.
How do I list all queries in my database in a list box??
Many thanks for any help.
Richard
I found an earlier thread by Wazz that told how do display a lookup value
=DLookup("[surname]", "tblB", "[staffID] =" & Forms![frmA]!staffID)
but it did account for blanks or nulls or if a field (numeric) is zero/no value.. can you add to this? anyone?
This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a diary style listing. Any help would be greatly appreciated....
View 5 Replies View RelatedHi all
Quite busy these days but never too busy to visit this website.
I have a question.
I am busy create a "Logsheet" database. Where you enter all your trips done with your vehicle.
Trip;Date;Trip_From; Trip_To;Start_Km; End_KM;
I do have a textbox where get the Trip_distance.(End_Km-Start_Km)
Is it possible too display on the current form the previous page End_KM.
Previous Trip End_Km-123456 (Display from previous page)
Trip Start_Km-123456 End_KM-123466 Distance-10
Next Page End_Km-123466 (Display from previous page)
Trip Start_Km-123466 End_KM-123486 Distance-20
I tried to do this but it came out only in a mess..