SteveS

LaRetta, The form view report layout extends 10 pages long and the text field enclosed is set to sliding and reduce size of the enclosed part. It seems like this should be a very simple thing to accomplish but after reviewing previous posts, it is not. I am not an expert and was simply looking for advice.

Doughemi, I tried that before and it did not work.

Efen, I changed the last page number to the current page number and this gives me the correct page number, but it does not give me the correct last page number of each report. I thank you for the first obstacle accomplished, but I believe there must be a way to show the last page number (total pages in report).

Yes, Form View.

Hello, I am using Filemaker Advanced 10. I have a script listed below that shows page # of # on the footer of each record in form view. Each record varies in length depending on the amount of text included in each record. This script works fine if you print one record at a time. I want to print multiple records at once and set the correct page number for each record starting with 1 and ending with the correct number of pages per record. The script below shows the footer page 1 of the total of all pages instead of each record. Freeze Window Go to Layout [ “K-9 Reports Print” (K-9 Reports) ] Enter Preview Mode Go to Record/Request/Page[ Last ] Set Field [ K-9 Reports::gnumberpages; Get ( PageNumber ) ] Go to Record/Request/Page [ First ] Print [ ] Enter Browse Mode Set Field [ K-9 Reports::gnumberpages; "" ] Go to Layout [ “K-9 Reports” (K-9 Reports) ] I would appreciate any help you could give me.

Self-join.pdfI ran into a problem with the self-join. I soon realized that I could not enter new data into the related self join fields. Please view the attached pdf file to view the screenshots of involved fields and relationships. If anyone knows how I can accomplish this task, please let me know and provide me with detailed instructions. Thank you.Self-join.pdf

Thank you for your help Consultant, I might have not made myself clear with the example I posted. I have a form that contains various business names & address info as well as customer information on the same table. I did a self-join relationship and it solved my problem. I enter a new record, enter the business name in the business name field and the business address + phone number and other related info auto populates in the associated fields. I did the same thing for the customer. My self-join relationships are based on the business name and customer name.

Hello, I have a customer/product database with a layout setup in form view that has customer’s information including address & image. I would like to have some type of feature set up when a new record is selected, and I enter the customer’s first and last name, their address & image will auto fill in the appropriate fields, if this information existed prior. Could anyone tell me how to accomplish this task with detailed instructions?

Vaughan, Thank you for your help, it worked! I set the page break before each occurrence and also set the reset the page numbers after each occurence. Your quick response to this problem saved me alot of time & stress. Steve

Hello, I just became aware of a problem encountered when printing browsed records from a layout report form that I designed. The report prints fine when printing a single record in form view, weather it is 1 or 8 pages long. This layout includes a header, body, & footer. The problem is visible when multiple browsed records are printed, a text field set to slide up runs into the second page over the header. This text field was designed to accommodate several pages of text if needed, set to (Sliding/Printing, sliding up all above, also reduce the size of enclosing part). Do I need some type of script to accomplish this task? I would appreciate any help on this one. Steve

Vaughn, I just seem to have problems with this, must be on my end. I can change the account name but cannot change the user name. I think I will just keep the runtime solution the way it was, assign the user's their account names, and user names, with associated permissions. Thank you.

Vaughan, I appreciate your input and assistance. I always try to work out problems that I encounter and keep on trying to figure out a solution. I tried the Add Account script, Add[AccountName:Get UserName);Privilege Set;"My previously defined";Expire Password] I thought I was almost there but got the "This name is already in use, please provide unique name," error message. Thank You

I set the default account name and prompted the user to change the default password with no problem. However, I did not see the change account name option.

I appreciate your direction “IdealData” and I believe I must do a lot of in-depth reading on this subject. I assumed many developers using FM Advanced have run into the same predicament. If anyone could provide me with a detailed explanation it would be greatly appreciated.

I designed a FM 10.0 runtime application with several privilege sets, (full access, limited access, & read only access). I made default account names with associated privileges for this runtime. When the end user opens up the program, the usual opening dialog box appears, ACCOUNT NAME:________ & PASSWORD:__________. By default, the name of the current user logged in appears inside the “Account Name” field. The end user must enter their default account name to access the program with associated privileges. How can I control privilege sets without knowing the end user’s account name. I want to distribute this application and give the administrator privileges to assign account names.

