Search results

I have a form in which we enter a date, say for when we receive an order say 21/08/2024. I wish to have the entering of that date trigger a textbox entry for a date that is say, one week more.

I have noted that when I click on the dependency icon the progress bar at the bottom of the screen says "searching for Dependency information"

Database is split Not sure what a persistent connection is. I work, adapt, make changes etc, to the front end on my home machine. I log onto the server to update the server.Users then log on to their virtual machines. Database has grown quite large and as it has been created and adapted as the...

I am opening it from the toolbar tab. I see the progress bar operating so obviously the "programme' is functioning but no pane appears to interact with

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