Search results

I am trying to create a cascading box. first time i am attempting to do an after-date code. i read post about cascading list and attempt to plug in my tables into the code. no luck. if i select branch from tblebranch( combo box 10) i want to select a Group Sector from a dependent...

My reports are blankand I do have data in the tables. my forms are based off tables, would did this be a factor why the reports are blank ?

I have the following tables setup: IncidentTble ScopeTble to relate both tables: ScopeTble/fields= Scope Id= PK= autonumber Scope=memo IncidentID=number the problem i encounter is: when I enter a scope, the IncidentID should show a number which is related to it. However, the...

ok... thank you. can you also explain if my facts regarding the order of creating a db is accurate, also, i like to thank everyone for all the help . in return, i have alway give good reputation comment to all of those have done such. thank you again

i was under the impression if you put data in it ruins you autonumbers numbering

can someone plz clarify for me if an order is required to creat your db. for example,what i know the order to be is as follows: table( i have not yet inputted any records because i will do it later when forms are created)>query>form and lastly report. the problem i am is having is twofold...

i dont have any records in the table so it will not display on the query, but i figured at the least i would see a blank line for enter.

not quite sure how to pose the question because not sure what the problem is. my form is just all grey, blank , no fields. when i use the wizard to create the form, i select the select query to base it on. so i am assuming that is the problem. chrissy. thanks guys for the help

I made a form which is from a select query. the query has numerous table and therefore numerous fields. the form appears empty in form view. all the fields are there in design view. i looked at obj source. its is off the query. what could be causing this problem?

thank you very much

Can a table stand alone? then what is the purpose of the table? to create a report off that table.

Did you mean have the Ids from Areas, Facility tbls insert into the Incident tble, do I need to reverse it?

Hi, My name is Chrissy. I am a Capt with the NYCFD. I am trying to learn Access as well as create my first DB. OMG, what was i thinking? Any help given to me is much apprepricated. This is hard. The field is my preference, but I am doing adm work.

lookup tables to me when i go into the properties and set up lookup tables.

each incident has different area/facilitis for the troops to meet. each incident has different hospital to take patient to during that incident

dont i need to have incid to related the tables? iam not sure what you mean by lookup tbles.

yes i did. thats why i ended up with so many relationships. the ones standing alone. arent related. as far as the weather tble. not sure i need it...

incident has different types and assorted messages for the event and it has different hospital locating and reporting location, etc...

the answer is i need that each incident can have numerous branches. these are large scale events.

i am looking to create statistical data regarding number of events for the year, and amount of resources and equipment allocated.