Recent content by Danick

It's working perfectly. Still can't believe how simple the fix was. Thanks so much for your help.

Would you please elaborate on how using the date function would resolve my issue about inserting Today's date by double clicking a cell?

Unfortunately, locking the header also won't allow filtering. Actually, that's the problem since double clicking the header also replaces the Column header with today's date. I may have found a work around for now by changing the range to Range("E3:E1000"). But I'm crazy about it...

Here's a simple code to insert today's date in a cell in Column "E" when double clicking any cell in that column. It works fine, however, I can't figure out how to make it start at Row 3 of that column. Any ideas? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...

I removed the Where clause which seems to work, but keep getting the Access Violation type conversion error. Suppose I can just suppress the warnings. Thanks for your help.

I like the staging table method but can't get it Update correctly. It only updates the records where the RevDate field is not null. So the staging table ends up with a lot fewer records. How can I get it copy all records and just bypass trying to CDate the null fields. Here's what I got so...

Forgot to mention that some fields are empty. So this gives me a run-time error 94 - Invalid use of Null

I thought about trying to do that. But I don't control the external data which are all text fields. If I use the import process to convert those text dates, I was concerned that Access would mess up the conversion as the formats are different as mentioned above. So I just kept them the same...

The main table in my database is imported from an excel table. All fields are TEXT fields. My continuous form has a column called RevDate and I'd like to have a button to sort the form by this field. Most of the time, the date is in a format yyyy-mm-dd. So using this simple code requires no...

Just to test it myself, I created a blank database with just a table, a replace query, a simple report, and a form with a command button to pass the replace query to the report. Surprisingly, this is working fine with no truncation. So now I have to go back to my original database which has a...

I'd really like to try to see if this code works but have no idea how or where to put it. The Form with the cmd button opens a report with the record based on a primary field. Do I put this code in the click event of the cmd button? The Open event of the report? Should it be a function in...

Can't find a way of using Replace(AnyText, ".", "." & Chr(13) & Chr(10)) In combination with AnyText => Left(AnyText, 65535) To get around the truncation issue with calculated fields.

I have a simple text box in a report which can contain several sentences. It could look confusing bunched up altogether. Is there a way to parse the sentences with a line breaks at end each period?

WOW - that's perfect!! I had just about given up on this one. Thank you so much for dedicating your time to this request. Of all the posts I've seen on the web asking for this functionality of wrapping the access window around the form, your code is the only one that actually works. I'm...

Using tabbed documents display wouldn't work for me as there are multiple forms and sub-forms being displayed. And the request hadn't really shifted, I just tried using different examples in order to try to provide a better picture of what I was trying to do. But that obviously didn't work...