Modules & VBA :: Auto Populate Hyperlink Control?
Nov 14, 2014
I have a form titled 'New/Edit/Search Contractor Employee" that provides controls to fields within a table titled "Contractors". In this table, I have a Hyperlink field that will store the location of the files related to individual employees. On this form, I have a Control that (at the moment) the user can copy a Hyperlink and enter into this, to populate the field. This will then allow the user to click on this Hyperlink to open up the individual folder location to drag and drop whatever files they want associated to this individual record.
I have created a Command Button to automatically create a unique folder for this record, VBA below:
Private Sub Command168_Click()
strPath = "V:IntProdTrans&OpsTERMINALSDriver and Contractor Database 2014ContIndPW" & "" & txtCompanyID
If Len(Dir(strPath, vbDirectory)) = 0 Then
MkDir strPath
End If
strPath = "V:IntProdTrans&OpsTERMINALSDriver and Contractor Database 2014ContIndPW" & "" & txtCompanyID & "" & txtFirstName & " " & txtLastName
If Len(Dir(strPath, vbDirectory)) = 0 Then
MkDir strPath
End If
End Sub
What I'm trying to work out now is how to automatically enter this new folder location into the Control, which is then viewable and can be clicked on. I managed to do this (can't for the life of me remember how) but it entered the location as text and I wasn't able to click.
The Hyperlink control is titled 'Induction Paperwork' relates to a Hyperlink field.
View Replies
ADVERTISEMENT
Aug 17, 2015
In a form, I have a comboBox with 3 columns.I update the field and with this piece of code, I update two more fields based on this comboBox data/columns.
Code:
Me.EUR.Value = Me.Combo37.Column(2)
Me.USD.Value = Me.Combo37.Column(3)
I wonder if I can update fields which are not parts of a combo.For example, suppose I have a form with two fields, DATE and USD, Once I update the DATE field, this event, auto populates the USD exchange rate field.
View 3 Replies
View Related
Oct 17, 2013
i've got a data entry form. when i click the button add all the other buttons go grey, i am in mode "New" also i am able to add, edit, records in this state, when i press save i want the supplierID field to automatically populate itself with the next SupplierID record THAT IS EMPTY. So say that my last record was ID number 45 then when i click add on my form and go into "New" state the SupplierID field automatically populates itself with "46" btw this is all an unbound form,
View 7 Replies
View Related
Apr 22, 2015
I would like a date field I have set up to auto populate the current date when I click on another field to enter information.. how would I do that?
View 5 Replies
View Related
May 28, 2015
I need some VBA coding to do the following tasks
Table 1: two columns - Child Tag and Parent Tag. Parent Tags can also be in Child Tag column. In other words, a parent can have multiple levels of children.
Table 2: one column - Backup Tag.
I'd like to have a form with a combo box, pick a Parent Tag, the search all its child tags and compare each Child Tag found with records in Table 2 to see if there is a match. Then populate all results in a tree view control.
A visual example :
Parent Tag
...Child Tag 1 - Back up tag found
......Child Tag 11
......Child Tag 12 - Back up tag found
...Child Tag 2
......Child Tag 21
...Child Tag 3
......Child Tag 31
.........Child Tag 311 - Back up tag found
View 7 Replies
View Related
May 29, 2014
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?
View 6 Replies
View Related
Mar 13, 2007
Let me explain my problem and say that I've found a partial fix to my problem, but I need help figuring the rest out.
I need to open a hyperlink on the internet and populate it with data based on a form record in my database. More clearly, I need to do a search on an address on a website called zillow.com, based on that address in my form in the db. For example, if the property address in my db is 123 Anywhere St., Topeka, KS 99999, I need to click a button that will open zillow.com, and populate the address and city/state/zip fields with the corresponding info from the record in the db. Here's what I've got so far:
VB Code: Original - VB Code Application.FollowHyperlink "http://www.zillow.com", , True, False Application.FollowHyperlink "http://www.zillow.com", , True, False
Here's the deal. When you do the internet search on zillow, it puts in %20 for every space and I can't figure out how to parse the record to automatically put these characters in.
I'm wondering if there's a way to tell the db in code to do this:
Application.FollowHyperlink "http://www.zillow.com/search/Search.htm?addrstrthood=2200%20Corley%20Drive&citystatezip=Las%20Cruces%2C%20NM%2088001", , True, False
I hope someone knows what I'm talking about. Thanks!
KellyJo
View 5 Replies
View Related
May 24, 2005
i dont know how to make it work.
simple, clicking on label in tabcontrol1 will bring you to tabcontrol2
View 5 Replies
View Related
Aug 29, 2014
I Have a table with 15000 entries. This table lists components we use. This table is used to generate queries/forms. I have been asked to add a hyperlink to this table to link to a drawing of the component. All the drawings are in PDF and in the same folder. I am looking for a way to automatically update the hyperlink fields all at once. The Hyperlink will be in the format of servershareddrawings12345.pdfwhere 12345 is the component name from the table.
But there are a few small problems with the component names.
1. If the component begins with a B- . The drawing name will be all the characters except when there is a second dash in the component. So if the component is B-12345-678 the drawing name will only be B-12345.
2. If The component begins with AB, The drawing will be the first 5 characters regardless of what follows, e.g. AB123.
3. Finally for all other components the full component name will be the drawing name.
Putting the naming to one side, how to go about auto generating the hyperlink. I have posted this in the table section, but maybe this should be in another section like queries or VBA.
View 2 Replies
View Related
Aug 25, 2005
What I’m trying to achieve is a database that I can enter the number of calls a salespersons makes in a day. Please find diagram below.
<< Date >>
,,,,,,,,,,,,,,,,,,No-Calls
Name
Ben,,,,,,,,,,,,,,,1
Bob,,,,,,,,,,,,,,,2
John,,,,,,,,,,,,,,3
I have kind of got one working but when I create a new day I have to type in all the names every time and it get a bit boring. Can anyone point me in the direction of how to auto populate the names of salespersons when I ad a new date ?.
I have attached a quick mock-up of what I have got so far so if I haven’t explained myself very well hopefully you can see what I’m gibbering about.
Any help would be much appreciated.
Thanks, Mary
:confused:
View 1 Replies
View Related
May 5, 2006
Hi all,I tried looking for an answer to this but I haven't found anything yet. I have a form that features a 'Bill To' and 'Ship To' section with 'City, State, Zip etc..' for each one. I'm triyng to create a button that my users can press to automatically copy the data from 'Bill To' into the corresponding fields in 'Ship To' to save time if the data is the same. I tried creating an update query but it seems to confuse the form code and throws errors.Any help you can give me would be appreciated.
View 5 Replies
View Related
May 8, 2006
I know this is a easy task, but I can't just figure it out. I have a table with branch No and Branch Name. In my form I would like the user to select the branch number from the combo box and the Branch name field will be placed in the Branch Name field automatically. How do I go about handling this task.
View 12 Replies
View Related
Aug 10, 2006
Hey, hows it going,
Ive been through-out a decent chunk of the internet, trying to figure out how to Auto-Fill or Auto-Populate a select number of Text Boxes on a form.
Example ill sit there type in someones ID number and his Name, Where he works. all of that information have come up yet considering its probably a really simple question, can someone please help me out.
Thank you, and im really sorry for the bother.
View 9 Replies
View Related
Dec 10, 2007
Hi, everyone! I hope that someone is willing to help me with a database that I'm trying to set up. I'm a teacher and want to use Access to track behavior notes and parent contacts. I'm trying to make the database work efficiently for me and need some help with auto-populating fields.
Here's an example of what I want:
Field 1= date (I have this setup to fill in automatically)
Field 2= student name
Field 3= behavior code
Field 4= comment
I want to type in a code for a behavior in Field 3, such as "t", and have "talking excessively" automatically pop up into Field 4. This would just make it faster for me to enter all my info, and then I can make a report that only shows the date, name, and comment without the codes showing up. I currently have the behavior codes listed in another table, but I don't know if that's where they belong or what. I've found some web sites that have codes for auto-populating, but I have no idea where to put them or what to change in order to personalize them for my database. Is there anyone willing to walk me through this? TIA!
These are the codes that I have:
codememo
bdid not have book in class
cdclass disruption
dadetention assigned
dcdress code violation
dsdetention served
hdhad head down throughout lesson
nwdid not complete classwork
ooffice referral
rreferral for 4 tardies
ssleeping
sdskipped detention
ttalking excessively
wdid not have workbook in class
View 2 Replies
View Related
Nov 11, 2005
Hey all,
Maybe im just having a brain fart, but I cant get this method to work.
There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the second one is open.
What I would like to do is pass the info from the first form on to the second one. The second one uses the bride's info and the wedding date.
I tried using the query to fill it in but I havent had any luck. Been a long day.. maybe just not thinking clearly.
Any help would be appreicated, and thank you in advance to any replies!
Thanks!
Mateo
View 1 Replies
View Related
Jan 21, 2006
I accidentally posted this in "general"...so I am posting it here under "forms", since it is "form" related. My intention was not to double-post...sorry.
Summerwind had posted an example to auto populate a combo box. The code below follows his example, but is not working for me:
The fields I have on my form are:
cboCompany
cboLocation
cboCompany is based on tblCompany( with fields CompanyName, Location)
When I update the cboCompany field, I want the cboLocation combo box to populate with all locations for the company that was entered into the cboCompany combo box on the form. E.g. The company "Visions" may be exist in the tblCompany with 3 different locations: Visions (Las Vegas), Visions (Ohio), Visions(California). When I pick the company "Visions" from the cboCompany combo box, I want the cboLocation combobox to be populated with "Las Vegas", "Ohio", and "California".
The code is as follows but returns empty records in cboLocation:
Code:
Dim StrSource As String
StrSource = "SELECT Location FROM tblCompany WHERE tblCompany.CompanyName Like " & Me.cboCompany.Column(1)
With Me.cboLocation
.RowSource = StrSource
.SetFocus
.Dropdown
End With
Can anyone help with this...thank you.
View 1 Replies
View Related
Jun 12, 2006
I have a standard Data Entry Form based on a WorkOrder. I am dealing with over 90 offices nation wide with mulitple offices in a state. I have a seperateTable that lists all 90 Offices which I have created a Query to Promt the user to enter the State code for that State.
Is there a way I can Select an Address from the Query and auto populate that information onto my WorkOrder form?
Any help would be greatly Appreciated as I have Exhausted myself trying to figure this out!
View 1 Replies
View Related
Aug 16, 2011
Okay--I have a table of scholarships, and each one has fields for primary contact, secondary contact, tertiary contact, etc., in which the names of the contacts associated with each scholarship are stored. What I need to do is to have every name pulled from this table and listed--each as its own row--in another table. I'd like it to do this automatically so that if a new name is added to the scholarship table, it will create a new row in the other table.
View 2 Replies
View Related
Sep 8, 2005
I am creating an inventory database and was wanting to know how to make a combo box or any box auto populate information from tables. I would like to have a combo box so that you can do a search inside of it and find the necessary product, select it, and all the product specs will be displayed. I have created the combo box with this information, but no luck getting it to populate on the form itself. Thanks in advance for your help.
View 4 Replies
View Related
Feb 25, 2006
Haven't touched Access in quite some time and now I can do a simple task.
Here's what I have:
2 Tables
Table 1 includes 2 fields COURSE CODE and COURSE NAME
Table 2 will be a list of students and the courses they have taken
What I'm trying to do is as I'm entering a new student in the database I want the course name to automatically fill in when I type in the course name.
I did lookup fields for both the course code and the course name to ensure the correct codes are entered. However since the data in table 2 does not autofill there is the posibilty of having a row with a course name that does not match the course code.
How can I force table to 2 match the course name and code relationship from table 1?:confused:
View 2 Replies
View Related
Mar 16, 2005
I have a form with a text box named HRName.
When I populate a combo box named BusOrgCode, I want to auto-populate the HRName box with the name that corresponds with the Bus Org Code. I get a run time error "2001." Help!
Here's my code:
+++
Private Sub BusOrgCode_AfterUpdate()
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function.
strFilter = "BusOrgCode = " & Me!BusOrgCode
' Look up HR Partner Name and assign it to HRName control.
Me!HRName = DLookup("HRName", "HR by Bus Org Code", strFilter)
Exit_BusOrgCode_AfterUpdate:
Exit Sub
End Sub
+++
View 2 Replies
View Related
Sep 22, 2005
I have a form with fields "Assigned To" and "Assigned Date". When "Assigned To" receives a value, i.e. Not=Null, I want to auto-populate the "Assigned Date" field with the current date and time. How can I do this? Any help is appreciated.
View 4 Replies
View Related
Aug 3, 2004
I am need of something that will help me auto populate the user name on a form. What I am thinking of is setting something that is diplayed when the form is open, asking users to enter their name. I then want this name to be populated in the user name of each record they update.
Can anyone help me? This sounds like a pretty easy thing to do , but sometimes what I think should be easy turns out to not do-able!
View 14 Replies
View Related
Nov 15, 2004
I am trying to auto populate a text box when i click on the button to add a new record. This is the code for the addnewsequence button.
Private Sub addnewsequence_Click()
On Error GoTo Err_addnewsequence_Click
DoCmd.GoToRecord , , acNewRec
Exit_addnewsequence_Click:
Exit Sub
Err_addnewsequence_Click:
MsgBox Err.Description
Resume Exit_addnewsequence_Click
End Sub
In this form is a text box called degree name that is link from the table degree. It autopopulates with the degree upon the sequence form first opening button clears the text box when i click add new sequence
any help greatly appreciated...
Thank you
View 2 Replies
View Related
May 2, 2005
Hi, just a quick question that i hopes not too hard.
Basically i want one of the fields on my form to get automiatically filled in. I'd like it to take the first letter from one field and the first letter from another field. What im trying to do is make a primary key field up from other fields they have entered.
So for adding new customer i want it to take the firstletter of the firstname and first let of the surname.
SO for myself Luke Tarrant it would be LT. Then i suppose i'll need to add some unique so there no duplicates as it a primary key field im trying to populate.
So for instance Luke Tarrant would = L + T +001
Then Lucy Tarrant would = L + T + 002
Any help wouild be brill!
View 6 Replies
View Related
Nov 20, 2013
I have limited Access experience, but have designed a database that we use here at work. In one of the forms for this database, there is a field where a distribution statement can be added manually, if the statement is received from a customer. However, we would like to add a "check-box" to the form, where is it is checked, the distribution statement automatically populates with a previously used generic distribution statement.
View 1 Replies
View Related