-
- Event Procedure
by Access Keen User
- 4 Replies
- Last post
by Access Keen User
- I want to set [Event Procedure] as I have set so many Event but one of my form, shows me following message.
Code is simple
DoCmd.OpenForm"My Form Name"
Where is the fault, if some one help me.
The expression On Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure ha
-
- Making an array in Excel with the file names of a particular folder
by Bartyb
- 5 Replies
- Last post
by Peter Mo.
- Hello, could anyone help me, I already have a macro in Excel that uses an array of filenames to process data, but so far I have to enter the filenames manually.
Basically, I want the macro to simply create an array in Excel with the files names and their extension (which will always be the same) located in a particular folder, sucha as:
Filename1.ext
Filename2.ext
...
Filename13
-
- Spooler error 1068
by Terminator484
- 14 Replies
- Last post
by virginia3443
- I have been all over hell and high water trying to find some way to fix this error, but alas, my efforts have been fruitless; so here I am. The Situation: After moving about a week ago, I just got around to re-attaching my printer (a Lexmark X1185 ). I then discovered that my computer (Windows XP sp2) apparently deleted my printer drivers all by itself, so now I cannot use the printer. I downloa
-
- How to pass the current user of office communicator to the asp .net application
by mrsamii
- 3 Replies
- Last post
by mrsamii
- Hi all, I am working on a client application for "live communication server" using Microsoft asp .net 2.0 with c#. I have problem to pass on the current user's email address (SIP address) from office communicator to my asp application. any suggestion would be really appreciated. Thanks
-
- How to pass the current user of office communicator to the asp .net application
by mrsamii
- 3 Replies
- Last post
by mrsamii
- Hi all, I am working on a client application for "live communication server" using Microsoft asp .net 2.0 with c#. I have problem to pass on the current user's email address (SIP address) from office communicator to my asp application. any suggestion would be really appreciated. Thanks
-
- Running More Than One Macro On One PC
by RAO_123
- 1 Replies
- Last post
by GTVic
- Is there any way to run two or more macros to run through one pc (simultaneously). Creating virtual machine is not an efficent way, can anybody please tell me a way (if there is any).
-
- Using FindWindow API to Get Focus and Send keys to a window
by Consulter
- 3 Replies
- Last post
by DVDK
- I have put together some code in VBA to naviate to a webpage in IE, wait for it to load, find a hyptertext link on the page named "spreadsheet", click it, wait for the "download file" window to load and the go through the process of saving the file into a specific directory using send keys.
The problem is, I am constantly losing focus on the windows. My code actually repeats
-
- GroupBoard Workspace 2007
by AnhVu
- 2 Replies
- Last post
by AnhVu
- Hi I'm using GroupBoard 2007 and I feel it great application. But I can't modify some function if my customer require. In page Newform.aspx, I don't want "OK" button allow submit if time user choice coincide with time in free/busy board. Please help me! thanks
-
- In VBA, putting formulas on an Excel speadsheet
by MS ISV Buddy Team
- 5 Replies
- Last post
by KenCubs
- Hi All,
I just wanted to express my thanks to Derek and all of you who have stepped in to help your fellow coders!
It takes some time on my end to escalate these questions and I'm so glad that many of you are getting answers to your questions more quickly with the help of other community members.
- brenda (ISV Buddy Team)
-
- Excel ComboBox and VBA
by truongn2
- 1 Replies
- Last post
by ADG
- Hi, I am really stuck on this, please help!!! I would like to have a ComboBox on a worksheet (worksheet1) that is populated by a list on another worksheet (worksheet1). Each time I select something from the ComboBox, it would display text in a cell within worksheet1. For example, the ComboBox would have "Cat", "Dog", "Cow". And when I select "Dog" from th
-
- Playing .wav files in Windows Vista with winmm.dll gets unexpected results.
by Dick Ainsworth
- 1 Replies
- Last post
by Stano
- Using winmm.dll to play .wav files with VB6 works great in all Windows platforms except Vista. In Vista, the same code generates delays, distorted sound, etc. Is there a simple fix for this Both 1 and 0 values for DWFlags produce similar problems.
Code I'm using is:
Declare Function playsound Lib "wimnn.dll" Alias "PlaySoundA" (ByVal lpszname As String, ByVal Hmodule
-
- I've received empower, but where are serial numbers???
by Ihor Bobak
- 6 Replies
- Last post
by orcmid
- Last year I ordered Action Pack - I received disks and serial numbers sticked on disk folders. This year I ordered Empower. I received many disks, many papers (license agreement and advertisement materials), but where are serial numbers I don't see them neither sticked on disk folders, nor among all papers. I cannot install Windows Vista... Can anyone give me a hint - where can I get my serial nu
-
- Compare Word Documents c#
by Ravi@asp.net
- 5 Replies
- Last post
by Ravi@asp.net
- Hi All,
I have to compare the text of two word documents using C#. These word documents contain images and text also. But I just wanted to compare the text.
Can anybody please let me know how to do this
Thanks,
Ravi Mullick
-
- using keyDown event to stop non-Hex input in Access form textbox
by .ken.
- 3 Replies
- Last post
by .ken.
- Trying to only allow hex input into a text box. I just started to learn visual basic a few days ago and it is all very neat how powerful it is. My code doesn't work, but any help would be appreciated. or any other ways of only allowing 0-F into a text box would work as well. Doesn't necessarily have to not allow G-Z into the box but needs to stop the program from running if it is entered.
-
- ReportFault() vs. WerReportCreate/WerReportSubmit() on Vista
by Claus Brod
- 12 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, I'm experimenting with the available APIs for error reporting. On XP systems, I'm using ReportFault(), which seems to work as expected- it displays the WER dialogs, sends data to the Winqual site (including minidump data), launches a debugger when asked for by the user etc. Is this the right place to ask questions about those APIs If not, please ignore the following. (But if you know where
-
- Can you use VBA to access a spread sheet embedded in a word doc?
by Trisped
- 13 Replies
- Last post
by Trisped
- I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
-
- what is this
by Newbee1
- 1 Replies
- Last post
by Adamus Turner
- Hi,
I just got an acer laptop and i'am trying to figure this thing out. From what I understand the vista program is suppose to be "da' bomb". The problem is that I don't know how to access most of what it is suppose to do. Like what is "VBA"...and how does it work
-
- Elegance (and performance) Problem
by Douglas Penna
- 5 Replies
- Last post
by magicalclick
- Hello,
I developed a class (class CMatrix, that holds a lot of functions not really related to the other class) to use in another class. Currently, it's working real fine, but I don't know if there's a better way to handle with this. What I do today is, in the main class:
Dim Matrix As CMatrix
... somewhere in a sub or property
Matrix = CMatrix.MergeSort(Matrix)
... rest of the code
-
- Retrieving ID field just created in OLEDB connection.
by Cimares
- 0 Replies
- Last post
by Cimares
- I'm using an OLE connection into a backend Database to create a new record. Standard VBA connection using conn as New Connection and rec as new recordset.
conn.Open dataprovider
rec.Open "so_test", conn, adOpenDynamic, adLockOptimistic
The above connects to the database and opens the required table. (Only 3 fields in the table)
rec.AddNew
Creates a new reco
-
- Excel 2003 CommandBarButton
by RonBonBon
- 4 Replies
- Last post
by RonBonBon
- Hi
I have added a CommandBarButton to my excel workbook.
My question is how can i make it load with my workbook (i mean when i open my file)
Thank's.
My code sample is:
Dim cb As CommandBar Dim b As CommandBarButton Set cb = Application.CommandBars("Standard")
Set b = cb.Controls.Add(msoControlButton, , , , True) b.Caption = "Hello" b.FaceId = 234 b.Style =
-
- Getting an Error Message while opening a report
by Sandeep Garg
- 1 Replies
- Last post
by Shasur
- Cannot open the report Error: The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored may not be responding. Click OK, get error: Exception from HRESULT: 0x800A03EC Please help me out .... --Sandeep
-
- Exchange 2003 - Schedule+ Free Busy - Abandoned on old server, how to move to new?
by E2Admin
- 0 Replies
- Last post
by E2Admin
- I have a flat Active Directory install that was built on Windows 2000 originally.
I have been running Exchange 2003 on the domain controller for some time without issue.
I was finally able to ge dedicated hardware for email and created a second Exchange server in the same admin group.
This server runs Windwos 2003 Standard R2 SP 2 and Exchange 2003 SP2.
I have transitioned all my m
-
- EXCEL PIVOT TABLES
by NICOBASE
- 2 Replies
- Last post
by Bruno Yu - MSFT
- Hello, I have a Pivot Table in Excel and I want to get the source tables of it. I need the tables that were used to create that Pivot Table. I really don't know how to get them, please help!!
-
- ListBox Controls in Access 2000
by Keithyboy1
- 1 Replies
- Last post
by Keithyboy1
- I have a listbox control on a form, which is bound to an employees table. Basically, the user can select 1 or more employees from the list and perform certain actions on them. This is all hunky dory.
However, when I close the form and re-open it, the list box scroll position is where I last left it, rather than being at the top of the list. Is there any property that can effectively reset the l
-
- Display a TextBox or Non-modal Message Box
by sg549
- 6 Replies
- Last post
by Andy Pope
- Hi all. What I'm trying to do is put up a user form with a text box while a process is running. I don't need a progress bar, as the process is not that long. I have created a userform that includes a textbox, but only the userform comes up when I ".show" it. Why won't the text box portion of the userform show
Alternatively, is it possible to put up a "non-modal" system