Search results for query: *

I'm using a simple query with a function call. In the trial the function returns a constant integer value. The source table has only 1 record. SELECT tblRoster.RosterID, tblRoster.RosterName, tblRoster.Comments, pfRosterStatus([RosterID]) AS RosterStatus FROM tblRoster; the function...

Am i correct in the assumption that .Name is not an exposed SeriesCollection or Series property in Access Graph objects? It seems the Access object model version is considerably restricted. I had high hopes for a handy means of conditional formatting.

Greetings, I hope someone can offer suggestions as to why the following error is raised(aside from the obvious: running on a non-2010 version)? Error 3856: The Microsoft Office Access database cannot update the data in tblNextNumber. The minimum required version to update the data is...

Greetings everyone, Binding DAO recordsets to a form raises Error 7965("The object you entered is not a valid recordset property". Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblProject", dbOpenTable) Debug.Print rs.RecordCount 'sanity check Set Me.Recordset = rs...

Greetings folds, It has been donkey's years since I removed a grouplevel section from an A2K report and all I can remember is that it was a non-intuitive process. Can anyone refresh my hazy memory on how it is done. By the way, these are sections created via the sorting/grouping dialog, not...

I inserted a new 5 column (presumably columns A,B,C,D,E) table into a Word 2007 docx. I entered a formula in the table referencing B1. No problem. Then entered the same formula in another cell of the same table and changed the reference to cell E1. I get a "E1 is not in table" response...

I am puzzled by the behavior of the Shell function PathStripPath in a VBA setting in that it merely overwrites the beginning of the string. If I pass a string "C:\FolderABCD\File.txt" the resultant string value is: "File.txt BCD\File.txt" This is fortunately not a show stopper since there are...

From the brief Microsoft references I've read, it appears that Access 2007 (or any of Office 2007) requires Windows XP or a later version. Has anyone had any experience with running the new Access/Office release on Windows NT? Thanks, Bill

Could someone have a look at the following code and suggest where I am going wrong in adapting to vb/vba. As is, the code crashes the application on: SendMessageRef(m_hWnd, EM_GETTEXTEX, tGTT, sBuff) C Datatypes and all the fun stuff like memory management are a new experience to me and a...

Hello, Get someone suggest what I am missing in including wildcard characters in the filter for a DAO recordset The following work: CName Like 'A*' CName Like 'A*A' CName Like '*A*' But this raises a syntax error: CName Like '*A' Substituting % for * brings the same results. THanks, Bill

This problem is occuring with A2K and A2003 running on NT2000. When any form with a RichText ActiveX control (in this case, version 6.0) is opened (in any view) for the first time during a session, a cd burning software (OEM with the computer) repeatedly attempts to run an installation from the...

Any suggestions on how to retrieve either the GUID or PIDL for NT2000 or XP folders? I've looked at the Shell function (SHBrowseForFolder), but as far as I can tell, it only provides for a single selection via a dialog box. I'd like to expose the ID's en mass. Thanks, Bill

I have been saving up some related questions regarding RichTextBoxes (RTB), so here goes: 1. It looks like RTB's no longer come as an ActiveX add in in A2003. Have they been replaced with something new and improved? Or am I missing something somewhere. 2. Peculiar behavior: I have a form...

I cannot properly close an instance of Excel that has been opened in Access. I create an Excel app in Access and export the results of a recordset to Excel Dim appExcel As Excel.Application Dim wkbExcel As Excel.Workbook Dim wksExcel As Excel.Worksheet ' Create the Excel Application and...

I would like to verify that a report (MS Access in this case) has actually printed. This is in a setting with Windows XP on a Novell network. So far I have been unable to raise a valid event handle from FindFirstPrinterChangeNotification although I have tried it both with and without a pointer...

Hi, Set cat = New ADOX.Catalog cat.ActiveConnection = CurrentProject.Connection For Each tbl In cat.Tables If tbl.Type = "TABLE" Or tbl.Type = "LINK" Then ' No views, queries or system tables. rs.Open (tbl.Name), cnn, adOpenForwardOnly, adLockReadOnly If I use the...

Hi, I've been tinkering with lumping a main form and several subforms into a transaction to allow rolling back data changes and it works satisfactorily with a couple of subforms in the admittingly rough coding format posted below. However, increasing the number of forms involved almost...

A couple of miscellaneous questions. 1. I am curious as to why I can create a Scripting object (dictionary) in VBA without having the Scripting library installed. Any other Scripting methods and properties are unavailable other than those specifically associated with the dictionary. Is this...

Hi, Can I programmatically delete a field from a DAO recordset? I see that the fields collection has a delete method, but I am at loss as to what to do with it. The object browser indicates a "name as string" parameter is needed and I presumed this meant the name of the field. But the...

I was with a retro client who is still keeping a unified (BE & FE)Access database on their "server" with all 10-15 users accessing this over the local network. Access A2K and A2003 versions are variously installed. While the database was in use, I opened up a VBA editor on the server copy to...