Search results

Hello all, I've recently upgraded a 2003 database to 2007. When I try to update the linked tables using the linked tables manager it shows the tables in the old .mdb file. When I select the new .accdb file and then try to start the update it gives the following error message: "The Microsoft...

That was it. Thanks!

I have a query that is sorted in ascending order by date. I created a form with a subform that pulls data from the query; however, when the data is pulled into the form it is no longer sorted by date. It seems like this should be pretty straightforward but I can't figure it out. Any thoughts...

No limit on the query, as far as I know. It's just a straight select query. There is one table that has tables linked to it; however, there is no missing data. Just created a new query and now it seems to work...ugh.

Hello all, I've got what's probably a simple problem, but I can't see the trees in the forest. I've got a query setup to pull data from a table. When I add new data to the table and then open the query, the query will not show any of the new records. Thoughts?

It was bound to the right column, I just had something messed up in the query. Thanks!

Here's one I can't figure out for the life of me. I have a form that is pulling data from a query. There's a combo box on the same form that pulls data from a table. The table consists of a primary key (auto number) and one field that is text. The combo box is bound to the primary key, but...

Care to provide an example? What I have is: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmTesting" stLinkCriteria = "[Category]= Financial" DoCmd.OpenForm stDocName, , , stLinkCriteria What happens presently is a critera box will open asking for a...

Is it possible to open a form using a command button and having that command button pass the query criteria as well, ie, When you click the button, it opens a form and provides the query criteria to the underlying query as well. The query criteria would be fixed; the user would not need to...

Good suggestion. I'll give it a shot after I let the smoke in my head clear out a bit...

Nope, nothing. Searched through all the code for the entire form, searched all of the controls on the form, all the fields on the form, and so on and so on. Guess I'm going to have to rethink this and start from scratch. :(

Here's the REALLY odd thing now...yes, I was trying for a control on the form named CATEGORY, but before I got your last message I removed the CATEGORY control from the form, the query, and the reference in the command button event, and it still asks me for a parameter for the Category...

No dice, still get a request for a parameter for Category

Thanks, I'll give it a shot.

Hello all, I've got an interesting situation that I can't figure out for the life of me. I have a form where users can select a control number from a combo box. They then click a command button which passes the control number they selected (and the associated control data) to a form. It was...

Yep, that's it. Thanks!

Hi all, This is probably way more simple than I can imagine, but for the life of me I can't figure out how to work this. I have a simple table with three fields in it, one of which is date/time. I have a form for entering data into that table and all I'm trying to do is have the date...

I'm sitting here laughing at myself because I'm such an idiot. Standing in the forest but can't see any trees. Ugh. Thanks. That worked!

Nope, CategoryID is not an auto number. It's a fixed number that is either 1, 2, or 3, and I need the form to open only those with a CategoryID of 1.

Unfortunately I can't post the DB as it has confidential data in it; however, the event that occurs when I clink the command button on the first form is: Private Sub FinancialButton_Click() On Error GoTo Err_FinancialButton_Click Dim stDocName As String Dim stLinkCriteria As String...