Search results

I have made my own print function and I want to allow users to use it from the menu by simply pressing Ctrl+P. I setup the menu item with the proper shortcut key, but Access keeps bringing up the normal Print feature. I tried unchecking Allow Full Menus in customize box, but no luck. Is there...

I generally just make a copy of it. You can write code to do this if you want to make it a little more dynamic.

My code already changes the attributes before deleting to remove system files. When deleting someone else's profile (also containing their temp files, etc.), the code deletes everything. But the profiles can only be deleted if you are logged in as admin, which probably removes any sharing...

Does anyone have any code that is able to delete temporary internet files, cookies, and history? With a great deal of help from Fornation, I have code that will delete all files and subfolders from a specified folder. This works great when I'm logged on as Admin and deleting other people's...

Nevermind. I found out that if you type the name it pulls up anyway.

I am trying to add my own menu bar to an application. I read the help file to find out how to replace the default menubar with the one I created. It stated that I should create it and then select it from the list in the startup menu. I created a new toolbar with all the menu options I wanted...

If you setup a combo box using the wizard, it walks you through finding a record on your form based on the value selected in the combo box (the 3rd option). It will then write the code that accomplishes this for you. This is the Access generated code where Combo0 is the combo box: Sub...

This is a stab in the dark, but did you try putting the code in Report_Load instead of Open?

I just wanted to move this back up into the active topics in case anyone can help with it who didn't see it over the weekend.

Okay. I found code posted here to create a batch file that ran a macro from a database. I set the macro to run a function located in my database module, and everything appeared to be working great. I tested it through the Task Manager at a specific time, and it worked great. But then I...

Thanks. That's exactly what he needed to know.

A friend of mine was trying to use the optional keyword in his function. I don't have any experience with it, so I was wondering if anyone could give him any advise on where he is going wrong. His syntax is something like below. Function Test(x as Date, Optional y as Boolean) If isMissing(y)...

Instead of changing my syntax, I've just changed the library references when I've converted to 2000. Try going to the references and check the DAO library.

Recreate the error and the access generated message should display t he error number.

Thanks. I'll try that next time I lock myself up.

This code is great, but I'm encountering some errors. I have a form that opens automatically when the database opens. It also hides the toolbars, etc. I am left with a gray space, where the toolbar previously appeared. I have tested calling the function on open and on load with the same...

It appears that the code in these links tells you if excel is open. Is there a way to tell if a specific workbook is already open?

The following seems to work: Dim ExcelWorksheet1 As Excel.Application Set ExcelWorksheet1 = CreateObject("Excel.Application") ExcelWorksheet1.Workbooks.Open "YourPath.xls" ExcelWorksheet1.Visible = True ExcelWorksheet1.Run "YourMacroName"

Every once in awhile I run some code that wasn't thought out well enough and never ends. Is there someway to stop the code from running without ending task?

Okay, I'm closer; but I still need help. I found the following, which opens the file (I guess I had to declare it as Excel.Application): Dim myObject As Excel.Application Set myObject = CreateObject("Excel.Application") myObject.Workbooks.Open "T:/IAT Schedule/Schedule " _ & Format(Week...