Search results for query: *

I am trying to open a form in Access which is a pivot table. I have read where the acDialog property should keep the form open but no matter what I do it just flashes and closes. I have inserted a STOP after the OpenForm and it is indeed being generated correctly it just gets closed without...

I have been reading this board for over a year and have gained a great deal of knowledge while doing so. This is a great place. I just wanted to share and maybe help someone as I have been helped. Recently I wanted to add floating tips to my menu items in the switchboard. But the form uses...

I am using the docmd.transferdatabase to import data from a database via and ODBC connection in VBA code. This database has numerous different companies within it. It works fine the first time I run the code. But if you run it again and select a different company from the database it still...

In my forms for date fields my users have requested the ability to enter dates using only numbers, no slashes. i.e. mmddyyyy which then gets converted to 3/10/2004 I have searched but found no solutions yet. What is the easiest way to accomplish this. It seems fairly simple and I have done...

Most people split a database to have one set of data used by multiple front end databases. Can it be done in reverse? I have three clients that will have their own data, same file structures, but will use the same front end in a terminal server environment. Thought it might be easier to do it...

I am relatively new to VB programming and have a very basic question. I have been using VB with very little knowledge of the nuisances of what I am doing. Basically hack attacks that seem to work, but I want to understand the reasons behind the code now. Can somone tell what the difference is...

I have a sub that dynamically sets the print area of an Excel sheet. It works perfectly when I run it from the VB editor. I set it up to be run by a function so that I can use it as a macro. I can run the function which runs the sub in the editor and it works fine. When I setup the macro to...

I have a sub that dynamically sets the print area of an Excel sheet. It works perfectly when I run it from the VB editor. I set it up to be run by a function so that I can use it as a macro. I can run the function which runs the sub in the editor and it works fine. When I setup the macro to...

I have several spreadsheets that are launched from an appliction. All I want the user to be able to do is enter data in the spreadsheet and save the file, nothing else. What is the easiest way to accomplish this? They must never be able to use the "open" to browse the network. Thanks...