Search results

Sorry - don't think I can help you with this as I've never tried anything like that. Sounds like its a limitation in Access Wish I could have been more help. FYI - Pass-throughs are SQL specific. You only use them on SQL (or other non-Jet) back ends.

convert your macro to VBA and then add the following before the code that runs the append: DoCmd.SetWarnings = False Don't forget to set it back to true after the procedure ends

I've used crosstabs as subreport in the past without and problems, but never tried a pass-trhough - which are you using as you recordsource?

DoCmd.OutputTo acReport, YourReportsName ,"MicrosoftExcel(*.xls)", "", False, ""

Are you saying that you getting an error message but the form still works ok? Please elaborate...

Hello, I have multiple dbs that alluse the same user id's. I have some code set up to allow users to open other databases from within their current database to allow them to bypass the whole login process. everything works fine, but I can't figure out how to transfer the global variables...

I'm having a problem with broken/missing references in a db I created. I believe this is being caused by the fact that I have some users running Win 2000 w/ Office 2000/Access97 and others running Win NT w/ Office 97/Access 97. My question is...Is it ok (i.e. safe) to copy all of the DLLs that...

I'm having a problem with broken/missing references in a db I created. I believe this is being caused by the fact that I have some users running Win 2000 w/ Office 2000/Access97 and others running Win NT w/ Office 97/Access 97. My question is...Is it ok (i.e. safe) to copy all of the DLLs that...

worked! Thank you. I was driving myself crazy...

Hello, I'm having a slight problem w/ something: I'm trying to run the following code open up a form w/ filters applied. Dim stFormName as String Dim stSearchCriteria as String Dim i as integer i = Len(Me!txtAddressSearch) stFormName = "frmExpenseLog" stSearchCriteria =...

I believe this works, but i haven't tried it in a while... DoCmd.RunCommand acCmdNewObjectQuery

Try referencing the controls name, i.e. Me!thetextbox

Actually I just tried it and it didn't work out right. However, there is an even easier solution.... Just use the round function to round off the sum of the numbers to be calculated ex: Round(thenumber,0) Then set the format to "fixed" and the number of decimals to 2

I don't know of any way to just hide the tables window. You may want to think about hiding the entire databse window, and creat a few combo boxes on your forms that list al of the queries/reports/etc, along with a command button to open the selected object in design view. To have a combo box...

There are only 30 days in november - i think that would cause the error...

add an error handler to the code

I'm relatively new to this, but you could always consider rounding to a whole number then concatenating the ".00" ex: Round(number,0) & ".00"

Out of curiousity, is it better to store functions in modules or create a seperate .dll and reference it?