Search results

I've looked at multiple threads concerning working with null values and how to get a hard number in place of the #error message. I have tried multiple ways and none seem to work. Am I overlooking something. In my query the Column ABC comes up with a number from a calc in another query or...

Thanks Brian. I've used that method before fairly often. Not sure what made me forget it this time. Thanks for the friendly reminder.

I have a query that pulls up data from two different plants with inspection dates. I'd like to place a conditional date range in the criteria. I tried IIf([assetarea]="West Plant",Between #6/16/2008# And #12/15/2008#,Between #2/20/2008# And #8/19/2008#) The query returns with no records...

I have a form that is unbound. Information is entered into the form which populates a subfrom via a query and when the Save button is clicked an append query is ran to add the records to the final table. I have a listbox on another form that displays all the records in the table. I need to be...

I appreciate you taking the time work on this. I don't really understand alot of VBA yet so I'm open to any shortcuts on reducing the amount of code. Thanks again

Thanks Moniker

Returns the same error message when ran in the immediate window. I don't know if it matters, but I started out the database with the listbox and double clicking to open the selected record. Then I incorporated the search tool to filter the listbox. Thanks for your help thus far.

Same Error in this line from Private Sub tanklist_AfterUpdate() Me.RecordsetClone.FindFirst "[tankno] = '" & Me![TankList] & "'"

I'm using the following code with a listbox and the Cool search tool. The search is working fine. The problem occurs when I try to click or double click a filtered record to open another form and I get the errer "Runtime error 7591. You entered an expression that has an invalid reference to the...

My first question is where would I put the VBA code and the second question is can you point me in the right direction or at least a source that can help out. Thanks

I'm going to try again. I have a query with InspDate and lbsperhour. I need to be able to insert any StartDate and EndDate and get the sum of emissions. For start/end dates not associated with an actual insp date, I need to assume the value of the previous inspection for however many days until...

I realize this is an old post, but would you mind sharing how you interpolated the values. Thanks

I realize this is an old post but I am needing a little clarification if anyone is still connected. I implemented Jon K's strategy for returning all records if the parameter prompt is left blank. However, what is the syntax for a situation where you have a Between [startdate] and [end date]...

Resolved with the following Application.FollowHyperlink "hyperlink", , True, True

I am already able to use the Between function to retrieve the information between inspection dates. However inspection dates can be from 1 hour to 33 days apart. So, if I just want to know the emissions for 1 month (jan1-Jan31)the returned value will actually be from Jan1-Feb 3 (in the case of...

I have a query that has InspID, InspDate, NextInspDate, Emissions (calculated by multiplying timeelapsed by associated InspDate Result) I have another query based off this query that sums the Emissions between two selected dates. This works fine as long as the dates I select are actual...

Did you ever find a solution to your problem. I've been playing with the following line of code attached to a command button. DoCmd.RunCommand acCmdViewFieldList But am having trouble getting it to work. Any Ideas?? Thanks Problem resolved by creating a custom toolbar with only the...

I'm pretty sure this is possible, but am having trouble figuring out how. I have a combobox that lists values from a query. The values are passed as parameters to the report. There are 5 values in the list. When any 3 of the 5 values are selected I need to change the report parameters to include...

Let's say I have a query on a form that returns results. Is it possible to double-click a record in the recordset and open a form. I am currently doing this just fine from a listbox, but am wondering if it is possible from a query.

I have several hyperlinks linked to an excel file on an internal company server. The problem is this. I can open and view the first hyperlink I click on with no problem. However, after I close the new window and click on a second hyperlink, the new window freezes up and won't display it's...