Search results

In this expression... =DMax("PmtDate", "InvoicePmt", "InvoiceNo = " & [Invoice]) ..."InvoicePmt" is a table, not a form. I understand this to mean what the Table looks like, not the Form.

Me is not valid in a TextBox.ControlSource. Me is an object reference in VBA. Use the name of a control, like... =DMax("PmtDate", "InvoicePmt", "InvoiceNo = " & [Invoice])

Maybe describe in greater detail the exact nature of the "trouble." : )

You can set a reference to "Microsoft Speech Object Library" to get more info in the object browser, and intellisense, and you can then do... Dim vox As New SpeechLib.SpVoice There might not be a male voice on your system. You can try... Debug.Print Vox.GetVoices.Count ... to see how many...

Similar to the balance of your bank account, you should never store the current quantity of your stock. Rather, you should always calculate stock levels by summing the deposits and withdrawals over time. You should have an tOrder table with a date, and links to a Customer and/or Supplier. You...

Make sure you don't have a hidden instance of MSAccess running. Open task manager and look in applications, but also in processes. Kill any instance you see of MSACCESS.EXE.

I would refactor the code more like... Private fso_ As New Scripting.FileSystemObject Private Function CreatePart() As Boolean Dim rsp As VbMsgBoxResult If fso_.FolderExists(obj_PartPaths.FullPath) = False Then rsp = MsgBox("New part number detected. Select OK to create a new...

Thanks Colin!

Well, I do not return your ill will in kind. I have tremendous and ongoing respect for your knowledge, the freedom with which you share it, and the enormous contribution you have made to this place over the course of many years. To me, politics, and our opinions in that arena, comprise only one...

The humourless orange man is a convicted felon.

You could... 1) replace the hyphen with a period 2) test if result IsNumeric(), and if so return result, if not return zero (or 9999999) 3) convert to single, and use that as your primary sort, and use the original field as the secondary sort. ...but obviously easier to store numeric data as a...

Ahh, the revenge motive, one of the hallmarks of great leadership.

Here's a way you can solve this problem without a single monolithic class for all controls. It wraps each control type in an interface.

If you want code execution to pause while a form is open, you need to open that form with the acDialog window mode switch. Edit your line of code that opens the form to be... DoCmd.OpenForm "MessageBoxF", , , , , acDialog, Args

SQL is a language. VBA is a different language. You can't execute SQL in VBA. The specific error you are getting is that VBA is expecting a Select Case statement, because VBA knows nothing about SQL syntax. You probably need to open your query named CustomerDiscountQ in design view, and edit...

I agree. This should be changed. I have users with 34" monitors, but I can't put controls past 22.75 inches because the Access.Control.Left property is an integer.

And my post #24 was considerably more important, but you chose the mindless one to respond to.

A mindless shot perhaps, but clearly worthy of a detailed rebuttal, to you.

For a rent-a-president, seems appropriate. He just watched videos to see how it was done.

I don't know much about this situation, but I have this observation: If an institution is conducting an investigation, it seems to me it would be a dereliction of duty if the head of that institution was to go on record citing conclusions in advance of the release of the investigation's findings.