Search results

Being as you did not explain what the "try" table is, I'm going to assume it holds only the description of the machine that you're attempting to add from your combo box. Design flaws aside, the simple answer to the problem you're having is related to the Bound Column of your combo box. By...

I'm making an assumption that you have a date stamp in your purchase history table. With this in mind, you can set the criteria of the query for the date field to MAX, this will show the latest date in that field. HTH Guy

Thanks, I kind of figured i'd need something to be able to see how they interact with each other. This will probably let me know at least part of the puzzle.

First I'll preface this with I have no idea if this is even possible. I have a personal database that I use to categorize and calculate totals on my bank transactions. As it stands now, I login to the online banking, export a .CSV with the transactions, import it to the database, run the...

Nope, you're basically spot on. I just didn't know if there was something I was completely missing by doing it the way I currently was (that would also be less complicated). My other line of thinking was using code to do it, but I quickly realized that while the query pane would look much...

The data queried is specific to the division, so you'd have for instance a Managed Portfolio report that has all 8 or so divisions totaled and then the same report for each individual division. I guess i'm not following what you're inferring as far as being partially the answer. The treatment...

It's cumbersome to produce and make changes to a report if it's required. I'm concerned that should someone else need to take this over it could be a nightmare for them. I know it currently like the back of my hand, but it's not exactly simple to understand all the moving parts at first glance...

I've got a large amount of reports that I generate on a monthly basis. As it currently stands, it is clunky, large, and takes a while to process. It's actually about 90 reports, each Report makes a page in the actual report I present to management. It's a portfolio report that shows asset...

Yep :) Mine was used in a complex form that I had. What you've described should work with PK/FK's. Sorry for the confusion.

Hi, Thanks for posting your question here. Glad you found us! I've had a similar implementation of this in one of the databases I manage, hopeefully this might point you in the right direction as well. This function iterates through each line of the table looking at, in this case, to see...

Hey all, looking to run a SAS project from within Access 2003 via VBA. If somone could point me in the right direction i'd appreciate it!

I did a little bit of reading in a reference book and found a handy object to use: InStr Below is the code i came up with to iterate through the transactions in the table, identify and set the category based on a description definition table, and move to the next transaction. Dim dbDatabase...

What I'm trying to think out is a way to take a list of bank card transactions and categorizing them from the transaction description provided by the bank. The way I envision this working would be to have a table to hold a list of description keywords. These keywords (such as "McDonalds")...

*Sigh*... WHERE [Acccount-Number] = " & Chr(34) & AcctNum & Chr(34) I've been looking at this for close to an hour and didn't notice that. Thanks again. I'm an idiot :P

The only queries it has are AssignGuar,AttorneyDel,AttorneyDetail

Ah yes of course... i changed it, but I'm still getting the same error.

It is indeed.

Nope, the name is a bit misleading. CAM_PORTFOLIO_QUERY is actually the name of a table. It was existing in the database before i got a hold of it, and I just haven't renamed it yet.

I am getting "Too few parameters. Expected 1." error from the above highlighted line.

This is the code i'm using, error line highlighted: Option Compare Database Public Function VerifyAcct(AcctNum As String) Dim dbDatabase As Database Dim rsAcctNumber As Recordset Set dbDatabase = CurrentDb Set rsAcctNumber = dbDatabase.OpenRecordset("CAM_Portfolio_Query", dbOpenTable) With...