Recent content by trax1337

I cannot explain this but what seems to be working as intended is:

Dates are a constant issue, for example, if I want to save a date in a table and I want it to have the format dd/mm/yyyy, I have to insert it as mm/dd/yyyy or it will be the other way around. No idea what is going on.

Me.IforceDate_Text.Value = CalculateDeleteDate(eanValue) Debug.Print "Function Result: " & CalculateDeleteDate(eanValue) Debug Result below: inside the function deletionDate: 03/11/2023 Function Result: 03/11/2023 Same Debug.Print results for: Me.IforceDate_Text.Value =...

Not directly, I'm using data from a Date Field inside the table but not the actual field. The value for the particular Date I'm using inside the form is set by vba code.

If it's not too much trouble, could you post a screenshot or some instructions on how to add a Date Field to a form? All I can find is "Text Box". Also, even with the formula above I'm getting the same results. Thanks.

It is a text field, what should it be? Format is set to Short Date.

I have no idea why this is failing, I simply want to make the background red if the Date is before Today. The results I am getting are all over the place.

Could you provide a snippet on how I would avoid this `detour`? Assuming my query would be: strSQL = "SELECT EAN, CrtStock, Adjustment, AdjDate " & _ "FROM tbl_adj_logs " & _ "WHERE AdjDate < #" & Format(deleteDate, "yyyy/mm/dd") & "#;" How would I send it to excel file...

Thanks, small typo there I think, but made it work with: excelWorksheet.Cells(lastRow, "A").CopyFromRecordset rs Out of curiosity is there a way I can do it without opening the excel sheet? Or are there other methods, just trying to wrap my head around access and vba. Also previous to the...

I'm trying something quite basic I assume but it's not working. I want to append the contents of an access table to an excel file or create the excel file if it does not exist. So far I either get errors or the excel file is overwritten instead of the data being appended. This is my full code...