We are trying to establish whether the RFID control will allow us to
record the delivery of multiple items tagged with RFID tags. The
product arrives in bulk on a lorry and we need to record all items in
the delivery as they pass the PDA scanner. The volume and nature of the
product means that we cannot individually scan each item, the scanner
will be set to work on long range and grab all of the RFID tags it can
see.

How would we program a Pendragon form for PDA to capture and record
each item in the batch?

Your first solution worked - I changed all fields on the first page to
hidden and it automatically goes to the second page, thanks Dave.

You are brilliant!

It's hard to know what is wrong without knowing what might have changed between
the time it worked and the time it didn't.

Did anything change on your computer or the network or the PF database or the
PDA between the time it worked and the time it didn't?

Dave




----- Original Message ----
From: sploxz <rabaip@...>
To: pendragon-forms@yahoogroups.com
Sent: Tuesday, October 14, 2008 12:52:20 AM
Subject: [pendragon-forms] Server connection Failed (1236)


Hello People!

Im new to the PDA (Tungsten E2 ) and pendragon forms!, i have developed
a form to collect data on HIV issues. Now my problem is everytime i
hotsyc it says server connection failed (1236) but at first it was
ocay. What could be wrong!






[Non-text portions of this message have been removed]

Hi,

If I understand what you want to do, you don't need the "dummy text field".  If
every field on the first page is hidden, PF should automatically go to the
second page.  I'd try that first.  (At least, in my forms where all fields on a
page are hidden, PF skips right over that page.)

If that doesn't work, though, you can always write a script in one of the ID
fields from the parent form like the one you wrote for the dummy text field.  In
fact, the script could be in any of the fields on the first page and should work
the same.

I'm not sure why the "enterscreen" event procedure isn't working, but you could
try the "open" event procedure and see if that works any better.  If neither
works, I'd suggest not hiding the parent form ID fields.  Keeping them read-only
is advised, but I've never tried hiding them.  Maybe that is creating some
strange kind of glitch.

Good luck,
Dave



----- Original Message ----
From: svines23 <svines23@...>
To: pendragon-forms@yahoogroups.com
Sent: Friday, October 10, 2008 11:20:51 AM
Subject: [pendragon-forms] enterscreen event


Hi all,

I'm having issues getting the enterscreen event to fire on a subform.

I have a subform with a dummy text field plus several other ID fields
on the first page.  The dummy text field contains the following
script:

enterscreen:
goto 10

Field number 10 is on the second page.  When I open the subform, the
event doesn't fire and focus is set to the dummy text field.  I've
also tried to use click: but that only seems to work if it's a button
rather than a text field.

Maybe there's a better way to do what I'm trying to accomplish: I need
to have all of my ID fields at the beginning of the subform so
information is linked to the parent form (only first 10 fields are
linked).  I don't need users to see or access any of these fields (in
fact they are currently read-only and hidden), so I just want to start
user input on the second page.






[Non-text portions of this message have been removed]

Hello People!

Im new to the PDA (Tungsten E2 ) and pendragon forms!, i have developed
a form to collect data on HIV issues. Now my problem is everytime i
hotsyc it says server connection failed (1236) but at first it was
ocay. What could be wrong!

Hi all,

I'm having issues getting the enterscreen event to fire on a subform.

I have a subform with a dummy text field plus several other ID fields
on the first page.  The dummy text field contains the following
script:

enterscreen:
   goto 10

Field number 10 is on the second page.  When I open the subform, the
event doesn't fire and focus is set to the dummy text field.  I've
also tried to use click: but that only seems to work if it's a button
rather than a text field.

Maybe there's a better way to do what I'm trying to accomplish: I need
to have all of my ID fields at the beginning of the subform so
information is linked to the parent form (only first 10 fields are
linked).  I don't need users to see or access any of these fields (in
fact they are currently read-only and hidden), so I just want to start
user input on the second page.

