Recent content by EastWind

I've not had to create a report from code. If you're using Access 2002, the good news is that you need not use DAO or ADO because forms and reports are Access objects and not data. What this means is that you can create/append a new report to the Access AllReports collection without needing to...

A way (not the only way) of doing it would be to create two buttons on your form: one for report-print preview and the other for report-print. If you have created the report beforehand, create a new button on the form from which you want the User to have these options. The form's button wizard...

InStr(StrVariable, " ") If StrVariable is a concatenation of First and Last Names, assuming the First Name has no spaces, then the above will return the character position of the space between the names. EastWind [infinity]

No, not yet. I had to move onto other things in my work. If I do, I'll certainly post it! [pc] EastWind [infinity]

Here's the code - minus the error handling: Public Sub (strTable As String) Dim strNewTable as String, strSQL As String DoCmd.SetWarnings False strNewTable = strTable & "_old" strSQL = "SELECT [" & strTable & "].* INTO [" & strNewTable & "] " _ & "FROM [" & strTable & "];"...

You can't. In order to pass parameter(s) to a query, you would need to do it via an ADOX catalog procedure and an ADODB command. Below is an example of how I passed parameters to a query and then executed it: Public Function upqryPmntMatchQtr()...

If you add the Excel library as a reference and type in the immediate window Excel.Workbook.Open > F1, Access Help will give you the syntax help for the following command: Excel.Workbook.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin...

Thank you for the response, however, no dice. I tried /u, then /i, then /u/i; I still received the same message. I'm still exploring hard-copy resources for more information, but no luck so far. If I run across why this is happening, I'll be sure to let you know. Thank you again for the...

Thank you for the reply. At the command-line, I typed: REGSVR32 /u /n /i DLLPathFileName I still receive the same error noted in my original message. As best I understand it, the /u /i combination calls the uninstall, and the /n is a requirement when using with /i. I thank both of you for...

Thank you for the response...I was starting to give-up hope. How do you unregister a DLL?

I tried to add a reference from <DLLPathFileName>. Instead of a successful addition to the registry, I received the following error message: <DLLPathFileName> was loaded, but the DllRegisterSever entry point was not found. DllRegisterServer may not be exported, or a corrupt version of...

I have no definitive idea about what is going-on, but a problem that I've run into before is UPDATEing columns of data-type Text to NULL; sometimes (I don't know when exactly), I must UPDATE to "" (empty text string). Also, part of your argument list is upd$AmountsPC-1; to which arguement does...

Could you go to the SQL of your action query and post it?

I tried to add a reference from <DLLPathFileName>. Instead of a successful addition to the registry, I received the following error message: <DLLPathFileName> was loaded, but the DllRegisterSever entry point was not found. DllRegisterServer may not be exported, or a corrupt version of...

I wanted to post this because this site helps to keep me sane in my job. I hope this is useful to someone else out there... I recently wanted to list all of the VBA names of all references that existed on my C:\ drive. In order to do that, I would need to search for all files in all...