Search results for query: *

I'm trying to set up my query where I can enter a part of a name and it searches by that. Here's what I put for criteria: Like "[Enter Name]*" So if I entered Bob, then all fields starting w/ BOb would come up. Bob Jones Bob Smith Bob Miller Thanks

I have a report that shows: Dlr, Count_of_Delinq, Min Days, Max Days It shows up fine. But what I'm trying to do is only show those with multiple counts.(leaving off the ones that have only 1 count.) I've tried coding, here's what i have: If txtTotalDays > 1 Then txtTotalDays.Visible =...

I am totaling all cost for different dealers. I have now 4 different categories. The way I have it now is: Each dealer has at least one acct, Each category is added up for each account giving me a total cost of the dealer for that category. But I am needing the 4 categories to be added up...

I have 2 controls on my form that are for comments. txtComments txtComments2 My comment section was a memo datatype but I changed it to text. On my reports, my comment box(when it was memo) cuts off at 255, so I'm going to make 2 comment sections. I'm trying for this: When the txtComments...

I am having trouble setting up a query. I have created a query to grab records containing info from 2 tables. The following is what is that query: curGcost curGrefund curSCcost curSCrefund curCLcost curCLrefund dtmAll Expressions: Total Cost: Sum([curGcost]+[curSCcost]+[curCLcost]) 'this...

I am trying to get all records that have been delinquent in any part for 45 days. Each record has these categories: G, SC, CL, O. Not all records have data in these categories. Here's what I have: I have an expression: Total: Sum([dtmGrec] - [dtmSent]) dtmGrec is the received date for...

I am trying to create a DAP from a query. I did create on from a query that pulls up all records past 45 days. But I tried with another query and it didn't work. I know the query works b/c I run reports off of it. It does the same as the first query but also seperates the information by...

I have created a query that pulls records that are > 45 days. My query has these fields: Total_Days: Sum(Date()-[dtmSent]) - Total - Expression, Criteria - > 45 (on 2 lines) chkAll - Criteria - False (on 2 lines) intDealerNum - Criteria - Like "121###", Criteria(2nd line) - Like "124###"...

I have a form with 5 different categories. I have 5 different types of costs: G, SC, CL, O, M. Each of these fields have 3 controls: Cost, Refund Amt, Refund Date. When the cost is $0.00(customer does not have this), then the refund amt and refund date controls are disabled. how could I go...

I have a report based on a query. When I bring up my report, memComments, will not show up on the report...instead it shows a tiny square box. Any help is appreciated. Thanks!

I have a form, its based on a query. That query contains an Autonumber(intID) from a Table(customers). I also have another table(dealers), that uses the ID number as well. Next to the dealer info, I can click the "+" and it'll show all customers pertaining to that dealer. I've seen some that...

I'm pretty much knowledge-less when it comes to programming. I was wondering if anyone could give me a tip or something on this problem I have I based a form on a query. The query contains two tables(Acct, Dlr), which are related by one field called DlrNum(combobox). On the form, I have the...

I'm having trouble with a form. I believe the Auto Lookup Query is the way to go...but I may be wrong. Here's my Form and Subform Form is based on a table called Warranty SubForm is based on a table called Dealer They are linked by Dealer# field. The MainForm consists of a person's...

I have a 2 categories, G and SC. Each of these categories has Cost, Refund, and Rec textboxes. I'm trying to get a checkbox(chkAllRec) to automatically be checked when the G-Refund, G-Rec and SC-Refund, SC-Rec is typed in. DOn't know if this part matters, but...I also have where if the G-cost...

I have a Form with a subform. The subform is linked to the form by strD# The subform has these fields: strD# strName strContact strPhone strFax strUpdate If someone makes a change to the record(minus strUpdate) in the subform, a textbox, strUpdate, needs to be filled with the current date (ex...

I'm guessing that this will take coding and I don't know coding very well. I have 4 categories...I'll call them A B C D. For each category, there is 3 text boxes, EX: A Cost, A Refund, A Rec Date I will have a checkbox for when each is rec. but not all accounts will have every category(A, B, C...

I have a spreadsheet that i need to make a copy of and then link that copy to the original so when someone goes into the copy, they see the updated information as well as being able to enter information and i can see the information that they entered(from the copy) in the original. Thanks

Is there any way to be able to run a query through a data access page?