Search results

In this database only, the Object Dependency Pane does not show even though I see the progress bar at the bottom of the screen doing its bit.

I want the user to see the file but not to save it necessarily. I assume they would be able to choose to save if they wished.

Thanks theDBguy DoCmd.OutputTo acQuery, "qryRepreportCompany3", "MicrosoftExcel(*.xls)", , True works fine. Saves the file, and while this is Ok=K, an option to NOT SAVE would be great Thanks for your prompt reply Bob

I am using : DoCmd.OutputTo acQuery, "qryRepreportCompany3", "MicrosoftExcel(*.xls)" to open the query results in Excel. This works OK but I would like to open the spreadsheet automatically once it is created. Saving is not necessary. All help appreciated

New contacts are added via a subform of the main form of customers. Customers are added via a separate form. If I look at the Contacts table the new contacts are listed but the joining StationID is missing. If I try adding it in datasheet view I get the error message "you cannot add or change a...

I cannot find any such references. If it helps, the problems only exists when I enter a new customer and then try to add a contact. There is no problem in adding a contact to older customers

Have read mentioned articles...tried to find any reference to "tblStationData2"...none found...rebuilt forms etc...no change Need help at my self taught level.

I am sure you are correct as if I type the info into the back end directly the error message appears as soon as I type in the "StationID". I have rebuilt the relationship, via Database Tools. Still no luck Any further help much appreciated....I am obviously not a professional developer

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?