Search results for query: *

I have a main form with 3 subforms. The forms all worked well where the subform 1 is all our products, subform 2 is the customers who take a product in subform1, and then subform 3 is the order qty by location. It works great. However, I just added a new dimension which kills me now. I...

How can I automatically make each record's data capitalized in each report field? Molly

I have a date field named CallDate. I have this field in a report header. I would like it to show the day of week. EG Monday or whatever the date converts to. I tried in the field on the Format row: =Format([CallDate],"dddd") but i received an error. It came back as...

I need a way to choose records based on the last monthID and the associated FormulaID. Maybe like a 2 field MAX problem ?? Attached is a small file to try. I need to records to show up in the query 8510Qry-P05 Total Fixed Cost The 2 records would be for: 692030 for month 200908 692744 for...

Could you point me in the right direction regarding the following. Maybe their is a white paper or an example. Or at least the terminology to help me search the internet. I would like to pick choices from 3 groupings that are on a form. The combination would be the basis for a query to run...

I am trying to take a date like 5/31/2009 and convert it in a query to 200905. The following does not work for me. Purchases MonthYear: Format([PO Date],"mmmm" & " "&"yyyy") gets me an answer of 2009 May I desire 200905. Thanks for your help.

Hi. I put a small sample file for you to check if you have time. I am drawing a blank. http://www.savefile.com/files/2084002 I need my subform to stay in sync with my Main form at all times. Initially, it does so. However, if I change my mind about 3 main form fields (cboSoldtoID...

I have another combo box for a customers affiliation. It works fine. I would like to refine the lookup to give me only the records that apply. For example, I may lookup an Affiliate named Jones Corporation and get 30 correct records. However the rest of the records show from 31 to 1800. I...

I am getting an error about Focus in my lookup combo box: "You can’t reference a property or method for a control unless the control has the focus." Look 9 lines below where i remark, "'next row is yellowed in the debug". The vba is from an earlier tek-tips request which worked fine in a...

I have a cross tab qry shown in datasheet view on a subform with no problem. It shows years as rows and three codes across for a price type. Later, If I add a new price type code, which will become a column in the cross tab, I will need to edit the subform for this fourth column that shows on...

I need to lookup records with a partial name. EG If I type pepper, i would like to see all records that have the word Pepper somewhere in the description. My current After Update only gives me records that "begin" with Pepper. However, I would like to see my choices for Pepper if the word is...

I need to figure out a way for an autonumber to also post to another field on the same Main form. i have a Main form with a few subforms on tabs. The Main form has a unique autonumber FormulaID. I need this main form record to post the FormulaID into another field which is in the same...

Is it possile or is there a white paper on the following. I would like to make a combo box on a form that contains say 60 products. For simplicity, the underlying table has 2 fields: CustID and ProductID. The objective is to pick say 10 products and run a report command button to see what...

I have a form button. I would like to add a message box that asks if you want to proceed to run a query. Here is what I tried unsuccessfully. I called them part1 and part2 for illustration. Can you help me? ============================================ Private Sub...

Is there a way to have report field us a certain color for a certain answer? I have a report field named "Visit Name". I has 2 possible answers. The visitID is either 5 or 100. I would like the visit names that have a visitID of 100 to show as RED in the report visitID column. I would leave...

I have a subform which i show in datasheet deault view mode. There is a field NAME called cboProductID with the CONTROL as ProductsID. In this datasheet view, the field title shows as cboProductID. I would like the title to simply say Products when i am in the datasheet subform. Is this...

I have my own startup form which opens up find during startup. However, for 4 or 5 seconds, I see the white Access screen that shows files, qry, forms, etc. Any way to avoid this and go directly into my startup form immediately? Thanks Molly

I am having 2 problems. In my subform1, I can choose a category value fine. Then in subform2, I need to choose a value which pertain only to the subform1 choice. I cannot get it to work. EG in my little sample file, if I choose baseball MITTS in subform1 cboFlcID field, I would like to pick...

I have an event on the main form. I would like the AccountID (field #2) background / fore colors to change whenever i click on the CheckActive (field #1) name field. Presently, this all works fine if i go to the next record and return back. I would like to see the AccountID field colors to...

I have a customer who uses an apostrophe in their name. Below is my On Event and On GotFocus vba for my lookup combo. It works. however, not for this 1 customer named EG .... Wilson's Battery. Is there a way to fix this? Thanks. Molly ---------------------------------------------- Private...