Search results

Sure, I can do that tomorrow. I'd really like to see what I'm doing wrong. Thanks!

The column count is correct. I can get to any of the columns when I'm on the form that the cbo is on. However, when I am on a different tab which has a child table of the tab that the combo box is on - it won't work. I went all the way up to the Forms! level and came down the Project, then...

The combo box is fine - I use it from it's parent form just fine... I think I'll just find another way around this for now. Thanks for your help

Thanks Paul - but that doesn't work either. I've tried all kinds of combinations of form! and form. etc... but nothing seems to work. I have about 7 columns on the combo box, and the only value I can get is column 0 without including .column(0) Any other ideas?

Hi all - I hope that I explained this so it could understood... I am trying to retrieve a column's value from a combo box. I have a 4 tiered relationship and I put the first tier on the frmProjects, the 2nd level goes on the frmProjectAssignments and the 3rd tab is a child of Assignments, and...

Yes, I'm using 2007 - I'll check into the help documentation for the QueryDef - never thought of that... thanks

Hi all, How can I change the RecordSource of a report being called in VBA using the doCmd.OutputTo creating a pdf file? As others have mentioned, there isn't a way to create a where clause or filter on the following: DoCmd.OutputTo acOutputReport, "ProjectSheet-Delay", acFormatPDF...

This works great! I created one local table that I can use with all of my combo boxes that need to have an "All" selection. I truly appreciated your quick response to my question - you saved me a lot of time. PS My entry in the local table is <All> so it is always sorted first in a text...

How simplistic! Thanks I'll try that right now.

Hi all, I'm using Access 2007 and I would like include "All" as the first selection in my combo box then populate the remainder of the combo box from an existing table. There are two fields, the first is the Primary key of the table, and the second is a description. I believe that I can create...

I wanted to share this with everyone because it really stumped me. The above code of Lagbolt worked GREAT when I was working with a table located in my front-end database. But, that was just my testbed. The table that I wanted to work with resides in the linked back-end database which just...

I don't have a lot of experience with the ribbons, but what I did was create my own ribbons and excluded the buttons I didn't want to show. Some of the buttons are in groups so you may have to find the individual ones to add. Hope this helps.

First Evan, thanks very much for your suggestion - and maybe you can help me again... My problem is the index... I get the same error as I mentioned above, 3251. I haven't had any problems with linked files before with either DAO or ADO, until now. I am writing to a many to many relationship...

I see you solved your problem, but maybe another way would have been to set a unique alternate key on that field. Then, the database would automatically stopped the duplicate entry.

Hi all, I wrote this routine temporarily using a local table in my front-end database. No problems... however, when I changed it to use the linked table, I'm getting the famous (I've seen so many conversations concerning this...) VBA: 3251 error - Current provider does not support the...

I truly appreciate your advice - and it works perfectly. Once can be so close, yet so far away.

Hi all, I've never used foreign keys for searching before... so I've researched all morning and I can't find any samples of how to use a unique foreign key that is comrpised of two long fields in an ADO recordset. Maybe it has to be DAO? I want to add new rows to tblEmpSkills from data in...

Thanks for the "mind" refresh - I was so close but I just couldn't remember exactly how to do this.

I spoke too soon - my query has a parameter and the domain of the dCount method states that no parameter queries are allowed. So I guess I'm back to the recordcount method of the recordset. Thanks Ken for the suggestion. I'm sure that I'll make use of this function in the futuer!

Hi Ken - and thanks for the quick reply. I never heard of this function, but from what I see on the help documentation, I think it will work perfectly! Thanks very much and have a great day!