Recent content by MarkRCC

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