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...

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...

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, "")...

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...

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...

Not sure if this should be a query question or a report question so I'm starting here. I'd like to create a report for the number of tickets each officer wrote within a date range. There are multiple ticket types (examples: MV4016, Parking, but there could be more). I can generate a query...

I've got a database that's been in use for 10 years and there's ~ 40 copies of it out there now. I have dtmInitialAppearanceDate in the database already and have it stored as short date in the column definition. Some newer customers are asking that I now also store the initial appearance time...

Ok, weird one here. When I try to get the .text value from a combo as the user is changing the value, I get a "Control must have focus" error. But it should have focus, I'm editing the @#$@# thing. Here's the only code on any of the control events: Private Sub cmbDefendant_Change()...

Ok, This may have been covered elsewhere, I'd love URL's to point look at. I have a table in the system that lets the user add payment plan information with the following info: Start_Date (date plan starts), Days_Between (days between each payment, 30 is default for 1/month), Payment (amount...

I'm working on a project and wasn't sure if this post should go here or in the VBA section. Since its more of a theory question figured I'd start it here. I need to read data from a 3-rd party Access database and pull the data from 3 separate tables in the remote database into a single table...

Question for the crowd: I have a a split database that's in use. Several of my customers have asked me for a limited version of the front-end that has a limited menu and only a couple of the forms available to users. All the data is read-only in for these users. I'm trying to decide if I should...

I have the following function that is supposed to return the full path to MSAccess.exe. It works fine on XP, Vista, Win 7 if they are all 32 bit but its failing on the second call to OpenSubKey and not getting anything back. I've looked in the registry for the sCLSID returned from the first call...

Currently my access application runs with Office 2007 and expect some of my users to start migrating to Office 2010 after the first of the year. Problem is, I need to support both at the same time. I currently have references to Excel, Word, and Outlook in my VBA. Anyone have recommendations...

I needed to write a comaddin to be able to read information from a web service for my Microsoft Access application. In my form_load() sub I have the following code to make sure the addin is loaded and it gets synched up with the controls on the form: With COMAddIns("myAddinName.Connect")...

I've added a reference to a vb.NET .tlb file. One of the methods in it is: Public Function getMessageList(ByVal agency As Agency) As <System.Xml.Serialization.XmlElementAttribute("receipt")> Receipt Dim results() As Object = Me.Invoke("getMessageList", New Object() {agency})...

I need to retrieve data from a web service. The only way I've found of getting at the service (and its data) is via a .NET add-in for Access. Within the add-in, I've followed the instructions from http://msdn.microsoft.com/en-us/library/aa902693.aspx to tie the add-in to a form in my Access...