Hello, Upon syncing the record of a form, I get the following error (specifics removed for clarity of discussion): Unable to append record in Form 'FormTitle'...
I've had this type of error msg in the past, where the supposed error field is the total number of fields plus one. Unfortunately I haven't found a consistent...
Thanks for responding, Pam. I'm curious to what triggers this. Anyway, to answer your question, the pk field that it is being mapped to is sufficiently large...
Sounds like you are not using the default Pendragon pk (actually a compound key). I was thinking this default was the key causing the sync error (with in the...
Ok. So the lesson learned here is to ignore the number field that is being referred. As it would turn out, there were two fields designated on the PDA as...
I have created SQL statements to update the Lookup Table (without using the Lookup Edit form feature). My question is that same data that I'm updating into the...
I don't quite follow where your list 'source' data is located? Could you tell a little more about that? Without knowing your specific setup, could you run a...
A nice feature of Pendragon Forms is the ability to script a lookup of information from a reference table for display purposes. Oftentimes this is used in a...
The list source is kept in Pendragon. It's just that to get it there I have several queries running (in Pendragon). I need to figure a way to have the...
Hi Rita, I understand your list is stored in pendragon, but if you have "several queries running to get it there". Where is it coming from, or, where are you...
During testing of my form design I have generated a lot of un-needed forms. Just wanted to double check, can I delete tables on the PC with the name of ...
Yes (I do this frequently - for a clean start). Of course, be sure the one table you WANT to keep is the one table (#) that you keep :) Sincerely, Rita DiOrio ...
Hi all! I just installed pendragon on my laptop and when i open the form designer window it looks all wrong, it is smaller and cut off, you can look at MY...
Hi, Is it possible to have it 4 Lookup List (look01, look02, look03, look04) and every time 1 is selected, it filters datad from the next? Example: Look1 =...
I would like to be able to have a user put the PDA on their computer, but have the data base reside on a computer that is currently managed by our IT...
You can do that with just Pendragon. The sync server has additional features... you may/maynot need. Look into it more and let me know if you need help. ...
Pamela's approach is good, but let's examine some possible requirements: If you'd ever have the need to sync to the database over the Internet (i.e. the pc...
Let me separate my immediate requests and my future wish list. Immediate - Handheld is synced to a users laptop which is connected to the lan. The database...
So based on my experiences, you might be better off starting with SyncServer. Your future experience is exactly what we do--- we have 5 users syncing remotely...
Hello everyone, I'm not sure if it's a bug or not, but whenever modifying the Advanced Form Properties to apply a created Filter (i.e. SQL sort criteria) on...
Hello again! I have various fields that have entry conditional upon previous values (or the existence thereof). In lookup lists, I will often use an if-then...
If the Pendragon application is now installed on the server. Would I need to use the server to develop and modify my forms? Or is there a way to design form...
I believe you can just open the FORMS32K.MDB file that resides on the server from your workstation... your server admin will have to share and grant you access...
Hi! First question to the forum, I'm hoping somebody can help... I have an Access application for managing survey/checklist data. When an inspector completes a...
Hi: I have a form which uses a datafile as a source for a lookup list. The data is filtered based on the value in another field. I'd like the data shown in...
Hello there, In case you get a Fatal datamgr.c type error and hard resets don't seem to fix the issue, just pay attention to the size of your lookup lists. In...