Search results

Been a while before I could get back to this. Thanks, this worked fine and my code now runs smoothly. Oddly, when I put a breakpoint in and step through I get the same issue as described above. When I just call it from the form, however, it runs perfectly. Any clue why that would be? Not a...

Hi all, My db exports a query to an excel file (specifically a .csv file) with address data. I need to format the zip code column to the Excel Zip Code format before saving (otherwise leading zeros are omitted). After searching this forum I found an old discussion (from 2005) that seemed like...

Thanks all. I found a solution http://msdn.microsoft.com/en-us/library/office/ff845624(v=office.15).aspx I modified that to add a new record

Thanks for the reply. That alone didn't fix it, however. I'm not sure why. In any case, I needed to request input from the user to establish the new record. I found something else online and set it up this way: Private Sub btnAddSingleRec_Click() Dim db As Database Dim rs As DAO.Recordset Dim...

Was supposed to have attached the Db to this in the original post. Trying again here.

Hi All, I posted this in the Forms group on Friday and was advised to repost more simply. I also decided that I think this is a table/new record issue more than a form one. This Db assists with an annual mailing requesting certifications from vendors. I want to be able to click the blue button...

Hi all, My Db has a master table with a two-field primary key. I have a main form, based on a query that primarily grabs data from that table. The form has a subform based on a table which is the "many" side of a one-to-many relationship with the master table. I'm having a problem adding...

No prob. Running that I get this in the Immediate Window: Debug.Print Me.Recordsource qryMainSubForm That query is the source for the Combo's dropdown. I guess I still need to limit the query to what is returned for the specific Main Form Record. Thanks!

Sure. Private Sub cboCertYear_AfterUpdate() Dim rs As DAO.Recordset If Not IsNull(Me.cboCertYear) Then 'Save before move. If Me.Dirty Then Me.Dirty = False End If 'Search in the clone set. Set rs = Me.RecordsetClone Debug.Print...

Thanks. I added that line in, and I got Runtime Error 13: Type mismatch. Clearly I'm missing something here.

Hi all, I have a form and subform that shows when a particular vendor has certified compliance which must be done annually. In order to navigate among the various annual records in the subform I use a combo with the RecordSetClone property as follows: Private Sub cboCertYear_AfterUpdate() Dim...

Hi all, I have a problem very similar to this recent thread. Mine differs in that I don't have a single document or query. Rather the user can select the document. Basically I have a dashboard in my Db that allows users to open a Windows dialog and select a Word doc to open and run a mail...

Of course, thanks! For the benefit of others, I actually had to change it to 0 rather than just removing the quotes.

Hi all, I have a text box that should only be visible when one combo's value is "No" AND a second combo is Null. This is the code I have but it's not working; the text box is invisible at all times. If it matters, Combo368 is bound to Boolean field in a table, with the combo's Row Source Type...

Thanks. I'll read over it and hopefully it'll explain what I need.

Sure. The Db tracks certification requirements where vendors have to provide a compliance certificate to us annually. tblMaster has the basic information about each vendor: name, contract date, section ref., cert requirement, audit rights, etc. Many primary vendors have multiple contracts so...

Hi all, I suspect I'm missing a database 101 issue here, so apologies if so. I have two tables in my Db: tblMaster & tblAddresses. They are joined with a one-to-many relationship, with the addresses being the "one" side. Many entries in tblMaster have the same address. I use a form, based on...

Thanks that worked great. For the benefit of others, I had to make an addition because navigating to a record where the combo value had been selected made them both show up. I added the following to the OnCurrent event of the form and now the text box only shows if the underlying combo is...

Hi all, I'm curious whether it's possible to display the label for a combo within the box itself, i.e. it would say something like "Enter Name" until the user clicked on it and opened the dropdown? I found this which is really old and I couldn't get it to work...

Perfect. This actually works better than I had originally planned because once I select the combo choice the fields are populated so I can see what the changes are. I set the Cancel button to set all fields to Null If I don't want to keep the changes. Thanks very much for your help today!