By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

How to display System date and other data on a Form?

P: 15
Hi,



I have a form in which 3 fileds are displayed on the top banner. They are DATE, NAME, LOCATION.

1. I want to make DATE filed dynamic where it whould read system date and display on it when ever I open that Form. I don't know what control to take for this whether LABEL or TEXTBOX.



2. Name field should display the name of the person who logged into the system or it should display some name and when it is focused it should become a combo box from where I can select the other name.



3. Location filed also should work like above where default value should be displayed and when I click on it it should be editable. i.e. it should become combo box and should allow me to choose different option.



Is this possible? Can someone suggest any idea on how to implement this.

I tried doing it by keeping Labels intially but they were not editable.

Even if I use TextBoxes I am not getting any idea how to implement this.



Thanks,
May 17 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
You are asking for an awful lot of information here. However, I will try to give you some guidance to get you started. Then when you have gone as far as you can you can post another question to clarify the issue where you get stuck.

Hi,

I have a form in which 3 fileds are displayed on the top banner. They are DATE, NAME, LOCATION.

1. I want to make DATE filed dynamic where it whould read system date and display on it when ever I open that Form. I don't know what control to take for this whether LABEL or TEXTBOX.
User a textbox and set the Control source of the textbox to

Expand|Select|Wrap|Line Numbers
  1. =Now()
2. Name field should display the name of the person who logged into the system or it should display some name and when it is focused it should become a combo box from where I can select the other name.
There are two issues here. You need to create a combobox of all the users.

You don't say how your users are logging in. Is there a table of user names? Are you using their NT log in or are you using Access Users workgroup? Clarify these questions and then post a new question about how to retrieve the name of the currently logged in user.

Once you have this name you can set the combobox to this name in the forms On open event.

3. Location filed also should work like above where default value should be displayed and when I click on it it should be editable. i.e. it should become combo box and should allow me to choose different option.
Again you need to create a combobox of all the possible locations. Is there a way of finding that location based on the user login or do you just want the user to be able to select.
May 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.