473,323 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Any Idea is welcome

I'm working on this database but I'm at a road block. I have two main
forms and a report to design. the first form is call project and the
second form is call filing. the project form is complete; There are
four require code that has to be used for each filing and there are 52
state that filing need to be done using those four require codes. The
one thing that I'm trying to avoid is that when repetitive progress. I
guess the best and simple way will be to have a drop down list of the
require code in the filing form, so when you select a state, you also
select the require code. But my problem is if you only have to file in
10 state instead of 52 you have to select all 52 state to insert a
require code. At the end I will have a report that shows all 52 states
and their require code. What is the best way to do this process
without having to go through the all process.

Nov 13 '05 #1
2 1459
kufre wrote:
I'm working on this database but I'm at a road block. I have two main
forms and a report to design. the first form is call project and the
second form is call filing. the project form is complete; There are
four require code that has to be used for each filing and there are 52
state that filing need to be done using those four require codes. The
one thing that I'm trying to avoid is that when repetitive progress. I
guess the best and simple way will be to have a drop down list of the
require code in the filing form, so when you select a state, you also
select the require code. But my problem is if you only have to file in
10 state instead of 52 you have to select all 52 state to insert a
require code. At the end I will have a report that shows all 52 states
and their require code. What is the best way to do this process
without having to go through the all process.


Could you rephrase your question?
Nov 13 '05 #2
I work in a filing unit, we file document in all 52 state for
approvals. when this document first arrive in my department we have to
record the detail of the document. I setup a project form in access to
record all the detail on the document, and it is working perfectly. Now
the next step in this process is to setup a filing form which is pretty
easy but my dilemma is that each document might not need to be file in
all 52 states, some state might automatically approval the document and
some state you have to wait until other major state approval the
document first before you have to file in that state. I want the
filing form to capture all the information without me having to input
it in.

I hope this makes more sense, please any input you have on this will be
greatly appreciated. thanks

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

50
by: 127.0.0.1 | last post by:
With all the problems with having register_globals = on, I propose the following idea: We define register_globals_manual = on as a new configuration default. What this does is enable 3 new...
4
by: Justin Koivisto | last post by:
On 10/06/2003 11:50 AM CST, the OP, 127.0.0.1, wrote: > httpget $user_id; > httppost $credit_card; > session $really_important_stuff; > > Each of these declaration lines would effectively enable...
6
by: Michael | last post by:
Hi, I'm looking for any source-code example, showing the use of midi sequencer and midi messages in C++. Which files have to be included ? I wrote a tool in JAVA which has bad timing problems...
13
by: Bryan Parkoff | last post by:
You may notice that switch (...) is much faster than function that can gain a big improved performance because it only use JMP instruction however function is required to use CALL, PUSH, and POP...
1
by: alex | last post by:
Hello I have some c++ code, which has been happily developped in the linux/unix world. Everything has always been compiled with different compiler (intel, KAI, g++...) and gnu makefiles For...
6
by: SB | last post by:
This while loop keeps repeating even when a correct character is entered.... cout<<endl<<"What day would you like to schedule the appointment?"<<endl; cout<<endl<<"Enter 'M' for Monday, 'T' for...
4
by: Alex Stevens | last post by:
Well, It's 4:10 on Friday Afternoon and I am now in a state of turmoil....... I've just spoken with a trainer (who's opinion would be in far higher regard than mine), and he's just told me that...
21
by: petermichaux | last post by:
Hi, I've been asking questions about library design over the last week and would like to get feedback on my overall idea for a JavaScript GUI library. I need a nice GUI library so there is a...
6
by: Ben R. | last post by:
Hi all, I'm running an asp.net website that allows its users to log events, say social gathewrings (with event date, time, address, descrption, etc) and allows people to post comments on each...
14
by: mankolele | last post by:
The " Welcome, mankolele. "part on each site how is it coded I thought it has something to do with COOKIES or SESSIONS but seems I am wrong anyone who could help me with this bit. Thanks in...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.