Search results

Thanks for the help all!!! I adjusted my SQL Statment with the correct format and updated the txtID to txtNumber on the my SQL statement. The SQL statement is giving me the desired result when I run it by itself. When I use the form I am still having problems unfortunately. The SQL Statement...

I have been working on a form to do so quick calcuations for me. I built a SQL stament and a form for me to enter the data. I have a txtbox called txtNumber, where I enter the number of the Seller and run the query which will display the totals for that seller in my form. The problem i am...

Sweet Works Great!!! Thanks for the info :)

Hello all, Is there a way to improve my code? Here is my code: Private Sub STATUS_AfterUpdate() If Me.STATUS = "CLOSED - INVAILD" Then Me.TimeStamp = Date End If If Me.STATUS = "CLOSED - FUNDED" Then Me.TimeStamp = Date End If If Me.STATUS = "CLOSED - DENIED" Then Me.TimeStamp = Date End If...

Hi all, I have a question; I am trying to build a form which a user can enter their ID#, press the button OK and the form will filter the query so the form can run some basic calculations for the user. I can’t seem to get ID to transfer to the query correctly. Any help would be greatly...

Thanks so much for the help. I pasted the code in the wrong area. It works great now!! I just want to thank you both for all the help and advice you have provided. Thanks again

Still no luck with the code. Here are the two screen shots. Hopes this helps :) Thanks Again

Thanks for the post. I am trying to build a custom display form :) I am still getting the #error here when I placed code in the control source for the Main Form txtbox: =IIf(Nz([MTDfundedTTL]) Is Null,Nz([MTDfundedTTL]),0). Thanks again.

Hello All, I need some help with a form problem. I have a main form which reads data from a sub-form called tbl_referral1. The problem I am having is when there is no data in the sub form I get the #error on a txtbox in my Main form designed to read from the sub-form. I have tried using...

Sorry, I am a still new to SQL Statments Can you give me a example of what you mean?

I have a question I keep getting a error when I try to fun my SQL Statment. Access says I tried to execute a query that does not include the specified expression 'Time Closed' as part of an aggregate function. Here is a sample of my Statment: tbl_referral.[Time Closed], tbl_referral.[MBR...

Thanks for the link, its a great help

Hello all, I am trying to build a form which will allow a user to a enter data and once the data is entered the User would click a button and the query the form is attached to will have the filtered data. Example: The User enters a User ID and then presses enter. The query will take the data...

Hi Guys, I think I have a problem, I didnt notice this before but for some reason my SQL Statment does not pull all the dates I am looking for. Example: 3/1/2009 3/10/2009 3/11/2009 pull normally, but 3/9/2009 does not pull on my search. Here is the updated SQL Statment:WHERE [Time Closed]...

You are a Genius!!! Thanks for the Help

Hello all, I am trying to make a query which displays all my records which are with in a date range and also the ones which do not a value yet. Example: Search: My date range is between 3/01/2009 to 3/06/2009 Records Found: Blank, 3/01/2009, 3/09/2009, Blank Here is my Sql Where...

Hi, Does anyone have any examples of how to do a search for any part in Access. I would like to be able to search for the word APPLE and get the data with any fields with the word APPLE. Example: Search: APPLE Result: apple, apple pie, apple color Thanks, Mike

Sorry for the late reply, You are a genius it works beautifully!!! Thanks, ALL

Thanks for the help. Yeah i am trying to update only the current month info and [DATE REFERRED] does not include the time. I tried the update but I am not getting anything in the update query, I think I missed something. WHERE (((tbl_referral.STATUS)="CLOSED - FUNDED") AND...

Thanks for the help. I built a Form and a Sub-form to tryout the code and listed a screen shot of it. I am having poblems getting the data from the subform to update all the Wigets and Cogs with in the date range with the new payout. Any pointers on what I might be doing wrong thanks Here is...