Search results for query: *

This is doing my head in!! I am simply trying to redirect the place that the user is able to save the sheet ie in my documents as the file is originally opened from a read-only copy on the server .. it should be simple but... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, cancel As...

Hi, I need to trap the save or SaveAs controls on the menubar, so I can control where and when the user saves a document. It's easy enough to see how the BeforeSave sub works, putting my own save commands in, but the problem is that when the code finishes, it still opens the standard save...

Hi all. Can anyong shed light on this problem. I have an XL sheet with the following code on a command button in the sheet: Range("a1").Value = "hahahaha" The same code is placed in a command buttton, but on a userform. Both work as expected. However, I now hyperlink to the sheet from a web...

Hi, I am trying to reference a particular combobox in excel. I know you can use a variable to reference cells etc such as: For var = 1 to 10 range("A" & var).select .... next but what about a combobox. I need to be able to change the value in a particular combobox out of a range of boxes...

Hi, I know you can use a variable to reference cells etc such as: For var = 1 to 10 range("A" & var) - dosomethin next but what about a combobox. I need to be able to change the value in a particular combobox out of a range of boxes, but this won't work (ie need to get to combobox5): var = 5...

I have converted a DB from access97 to 2000. Now I have 3 extra field in each table S_Guid, S_Generation and S_Lineage. I can hide them but they keep coming back? Can anyone please tell me how to get rid of them. Can I just delete them? Thanks

I am trying to use a variable to test if a use has pressed shift on a control.. that part is all well, but I need to know which control will be affected. The function carries the control name into it under the variable 'Ref'. How do I use this to get the value from the referenced control? (This...

Here's a funny one - We have ISA configured to log to SQL database & running in W2000/AD/DHCP structure. It's showing records as expected - anonymous requests prior to authentication, then correct ID used once use is authenticated. Now I used my XP pc (logged on as user) to remote into the...

Can anyone help out here? I get the following error message: +++++++ Compile error: Function or interface marked as restricted, or the function uses an automation type not supported in Visual Basic. +++++++ The thing is that the compliler highlights this line... Set db = CurrentDb a basic...

Is there a way of moving the cursor in the define name 'Refers to:' field. Any attempt to press cursor keys results in a reletive address being inserted rather than moving along the field Thanks Georg

Is there a way of moving the cursor in the define name 'Refers to:' field. Any attempt to press cursor keys results in a reletive address being inserted rather than moving along the field Thanks Georg

Am I missing something. I have trawled thru the posts and came up with this... Private Sub mnuCopy_Click() Clipboard.Clear Clipboard.SetText Text1.SelText End Sub I modified it to : Private Sub Mysub() Dim Mytext as string Mytext = "sometext" Clipboard.Clear...

I am trying to use public variable in a database. When I open the main form, a sub calls the Init routine which creates a bunch of public variables. all & well. But as soon as I go to the last record in the database via the form, all my vars are reset. What could cause this? I've tried creating...

Can anyong help? I need to automatically save an XL sheet in a webwite (http://url/book.xls) to my hard disk. this needs to be done on a regular basis so an automated VB process running in background (or TSR) would be ideal. Can someone please put me on the right path with a bit of help on the...

Hi all, I have a bit of code that exports data from Access to XL. Once there XL VBA code formats the data for me. At the moment I have to fire the macro from XL manually. Is there a command in Access VBA that will run an XL macro Thanx Georg

Is it possible to access an open but NOT YET SAVED spreadsheet from Access VBA? The situation is that I receive via e-mail XL sheets that have data to be added to a new record in Access. I create the record in access, open the mail XL attachment, manually copy the data across from the cells and...

I am trying to run a bit of VBA from access to do actions in an Excel sheet. The code goes like this.. Set objXL = GetObject(XLS_LOCATION) Set objSheet = objXL.Worksheets("sheet1") With objXL .ActiveSheet.Range("D2").Select .ActiveSheet.Cells.Find(TheNumber...

I have has some success in manipulating data in excel via VBA from Access using Set objXL = GetObject(xls_location) With objXL ... This is fine if the file is saved somewhere and I can supply the location. I now need to work on a spreadsheet located on a web server. I access it using...

Hi, can anyone help out here. I am developing some code to automate a spreadsheet and 2 bits just won't work.. 1. a simple sort routine.. (1st I need to find the last used cell) NewName = Application.InputBox("Enter the Student's Whole name") With...

I have a query which returns totals by month. The month field is returned 01/01, 02/01, 03/01 etc. Is it possible to get it sorted so it starts a year ago and ends with the current month ie the sort order would be 06/00, 07/00 .... 04/01, 05/01. Non of the standard sorts seem to work this way...