Recent content by scotthutchings

I have the following record in a table: DocumentID NickName DocPath CreatedBy CreatedOn 4 Alum Frame Detail C:\IMS\Development\IMSDocuments\1CCE51E2-1022-44C1-B312-7B9995E2B280.pdf Peter 4/28/2014 1:57:28 AM How do I set up a hyperlink so when the user clicks on the file name, the document...

That is perfect. Thank you.

Perfect. How do I call the system browse window so the user can specify the file?

I need to make a copy of a pdf document that the user identifies in a "hidden" folder that is associated with my backend database. I am not sure how to code this. I am using Access 2013. Can anyone point me in the right direction? Thanks Scott

Got it. Thanks!

The code is to look up the tax rate for a project called [Project Name] (a primary key) and assign it to the variable PTR. The error comes when the PTR = DLookup... code runs.

I am receiving the following error: 3075 Syntax error (missing operator) in query expression 'Project Name = "Scott's Training Project(21)"'. at 'cmbCONumber_NotInList" when my Dlookup code runs. Here is the code: Dim Project As String Dim strMessage As String Dim rs As Recordset Dim PTR...

I need to hide some lines on the first page of a report but display them on subsequent pages. I was able to do it with the controls using conditional formatting but it does not appear that I can do that with lines. Any ideas? Thanks! Scott

I have a database created on a windows xp computer in Access 2007. When I install a runtime version on several computers with windows 7 I started getting and error code #3075 Function Isn't Available when I try to pull up a report that uses formatting functions like currency, date, left() etc...

I have an Access 2007 database that I set up that is somehow connected to SQL Server. I am not entirely sure how it got connected but the current front end and back end are entirely contained in Access. Right now, if the SQL Server services are turned off, nobody can log into the database...

I have a form that when it opens runs the following code in order to hide every control except the required input: For Each ctl In Forms![Bid - Bid Proposal]![Bid - Proposal].Controls If Not ctl.Name = "cmbReference" And Not ctl.Name = "ReferenceLabel" And Not ctl.Name =...

I have an database that was programmed in Access 2007 on a desktop of one of my clients. I have a laptop with Access 2010. The 2007 file (IMS.accdb) works great in my clients office. When I copy the database to my laptop it will not open when I am not connected to his wireless network - even...

Perfect! This is just the function I was looking for! Thanks for your help!

I have a Text that often contains the length of an item which can include feet and inches written like 3'6". I need to use select statements and copy/insert these fields using code but I don't know how to handle the Quote symbol. A couple of data samples are: 171A 36" 3070 5-3/4" 18ga...

I have a variable length project number from which I need to extract just the numeric portion. How do I determine the location of the first alpha character? Location = InStr(MyField,???)