Hover effect on data in text fields
It is fields on a form showing recipes on specific products (coatings), and at the time i started making the form, I didn't anticipate that some of the individual ingredients would have letters more than 14 letters. there is a simple solution... just extend the fields in width, but its not that easy because of the setup/design (there are approximately 100 fields on 7 different forms that are to be rearranged.. I thought perhaps some sql in the "textkontroltip", is that possible?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a text file in which records are updated say every 3 hours. Fields in this text file are separated by commas. I am importing these fields into MS Access 2007 using the external data text file mode.
I am able to import all the fields for the first time but when the text file is getting updated, the Access file also needs to get updated.
My other question is I have this text file on my C: and this access file takes in the data from the text file using the external data. Now say if I want to achieve portability in other words if I transfer these files to any other computer is there any way that Access can look for this particular file to import data without connecting to it explicitly everytime.
if so, I believe the second one can be taken care of later too.
The command prompts open up reports, but they have to put certain criteria in text boxes for this run. There are that many different reports with different criteria its hard for users to remember everything. So I thought when they hover over the command prompt that opens report a little message appears to tell them which criteria needs to be entered.
I can use the OnMouseMove event to know when the mouse is over a control but not when the mouse leave.
are there any 3rd. party apps that can be used ?
The problem is that the text is not an actual hyperlink. After it's clicked, nothinghappens.
When I delete the imported hyperlink, and enter it manually, the hyperlink opens an email message and the address is inserted in the To: field.
Is it possible to create a custom smart tag to be filled with data from another table. I have seen the microsoft smart tag sdk to create custom smart tags, but I don't think I can do that procedure. A good example of what I need is on this forms site if you hover over the thread title a flyout box pops up to show you more information. These are the tables I have that have the information I am dealing with for this issue:
Task_ID (Text) Narrative(Text)
Task_ID (Text) Maint_Funct (Text) MOS_ID (Text) Quantity(Number) Time(Number) DateTime(datetime)
On a form,form1 I have a listbox Listbox1 that sorts the Task_ID's and I have it setup for one selection at a time. Would I on a Got Focus event place a
Select Task_ID, Maint_Funct, MOS_ID, Time FROM Site_Visits
WHERE Task_ID = form!Listbox1 ""
Then have it display in a flyout box.how?
If there is no functionality in Access 2007, then thats cool too, it would be nice to see is all
For example I entered the following data:
widht3 width10 width5
------- --------- -------
2 452 96
but it should store in table like
002 0000000452 00096