Search results for query: *

Hi Duane. Thanks for the reply. I hate to sound like an idiot, but could you explain further? I've been playing with the SQL statement and can't seem to get my head around the proper syntax. One additional question, if I may. I've just been informed that the report needs to calculate...

Hi. I have an Access2000 database that tracks Broker commissions. For example, BrokerA had sales (and commissions) for Ins. CompanyA, Ins. CompanyB and Ins. CompanyC this month. BrokerB had sales (and commissions) for Ins. CompanyA and Ins. CompanyD this month. BrokerC had no sales (or...

Hi Duane. Thanks for the prompt reply. Here's the info: 1)Form Name: CriteriaInput-TopProdMonthlyRpt Record Source: tblBrokerInfo Field1: Name: BrokerName ControlSource: None RowSource: SELECT tblBrokerInfo.BrkrID,tblBrokerInfo.BrkrLN...

Hi. After reading FAQ # 703-2696, "Use a form and query to send criteria to a report.", I decided to try it. I have the report and query working ok if I have the query ask for a parameter. For example, i set, [Please enter a last name] in the "LastName" field of the query...

Hi. Out of the blue I'm getting an error message when trying to enter data into a subform. The main form is used to select a employee from a table and the subform is used to gather data for the employee selected. All was working well and now I'm getting the following error message when...

Hi Roy-Vidar. Thanks for your response. Now that you mention it, it HAS been pretty lonely...<laughing> To answer #2 first, Here's a representative part of the CASE statement: Select Case CmpnyName Case &quot;Unity Life&quot;, &quot;Liberty Health&quot;, &quot;Benecaid&quot...

Anyone?

Dang. I spoke too soon....For some reason it cleared, but now, while testing (nothing changed except I'm trying to figure out how to place an informational message on the screen when a certain condition is met in a SELECT CASE statement. I put MsgBox(&quot;Please enter an amount&quot;,vbOKonly)...

Well...Just when you think you got it figured out. The &quot;=&quot; sign was the problem...The Expression Builder function automatically places an &quot;=&quot; sign in front of the <tablename>!<fieldname> expression even though you don't need it... Thanks anyway!!! Mark

Oops. The ControlSource &quot;name&quot; that was created has an &quot;=&quot; sign in front of it. =[tblBrokerMonthlyData]!BrokerFYCMS Again, many TIAs Mark

Hi. I added a new field to an existing table and now want to populate that field from an existing form (subform actually). I created a text box and, using the expression builder on the text box's ControlSource property, created the following syntax: [TableName]!NewFieldName I'm getting a...

Ok. This is how I did it. The user won't ever have to input any data into this calculated control so I set it's &quot;Locked&quot; property to Yes and it's tab stop to Yes. Now the person enters the commisson rate, hit's the <TAB> key and the focus goes to the calc control box and a message...

One more question if I may. Unfortunately, I must save an &quot;answer&quot; from one of the calculated controls to my database. I know...it's taboo to save data from a calculated control. Is it possible to have the calculated control &quot;save&quot; the information to a field in one of my...

Hi all. The Select Case statement is working perfectly! In fact I've got a nested Select Case working. Many thanks for the help. You folks are great!! Mark

Hi. I have a form with a subform. The main form allows an employee lookup. The user selects an employee name from a combobox which then displays that employee's info (address, phone, etc). If the employee chosen is correct, the user presses the <TAB> key and the focus moves to the subfom...

Hi. Thanks for the rapid response. Neither suggestion is working, but I think it's a syntax thing. nberryman: I tried creating a macro in the &quot;After Update&quot; property with the &quot;Set Value&quot; function with the following: item: [tblname]![tblfield] (table/field where the...

Hi. I know it's a bit of a taboo to save the value(s) of calculated ,unbound text boxes but I find it necessary to do so. I used the &quot;AfterUpdate&quot; property in the calculated text box to copy the value to the field in my table. What would be the proper syntax as nothing is being...

<patting myself on the back> I realized that the SELECT CASE InsCo line was wrong. To make it work, I had to make &quot;InsCO&quot; match the field that the CASE statements was testing. It was spelled wrong. DOH. Anyway. MANY thanks for all the help. Mark

Ok. I just sh**canned the above &quot;trial&quot; and went with the case statement. I followed Krystoff's (Chris) advice and created a CASE statement in the AfterUpdate property of the Company Name box on my subform. I'm not getting any error messages but nothing is showing up in the...

One big OOPS on my last post. I just realized that I'm getting errors because it won't place the formula from the formula field into the control source property and process the formula. It's trying to place the actual formula string into the unbound field. At least that's what I think it's...