Search results

i created a subform of branches which breaks down to groupsector. i would like to just select branches by Ids groups. for example, branch id #1 I dont know want to see branchid #2 or branchid #3. the form is based of table. i have tried to base it off a query but then too many queries are...

i have a combo box which will not allow me to select any of the options. i have limit to list set to no. i believe all the properties with are necessary are set correctly. any suggestions?

it takes 4 different parameters( branches =" incident commander and staff", "planning", "fire", "hazmat" ). is there a macro or VBA coding so that the front end user doesnt not have to input every parameters-for the most part the parameter hardly vary. i needed to group the branches which...

is there any way to have two subforms which are linked to the same table but each subform have, again, the same recordsource but on the first form display a few records and the 2nd subforms have the remaining records. the forms would display in datasheet view. can anyone help with this

I have been reading a book on SQL language. Its a great book and very easy to comprehend. I would like to practice the syntax of the language but I dont know where I would write the language. Its in an event tab. VBA code. I doesnt tell me that part. LOL. any help and all help appreciated...

i would like to create a form based off a query; showing a few records to display at a time, perferribly by one specific branch. my query allows duplicates values. i have tblebranch (one side relationship)and tblegroupsector (many side relationship). at the end i would like to see one...

i have two tables which are related by IDs. tble one Inctble (fields): incident id- pk incident name: date time tble two Resourcetble (fields): ResourceID-pk incidentid-fk resourec name resource title when i try to update resource table, i get the message that "i can not update table...

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...

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 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?

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

How many tables is the limited when linking subtables to a main table. ie, i have one many table that has 36 subtables linked to it. will this have an effect on the db in any way?

can anyone look at my tbles and give me an idea if there are normalized. my db is to track city events and the usage of logistics and resources. i would like to create reports based on the forms. i would like the forms to be able to have predefined combo boxes and able to edit those combo...

anyone know where i can find a user group that meet regularly to discuss access. im struggling. i am gratiful for all the help i receive here on the board. but at times it gets very diffcult. looking for help. do i have to pay additional fees to upload my db so someone can look at it. tried...

I am trying to create Forms and when i look at the table to select the field, the field is not an option-two of the three field display.

do you have to format a report each time after you run a report. or once you format it, it will look the same each time when you run the report?

My subforms do not seem to be link to the main form. i thought maybe it had to do with parent and child links however, after linking them . they still do not seem to be related. i also checked the relationships. do the two tables of the subforms have to be linked? the two subform tables are...

How many subforms can you have on a form. And are they link by the parent child property fields?