S
Shannen
Hello All! I'm actually a business analyst and not a programmer or
developer. Due to my job requiring the analysis of tons of data and
recreating processes with multiple users, I have become dependent upon mostly
Access and Excel to accomplish my job. One of my downfalls is that I don't
know any programming. I can edit something that is already written but
cannot write something on my own. I am self-sufficient in all other areas
(i.e; macros, formulas, design, relationships, etc.). I know when it's time
to ask a friendly local programmer for assistance and and what can be
accompished. I just wanted to throw that out there in case it helps with a
response.
Currently, one of the databases has become critical to our team's job. The
database will have to become a mutli-user platform (7 Users). Unfortunately,
due to our security setup (strict and rolling servers), I cannot enable the
database to operate in a shared mode not even as a split database. Instead
of starting a new project that will require a Six Sigma format and the use of
valuable programmers, I'm opting for a simple solution with as little
programming as possible. I'll borrow code or plead for help on any bells and
whistles that are needed. I founf InfoPath and realized that this would be a
perfect solution for our situation. The users can save their data and submit
at anytime. They can also query at anytime.
Since I am new at InfoPath, I will run into some roadblocks along the way.
I am having trouble right now and am hoping that someone can provide a
solution. My form is working great so far with one exception. For my main
table, I have an autonumber field as the primary key. I am getting errors on
this field when I submit the data. InfoPath is passing that field with a 0
value which would cause a duplicate record. How do I get the record added to
the database with the next number in the sequence? I have tried a few
differemt things but nothing seems to work. I don't want anyone to have to
query records for the last number. I couldn't find any support for this
particular issue. I need to get this rolling as quickly as possible because
it's affecting production. Does anyone have a solution to this simple issue?
--
Tx,
Shannen
"Don't take things too serious, you'll get stuck in the details and never
reach your goals."
developer. Due to my job requiring the analysis of tons of data and
recreating processes with multiple users, I have become dependent upon mostly
Access and Excel to accomplish my job. One of my downfalls is that I don't
know any programming. I can edit something that is already written but
cannot write something on my own. I am self-sufficient in all other areas
(i.e; macros, formulas, design, relationships, etc.). I know when it's time
to ask a friendly local programmer for assistance and and what can be
accompished. I just wanted to throw that out there in case it helps with a
response.
Currently, one of the databases has become critical to our team's job. The
database will have to become a mutli-user platform (7 Users). Unfortunately,
due to our security setup (strict and rolling servers), I cannot enable the
database to operate in a shared mode not even as a split database. Instead
of starting a new project that will require a Six Sigma format and the use of
valuable programmers, I'm opting for a simple solution with as little
programming as possible. I'll borrow code or plead for help on any bells and
whistles that are needed. I founf InfoPath and realized that this would be a
perfect solution for our situation. The users can save their data and submit
at anytime. They can also query at anytime.
Since I am new at InfoPath, I will run into some roadblocks along the way.
I am having trouble right now and am hoping that someone can provide a
solution. My form is working great so far with one exception. For my main
table, I have an autonumber field as the primary key. I am getting errors on
this field when I submit the data. InfoPath is passing that field with a 0
value which would cause a duplicate record. How do I get the record added to
the database with the next number in the sequence? I have tried a few
differemt things but nothing seems to work. I don't want anyone to have to
query records for the last number. I couldn't find any support for this
particular issue. I need to get this rolling as quickly as possible because
it's affecting production. Does anyone have a solution to this simple issue?
--
Tx,
Shannen
"Don't take things too serious, you'll get stuck in the details and never
reach your goals."