Topics Search

Hover effect on data in text fields

Hover effect on data in text fields
Views: 119
I need the hover effect on text fields on my main form. I cannot just use the "textcontroltip" because the hovertext must be the data written in the specific textfield.

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?
Sponsored Links:

Similar posts...


Hover over button - Message

Hover over button - Message Icon
Is there any way to make a small text box appear when you hover over a button with your mouse? For example, I have a button with the "duplicate record" picture on it, but I would like a text box, or anything of the sort, to appear with "Duplicate Record" when I hover over the button.

importing excel text data into access memo fields

importing excel text data into access memo fields Icon
I have an excel spreadsheet that contains text data, large text fields that I want to import into access; however, as you know, access limits text fields to 255 characters. Is there vbcoding to do this? I have tried changing the table fields in access to memo but this changes back to text as soon as the data is imported.

Import all Fields as Text

Import all Fields as Text Icon
I have about 30 text files with different number of fields. I am importing them with a script and I want to make sure all data is imported without data type errors (all files are comma deliminated without a field header). My solution is to import all fields as text. How can I accomplish this in VB? I created a import specification with a default of 150 fields all set to text but this did not work). I know one file has at least 70 fields, so I chose 150 to be on the safe side. Can this be accomplished?

message appears when hover over Command button

message appears when hover over Command button Icon
I would like it so when users hover over a command button a message appears.

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.

Hoover effect, is it possible ?

Hoover effect, is it possible ? Icon
is it possible to have Hover effect in Access ?
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 ?

Importing text data

Importing text data Icon
I have a problem with MS Access. It goes like this

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.

Imported data not recognizing email address hyperlinks

Imported data not recognizing email address hyperlinks Icon
I have a database that I import Excel data into. After importing, the email addresses do display as hyperlinks (the data type is hyperlink, and the text is blue with an underline), and they appear to act as a hyperlink - when I hover, the little pointing finger appears as I click the text.

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.

Flyoutbox on hover in Access?

Flyoutbox on hover in Access? Icon

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

If there is no functionality in Access 2007, then thats cool too, it would be nice to see is all

VBA Type Mismatch for link criteria

VBA Type Mismatch for link criteria Icon
I have the code below to open a pop-up form from within a form but whenever the code runs I get Run-time Error 13, Type Mismatch.Both the EnquiryCatergory and TenderRef fields are text fields as are the Descritpion and Tender fields so why would I get a ype Mismatch. Also when I debug the error and hover over each element I get the correct info shown i.e. Me![Description] = "Paving" and Me![Tender] = "11N216".

leading 'Zeros' in data

leading 'Zeros' in data Icon
I have a table having different text field( about 12 fields). The data has been filled through a form. What I need is that export this data in text file for COBOL processing. But it requires fixed width of fields.

For example I entered the following data:

widht3 width10 width5
------- --------- -------
2 452 96

but it should store in table like

002 0000000452 00096
Sponsored Links: