Concanotating Date() in a form issue
I have a form with the following text fields: StartDate EndDate Total The StartDate field uses a DatePicker, the EndDate has Date() in it's SourceControl property. I am using this code in the Total SourceControl property: =DatePart("yyyy",Date())-DatePart("yyyy",[4StartDate]) & "y " & Abs(DatePart("m",... 3 Sep 2009 05:20
GoToRecord on a subform...
How do I give the string name of a subform in the following: DoCmd.GoToRecord acDataForm, "Subform name string", acGoTo, recnum Or if this is not possible, here is what I am trying... I have 3 forms, Subform A is a continuous form w/ Name and Title only (onClick routines position the form B record). Form B ... 23 Jan 2009 16:13
cmd button to open small form when value is null
Okay I have afrom titled "frmContact". this form has txt boxes that are populated from the tblContacts. In the form header I have a cmd box called "cmdAddFromOutlook" whe this is clicked it will open a search window form outlook and enable the user to enter a name and the name will be added to the records. I c... 22 Jan 2009 15:01
OutputTo pdf error
I have a listview control on an Access 2007 form where users can select any or all of a list of names who will be sent an email with a pdf certificate attached. The pdf is an Access report. I'm using the following code and the OutputTo line is generating an error number 2501 (The OutputTo action was canceled)... 11 Nov 2008 20:45
Cascading List Boxes
Hi-- I have a form with a combo box that selects distinct from a lookup table, called cboStates. When I select an item from it, a list box populates with a list of values that match . For example, if I choose Oklahoma, it shows all cities in Oklahoma in lstCities. I then use that lstCities to filter a subfo... 17 Jul 2008 17:53
scanning to access table
Ok.. I have a table that i created in access and with the onclick event ran the code below. It worked perfect. It called the scanner, scanned the file(s) and when you clicked done it loaded the file upto the table. I move the table to a sharepoint which is using sql express as the backend. I then relink the... 15 Oct 2007 00:34
whats wrong with this code?
------------Begin code--------------------------------- Dim rs As DAO.Recordset Set rs = Me.RecordsetClone Dim strInmateID As String strInmateID = Me.ImateID rs.FindFirst "InmateId = '" & strInmateID & "'" If rs.NoMatch Then MsgBox "No entry found.", vbInformation, "Data Not Found" ElseIf Not rs.EOF The... 14 Sep 2007 05:25
Help getting Sample database for Doug Den Hoed's article 'Taming the Treeview Control'
Dear All: If anyone has a copy of the TreeLib.mdb database mentioned in Doug Den Hoed's, 'Taming the Treeview Control' artilce published by Smart Access in October 2000, could you please email it to me. This artilce is listed on MSDN, but the download is no longer available. I am looking for a BOM sample for i... 31 Aug 2007 09:58
Microsoft Office Access failed to create the Visual Basic module
Alright so I get a warning message like this when I try to code in Visual Basic now. For a form I have. I basically am accessing a Microsoft SQL Server over a domain. I have complete domain access on my account. When I initially created the form I could create from the Code Builder (Visual Basic Module), an... 22 Apr 2007 20:47
Copy files with Microsoft encryption enabled
Hi All, Just ran into a dilly of a problem. A department in our company decided to turn on the encryption for the Documents and Settings folder. (right click, properties, advanced, encrypt contents) A database that I inherited sits in the Application Data folder and dumps data to Excel and then copies the Exce... 22 Mar 2007 18:05