-
- Error 380: Invalid property value:Help Me Please
by OS*Bomzer
- 1 Replies
- Last post
by extremeb
- Im working on some coding for an assignment i was given and i neede help as fast as possible. I have been recieving an error message that reads as follows:
Run-time error: "380"
Could not set the Value property: Invalid property value
Ive used F8 in attempt to locate the problem and i have highlighted where i believe the problem is in the coding below:
Dim Row As Inte
-
- Windows Error Reporting - handling unanticipated errors
by John Blight
- 7 Replies
- Last post
by John Blight
- For Vista certification, is any handling of unanticipated errors prohibited (other than throwing them)
Let's say an application has to process a large number of files. If an unanticipated error occurs when processing one of those files, I wouldn't want that to prevent the application from processing the rest of them. Could we report the error through WER, but also handle it
-
- Is there a better way to debug.
by SHolst22
- 2 Replies
- Last post
by Andy Pope
- I learnt all of my programming in Java and used to use the command prompt/debug window extensively to print information out to. I could use this to check flow and determine when things were executed, the order and more information about the workings of the code.
In VB I have been using Msgbox along with the Str() command. This is rather intrusive to the operation of the system. It also ma
-
- Display a value in a looping status
by Victor_TanTW
- 1 Replies
- Last post
by Jade_Emeperor
- Hello. I am working on a program that requires me to generate a status of the program I am writing. Up to now I can display every string values out onto the txtDisplayText box but except that last one which the value was generated from the serial port
Code Snippet
Dim sRx_Buffer As String
Dim sRx_Msg As String
commSerial.Output = stringValue
sRx_Buffer = commSer
-
- Excel Macro
by ramkshetty
- 0 Replies
- Last post
by ramkshetty
- Help needed for the code in excel Marro...
I have a backend excel file in LAN server, which acts as main database...
and n numbers of fronend excel file with n numbers of users......
I have written a code where data will be submitted from frontend to backend in a click of a button....
I want to check if the backend excel file is open somewhere/anywhere before executi
-
- Subscript out of range with a simple sql :-( [newbie to VBA]
by Maximus
- 14 Replies
- Last post
by Andy Pope
- Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers!
Code Snippet
Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
-
- VB code in Access forms
by CatherineS
- 1 Replies
- Last post
by Bruno Yu - MSFT
- Hi, i'm a beginner in the VB code world but enjoy making things happen in the rare instances that they do! I'd really like some VB code / help for the following:
I 'm designing a database with user input forms and am stuck on how to use VB code to make it do the things i want it to...
I want code to do the following:
For each new record i only want the parent form to be acces
-
- Run-time error '13': Type Mismatch
by whateveritis
- 2 Replies
- Last post
by whateveritis
- i always get this error when i try to run...does anyone know what's the problem
Code Snippet
Option Explicit
Private Sub UserForm_Initialize() UpdateData cbxDept.AddItem "Marketing & Sales" cbxDept.AddItem "Supply Chain" cbxDept.AddItem "Purchasing" cbxDept.AddItem "Technical & Production" cbxDept.AddItem "R
-
- 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
-
- Access Data Project, form bound to Sproc, need to update, etc
by Computermike
- 2 Replies
- Last post
by JKnow
- I have an Access Data Project. SQL Server backend, access forms.
I have a form bound to a stored procedure. The storede procedure is based on two tables. The form needs to update and delete records in one of the tables. I set the Unique Table property to the table I need updated.
When I try to update a record I get the error'This recordset is not updateable" It worked fine when the
-
- Conditional Formatting Problem/Bug?
by FaV1105
- 8 Replies
- Last post
by FaV1105
- This is my first time in a forum. I have mostly found all the answers I could but I can't seem to find the answer for this:
I don't know if this is a bug in excel or if I am doing something wrong.
I start a new Excel application from another workbook and apply a conditional format that uses an array formula for its condition (I have read that conditional formatting always formulates
-
- Creating new table in Access 2003
by Tantani
- 2 Replies
- Last post
by Tantani
- Dear, I would like to pick up few rows from existing table in Access 2003 and put them into new table via VBA. Any solution Thank you in advance!
-
- Justifying text in message box
by une
- 2 Replies
- Last post
by une
- Is there a simple way to justify text in a messgae box Consdier the following text;
The number of lions = 23
The number of tigers = 2
The number of monkeys = 34
I would like the words and the equals signs to be left justified in the message box and I would like to right justify everything to the right of this. This would mean the numbers would all be right justified and line up
-
- Problem with events
by Keithyboy1
- 3 Replies
- Last post
by Keithyboy1
- I have created a customised control in a class module, which works in a similar way to a combo box. It consists of a label, on which I have a button. When the button is clicked, a frame control appears below in a similar fashion to a combo drop down pane, on which I have various check boxes which a user can check or uncheck as required. The button click event basically sets the visible property of
-
- vlookup
by Namrata Prashar
- 14 Replies
- Last post
by Namrata Prashar
- Hello
can anyone help me with how to write the excel vlookup function in vba
the function in excel looks like this
VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE)
how can i get something similar working in a macro.
thanks
namrata
-
- CRM 3.0 Error: Subreport could not be shown
by RSorenson
- 2 Replies
- Last post
by AnonAG
- I have a user that is getting the error "Error: Subreport could not be shown" when doing a report for a quote. She can do a report for an order but just not for the quote. I tried logging her in with different computer and get the same result so I think it is at the server level. Please give me some direction on what to do next.
Thanks
-
- sending emails from MS Word with variable subject line
by gve2002
- 9 Replies
- Last post
by Andy_F
- Hi,
I've searched these forums but have not been able to find exactly what I need.
I know how to send emails with VBA in Word, but the only problem I have is that as far as i'm aware the subject line is always fixed in the code ( .Subject = "New subject" )
What i'm trying to do, is send reports i have reviewed to an email address by clicking a button in
-
- Easy msgbox Query
by jaxgev
- 8 Replies
- Last post
by Andy Pope
- Here's what I'm looking to do in Excel: User inputs data in cell C7 A function in cell C11 calculates A function in cell C12 calculates I want to ensure that both C11 and C12 are positive based on C7 input If they are not, I want a msgbox to appear saying, "Enter a Larger Value." I used the Change event over the Calculate event because it's my understanding that the Calculate event wi
-
- ThreadHijacker and WER report
by DHON
- 2 Replies
- Last post
by DHON
- Hi,
In my application I introduced AV thru code and getting a proper report. But, when I introduce AV using ThreadHijacker, GetModuleHandleExW() is unable to find the module handle. Report looks like as shown below.
Problem Event Name: APPCRASH
Application Name: Appln.exe
Application Version: 4.5.0.0
Application Timestamp: 46b0270c
Fault Module Name: unknown
-
- How to turn OFF Simple File Sharing via Policy Editor in Server 2003
by TheTom
- 2 Replies
- Last post
by 1222256
- We are in the process of rolling out Sophos AV. One requirement is that you must turn off Simple File Sharing on clients (XP Pro). As we have 100 desktops to deal with, we'd like to do this via Policy Editor. I can NOT find any entry that will accomplish this in the editor. Any help out there Thanks!
TheTom
-
- update cell value using loop
by Alen cappelletti
- 1 Replies
- Last post
by Spidermans_DarkSide - MSP, VSI
- Hi,
I try to develop this script but now I have a brake.
What I must do
I got an array of column like C, E, F, T,... and I must update all cell setting above everyone the char '.
Example: my cell have the value of sun...I must update like 'sum.
This for a problem of import values into integration services of SQL server 2005 (SSIS).
But the loop must be run untill the last
-
- Automating PowerPoint
by Jenise
- 4 Replies
- Last post
by Andy Pope
- I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday.
Can you please suggest how I can automically execute my vba code to run
thank You!
-
- Using Autofilter in VBA with a range of criteria
by jabodaddy
- 3 Replies
- Last post
by Joe Dawson
- I have working code to autofilter the list I'm interested in for a single criterion in several fields. However, I can't find anything anywhere that shows how to write the object model fields so that I can use a date range.
ie. I thought that I would be able to use
RangeObject .AutoFilter(Field:=1, Criteria1 > Date1, Operator:=xlAnd, Criteria2 < Date2)
I'm not sure that it's poss
-
- Need Urgent Help from the good people
by keilah
- 3 Replies
- Last post
by Rong-Chun Zhang - MSFT
- Hi People
I am having trouble with a excel spreadsheet. I am pulling in live data from a MS Access database, that has datatwo sets of portfolio IDs.
In Col A the Portfolio Id are shown as individual (separated) in Col (say) G, the Same IDs are conbined (as shown below) for example:
ColA ColG
Barclays1 Barclays 1+2 (shown as)
Barc
-
- Excel Checkbox - Multiple controls-only one may have value of true
by suznal
- 10 Replies
- Last post
by suznal
- I have checkboxes on a sheet of which, the value of only one may be true at a time. (By the way, I am not allowed to use option buttons on this workbook). I have figured out the basic code to use if there are only two checkboxes involved, but each instance I have involves a minimum of three and sometimes five checkboxes.
The code I have works well (for a pair of checkboxes) provided I supply it