Search results for query: *

That was simple enough. I think I am blushing. I borrowed this code from a process that prints a report from Access and did not realize the full implication of that line. I do now. Thanks.

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...

In the VB code for this form you need to update the Filloptions() sub. The variable is called conNumButtons. I have altered my switchboards to double the number of items on them. I always edit the switchboard table manually to add new menu items.

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...

Yes, I figured that but I don't know how to do that when I am using the transferdatabase method. I don't know what to call the connection. I thought about using a real ADO connection like what you have. But it was a lot more work and I sorry to say I was being lazy.

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...

I placed code in the on click event for the date field that empties the date and then repaints the screen so that when they click in the field they can enter mmddyyyy easily. Seems to work. FYI.

Thanks, I do see what you mean. Not very user friendly. But, then again, I didn't really want to change it to begin with so I may just let them see a solution and convince them the old way it better.

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...

Wont you method create multiple front ends that have to be maintained? Or are they updated at login? I am new to this process. We have Access 2002. Thanks for the reply and info.

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...

Thanks everyone for the information. I am trying to make the conversion from hacking to actually knowing what I am doing and this type of information is valuable to me.

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...

Thank you for the reply. I solved this problem with the help received in another thread. I need to express myself explicitly.

Thanks "PHV" that fixed it. I can usually piece together what I need to do but don't always know the why of some of the coding. Thanks again.

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 am just running the macro from the Macro setup are in Access. Here is the code. It works correctly when run from the VB editor. Sub FindUsedRange() Dim xl As Excel.Application Set xl = New Excel.Application xl.Workbooks.Open "F:\My Documents\weeklyrpt.xls" xl.Worksheets.Select (Sheet2)...

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...