Re: Command button for "Insert hyperlink"
Although F5Tornado's point is well taken - it may have been a smidge over board.
I am not sure that there should ever be a response to a thread to point out how old a thread is and WHY someone is posting to it. If there is a time limit on threads...
I am looking to extract a dollar amount from a text box in a query. The dollar amount will reside in general text, "It cost $4,370 and was...." and can be anywhere within the text box. The dollar amount sometimes has cents. There will also be times that there will not be any dollar amount...
I figured out how to get the MS dilaog box to open and to save a file path to a subform:
Private Sub cmdAddHyperlink_Click()
Dim strfilter As String
Dim strInputFileName As String
strfilter = ahtAddFilterItem(strfilter, "All Files (*.*)", "*.*")
strInputFileName =...
I have succeeded in getting a button to delete a single record in a subform, here is the code:
Private Sub DeleteRecord_Click()
'Ask User if He/She really wants to Delete the Record...
If MsgBox("DELETE RECORD!" & vbCr & vbCr & _
"Are You Sure you want to Delete this Record?" & vbCr &...
I am trying to add a button to a form that populates a sub form (data sheet) with hyperlinks. I also want to have a delete button available to delete these link(s), in case of wrong pick or attachment change.
I have searched and researched the topics available with no success. I have come...
You can't open or create a Db, new or existing
Problem solved: COMPLETELY unistall and re-install Access, did not work using the repair, re-install, etc. from add or remove programs. It now works fine.
I tried to create a Db from her computer and still get that error message. I then re-installed MSOffice and still having the problem and getting the error message.
The Db was created and it being accessed by the same version accross the department. The program is rolled out via our network. Out of 15 computers, there is only one having this issue. So there is no previous version accessing it.
The error is Cannot open a database created with a previous version of your application. (Error 3041). I clicked on help and the content tells me "you have accessed a Db that is in an outdated format. Compact the Db & try the operation again." I can not compact it on the computer, will not...
Bound to a field in a table. I have a form that is bound to a table, but have as of right now, 5 "count" queries bound to fields in the form. When I have those queries in the SQL statement, the option group does not work, just shows the value of what is in the table.
I am looking for a pop up that will not only let me pick a date and fill it in a field, but also pick a time, not the present time, but a time in the future in 15 minute increments. Any direction is greatly appreciated.