i can help but only if you are more spefic in what you want te develop beolw
is my contact number, i have been working with pedragon for the last four
years
+447810352583
Regards
Mphatso

On Tue, Oct 7, 2008 at 9:02 PM, bex21044 <bex21044@...> wrote:

>   I work for Save the CHildren and am a first time PenDragon user. I am
> attempting to create a questionnaire in PenDragon for a household
> nutrition assessment we will be conduting in Darfur at the end of the
> month and was wondering if anyone has some example forms that they
> could post and share with me? I am having some difficulty with the
> scripting as I have never used a computer programming language before.
>
> Thanks,
> Becca Levine
>
>
>



--
Mphatso A. Mpambe
I.C.T Administrator
Malaria Alert Centre
Cell: 265 9 959 800
E-mail: mmpambe@...


[Non-text portions of this message have been removed]

Hi Becca,

There should be a bunch of sample forms already on your computer.  They come
with the program.  They are in C:\Program Files\Forms3\Sample Forms.  You can
import them by clicking on "Import", then selecting "Import a form design from a
.PFF or .CSV file."

(Your "Forms3" folder might have a different number, but just look for the
"Program Files\Formx" folder.)

If after looking at these sample forms you still need advice on a specific
script or function that you want to perform, I'd be happy to help.

Good luck,
Dave



----- Original Message ----
From: bex21044 <bex21044@...>
To: pendragon-forms@yahoogroups.com
Sent: Tuesday, October 7, 2008 1:02:02 PM
Subject: [pendragon-forms] Example forms with Scripting


I work for Save the CHildren and am a first time PenDragon user. I am
attempting to create a questionnaire in PenDragon for a household
nutrition assessment we will be conduting in Darfur at the end of the
month and was wondering if anyone has some example forms that they
could post and share with me? I am having some difficulty with the
scripting as I have never used a computer programming language before.

Thanks,
Becca Levine






[Non-text portions of this message have been removed]

I work for Save the CHildren and am a first time PenDragon user. I am
attempting to create a questionnaire in PenDragon for a household
nutrition assessment we will be conduting in Darfur at the end of the
month and was wondering if anyone has some example forms that they
could post and share with me? I am having some difficulty with the
scripting as I have never used a computer programming language before.

Thanks,
Becca Levine

You should be able to use the "Left" or "Right" functions to extract the
leftmost "x" characters or the rightmost "x" characters from any particular
value.  Or the "Mid" function to extract a section in the middle.  Check the
Scripting Reference for more details as needed.

Dave





----- Original Message ----
From: Dawn Anastasi <danastasi@...>
To: pendragon-forms@yahoogroups.com
Sent: Wednesday, October 1, 2008 2:54:31 PM
Subject: [pendragon-forms] Trim function


Is there a "trim" function for stripping out leading and/or trailing
spaces from a field in a calculate event?

Dawn






[Non-text portions of this message have been removed]

Is there a "trim" function for stripping out leading and/or trailing
spaces from a field in a calculate event?

Dawn

I have an MS Access database that uses GUIDs as primary keys. My
database is built around an "Events" table.  When entering data you
must select a location and the Location_ID is added to the Events
table.  I do this by looking up to a reference form (not read only).
This works fine on the handheld but when I sync with the PC the GUID
representing the Location_ID does not transfer.

I imported the table designs and made sure that the proper fields were
designated as primary keys.  I updated the code module in the Forms
application after reading the Knowledge Base article about working
with GUIDs.  I have gone over the Field Mapping many times.  I am
still having a problem of transfering a GUID from the handheld to the
PC.

The only thing I can think of is that the Access DB stores the GUID as
a Replication ID and the handheld stores it as Freeform Text.  Is
there anyway to work around this problem?

Any ideas would be greatly appreciated.

Thanks.

Geoff

I have a question for the group.

We're currently using Pendragon for a ESM research study. It's quite
important that participants fill out the questionnaire within a
certain time limit.

We're using the alarm program to signal them when it's time to
complete a survey.

