Search results

i can only assume that it was carved into stone tablets

Royal Dutch Shell (Shell petrol) use a huge amount of freelance IT staff, i only know this as my wife is a Programme manager for Shell Retail IT.

database is attached if anyone does have 5 minutes to show me where im going wrong. in a nutshell. i have a form called RESPONSES, within the form (and table) i have a YES/NO selection. i have created a query that i thought would work (called responses query) im looking to display a list...

i have a Project ID number that links both the subform and the main form. The relationship is set up and working. I have selected the items from the table that i want to display within the query and added "no" within criteria of the field that contains Yes or No. however, the subform that...

Guys, i have a subform displayed on a main form that i wish to show every record that has a "NO" response to a question. could someone step by step the query for me at all please?

Yes. No matter what parent form i am in i only have the option to scroll down to two records. to be fair its not too much of a problem, however it is bugging me as to why other subforms are working no problem when they were created in the same way.

Any idea why my continuous forms stops at 2 records? i have a form with various subforms within, 3 of my subforms scroll down to record as many records as i need. however ONE subform will only allow for 2 records?

solved it. Thanks for the input though.

SOLVED - there was a hidden Query that i didnt realise i had

attached below select VIEW ALL EVENTS. click Event ID PMI

its a local table

Attempted to manually type the control name - Not working. Table has new entry PMI price box with manually typed control source not working control source is not showing updated table field.

Table is already linked to a form and all boxes in form are bound by control source. Added a new column within the table and set the format. opened form in Design view and added a new box attempted to bound the box in the control source selector new table column not visible within control...

Hi Guys Ive added a new column in a table but this is not showing within the control source selection. Am i missing something?

That you for that GP George, sorry to ask but where in the second line would i place the filter?

Sorry Gasman, as explained before, i really am new to Access, what would my correct Criteria be? within the code above, where is the incorrect item? Thanks Gasman

To clarify. the event code remains as 1 as this is event number one, but i may have numerous different EWNs (early warning notice) for any delay to any event (an event could be delayed for multiple reasons)

the outcome selects the current record that i am working on and sends it to PDF (only the current record) the EventID is irrelevant as there are multiple events but each event has multiple NCE or EWN ID. code is below. Option Compare Database Option Explicit Private Sub...

does the same thing with both versions. sends the report to PDF and will only send the current record that i am working on. when i attempt this with other forms it send the entire list of reports found within that form. my issue is that i only wish to send the current form, to report and then to...

both version give the same outcome