Search results

Hey guys. I'm getting this error message when trying to delete something from a recordset based on a query. Basically if there is a negative number in the recordset, its purpose is to cancel out a positive number of the same value. So what I'd like to do is delete all negative rows and the...

Is there any way to programmatically change the selected index of a combo box in Access 97? .SelectedIndex doesn't seem to be included in this version.

Hey guys, probably a simple question but I can't figure out how to step thru a combobox. I just want to fill an array with every item in the combobox. The combobox is named Combo95. Any ideas?

Well I actually just solved my problem :) Made a seperate Append query, which used the first query for its fields, and kept the first query as a Select. This seems to work fine. Thanks for the help.

Oh I understand the questions, thats no problem. Yes, the combobox is basically a search box that lets the user select a customer from our database. The other table is basically one where I want to store the results from the query (StartDate, EndDate, and Use). And you're correct, I am using...

Sorry let me tell you more information on what I'm doing. The number in the combobox is a SiteID, basically it identifies a customer. The query then uses this to pull up an electric usage profile from that customer for the last 12 months. What I want to do is insert this information into a...

The row source for the combo box is from a different query

It is pulling a number from a Combobox on a form. How would I get around this?

Hey guys, having a problem. I have a Select query. If I open the query in design mode, change it to an Append query, enter the table to append to and run it, it works fine. However, if I save the query then close it, and run it again I get this error message: "An action query cannot be used as...

Yeah I see where my error was, thank you. Used your third suggestion and it works perfectly thanks a lot.

Hey guys, can anyone tell me whats wrong with my syntax here? Not sure where I'm missing quotes, or whatever it is I'm missing... PreviousAverage: iif([BeginDate] <= DateAdd("m", -12, Now()), 0, DLookup("[AverageforPeriod]", "qry12month", "[BeginDate] = DateAdd("m", -1, [BeginDate])") The...

Hey guys, have a question. I'm using Access 97. So I have a linked query I made in query designer. What I'm trying to do is call a VBA function I have in a module from the query designer. What this function needs to do is check if we are currently on the first row of the query (or the earliest...

Thanks for the welcome :) Yeah I actually figured out what you guys said about 2 minutes after posting this. Don't know why I thought this was possible. Looks like I'll use the average method. Thanks for the replies.

Hi all. I have an Access97 database. I'm currently having a little trouble with a query I'm making. Basically, I have to pull a customer's electric usage from the past 12 months. That part is easy. However, I need it sorted by month, like January 1st-31st all summed up, then Feb, etc. The...