Is there any way to have the questionnaire automatically close out if
they do not respond within a specified amount of time?

Would Pendragon 5.1 be compatible with a Windows Mobile 6.1 touch
screen device?

Specifically the Ipaq 910 Mobile Messenger. I am encountering Style Tap
installation errors.

Thanks

Dave Isaak
http://www.sixbluedata.com

Have you tried this yet?  If you haven't, go ahead and try to set it up.  If it
doesn't work, tell us that and include the script you wrote to try to make it
work.  If it does work, you could report back with that info as well.


I can't see why it wouldn't work, although if you have an <open: / gotosubform>
type of script on a form, you'll probably *always* go to the subform first,
unless you add some sort of if/then conditional stuff up front.  But if that's
what you want, I don't see why it wouldn't work.

Dave



----- Original Message ----
From: Andy Finkelstein <a_big_fink@...>
To: pendragon-forms@yahoogroups.com
Sent: Monday, August 25, 2008 1:46:26 PM
Subject: [pendragon-forms] Scripting Open: gotosubform


Is it possible to use the open event to trigger a gotosubform?
I would like to have the user select an item in the record list, then
have a subform open with the information of the record selected

Thanks
Andy






[Non-text portions of this message have been removed]

It looks like this should be no problem.  Windows Mobile 2003 is compatible.

http://www.pendragon-software.com/hardware.html

Dave



----- Original Message ----
From: sgasman211255 <sgasman211255@...>
To: pendragon-forms@yahoogroups.com
Sent: Saturday, August 30, 2008 8:06:55 AM
Subject: [pendragon-forms] windows Mobile 2003


I have a ppt8800 with Pocket Pc 2003 OS software,I want to change to a
ppt8846  128mb with windows Mobile 2003 OS is this software compatible
with Pendragon 5.1 ?

Regards

Sergio Gasman

Santiago, chile






[Non-text portions of this message have been removed]

I have a ppt8800 with Pocket Pc 2003 OS software,I want to change to a
ppt8846  128mb with windows Mobile 2003 OS is this software compatible
with Pendragon 5.1 ?

Regards

Sergio Gasman

Santiago, chile

Is it possible to use the open event to trigger a gotosubform?
I would like to have the user select an item in the record list, then
have a subform open with the information of the record selected

Thanks
Andy

With an iPaq 210 (w/ WM6) and a CF modem Forms 5.1 will send data but,
after a long wait, gives the error "Disconnected while receiving
data.  Sync failed."  Works fine when using ActiveSync or WiFi, but we
need to use a landline modem in some locations.  This setup worked
fine with our Dell x51v (w/ WM5).

Any suggestions?  Thanks,

Erik

hello.

I need to work some forms on my pocket pc so then I can synchronize
with my main access database.

The problem here is that I'm creating some forms on the Pc but then
when I synchronize with pocket pc nothing pass to pocket pc.

What wrong?

This is my full log file:
:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:22:07 from
address 127.0.0.1/54548.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Missing User Profile.  The name of your handheld device
(WINDOWSMOBILE44) is not in the user list in database
C:\Users\Public\Forms3\FORMS32K.MDB.
Pendragon Forms 5.1

