Search results for query: *

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

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

Hi. I'm working on a form with a related subform. On the form, I use a combo box to find a name(person or company which then populates the main form with that persons info. Works great. I then tab down to the subform which allows me to enter transactions for the person or company listed on...

Hi. As a newbie to Access I have received tonnes of GREAT advice on building tables in the &quot;tables and relationships&quot; forum. I'm now in the process of building forms and subforms, etc. My basic database requirements and table info is listed below. I have already built the basic...

Hi. I've been assigned the task to do the following and hope you fine folks could give me a few ideas on how to set up my tables, etc. Task: Create an access database program that would track the commissions of approximately 1000 independent brokers on a monthly and YTD basis. These brokers...

Hi. I have a field within a table (2 fields total: company name & rate) with the following settings: field name: rate data type: number field size: long integer format: percent decimal places: 0 default value: 0 The default value in the field itself shows: 0%...

Hi. When trying to do a Windows update, I clicked on &quot;Scan for updates&quot;. The message, &quot;Windows Update is looking for available updates....0% Complete&quot; appears and then hangs there. I've tried Microsoft's suggestions of clearing cache, removing the installation...

Hi. I hope this is the right forum to ask this question. If not, please direct me to the proper one. I have a SQL database and would like to have a listing of all the tables in this database as well as the linking relationships of the tables. I'm running SQL Adaptive Server Anywhere v...

Hi all. I was hoping one of you fine folks could shed a bit of light on these sore eyes. I'm trying to set up a website using IIS 5 on a Win2K server (patched current). I'm pretty new using IIS, etc, but though I had everything set up properly. My problem is this. I've put up a test page...

Hi. Running Office 2000 on a Windows 2000 Pro workstation (1.8 GHz Pentium 4 with 256 MB RAM). Just installed Office 2000 on this workstation and all works fine except for Excel. All opens fine and seems to work ok until I highlight either a cell or a column and try to set bold, centre...

Hi. Environment: NetWare 5 (patched current) network Windows 98/2000Pro workstations (patched current) Question: I recently upgraded my workstation from Windows 98SE to Win2K Pro. Under the Win98 OS I could run &quot;RCONSOLE&quot; from the RUN command line and log into my...

Hi. I hope this is the right forum to ask this question. If not, please tell me where to go (you know what I mean!). I'm currently running SQL Anywhere Studio 6 and have a 5-user license. I'm in the process of purchasing an additional 10-user licenses and wondered if someone could walk me...

Hi. Just wondered if it was possible to do the following: We have a MS Word 2K document (staff phone list) that I would like all GW users to have access to (Read Only/Print rights). Is it possible to just place a pointer/shortcut in a library to point to the document on the network? This...

Hi. I just setup a new Win2K PRO workstation and am trying to setup a printer. We're running a NetWare 5.0 (patched current) network. The printer is an NDPS printer and I can't &quot;see&quot; it either in Printer Setup or Network Neighbourhood. If I log onto a Win98 workstation, I can see...

Hi. Environment: NetWare 5.0 (patched current), GroupWise 6.0. Question: One of my staff has requested that I turn off the message size limitation to allow her to send an oversized email (message + attachment). The only place I've ever set email attachment size limitations are in NAV for...

I have an existing Word document that, for the last year or so, was approximately 70 pages in length. This morning when I opened it, it was showing 12 pages in length. Another funny thing is if I try to scroll down to the &quot;new&quot; bottom of the document. Word stops responding (freezes)...