Search results

I have a custom ribbon in my 2007 application. In the custom ribbon I have a bunch of stuff and part of it is: <group idMso="GroupRecords"></group> <group idMso="GroupSortAndFilter"></group> <group idMso="GroupFindAccess"></group> The ribbon works fine in...

I have code in several methods on one of my forms. When the user filters by form, all the code fires and most doesn't need to since there isn't any data on the form as the user is putting in their filter information. Is there a way to tell if the form is open to do a filter by form? Regular...

Figured it out by commenting out the calls to store/set to make sure the accde worked without any of it in there. Then uncommented the first form save and set so only one was happening and copied that accde. It worked. Went to uncomment the second I realized that I had Set FormColumnOrders...

Posted the code in my first reply but here is the code that changes the columns: Public Sub SetFormDisplayOrder(ControlList As Controls) Dim myColOrder As clsColumnOrder Dim lngCount As Long Dim CurrentControl As control If Me.Count > 0 Then For lngCount = 1 To...

Cronk, yes. If I copy the accdb to the 2010 system it opens and runs fine with no errors. Dave, Will check the order of the references to confirm they are the same.

Here is my clsColumnOrder code in case it matters: ' Module : clsColumnOrder ' Description: ' Procedures : Get UserID() As Long ' Let UserID(ByVal lUserID As Long) ' Get FormName() As String ' Let FormName(ByVal sFormName As String) ' Get...

I have Access 2007 (32bit) on one machine and Access 2010 (32 bit) on another. I've written some code to save the column settings on 3 datasheet subforms. If I create a .accde on the 2007 machine from the .accdb on that machine everything works fine. If I copy the .accdb from the 2007 machine...

Well, this is Access so field size sets the limit for how many characters the field will store. In this case the field is Text, Field Size = 25. I have two columns in the table with the exact same settings. Except, the LOR_NB field has extra characters tacked onto the end while WI_STE_NB...

JHB, I just included that snippet since the function is so long. Here is the complete code. The only field that I've found fills the full character length is LOR_NB.: Private Sub TransformandAddv10(Records As DAO.Recordset, formType As String, Optional UsingSQL As Boolean = False) '...

Weird behavior copying a column from one record to another. Code is: Set fld = Records.Fields("violationLocalOrdinanceNumber") If Len(fld & "") > 0 Then rst!LOR_NB = Nz(Records!violationLocalOrdinanceNumber, "")...

Thanks Cronk. That got me going down the right path. I had to setup a query to get the max transaction id < [StartDate], grouped on citation number. This gets me the last time the citation was sent outside the user's date range. Had a couple other steps afterwards but this was the main thing...

Think what I need is a subquery but not sure how to format it correctly. I have a table: tblCitationTransmit that I'm trying to use to create a report. I'm pulling all the fields in the table based on the dtmTransmitTime (when the record was sent) so select * from tblCitationTransmit where...

The following function properly returns the My Documents path on all my client's systems except one. Its a Win8 system and the IT person changed My Documents to be on a server. I get a error 76, path not found from pappWord.System.PrivateProfileString. If I run as an .accdb on the system it...

I have a VB.net Access COM add-in that connects to a web service to pull data. If I run my .accdb it connects to the service fine and pulls the data. If instead, I compile the .accdb into a .accde and run the same command from the .accde, I get "ActiveX component can't create object" error. I...

Hadn't thought about linking to the tables temporarily. Will give that a shot. I can't keep them as linked permanently though because the database name changes and they won't let me keep the connection open permananetly.

I use Set db = DAO.OpenDatabase(TicketDB, False, True) to open the connection and then build a query in VBA to submit to the database.

I was thinking I could use some queries to pull the data into my primary database where I have the join query for the 2 vehicle tables but I'm concerned about performance if there is a lot of data.

I'm needing to pull information from one access database into another. The database that I am pulling from has undergone some changes so I can no longer do a straight join to get all the information that I need. Basic layout: Primary Table: PRD_Header (key field PRDKEY) Linked table...

Was wondering if anyone had experience using the FMS database analyzer and if so, if you were happy with it/recommendations? I've got a database that's been around since 2001 that could use some help. I'm slowly working though MS Access performance faq's to find things to update but was...

Thanks JHB, that did the trick. Can't believe I've been using access for 10+ years and this is the first time I've dealt with a cross tab.