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 16 of 16
Search took 0.01 seconds.
Search: Posts Made By: goels
Forum: Access VBA October 14th, 2004, 10:02 AM
Replies: 1
Views: 1,114
Posted By goels
Adding value to a date & setting update criteria

Hi all,

I have a two column table in which the dates are stored in a mmddyyyy format. Now i have to create a query whereby i can check if the date that i have in my Datesupdate field for whether...
Forum: Access VBA October 13th, 2004, 12:26 PM
Replies: 2
Views: 11,102
Posted By goels
Hey thanks Clive. I actually in the meantime...

Hey thanks Clive. I actually in the meantime found out two ways of doing the same:

(I)
Dim dDate As Date
Dim strText As String
dDate = Date
strText = Replace(CStr(dDate), "/", "")

The...
Forum: Access VBA October 13th, 2004, 10:11 AM
Replies: 2
Views: 11,102
Posted By goels
Date conversion in Access VBA

Hi all,

I have a two column table in my Access database which is used to store dates. The dates are stored as mm/dd/yy say like 10/13/04. But i want to get the dates passed to a string variable as...
Forum: Access VBA October 7th, 2004, 08:13 AM
Replies: 0
Views: 2,670
Posted By goels
Opening MSAccess Form from Desktop shortcut

Hi all,

I have an MS Access form which is used to display reports according to the combination chosen in it's combo boxes. I wanted to know if there is a way in which i could create a shortcut for...
Forum: Access VBA October 7th, 2004, 06:58 AM
Replies: 6
Views: 2,233
Posted By goels
Thanks Greg i just did that and it's working...

Thanks Greg i just did that and it's working perfectly fine.

Chow
Goels
Forum: Access VBA October 7th, 2004, 06:01 AM
Replies: 6
Views: 2,233
Posted By goels
Hi all, I have solved the issue of ...

Hi all,

I have solved the issue of cboaccountname.Value not showing the requisite value. What happens is that by defult it takes the value in column 0 which is the primary key value. So we have...
Forum: Access VBA October 7th, 2004, 04:14 AM
Replies: 6
Views: 2,233
Posted By goels
Hi Greg, I used & instead of + but the...

Hi Greg,

I used & instead of + but the result is the same i.e instead of the value within cboacountname say Microsoft getting passed, it's position in the table i.e say if it is record no.2, 2...
Forum: Access VBA October 6th, 2004, 12:18 PM
Replies: 6
Views: 2,233
Posted By goels
A Access Form issue

Hi all,

I have a form in Access which has 3 combo boxes representing the entities accountname, date and report type respectively. The value in these comboboxes is coming from 3 separate tables...
Forum: Access October 5th, 2004, 08:33 AM
Replies: 1
Views: 3,803
Posted By goels
Inserting a MSAccess form into an Intranet webpage

Hi all,

I have a MS Access form which has 3 combo boxes on it. These combo boxes are there to get a combination of account name, report type and date; and then according to the chosen combination...
Forum: Access VBA October 1st, 2004, 02:38 PM
Replies: 7
Views: 7,709
Posted By goels
Dear Ray, One can acheive the desired...

Dear Ray,

One can acheive the desired functionality thru:

Shell ("\\lvamfs01\advent\Axys\Axys32.Exe script testappend3.scr " & batchpassvalue & " -exit")

Cheers
Goels
Forum: Access VBA October 1st, 2004, 02:36 PM
Replies: 1
Views: 1,172
Posted By goels
Dear All, I found out the way in which one...

Dear All,

I found out the way in which one can acheive the desired functionality. Posting the answer here as it might be of some help to any viewer:

Shell ("\\lvamfs01\advent\Axys\Axys32.Exe...
Forum: Access VBA October 1st, 2004, 06:29 AM
Replies: 1
Views: 1,172
Posted By goels
Expandable Variables

Dear All,

Here's a quick one:

I was trying to pass parameters to this script file in VBA code :

Shell "\\lvamfs01\advent\Axys\Axys32.Exe script testappend3.scr batchpassvalue -exit"

where...
Forum: Access VBA October 1st, 2004, 06:06 AM
Replies: 7
Views: 7,709
Posted By goels
Dear Ray, Thanks a lot for your prompt...

Dear Ray,

Thanks a lot for your prompt reply. To update you on the problem, i was actually trying to run an Axys (the financial software which runs at my place ) script file from VBA code and...
Forum: Access VBA September 30th, 2004, 03:05 PM
Replies: 7
Views: 7,709
Posted By goels
Creating, Writing to and Deleting Text Files

Hi all,

I am trying to achieve the following functionality using VBA code:

Create a text file
Store a string in that text file, the string itself being contained in a String variable.
(Then...
Forum: Access VBA September 30th, 2004, 08:44 AM
Replies: 2
Views: 12,086
Posted By goels
Thanks a lot for your help. It was such an...

Thanks a lot for your help. It was such an oversight on my part not to notice it. Thanks a lot.

Cheers
Goels
Forum: Access VBA September 30th, 2004, 08:21 AM
Replies: 2
Views: 12,086
Posted By goels
Nested Do Until Loop

Hi Everyone,

When I test the below given code in the immediate window of VBA Editor the innermost loop functions while the outer loop is not entered into after the innermost loop has finished.
...
Showing results 1 to 16 of 16

 




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