ITOjim

Just got the 8 upgrade and was testing the backup files first and ran into a problem where the fields from all of the previous records are not accessible. When you open the Invoice dbase you can see all 1200 records but you see no text in the fields and they are not a selectable item. If you try to select a field and type into it you get the prompt indicating that you should select a field first. However, if I create a new invoice it works fine and I can see everything. There is a secondary issue that we have been living with since the upgrade to 7 that I should mention as well (same database) We have an area for multiple types of labor charges. It has 3 repeating fields and one text field: Labor Account code- drop down list of the code (repeating) Description-You select the above and this is automatically entered (repeating) Hourly rate- same as description Qty- Txt entry You pick the code (it actually shows the code & brief description) and it populates everything and dumps you into the QTY field. Here is the problem, the first row works fine, the remainder only populate the code not anything else. Here is the rub, we have the identicle thing for the materials and it works fine. The first issue is the most important, but I would love to fix the second while I was at it. Any help would be appreciated. Jim

could you give me an example of how to do it?

all, we recently upgraded to 7 and ran into a strange problem and I hoping the group could help. We have an Invoice file that has two sets of repeating fields. One for Labor Codes and one for equipment. The user enters the first field in the labor line and a pop up of the code # and Description field show up. When one is selected the labor code gets put into field A, the description goes in field B, and the unit cost goes into Field C. This works for the 1st row of the repeating field but not the remainder. When you enter the second or subsiquent rows you see the Code # and Description. Once selected the Code # gets pasted into Field A but nothing gets entered into B or C. I have the exact same thing for Equipment and all of those repeating fields work fine. Any ideas? Jim

I have a Log Database that tracks events in a computer room. I am trying to share it with others. Here's my story... Database name: Log File Accounts: king (full access) Superuser (not full but more then just data entry) Basic (data entry only) there are 4 secondary files linked to the Log database. They are: building staff inventory emergency There are two accounts on each of those four files king (full access) simple (data entry only) We have set the File Options to four secondary files to Open with account "simple" using the correct password. What should happen Double click on Log Asks for name and password you are in or not If you enter the wrong name /password you dont get in. If you enter the correct name and password, the four secondary files open automatically (no name and password needed) using the "simple" account. If you hold down the shift key after entering you name and password the first time you are prompted for name and password to open secondary files. What is happening Double click on Log Asks for name and password then ask's for name and password to each of the four secondary files. If I happen to log in using an account that is the same on the four secondary files (king) then I am not prompted for log on information. Both the applcation and server version are the most recent (all updates applied). Am I missing something?

got it! one more thing off the list, sweet. Thanks Jim

got it! one more thing off the list, sweet. Thanks Jim

got it! one more thing off the list, sweet. Thanks Jim

I created a global as you indicated, what would that script look like?

I created a global as you indicated, what would that script look like?

I created a global as you indicated, what would that script look like?

All, I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift. I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call. Any ideas? Jim

All, I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift. I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call. Any ideas? Jim

All, I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift. I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call. Any ideas? Jim

Sorry, it was 7.03 with a caffeen enhanced add on, but that still doesnt explain the issue. I redesigned one of the pages to get away for the need of a menu/list but I need something that works at normal speed for the others. Any ideas? Jim

I updated to Rev 7.04- opened a soda and had 1/2 of it go on my keyboard- and we are still slow. Slower since most of the key's on the left side are stickey. (anyone know a good way to clean a KB?) I noticed the difference between the two types of menus (menu & list) as well. what is the rule of thumb for using one over another?