0:Block Size 835 bytes.
0:Sent 835 bytes (at 52% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:22:08.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:22:36 from
address 127.0.0.1/54563.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Missing User Profile.  The name of your handheld device
(WINDOWSMOBILE44) is not in the user list in database
C:\Users\Public\Forms3\FORMS32K.MDB.
Pendragon Forms 5.1

0:Block Size 835 bytes.
0:Sent 835 bytes (at 51% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:22:36.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:22:56 from
address 127.0.0.1/54568.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Missing User Profile.  The name of your handheld device
(WINDOWSMOBILE44) is not in the user list in database
C:\Users\Public\Forms3\FORMS32K.MDB.
Pendragon Forms 5.1

0:Block Size 835 bytes.
0:Sent 835 bytes (at 51% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:22:57.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:25:30 from
address 127.0.0.1/54589.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
License count exceeded. You must purchase more licenses.
Pendragon Forms 5.1

0:Block Size 3505 bytes.
0:Sent 3505 bytes (at 65% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:25:31.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:26:14 from
address 127.0.0.1/54596.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:26:15.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:28:29 from
address 127.0.0.1/54612.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:28:30.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:29:24 from
address 127.0.0.1/54623.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:29:25.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:29:36 from
address 127.0.0.1/54626.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:29:37.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:30:23 from
address 127.0.0.1/54641.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:30:23.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:30:43 from
address 127.0.0.1/54653.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:30:43.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:31:47 from
address 127.0.0.1/54668.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:31:48.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:36:32 from
address 127.0.0.1/54714.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:36:33.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:36:57 from
address 127.0.0.1/54718.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:36:58.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 14:38:19 from
address 127.0.0.1/54729.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
14:38:20.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/16/08 17:20:36 from
address 127.0.0.1/55472.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/16/08
17:20:44.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 08:54:38 from
address 127.0.0.1/56639.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
08:54:53.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 09:40:54 from
address 127.0.0.1/56927.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
09:40:56.
-------------------------------------------------

0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
10:10:55.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 12:36:52 from
address 127.0.0.1/49827.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
12:37:02.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 12:38:38 from
address 127.0.0.1/49853.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
12:38:38.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 12:51:00 from
address 127.0.0.1/49910.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
12:51:01.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 12:59:15 from
address 127.0.0.1/49950.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
Pendragon Forms 5.1

0:Block Size 3444 bytes.
0:Sent 3444 bytes (at 64% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
12:59:17.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 13:06:00 from
address 127.0.0.1/50002.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:Log messages for WINDOWSMOBILE44
Evaluation version.
License count exceeded. You must purchase more licenses.
Missing storage limit value for form 'PickingList' (401447248).
Defaulting to 500KB.
Pendragon Forms 5.1

0:Block Size 3595 bytes.
0:Sent 3595 bytes (at 63% compression).
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
13:06:01.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 14:45:18 from
address 127.0.0.1/49476.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
14:45:20.
-------------------------------------------------

0:User WINDOWSMOBILE44/pendragon connecting at 07/17/08 14:45:56 from
address 127.0.0.1/49480.
0:User WINDOWSMOBILE44/pendragon authenticated.
0:User WINDOWSMOBILE44/pendragon disconnected normally at 07/17/08
14:45:57.
-------------------------------------------------

If you just want to send records from the PC to the handheld, it looks like all
you have to do is enter new records in the form on the PC.  When synchronizing,
Pendragon will realize that these records are not and have not been on the
handheld, and will send them.  (At least, that's how I read the Synchronization
Rules in Chapter 5.)

Make sure the UserName field in the form is populated on the PC with the exact
username of the handheld.  Make sure the handheld name is in the Users list. 
And the Groups list needs to have both the form and user indicated in one of the
groups.  That is how you assign which forms go to which handheld.

If you have all those set right, you should be good to go.  Pam's suggestion
about adjusting the query in Additional Download Criteria is right on, too.

Dave



--- On Mon, 6/16/08, Pamela Zimmerman <pzimmer@...> wrote:

> From: Pamela Zimmerman <pzimmer@...>
> Subject: RE: [pendragon-forms] Push records to handheld?
> To: pendragon-forms@yahoogroups.com
> Date: Monday, June 16, 2008, 9:25 AM
> Morning Phil-
>
>
>
> You would typically use a completion checkbox on the form
> to remove the
> records, (cascading if you have subforms).  The user ticks
> the box when it
> is time to remove the record.
>
>
>
> Possibly you want to add some details to the ‘additional
> download’ criteria
> box on the Synchronization tab in advanced form properties
> to address the
> quarterly records?  See page 214 in your book for some good
> examples.  Does
> any of that help?
>
>
>
> Pam
>
>
>
>
>
>
>
> From: pendragon-forms@yahoogroups.com
> [mailto:pendragon-forms@yahoogroups.com] On Behalf Of
> pcboudreau
> Sent: Monday, June 16, 2008 10:57 AM
> To: pendragon-forms@yahoogroups.com
> Subject: [pendragon-forms] Push records to handheld?
>
>
>
> I'm hoping this is just a noob question, but I
> haven't found a way to
> push records from the PC to the Handheld.
>
> I don't want the data to be hidden because the user may
> need to update
> records from time to time. However, I would like a
> different set of
> records to be sent to the handheld depending on, say,
> quarterly
> sampling stations.
>
> What am I missing here?
>
> Cheers,
> Phil
>
>
>
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 270.3.0/1505 - Release
> Date: 6/16/2008
> 7:20 AM
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 270.3.0/1505 - Release
> Date: 6/16/2008
> 7:20 AM
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>

Morning Phil-



You would typically use a completion checkbox on the form to remove the
records, (cascading if you have subforms).  The user ticks the box when it
is time to remove the record.



Possibly you want to add some details to the ‘additional download’ criteria
box on the Synchronization tab in advanced form properties to address the
quarterly records?  See page 214 in your book for some good examples.  Does
any of that help?



Pam







From: pendragon-forms@yahoogroups.com
[mailto:pendragon-forms@yahoogroups.com] On Behalf Of pcboudreau
Sent: Monday, June 16, 2008 10:57 AM
To: pendragon-forms@yahoogroups.com
Subject: [pendragon-forms] Push records to handheld?



I'm hoping this is just a noob question, but I haven't found a way to
push records from the PC to the Handheld.

I don't want the data to be hidden because the user may need to update
records from time to time. However, I would like a different set of
records to be sent to the handheld depending on, say, quarterly
sampling stations.

What am I missing here?

Cheers,
Phil





No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.3.0/1505 - Release Date: 6/16/2008
7:20 AM


No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.3.0/1505 - Release Date: 6/16/2008
7:20 AM



[Non-text portions of this message have been removed]

I'm hoping this is just a noob question, but I haven't found a way to
push records from the PC to the Handheld.

I don't want the data to be hidden because the user may need to update
records from time to time. However, I would like a different set of
records to be sent to the handheld depending on, say, quarterly
sampling stations.

What am I missing here?

Cheers,
Phil

I can't see any easy way to do what you want to do.
There are a few ways to sum *all* of the items in a
field, but no easy or obvious ways to do the
equivalent of a MS Access "Totals Query" (e.g., "Group
By" Customer).

You might be able to get at this using "Lookup to
Another Form", where your list below is the
"reference" form.  You could make new forms for
individual customers, set up a "lookup to the
reference form", and select the records of a
particular customer.  Then you could do a sum of all
items in that form.

Or you could just wait until you download the data to
the database and do a Totals Query there.

Good luck, and let us know if you figure it out.

Dave



--- refnstripes <refnstripes@...> wrote:

> I want to write a script to perform a simple sum of
> data.  See the
> table below:
>
> Customer Date         Amount
> XYZ Corp 5/5/2008  25.00
> ABC Inc         5/5/2008  35.00
> XYZ Corp 5/4/2008  30.00
> XYZ Corp 6/10/2008  40.00
> ABC Inc         6/3/2008 100.00
>
> Script to filter by customer to place the sum in
> another field on the
> same form or filter the data for a select customer
> and give the
> summary for the customer total on another form.
>
> Results would be as follows:
> XYZ Corp 	 95.00  place in a separate field
> ABC Inc 	        135.00  place in a separate field
>
> It is essentially the same "Sum" you see by
> reviewing records using
> the "Quick Sum and Average", see page 63 of the
> users guide.
>
>
>
>

I want to write a script to perform a simple sum of data.  See the
table below:

Customer Date         Amount
XYZ Corp 5/5/2008  25.00
ABC Inc         5/5/2008  35.00
XYZ Corp 5/4/2008  30.00
XYZ Corp 6/10/2008  40.00
ABC Inc         6/3/2008 100.00

Script to filter by customer to place the sum in another field on the
same form or filter the data for a select customer and give the
summary for the customer total on another form.

Results would be as follows:
XYZ Corp 	 95.00  place in a separate field
ABC Inc 	        135.00  place in a separate field

It is essentially the same "Sum" you see by reviewing records using
the "Quick Sum and Average", see page 63 of the users guide.

Pete,

I see what you're saying now.  Terminology matters,
and Pendragon's reference document doesn't use the
term "lookup table", so I wasn't sure what you meant
at first.  You mean "lookup lists".

It looks like you can only select one item from a
reference form to go into the Lookup List field of the
original form, which is what you are experiencing.
The only thing I could find in the reference doc about
getting multiple items into a field is the way you
already have it set up (Freeform Text field with a
link to a Lookup List).

You could also use a Multiselection List field, but
that is probably even more of a pain than the system
you already are using.  And it only allows for 32
items.

As long as you need the ability to select multiple
plant species into one field, you're probably using
the only method you can use.  If you only need the top
three species, or percent area values for six species,
or something like this, however, you could just set up
three fields (or six) and make them Lookup Lists to
Another Form.

Good luck,
Dave



--- jupppy <jupppy@...> wrote:

> Well Dave,
>
> I originally had a freeform text field with an
> imbedded lookup table
> that housed a number of plant species. I was fooling
> around with the
> idea of using a lookup reference form instead of a
> lookup table
> mainly because of the search capability, however
> after I tried to do
> just that, I found that I couldn't add more than one
> plant species in
> the field. Instead, after trying to add a second,
> the first entry was
> erased. I haven't created a script. Before I even
> start this process,
> I wanted to make sure I could even go the lookup
> reference form route.
>
> Thanks for your help!
> Pete
>
>
>
>
> --- In pendragon-forms@yahoogroups.com, Dave
> Hockman-Wert
> <dhwert@...> wrote:
> >
> > Could you explain more about how you set up this
> form
> > (or forms?)?  I find it a little hard to know
> quite
> > what you're doing from this description.  An
> example
> > of your form(s) and any scripts you're using would
> be
> > useful.
> >
> > Dave
> >
> > --- jupppy <jupppy@...> wrote:
> >
> > > I was wondering if anyone has used a lookup
> > > reference form in a
> > > freeform text field. What I was aiming to do was
> to,
> > > instead of using
> > > an imbedded lookup table which is fairly limited
> in
> > > size, use the
> > > lookup reference form in the same manner (but
> having
> > > the much greater
> > > size capacity and searchable capability).
> However,
> > > after completing the
> > > form, I found that I could only populate the
> field
> > > with only one value
> > > and each time I tried to add another, the
> previous
> > > value was erased...
> > > Is it possible to use the lookup reference form
> and
> > > still be able to
> > > fill the freeform field with multiple values or
> do I
> > > have to revert
> > > back to the less robust lookup tables??
> > >
> > > Thanks
> > > Pete
> > >
> > >
> >
>
>
>

Well Dave,

I originally had a freeform text field with an imbedded lookup table
that housed a number of plant species. I was fooling around with the
idea of using a lookup reference form instead of a lookup table
mainly because of the search capability, however after I tried to do
just that, I found that I couldn't add more than one plant species in
the field. Instead, after trying to add a second, the first entry was
erased. I haven't created a script. Before I even start this process,
I wanted to make sure I could even go the lookup reference form route.

Thanks for your help!
Pete




--- In pendragon-forms@yahoogroups.com, Dave Hockman-Wert
<dhwert@...> wrote:
>
> Could you explain more about how you set up this form
> (or forms?)?  I find it a little hard to know quite
> what you're doing from this description.  An example
> of your form(s) and any scripts you're using would be
> useful.
>
> Dave
>
> --- jupppy <jupppy@...> wrote:
>
> > I was wondering if anyone has used a lookup
> > reference form in a
> > freeform text field. What I was aiming to do was to,
> > instead of using
> > an imbedded lookup table which is fairly limited in
> > size, use the
> > lookup reference form in the same manner (but having
> > the much greater
> > size capacity and searchable capability). However,
> > after completing the
> > form, I found that I could only populate the field
> > with only one value
> > and each time I tried to add another, the previous
> > value was erased...
> > Is it possible to use the lookup reference form and
> > still be able to
> > fill the freeform field with multiple values or do I
> > have to revert
> > back to the less robust lookup tables??
> >
> > Thanks
> > Pete
> >
> >
>

Could you explain more about how you set up this form
(or forms?)?  I find it a little hard to know quite
what you're doing from this description.  An example
of your form(s) and any scripts you're using would be
useful.

Dave

--- jupppy <jupppy@...> wrote:

> I was wondering if anyone has used a lookup
> reference form in a
> freeform text field. What I was aiming to do was to,
> instead of using
> an imbedded lookup table which is fairly limited in
> size, use the
> lookup reference form in the same manner (but having
> the much greater
> size capacity and searchable capability). However,
> after completing the
> form, I found that I could only populate the field
> with only one value
> and each time I tried to add another, the previous
> value was erased...
> Is it possible to use the lookup reference form and
> still be able to
> fill the freeform field with multiple values or do I
> have to revert
> back to the less robust lookup tables??
>
> Thanks
> Pete
>
>

I was wondering if anyone has used a lookup reference form in a
freeform text field. What I was aiming to do was to, instead of using
an imbedded lookup table which is fairly limited in size, use the
lookup reference form in the same manner (but having the much greater
size capacity and searchable capability). However, after completing the
form, I found that I could only populate the field with only one value
and each time I tried to add another, the previous value was erased...
Is it possible to use the lookup reference form and still be able to
fill the freeform field with multiple values or do I have to revert
back to the less robust lookup tables??

Thanks
Pete

Hi Dave - thanks a lot for the response!  You were right, it was a computer
settings problem.  So now I can access the database in Access from the other PC
which is great for now, but eventually I would like to get the Pandragons Forms
Manager software on this other PC.  Is it possible to have two computers running
the Forms Manager software, but to have both systems accessing the same database
which is saved on one computers local drive?

Thanks again, and have a great weekend.
Stu

From: pendragon-forms@yahoogroups.com [mailto:pendragon-forms@yahoogroups.com]
On Behalf Of Dave Hockman-Wert
Sent: Tuesday, May 20, 2008 5:03 PM
To: pendragon-forms@yahoogroups.com
Subject: Re: [pendragon-forms] Accessing database from a differnt pc


Any other computer that wants to connect with
Pendragon Forms will have to have the software loaded
on it. Otherwise, that computer will be able to
access the database and its tables, etc., via MS
Access, but it won't see the Pendragon Forms Manager,
since that is part of the Pendragon Forms software.

I'm not sure why the database is read-only. Did you
load it as Access 97, the older version? Did you try
removing the "read-only" restrictions in the
Properties dialog box for the file and/or folder? I
don't think the read-only limitation you're
experiencing is related to PF, but rather to your
computer/network set up, somehow.

Dave

--- h_stuart_paul <spaul@...<mailto:spaul%40muskoka.on.ca>> wrote:

> I'm new to the Pendragon Forms program and I would
> appreciate any
> help. I have the program working on our main pc
> currently but I would
> like to give write access to the database to another
> PC on the
> network. The folder "C:\Program Files\Forms3" is
> read only so I can
> give the other pc access to the folder but script
> errors occur when the
> Forms32k.mdb is opened. When the database is opened
> (after cancelling
> the script errors) the Pendragon Forms Manager is
> not available and the
> database is read only.
>
> Am I going about this the wrong way? Thanks in
> advance!
> Stu
>
>



[Non-text portions of this message have been removed]