Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 23 of 23
Search took 0.01 seconds.
Search: Posts Made By: kritimehrotra
Forum: Excel VBA December 1st, 2006, 11:12 AM
Replies: 3
Views: 2,219
Posted By kritimehrotra
Hi, I'm having some trouble again! It turns...

Hi,

I'm having some trouble again! It turns out that the Worksheet_FollowHyperlink event (or in my case the Workbook_SheetFollowHyperlink event) is triggered only if the hyperlink clicked is a...
Forum: Excel VBA November 30th, 2006, 02:10 PM
Replies: 0
Views: 2,396
Posted By kritimehrotra
SheetFollowHyperlink event

Hi,

I have code for the SheetFollowHyperlink event in the ThisWorkbook object.

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
ActiveWindow.ScrollRow =...
Forum: Excel VBA August 1st, 2006, 08:40 PM
Replies: 0
Views: 898
Posted By kritimehrotra
object vs text hyperlink

Hi,

I have textboxes created from the Drawing toolbar, which I have turned into a hyperlinks by right-clicking and adding a destination from there. I also have regular text hyperlinks in my...
Forum: Access VBA July 28th, 2006, 05:56 PM
Replies: 0
Views: 1,178
Posted By kritimehrotra
autocenter controls on form

Hi,

I have a rather simplistic problem that I can't find a solution to! I have a form that I want to maximize every time it opens (which I have achieved through DoCmd.Maximize in the Form_Load...
Forum: Access July 28th, 2006, 05:55 PM
Replies: 1
Views: 1,195
Posted By kritimehrotra
autocenter controls on form

Hi,

I have a rather simplistic problem that I can't find a solution to! I have a form that I want to maximize every time it opens (which I have achieved through DoCmd.Maximize in the Form_Load...
Forum: Access July 28th, 2006, 05:54 PM
Replies: 0
Views: 811
Posted By kritimehrotra
Startup Options/Database Password

Hello,

I have a database with certain startup options for the end user. What I would like is for the database to prompt for a password ONLY IF the shift key is used to try and bypass the startup...
Forum: Access VBA July 28th, 2006, 05:49 PM
Replies: 0
Views: 959
Posted By kritimehrotra
Startup Options/Database Password

Hello,

I have a database with certain startup options for the end user. What I would like is for the database to prompt for a password ONLY IF the shift key is used to try and bypass the startup...
Forum: Excel VBA July 28th, 2006, 03:25 PM
Replies: 3
Views: 3,360
Posted By kritimehrotra
hi, thanks so much for your reply, but i need...

hi,
thanks so much for your reply, but i need to hyperlink FROM a chart, not TO chart. i.e., i need the chart to be the link, not the destination of the link. any thoughts in that area?
kriti
Forum: Excel VBA July 24th, 2006, 08:32 PM
Replies: 3
Views: 1,934
Posted By kritimehrotra
yep, that worked great. i think i had posted this...

yep, that worked great. i think i had posted this earlier.
Forum: Excel VBA July 20th, 2006, 10:24 AM
Replies: 3
Views: 2,219
Posted By kritimehrotra
Thank you so so much. It worked great.

Thank you so so much. It worked great.
Forum: Excel VBA July 19th, 2006, 08:21 PM
Replies: 3
Views: 2,219
Posted By kritimehrotra
hyperlink - top/bottom of screen

Hi,

I have hyperlinks in a sheet that simply take you to other places in the same sheet. The problem I am facing is that on some computers, clicking on a link (let's say it's destination is cell...
Forum: Excel VBA July 19th, 2006, 01:58 PM
Replies: 2
Views: 1,948
Posted By kritimehrotra
worked like a charm :) thank you so much.

worked like a charm :) thank you so much.
Forum: Excel VBA July 19th, 2006, 01:57 PM
Replies: 3
Views: 3,360
Posted By kritimehrotra
chart object as anchor for hyperlink

hi,
is there a way to use a chart object as an anchor for a hyperlink in vba? probably using the statement activesheet.hyperlinks.add anchor:=... and so on.
i believe shape objects can be used as...
Forum: Access VBA July 18th, 2006, 12:37 PM
Replies: 3
Views: 1,383
Posted By kritimehrotra
hey boyd, thanks for replying... what would...

hey boyd,
thanks for replying...
what would the DoEvents do?
kriti
Forum: Excel VBA July 18th, 2006, 12:03 PM
Replies: 2
Views: 1,948
Posted By kritimehrotra
after creating chart -> type mismatch error

Hi,

I'm generating a rather lengthy report in Excel with a lot of sections, drawing on data from Access. For each "section", for various sets of data, I need to generate a chart. So far I have...
Forum: Excel VBA July 17th, 2006, 03:19 PM
Replies: 1
Views: 1,899
Posted By kritimehrotra
Hi, I'm not a 100% sure what you mean...do...

Hi,

I'm not a 100% sure what you mean...do you want the user to be able to input entries for the combo box? Or will they always be pre-defined?

Also, there are 2 ways to create a combo box in...
Forum: Excel VBA July 17th, 2006, 01:42 PM
Replies: 3
Views: 1,153
Posted By kritimehrotra
ok. i haven't used ado, i've used dao...so i'll...

ok. i haven't used ado, i've used dao...so i'll give the code based on that.

Sub Macro1()
Dim acsObj As Object
Dim acsTbl As DAO.Recordset
Dim acsDb As String
acsDb = "C:\db1.mdb"
Set acsObj...
Forum: Excel VBA July 17th, 2006, 10:21 AM
Replies: 3
Views: 1,153
Posted By kritimehrotra
Will you be appending to an already existing...

Will you be appending to an already existing table in db2? Or creating a new table?
Forum: Excel VBA July 17th, 2006, 10:20 AM
Replies: 3
Views: 1,934
Posted By kritimehrotra
hyperlink

Hi,
I have hyperlinks in a sheet in Excel, for example cell A6 is linked to A101, A7 is linked to A201, and so on (the number of such hyperlinks changes dynamically, so there isn't a fixed set). The...
Forum: Access VBA July 17th, 2006, 10:15 AM
Replies: 3
Views: 1,383
Posted By kritimehrotra
Countdown

Hi,

I have a form that generates reports for an end user by clicking a button. However, the process can take up to or a little more than half an hour. What I need is some form of timing mechanism...
Forum: Access VBA July 17th, 2006, 10:09 AM
Replies: 1
Views: 1,491
Posted By kritimehrotra
I am not sure if this is what you're looking for,...

I am not sure if this is what you're looking for, but in the VB editor, if you click on Tools -> Options -> Editor -> Tab Width, you can set how much the "auto indent" should be. If, however, you are...
Forum: BOOK: Beginning Access 2003 VBA June 30th, 2006, 01:01 PM
Replies: 3
Views: 14,090
Posted By kritimehrotra
I just realized actually, that I'm getting the...

I just realized actually, that I'm getting the exact same error for EACH sub, not just the form_load() one. So any button that I click on, I get that error. Basically my form isn't able to do...
Forum: BOOK: Beginning Access 2003 VBA June 30th, 2006, 12:35 PM
Replies: 3
Views: 14,090
Posted By kritimehrotra
On Load: "Invalid Outside Procedure"

Hi,
I have an error message popping up when I load a form, saying:

The expression On Load you entered as the event property setting produced the following error:
Invalid Outside procedure.
*...
Showing results 1 to 23 of 23

 




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