Hello,
I have a MS Access form with a few hyperlinks on it. I have tried to achieve effect similar to hyperlink roll over effect on a web page: when mouse pointer goes over a hyperlink it changes colour, etc.
Unfortunately, all I could find was MouseMove event:
Sub Label_MouseMove
Label.ForeColour=vbBlue
End Sub
But in this case hyperlink stays blue even after mouse pointer leaves it. And I would like hyperlink get back it's initial colour.
I am investigating on the possibility of setting up an approval process for our employee intake procedure by using MS Access and Outlook.
The idea is for the requester to open an intake form in Access and fill in the new employee's information and send an Outlook email to the manager for approval. I know how to trigger off an event on the form to send an email to the manager but my challenge is how to create a hyperlink in the email for the recipient to directly open the intake form with the specific record, without the need to open the database and find the specific intake form.
The intake form is built in a frontend .mde file on a shared drive where all users have access to.
I have a Review Date field where a client needs to be re-assessed either on a monthy, bi-monthly or tri-monthly basis. I suspect I could create a table to store successive review dates and include it as a sub-form on my main form but I am guessing that it might be too cumbersome and not as efficient as some of you guys might do it.
Would it be possible therefore to have the Review Date roll over to the next review date at a given interval after say some kind of command button or tick box is clicked?
Just a thought, but if there is anyone out there that could advise me I would appreciate it. :)
I have done the mistake of not keeping a backup, what I did is split my database file access and then created my mde file, I need to change some data on my tables, but I get the msg that I cant edit a linked table, is there a way that I could put things back the way it was, also this path that was created is it possible to change for future purposes (I might have to move the dir into a different path)
Developing in Access 2000. The mouse roller button moves to the next record in a form. Does anybody know how to trap the roller button? Setting me.cycle to 1 prevents the same happening when you tab from the last field but does not stop the mouse roller ball.
Hello, I have two images (img1 and img2) and I want to have img1 visible when the form opens and when I run the mouse over img1 it changes it to visible = False and img2 is visible = True. Also when I mouse off the image it changes back to img1… How is this done? Thanks!
Hello, I'm having a little problem with an Access Query. Simple table design, with relationships as normal, using a junction table for a many-to-many link.
Table1 Field: Area (Text) Field: T1_ID (AutoNumber)
Table2 Field: T2_ID (AutoNumber) Field: Value (Double)
Query1 Sources: Table4, Table3Join, Table2, Table1 Fields: Description, Area, Value
SQL:
SELECT Table4.Description,Table4.Area,Table2.Value FROM Table2 INNER JOIN ((Table1 INNER JOIN Table4 ON Table1.T1_ID = Table4.Area_ID) INNER JOIN Table3Join ON Table1.T1_ID = Table3Join.Area_ID) ON Table2.T2_ID = Table3Join.Value_ID;
However, with this design as it is, I cannot "edit" the Description field, or change the Area field. The entire Query becomes read only. Why is this? And how should i re-write this to allow me to use the relationships which Link Table2.Value to the appropriate Table4.Area (and display them both in one query), while allowing me to edit all the sub fields.
I am trying to write code to change the color of the text on a button on a continues form. I only want the button for the specific record, that meets the requirements of the if/then, to be effected. The code below will change the button for every record if one record meets the requirements.
If Me.datPMDueDate = Date Then Me.cmdAccessMaintenance.ForeColor = 65280 Else If Me.datPMDueDate < Date Then Me.cmdAccessMaintenance.ForeColor = 255 Else If Me.datSMDueDate = Date Then Me.cmdAccessMaintenance.ForeColor = 65280 Else If Me.datSMDueDate < Date Then Me.cmdAccessMaintenance.ForeColor = 255 Else Me.cmdAccessMaintenance.ForeColor = 0 End If End If End If End If
i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?
SELECT Count(Query1.Route) AS NumberofReRoutes, Query1.Route FROM Query1 WHERE [Start Date] <= #9/30/2014# AND [End Date] >= #9/1/2014# GROUP BY Query1.Route ORDER BY "NumberofReRoutes" DESC;
The last line seems to make absolutely no difference. I can change it to ASC, or I can remove the line entirely, and nothing changes. I need these sorted by the NumberofReRoutes field, but this method isn't working!The output at the moment is two columns: Route, and NumberofReRoutes.
Hello the problem I am having is that when I imported data from excel, it somehow placed carraige return at the end of the text box ( this is what I believe), this is a problem because in that field is a drop down box and it complains about my value not being valid. I press the del key behind the value and it doesnt complain. Can anyone help me?
I am importing data from a sharepoint list on to Access 2007, as linked data where any changes I make on Access is made to the list and vice versa. However, I recently made a change to one of the column types and this change is not being made on Access. I have changed a column type from choice to single line of text but I still see the list of choices when I access the list on Access 2007.
I have refreshed the list by right clicking the linked list and pressing refresh list. The list is set to not cache the list and is not set to work offline so cannot see why the change is not being made. I don't want to mess with the list be removing it and re-adding it as I have multiple queries set up which are being fed in to an excel file I use to create reports from the data. I have no knowledge of VBA, so there is none of that being used on Access.
I have (from SPSS) many multiple regression analyses, and each one of them has about 7-8 independent variables. I need to find the effect size-in particular I want to have effect size above 1% and statistical significance p<0.001. I am familiar with p, but I cannot understand whether effect size is b, beta or R square and how to interpret it.
It is a strange effect I get when switching among records.
In a form I have a TAB Control with some pages, when I open the form everything is ok:
But, when switching continuosly among records, the font becomes strange, looking like being bold.
It seems to happen only when using TAB control or, if you prefer, only on every TAB control's page except for the first one. Tried on different pc with different resolution.
Is it possible? I want a link that can be put in a mail (to someone in our network) and clicked. It should open Access on a specific database and I should be able to use parameters (like /cmd and /wrkgrp). I'm lost... :confused:
I created a hyperlink that links to a zip file. But when I use IE to browse the page, I cannot see "save target as" after right clicking the hyperlink. Why? Thank you very much for any help.
I have a table with one field set as a hyperlink. I have to generate the hyperlink according to what else is going on in the record, I do this by assembling a text string which I can write to a text field in the same record. I have no problem doing this but when I try to copy that string into the Hyperlink field I get type mismatch. Incidentally if I put two text boxes on a form and bind one to the text and one to the hyperlink field the I can 'cut and paste' it OK so how come I can't do it with Access basic?
Dim stGunlib As String Dim stGunlib2 As String stGunlib2 = [Stock number] stGunlib = "www.shooting.uk.com/Gunlibrary/" + stGunlib2 + ".jpg" [Link] = stGunlib [Picture] = stGunlib ([Picture] is a hyperlink field) it goes wrong here
I copied my data from MSAccess which one of the fields is a hyperlink field into excel. Well, the field contains text reading "FileA" but the hyperlink is dbfilesFileA.doc. Since I have it in Excel now, I want to be able to just have the data read "FileA.doc" instead of FileA, I thought if I can get the field to read the hyperlink path dbfilesFileA.doc then I can maybe use the Mid formula to take out dbfiles....
I have scoured the net and these forums looking for the answer but cannot find a good solution.
I am producing flow charts in Visio, and then saving them as HTML documents for use on our Intranet. Within the Visio flow diagrams I am using Hyperlinks on various shapes and text, to enable the viewer to open various other documents in various other applications. This seems to work fine in my web browser for normal office documents, like word and excel, but I need to be able to do it for MS Access databases too! Because the web browser tries to open it in the browser itself, the database won't open and I just get the normal "Web Page Could not be found" screen.
Another useful feature would be to be able to open to a number of different specific forms from a database, depending on which hyperlink is clicked. I assume this is not possible as you only seem to be able to define on page to be displayed upon opening the DB. Am I correct?
I'm trying to create a pdf report displaying records in a columns, with each record having its own hyperlink. Rather than displaying the actual hyperlink, which is quite long, I'd like to portray a friendly_field like in Excel (Hyperlink("Link"). Hyperlinkpart doesn't seem to do this.Is there a formula I can create in a query where I can reference each individual hyperlink but show it as a "friendly_field" such as "Link"?
How do I restrict access to the database while still being able to add a new hyperlink? I tried deselecting the "display navigation pane" option. But when I do this I am unable to add/edit a hyperlink in a form - when I right-click the only option I get is "add to favorites" rather than "edit", etc.
We are using access 2010, I have a blank form that produces an ID number for the specific record when saved. then i have other forms where the ID field is hyperlinked to the original form that was entered. I now have 2 users that are unable to open the hyperlinked form. when i login as them im able to open the hyperlinked form.
Private Sub ID_Click() On Error GoTo Error_Catcher_1 DoCmd.OpenForm "NewRequestForm", , , "ID= " & Me.ID, acFormEdit
I have a field in a Table (tblMainFile) named "File Location" which contains a hyperlink for each of the files.I have a continuous form (from a query) which displays information from the tblMainFile table.the form shows a text box (with the hyperlink) which is clickable to take them to the link location.I would like to have a button which says (GET FILE) or a different text box which simply says "Get File" as opposed to the entire hyperlink.
