Search results

Hi All, As I build more and more databases, I am trying to standardize my workflow, making use of templates and data models. This is more of a discussion than any single question. I was wondering how you guys plan out a new project? Do you have a data model template you send to your...

Hi All, How can I have a Text Box control on a Form or Report display a record from a table? I've had trouble with this before and have had to create workarounds. I want to be able to use the Control Source property, it seems like there shouldn't be any issue, yet I get a "#Name?" error. The...

Hi All, I have an Excel workbook that I want to push through into Access, but the owner of the file has NOT been diligent with their data cleanliness, whatsoever. So I am now tasked with cleaning up the data before I can import it into Access. One field I'm struggling with is a "Price per KG"...

Hi all, Probably very simple but having an issue where some of my dates in a table are being written as long dates, and some short dates. I thought instead searching and fixing each date modifier, I'll simply write a short piece of code to run at the end of the module to reformat all dates...

Hi All, new here! I'm a Supply Chain Analyst, generally working around production and/or procurement planning. I have been developing databases on and off (dependent on job) for around 8 years. I am completely self taught, but as a result, I lack the standardization of classically trained...