Search results

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. Thanks for the help.

I don't know code that well. I'm trying to count for all curGrefund fields in my report. I need to count only those that have a dollar amount. I do not need to count the ones that are $0.00. THis code works but I wanted to make sure there won't be any problems down the line. Thanks for the...

I am trying to use conditional formatting in my report but I am having trouble. I am trying to get these fields to be bold: txtName curGcost curGrefund curSCcost curSCrefund The condition is: Expression Is [chkDealerVisit] = True When I view my report, it comes up with the appropriate...

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 a comments on my form. I have contacts with them having from 1 to many customers accts. I am trying to come up with a way to update the comments for a contact that adds those comments to all their customers records...but not to those that have been closed. How would I add these...

I am having a problem when I enter data into my form. I have two controls that are currency and 1 that is date/time. If the first currency control is 0 or null, then both the others are disabled. If I enter 0 or delete the default "$0.00" in the first control, the 2nd control will show...

I created a switchboard and when I click on it to bring up my form, the search functions on the form won't work. I created the search through the combo box wizard. It gives me this error: Run-Time Error '3021': No current Record. Any suggestions? Thanks

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'm getting this message when I try to check Cascade UPdate and Delete. I have already a relationship between the two tables(One to One): "INvalid field definition "intID" in defition of index of relationship." intID is what connects my Customer table and Auto table. In the customer table...

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 have a form based on a table and I just added 3 fields to the table. When I go to the form to add these fields, they do not show up in the field list. I've also tried creating a textbox and going to the Data Tab and choosing the data source but those 3 new fields are still not showing up...

Does anyone know of where I can find something on how to create a Find button? I don't want to use the one you can create through the command button wizard b/c its not what I want. I need it to do a search by one control. If I use the wizard Find button it will be a pain for the user, with...

I have a subform and when the controls on it are updated, changed from previous info, then I need a control(called dtmUpdate) to show the current date (=Date()). How would I go about doing this? Thank you

I created a form based on a query. When somenoe chose a certain number, I needed for it to fill in other fields once that number was chosen...that was accomplished...BUT...what if someone adds a number that is not in the list. I do have the Limit to LIst set to No. When I type in a number...

I have a Subform on my form. I am trying to get it to be filled in when someone does the following: Enters number into txtNum and then clicks on the OK cmd button. The form is based on a table called Cancel. The subform is based on a tabled called Deal The controls on the subform are as...

I don't know code very well...go easy on me. How would I code something like this... I have a checkbox that needs to be checked when BoxA and BoxB are not 0 or null. I'm pretty sure how to do it if it was just Box A, but two I'm a little lost. I don't think I need two If statements. Thanks...

everytime i try to tab from my subform, it creates a new record for that subform. Also, about the subform, the control that links the main form and sub form is unique. I have now set my Cycle property on my subforms and forms to Current Record. How can I tab from the subform to the main form...

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...

When I create a form, it will not allow me to edit or add or delete. I can only view it. Allow Edits, Additions, Deletions, FIlters are all set to yes. Also Recordset Type is not set to Snapshot. Could someone help with this? Thanks!