Search results

What do you men "orphaned/ How to fix?

I have a form with three subforms. all is well except for recent entries in subform frmContactDetailsSubformRF, linked by StationID that says..."you cannot add or change a record because a related record is required in table "tblStationData2". "tblStationData2" is a table that has been renamed...

Data will be pulled from the PDF whenever FedEx changes their rates, which could be yearly or, depending on world volatility every 3 months. I have a good understanding of rational database but normalization is new

WOW! OK guys this is new to me...trying to understand this normalising process...do I apply it to the spreadsheet? Can you point me to a good utube etc. Be kind and help with the procedure necessary. I am not a pro so keen to learn Bob

Hi Guys i will add a few bits that may help The data in the table comes from a PDF converted to Excel then into the table thru to Z Converted Spreadsheet: etc

I have this table: etc and I need to look up, say,the figure ($) in ZoneD for the KGWeight say 2.0 and get the result of 39.21 DLookup("[ZoneD]", "tblWeightZonesFedEx", "[KGWeights] = " & Me.txtCalculatingWeight) would be fine if I only had ZoneD but there are approx 20 such zones. I know which...

Thanks for the help...at least i can see a way forward Bob

Thanks Mate, working on it Bob

I have this situation: one table holds all the contact people for Manufacturers [tblSuppliers], another table holds the contacts for Distributors [tblDistributors]. The problem is that a few companies are both Manufacturers of products and Distributors of other company's products. I need to...

Yahoo! Thanks. i have been trying using that page of options but I guess not the correcy option. Thanks again

I have this site and have tried everything but no luck! Would a text box be different to label?

Is it possible to hide a label on one open form by the click event of a control on another open form?

My database has a field "Town" as part of the address of each customer. Each town (say Brisbane) can have many customers, so when i use a combo box to select a town I get multiple instances of each town. How do i get it to show only one instance of each town? Thanks in advance Bob

Tried all this...no good. Is there some way I could have changed a setting in Options that could do this. I have been looking into security etc

Well! I have MS 365 of course, but I bought and installed separately the Access2010 when I first purchased the computer, so I figured that in developing it would still e 2010. How can I tell otherwise?

Single desktop computer..connects to laptop for conferences etc, Database is transferred via a shared folder but generally I use only the desktop. Monitor is 9 years old and set at makers resolution

Has been there in use for years, but disappeared recently

Tried this just now...pane stays to the right...physically moved it to the centre... made no difference

In my instance the problem exists in all queries in the one database, even when creating a new query. I can get around the problem by dragging a table from the navigation pane on the left hand side. Since the development of this database is on going (bosses keep coming up with new requests), I...

YES