Modules & VBA :: Save User Entry As Part Of Hyperlink Then Display In Subform
Nov 21, 2014
I have a form with multiple textboxes and comboboxes that allow for user entry, and a subform displaying a table, where the entries from the form are saved and can be retrieved. It's basically a way of creating new task entries and editing existing ones from a single interface.
One of the fields is an "issue number" of sorts, which is a 5-digit code that identifies the task. We have a website where details of each task are stored, and the URL format is akin to this: [URL] ....
The functionality that I'm hoping for is that when the user saves the record, it will be saved as the full link address, by concatenating the static first portion of the address and the code entered by the user. However, I need the table to still only display the code, not the whole link address, and will follow the full address when clicked in the subform table.
View Replies
ADVERTISEMENT
Nov 11, 2007
Given a table field that is a hyperlink type.
I need an Update Query to set all records of that table so that the Displayed Value part of the hyperlink field (not the Address part) is set to a particular value.
Any ideas how?
Thanks.
View 1 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
Feb 3, 2005
Hello,
Can someone please tell me how to make it so that a user must save on a form or there is nothing entered into the table? As it stands anyone who views the form creates a new record.
Thanks in advance!
View 4 Replies
View Related
Feb 12, 2014
So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I am using Access 2010.
View 2 Replies
View Related
Oct 20, 2005
Hi,
I want to only save changes made to the DB row when the user clicks the Save button I created. I have some text boxes which currently are bound to different columns in the given row (ex: name, address).
Right now, changes are updated automatically when the form is closed or when focus moves to a different tab page.
Is there any simple way to do this? Currently all form input objects are bound to their respective columns (ex: name, address). Should they be bound, or should I just perform a query when the form opens to find the specified item then load the different fields into the proper text boxes.
Also, when I TAB through all my input boxes and the TAB focuses on my Tab Conrol Object the text boxes are automatically updated with the next item n the DB (next row). How can I prevent this?
Thanks!
DRT
View 1 Replies
View Related
Dec 16, 2004
I have what I think is a difficult problem to overcome...
I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.
Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!
If this is not possible, do you know how I can acheive this?
Thanks
S
View 1 Replies
View Related
Jan 20, 2015
I have a query which is a concatenated field of text and then a field from a table that has a hyperlink.
i.e 15mm predesigned mould Drw: [L:10527-123-A.pdf#L:10527-123-A.pdf#]
I want it to display in the query field as just the hyperlink
15mm predesigned mould Drw: [L:10527-123-A.pdf]
View 5 Replies
View Related
May 16, 2014
I'm trying to use ghudson's browse button in a form on MS Access. It works well, but I'm running into a tiny bug after implementing it into my database.
[URL] ....
I am able to browse, I am able to select a file, and am also able to have it display into the hyperlink textbox.
However, when I try to click on the hyperlink in the textbox, it does not take me to the file.
To fix the bug, and to get the hyperlink working again, I have to modify the hyperlink within the textbox, then bring it back as it was. (generally, I hit backspace, and replace the letter I removed.)
View 6 Replies
View Related
Dec 4, 2014
How can I make certain my user enters records on a subform before attempting to save the main form? Right now they can completely ignore the subform before saving the record.The Main form has business address, etc. on it. the subform is bound to a join table that lists the multiple categories, subcategories and sector the business is listed in for a directory.
I already have my fields set to required at the table level in the join table, and have some existing VBA in both my subform (to update edited date) and my form (to validate empty records where a certain condition is met) but that's not the issue...
How do I focus the user to enter a record on the subform to the point where they are forced to enter something and complete the subform before the record is updated.
View 2 Replies
View Related
Sep 16, 2005
I'm writing some "Help" for an Access database that I've created, but lots of others will be using.
All I can think of is to type it all into a form which is then displayed when the user clicks a button I'll create on the menu. As it's going to be a long form, I want to put a "Contents" section at the top, with hyperlinks to relevant sections further down.
Is there a way to make one label (cos that's all the text is) hyperlink to another label in the same form? Or should I be going about this in a completely different way?
I've read a lot of the hyperlinks Q&As in the forums, but haven't found the answer to this yet. Thnaks in advance for any help.
View 4 Replies
View Related
Dec 6, 2013
Access 2010:
The database I'm working on stores label images, or better stated, it stores file paths where the label images are stored. These paths are used in reports and forms to view the label images within the database. What I'd like to do is to create a "save" or "email" button that will allow the user to select a location to save just a copy of the image in jpg format. I realize that it is possible to imbed the jpg image into a report and export it as a pdf. What I'd really like to do is find a way to save the image (perhaps by copying it from the path in the database and simply relocating it) and preserve the jpg extension if that is possible.
I am also aware that there are third party applications that will convert pdf reports into jpg files however network restrictions keep me pretty limited in my ability to download third party software.
View 2 Replies
View Related
Apr 22, 2014
i have a form with subform in it, and when i press the save button in the main form it saves only the records in it but it wont save the records in the subform
i found on microsoft this code
DoCmd.Save acForm, "New Employees Form"
how can i use it to save both the main form and subform together
View 3 Replies
View Related
Jul 2, 2013
I have a MainTable with Subform. The Subform is based on a Query. I want to save the data/Fields from subform to my TempTable..
MainTable Fields:
EmployeeNo
Name
Position
TempTable Fields:
ID*
Salary
Allowance
Subform Fields:
EmployeeNO (not Shown on Query results)
Salary
Allowance
I want the fields in my subform to be saved in TempTable..
View 4 Replies
View Related
Dec 2, 2006
Hey all,
I am embedding a MS Access 2003 Database form into web page (iframe) by creating a "Data Access" form.
I have created it all and it works fine. But there is one last thing i need to sort out.
When the user clicks the Submit button (Really a Save Record Button), i would like the button to also forward the visitor to a basic "Thank You" html page, in the actual iframe. At the moment the record saves, but it doesn't give the visitor any acknowledgement that they submitted successfully.
What code do i need to add to the <Button> code on the Data Access form, in order to create a hyperlink. I am not too familiar with VB.
Thanks.
View 3 Replies
View Related
Feb 23, 2015
I have a field that is pre filled in with a value. The name is "Business".Then there is a combo box with various values. If the user would select a value that does not match with values that can be selected if in "business" a value is selected, it should show a message that the selection is wrong and user needs to select the correct one.
Example:If in the field "Business" the value "Food" is selected, then the possible values to be selected in the combobox would be: Fruit or Meet or Fast Food. If the value in "Business" would be "Wood" only selections could be made: Talble or Chair or Cabinet.So, if a user select "Food' in "Business" and in the combo box "Chair", it should show a message that the wrong selection was made and don't let them use the wrong one.
View 11 Replies
View Related
Oct 3, 2006
Im trying to make a data entry form which will add a new record to a database. My problem is when I associated it with a table. it starts off with a record already populated in the fields. Can someone tell me how to start off with a blank form to add new information.
Part 2
I wish to have a combo box that will drop down with SSN#s and populate the Address field automatically so that a person with additional orders will not have duplicated addresses but just one main address.
Thanking you all in advance!
View 4 Replies
View Related
Sep 8, 2013
I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.
View 3 Replies
View Related
Nov 5, 2014
I am adding new record into subform via recordsetclone method. The problem is that record is added but on save it does not appear in the table. If add this record manual using subform everything works. When record added manually update of the record works fine.
C
'Add Wastage value to flooring area section
Private Sub Wastage_AfterUpdate()
Dim rsFlArea As DAO.Recordset
Dim Wastage As Double
Dim Item As String
Set rsFlArea = Me.OrderFloorAreaEdit.Form.RecordsetClone
[Code] .....
View 6 Replies
View Related
Nov 6, 2012
I'm trying to save a report to my Desktop as a pdf - adding a date {that I am retrieving from a query} as part of the pdf file name.
I get a
Run-time error '2501' - The OutputTo action was cancelled.
(See screenshot).
Here's the code I'm using. So far - all I've tried to do is run the function from the Visual Basic Editor.
Function SaveReport()
Dim strSQL As String
Dim strPath As String
Dim strFilename As String
'Get the ReportDate.
[Code] .....
View 4 Replies
View Related
Feb 13, 2015
How do I display a more meaningful message instead of the cryptic error about having to enter data into blah blah blah. How can I trap that error and provide them a more meaningful message about entering data. I have tried the following;
Main form name frmPatientRecords
Sub form name DentalRecords Subform
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Nz(tblPatientDetails!recordid, 0) = 0 Then
MsgBox ("sorry. Please complete the main record entry")
Parent.SetFocus
End If
End Sub
View 14 Replies
View Related
Aug 23, 2006
I have a combo box(based on a table) on a form which autofills 12 textboxes. The problem is when i switch to the next record on the form the auto filled textboxes stay the same as the first record. when a new item is selected from the combo box all the records are changed once again. I dont know if this is explained well enough but any help would be great
View 3 Replies
View Related
Mar 9, 2006
i've looked but can't find the answer!! which is unusual as this forum covers everything.
i have a field [photo location] with a hyperlink to a folder within which is a number of images. at the moment i have 2500 folders and its growing daily. the action i want when the 'photo location' field had got focus or when clicked is for the photos within the folder to open [not within the form itself] - either in seperate windows or preferably all together. i am using irfanview to display the images but am easy on this point. i do not want to give each photo its own hyperlink because there are thousands of them. any suggestions as to how i should do this?
thanks
View 2 Replies
View Related
May 12, 2014
I have a table called ComponentIndex with about 3000 entries. Each entry has an ID field and data in a hyperlink field called MSDSlink.
For each entry, I want to copy just the address part of the hyperlink to a new text column, let's call it MSDSAddress. This way, I only have the URL and no displaytext in that new column.
How would I go about doing so?
View 5 Replies
View Related
Aug 23, 2006
hi everybody, im have a database with table called "project". there are many column in this table. my user want to export this table to Excel, but only some of column, with particular order ( depend on him) to analyze in Excel.
he asked me to build a form with a list box, drop box,somthing like this, so he can choose what column to export in what order.
i try to make a query like this: " Select Forms!UserInput.combobox1.value , Forms!UserInput.combobox2.value,etc, From Project" but it wont work.
Dou you have any idea.
thanks in advance
View 2 Replies
View Related
Nov 7, 2014
So I have a table with 2 fields.The first field has the addresses to multiple hyperlink paths to folders on my computer.In this field the display text matches the hyperlink paths.In the second field I have the desired display text for field 1.I have tried using an update query to either:
1) Change the display texts of field 1 to match field 2 while preserving the hyperlink path
2) Add the hyperlink path from field 1 to field 2 without altering the display name.
I cannot get either one to work. Upon updating field 1, I lose the path, and upon updating field 2, I lose the name.
View 3 Replies
View Related
