Recent content by Javalon

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...

Huh, that worked! Thanks! Any idea why using what feels like the 'normal' way didn't work? My only guess is, although the table only contains one record, I was referencing the field as a whole. Which it didn't like. Other than that, no idea...

Hi, I just tried but I don't use the function very often; it didn't work. But, have I written it correctly? The table name is "Reporting_Month" The field name is "Month_Name" I entered =DLookup([Month_Name],[Reporting_Month]) It returned the same #Name? error.

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...

I, uh, fixed it. Completely exasperated, I just copied and pasted the whole lot into a fresh book, and went through every single one of my aforementioned steps again. Then, it worked. I have no idea why it now worked, and I'm somewhat beyond caring. :sleep: What was supposed to have been a...

I just tried it, no luck. Am I able to upload files here? I could drop the column in question into a blank book to see if any of you geniuses can figure it out. (Of course would not include any sensitive information)

Of course, our UOM is always kg anyway, causing me more annoyance at the use of ‘per kg’ inside the ‘price per kg’ field for purchase orders that are always in kg... lol! I now have another issue. I have the document ready to import into Access, however, I’ve been getting paste errors on...

REPLACE! - When you're stressed and working on something I find you often get tunnel vision. Find & replace is so simple! Just applied it and fixed 90% of the records in a couple seconds. Thanks for both solving my issue AND pointing out my stupidity:LOL:

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"...

Dammit Eugene, ya got me! How would I go about adding that property?

This worked! Thanks! I do have the field set to short date, which is why it was confusing me. I have a multitude of functions and queries that modify the original dates based on various factors, some of which were apparently writing the long dates. Hence my headscratching and eventual idea to...

It didn't like this, threw up error 3270, Property Not Found. Thanks anyway

I'll give these a go now, thanks for the reply! AND thanks for the tip on posting code, I've not really used forums for programming before so didn't realize it was a feature, thanks (y)

Haha! Don't you worry, I've been doing this long enough to know to keep backups! In fact, I actually pull the data from a CSV and entirely rebuild the table into a static. So the original data is still preserved in CSV (y)

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...