This must be some type of bug in FM10, because I accessed the internet via IE web browser and typed: http://local.google.com/maps? inside the address bar and accessed Google Maps with no problems. I entered my address inside the search box and it worked correctly. The map appeared on the right side which gave me the desired options, traffic, satellite, & terrain. If anyone knows how to fix this please let me know. Thank You.

Hello, I am using FM10 developer and have a problem with my web viewer displaying. The viewer was displaying properly until recently, I tested the viewer and noticed this problem. I get the following message; (“Still loading slow?” Try basic HTML). The page does not load. I tested this out on other computers on my network and have the same problem. I am using Google Maps (US) with the required, address, city, state, and optional zip code fields. I copied the web address I am using from the web viewer setup; ("http://local.google.com/maps?" & "q=" & /*Address=*/ ${K-9 Reports}:street & "," & /*City=*/ ${K-9 Reports}::city & "," & /*State=*/ ${K-9 Reports}::state & "," & /*Zip Code=*/ ${K-9 Reports}::zip & "," & /*Country=*/ ""). I am using Windows Vista and have Internet Explorer set as my default web browser. Can anyone help me out on this problem?

I would like to thank both of you for your help! Fenton, you were right! The file path was incorrect. After you mentioned this, I looked at the file paths and soon realized it was incorrect. Thank You again!

I am using FM Advanced 10 using Windows Vista and have a problem with a script designed to export records from several tables to a file folder. The export script does not work properly in the runtime version. I get the following error; File; "ExampleReport" could not be created on this disk. Use a different name, or make more room on the disk, unlock it or use a different disk. The export script works fine, but when I bind the program up as a runtime file I get this error message. Example code; Send Event["aevt","odoc";"cmd /c md c:ExampleReport"] Export Records[No Dialog; "ExampleReport.fp7"; Unicode (UTF-16)] Any help would be much appreciated.

I have faith that someone will have an answer.

Bcooney, Thank you for your help, I went to the thread you suggested but somehow got lost in the calculations to arrange the signature block to the bottom of the last page. I am using FM 10.0 and believe the Status(CurrentFoundCount)described in the thread should be Get(FoundCount). Anyway, do you know any easier way to accomplish this task?

I have a layout setup in form view designed to print multiple pages, depending on the amount of text contained in each report. I have a few signature lines that I want to print out at the bottom of the last page. I set the sliding/printing on all fields inside the body section to sliding up based on all above and also reduce the size of the enclosing part. I believe the title footer will print the first page and not the last, does anyone know how to accomplish this task? Your help would be appreciated.

Maybe my previous post was not clear, let me ask you this. If you designed a paperless database and have two text fields designated for a Trainee & Supervisor's name, how could you authenticate the user who entered their name inside their designated field? Any help would be greatly appreciated!

Months ago I inquired about digital signature fields, members responded and gave me good tips. I do have some related issues to solve and hope you can help me. I designed a layout report that includes two text fields at the bottom. One field designated for the SUPERVISOR and the other field designated for the TRAINEE. The Supervisor and Trainee sign off when the report is completed. It was suggested earlier that I set the “Field Level Access” for each field in the ACCOUNTS & PRIVELIGES section to limit who has access to the SUPERVISOR field and the TRAINEE fields. That seemed to be a logical solution at the time but I realized another problem, any supervisor can enter whatever name they desire in the supervisor’s signature field and any trainee can enter any name they desire in the trainee’s signature field. Another member’s tip requested the following; Get(accountname) “unstored” which will give me the current user who is logged in. Many users do not use their full name as their log-in screen name. I set up the database for users to log into the database with predefined account names based on account privileges. Example – Supervisor1, Supervisor2, Supervisor3…. Trainee1, Trainee2, Trainee3… all have individual passwords. If the account name “Supervisor1” is assigned to user “James Brown,” how can I set the signature field to only accept text entered as “James Brown?” Thank You

That worked out fine. For some reason, I thought it was only possible to slide one field up. One of the fields had text clipped between pages, I believe I can fix this by moving the involved fields up or down slightly. Thank You!