Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 32
Search took 0.01 seconds.
Search: Posts Made By: sunny76
Forum: Excel VBA December 18th, 2012, 09:16 PM
Replies: 3
Views: 2,114
Posted By sunny76
Forum: Excel VBA November 26th, 2012, 11:43 PM
Replies: 3
Views: 2,114
Posted By sunny76
Concatenate text from columns and rows

Hi All,

I have data in a number of rows and columns that I need to concatenate the text within this range. The number of rows and columns are different each time therefore, I wrote a code to...
Forum: BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 August 13th, 2009, 05:38 AM
Replies: 0
Views: 3,511
Posted By sunny76
Help! Conversion Excel 2003 VBA codes to Excel 2007

Hi,

I have many Excel VBA macros in my office and we're now in the midst of upgrading to Excel 2007. Is there any way to convert the Excel 2003 VBA to Excel 2007 so that the existing macro...
Forum: Excel VBA July 2nd, 2008, 08:25 PM
Replies: 0
Views: 1,265
Posted By sunny76
Excel crashes

Hi all, I have been problems with my excel macro recently. Excel 2002 will crash when running VBA. The Excel will close and attempt to recover the excel file but the recovered file will contain only...
Forum: Access June 17th, 2008, 04:07 AM
Replies: 2
Views: 2,206
Posted By sunny76
Help to query for data by 30-mins interval

Hi, I need help to design a query to display the records on a 30-min interval from a table.

The table contains data with different timings (e.g 9:45:42 AM). Is it possible to query and display...
Forum: Access April 14th, 2008, 09:03 PM
Replies: 0
Views: 787
Posted By sunny76
Need to match data in all fields in 2 tables

Hi,

I need to match the data in all the fields between 2 tables.

eg.
Field 1 (Table 1) = Field 2 (Table 2)
Field 2 (Table 1) = Field 2 (Table 2)
so on......

Using the wizard, I'm only...
Forum: Excel VBA November 27th, 2007, 05:53 AM
Replies: 3
Views: 1,511
Posted By sunny76
Hi Shasur, thanks for your help. Your code...

Hi Shasur,

thanks for your help. Your code worked wonderfully!

Thanks.
Forum: Excel VBA November 22nd, 2007, 10:16 PM
Replies: 3
Views: 1,511
Posted By sunny76
Need help in Excel VBA codes

Hi,

I need help to do the following:

I have 100 rows of text messages on a sheet named "B_Msg".
I need to transfer every row of these text messages to another sheet "Msg" but before each...
Forum: Access October 17th, 2006, 07:56 PM
Replies: 4
Views: 1,172
Posted By sunny76
hi, many thanks. look forward to receiving the...

hi, many thanks. look forward to receiving the script from you tomorrow.
Forum: Access October 17th, 2006, 02:15 AM
Replies: 4
Views: 1,172
Posted By sunny76
MS Access Query

Hi,

I'm running some statistics compilation using Access. I'll need to import data from .csv format to Access before generating the reports. The problem is that the data may sometimes be not...
Forum: Access February 19th, 2006, 08:28 PM
Replies: 3
Views: 1,261
Posted By sunny76
Hi, The data are imported into Access from a...

Hi,

The data are imported into Access from a .csv file. I would like to search data based on the fields. If possible, to enable search based on more than 1 field.
Forum: ASP.NET 2.0 Basics February 17th, 2006, 08:37 AM
Replies: 1
Views: 2,547
Posted By sunny76
Problem with Codebehind - urgent

Hi,

I'm a beginning with ASP.NET. I'm using Visual Studio 2005. The code below is extracted from Visual Studio 2003. Could the difference in version cause the error? Pls advise.

The code is as...
Forum: Access February 16th, 2006, 11:29 PM
Replies: 3
Views: 1,261
Posted By sunny76
Seek record in Access

Hi, I like to create a form where user can use to seek records from a table by specifying 1 or more search criteria. Based on the criteria specified, I'll like to display the results in a datasheet...
Forum: Access January 16th, 2006, 05:23 AM
Replies: 3
Views: 1,234
Posted By sunny76
Hi, I want to literally turn them into ***. ...

Hi,

I want to literally turn them into ***.

Regards
Forum: Access January 13th, 2006, 01:18 AM
Replies: 3
Views: 1,234
Posted By sunny76
Help with update query in Access

Hi,

I need help with update query function. I have a table with a field, "user_no", containing information which I need to manipulate. The info contains 5 characters, beginning with G. The last 3...
Forum: Excel VBA September 19th, 2005, 09:31 PM
Replies: 2
Views: 1,387
Posted By sunny76
Hi, The run-time error happens at the...

Hi,

The run-time error happens at the following code:

Selection.Sort Key1:=Range("L1"), Order1:=xlAscending, Key2:=Range("G1") _
, Order2:=xlAscending, Header:=xlYes, OrderCustom:=1,...
Forum: Excel VBA September 19th, 2005, 12:33 AM
Replies: 2
Views: 1,387
Posted By sunny76
Sorting

Hi,

I recorded the macro to sort some data in Excel and copied the code into my program. But after doing so, the macro won't work. What could be wrong?

Worksheets("Data").Select...
Forum: Excel VBA August 19th, 2005, 01:24 AM
Replies: 2
Views: 21,125
Posted By sunny76
Macro to count the no. of sheets

Hi, anyone know how to write the codes to count the total no. of sheets within a workbook?

Please advise.

Thanks :D
Forum: Excel VBA July 6th, 2005, 03:02 AM
Replies: 1
Views: 1,029
Posted By sunny76
Need help to write codes to sum values

Hi,

I have a table with values and I need to write a code to sum up the values in the rows under each column (starting from Column D). The no. of rows varies everytime. Does anyone know how to do...
Forum: Excel VBA July 6th, 2005, 02:58 AM
Replies: 6
Views: 4,780
Posted By sunny76
Hi, tried as suggested but still the same error...

Hi, tried as suggested but still the same error message.
Forum: Excel VBA July 5th, 2005, 07:32 PM
Replies: 6
Views: 4,780
Posted By sunny76
Hi, I tried to use the code you suggested but I'm...

Hi, I tried to use the code you suggested but I'm still encountering "Run-time error '1004': Application-defined or object-defined error". What else could be wrong?

[V]
Forum: Excel VBA July 5th, 2005, 04:31 AM
Replies: 6
Views: 4,780
Posted By sunny76
Problem with defining cells in Excel VBA

Hi,

I'm trying to fill row 1 with colour but the no. of columns is dynamic. As such, I'm trying to write a code to detect the no. of columns and apply the colour. The program keeps giving me...
Forum: Access VBA July 5th, 2005, 02:12 AM
Replies: 2
Views: 1,417
Posted By sunny76
Deleting table using Macro in Access

Hi,

I have problems creating macro to delete a table in Access. It keeps prompting me "Action Failed". Can anyone advise what is wrong?

Thanks
Forum: Access VBA July 4th, 2005, 01:05 AM
Replies: 2
Views: 4,499
Posted By sunny76
Hi, Yes, seems like the relationships need...

Hi,

Yes, seems like the relationships need only to be established once. But now, I have a problem creating a macro to delete the table. The macro action I'm using is "DeleteObject" but I get an...
Forum: Access VBA June 30th, 2005, 09:52 PM
Replies: 2
Views: 4,499
Posted By sunny76
VBA to create relationships in Access

Hi,

Does anybody know how to write a VBA to create relationship in Access?
I have a table imported from Excel and this table is linked to other tables in Access to create various queries. The...
Showing results 1 to 25 of 32

 


All times are GMT -4. The time now is 09:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.