Search results

You could also use the scripting method: strUserName = CreateObject("WScript.Network").UserName strMachineName = CreateObject("WScript.Network").ComputerName How I approach this, wrap the above snippets of code into a function (a function for each) with the return value the UserName...

Yes, it's all about positioning of the mouse. Yes, I got it to work.

I assume you are not sending an Outlook email from within Access. I've had a quick play around and can't copy multiple fields to the clipboard. Edit: I could copy an entire row or entire column but not specific fields across rows and columns.

Glad you got it sorted, but I am not an expert.

Firstly check out the docs here. From the docs here is a sample nested iif statement. =IIf([CountryRegion]="Italy", "Italian", IIf([CountryRegion]="France", "French", IIf([CountryRegion]="Germany", "German", "Some other language"))) You'll note the nested iff's are a part of the false...

The immediate window is your friend and very useful for checking out quick solutions. I, for one, can not remember every in-built function but in the back of my mind, I know something is there. Usually, it's a quick Google search, that in the main sends me to the Microsoft Docs, and then I...

Straight from the immediate window: ? now 12/04/2019 11:55:33 PM ? format(Now(),"hh:nn") 23:55 num = 0600 ? format(num,"##:##") 6:00 ? format(num,"0#:##") 06:00

After assigning the Sql to task, next line do a debug.print task and show us the result. I've highlighted in red possible problem areas. Is that a period between Cert.LicNum? In the Where clause, are they numbers, if not, and they're string values, they should be quoted. Edit: The Where...

It's where you use the server name in lieu of a drive mapped letter. https://docs.microsoft.com/en-us/dotnet/standard/io/file-path-formats What was the result of the debug.print?

Just thinking about my comment, if your table is linked and working, then the drive mapping should be in sync (still prefer the unc method). As Gasman suggested, a debug.print is in order.

Are you using drive mapping or unc? If drive mapping, could it be that the server is not mapped as you think.

I know I'm coming in late here but others have suggested checking for 'is it a new record' and that I agree with. Somehow, I think you are overthinking the issue and making it unnecessarily complex or awkward. You state that your ComboBox has five columns of data, and I assume one column is...

No worries, glad I could help.

Where you would have had your hyperlink field, that is now a normal text field that contains the relative path and filename of your external file. Do not include the absolute path (you can, but then you are restricted or hampered if changes to folder structure are made). Now when wanting to...

How do you know your users will have Adobe Reader? Yes, I know it's a freebie, but the question is still valid. I know this doesn't answer your question directly but have you considered storing your images/files in a predesigned folder structure relative to the backend data file. When...

The reason why one of your sum calculations worked and the other didn't is that the one working (TransactionQuantity) referred directly to a field of the recordset. The other sum calculation (TransactionTotal) didn't work because you were referring to a non-field control source. That is, the...

Thanks MajP, I'm looking into this now.

Hi Joseph, welcome to the group from another Aussie.

Double quoting, single quoting, make it easier on yourself, write a function to do it. A sample can be found here (this site):

Could it be a space at either end of your variables (form controls).