Can anyone tell me how to interpret the results from
EnumAvailableMedia
I have queried my Application object and it returns these results about my drives:
Drive 1
QR.GetColumnString(I, 1) = "C:\"
QR.GetColumnLong(I, 2) = 920580096
QR.GetColumnLong(I, 3) = 0
Drive 2...
Is there any way to use an apostrophe inside the like statement? For instance I want to find people with the last name that starts with <b>O'Co</b> as in O'Connell.<br><br>Are there other delimiters that can be used to make SQL ignore the apostrophe without using the _...
Can anyone tell me what cause the following message:<br>
<br>
'MyFormName' has been changed since the last time you opened it, either by another user or because another instance of it was opened on your machine.<br>
<br>
<br>
I get this error on a form when I jump from it to an invoicing screen...
Are you running a delete query before you import the new data? Are there any Autonumber fields in the table, that may be getting stomped on with the new data?
Does anyone know the correct procedure calls to start the built-in wizards (Mailing Labels). For instance to pass the wizard an SQL statement. <br>
<br>
<br>
Thanks
Access 95 & 97 both use the OLE Automation library to determine what rules to apply to dates. So any software you install that updates or changes this library will affect how access handles dates. <br>
<br>
I suggest (If you haven't already) that you read the following article:<br>
<br>...
Here is a Brute force approach with no error trapping,<br>
<br>
<br>
Sub ClearForm()<br>
Dim frm As Form, ctl As Control<br>
<br>
' Set the current form as the target<br>
Set frm = Screen.ActiveForm<br>
' Enumerate Controls collection of each form.<br>
For Each ctl In...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.