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 20 of 20
Search took 0.01 seconds.
Search: Posts Made By: amerk20
Forum: Excel VBA January 10th, 2006, 03:32 PM
Replies: 5
Views: 7,085
Posted By amerk20
Maccas, Thank you sooooo much. This worked...

Maccas,

Thank you sooooo much. This worked perfectly!

Cheers!

Rick
Forum: Excel VBA January 10th, 2006, 02:21 PM
Replies: 1
Views: 1,942
Posted By amerk20
You should be able to use the UserName property...

You should be able to use the UserName property of the Application object to return or set the name of the current user.

Example
This example displays the name of the current user.

MsgBox...
Forum: Excel VBA January 10th, 2006, 02:14 PM
Replies: 5
Views: 7,085
Posted By amerk20
Need help AFTER saving an Excel File

In Excel 2003, I currently have code that changes the xlCalculation setting to MANUAL (instead of Automatic) at the BEFORESAVE Event of "this workbook". What I'm now looking for is a way to...
Forum: Access VBA August 30th, 2005, 07:44 AM
Replies: 6
Views: 1,776
Posted By amerk20
It worked perfectly. Thank you very much. :) ...

It worked perfectly.
Thank you very much. :)

Rick
Forum: Access VBA August 29th, 2005, 10:36 AM
Replies: 6
Views: 1,776
Posted By amerk20
This sounds like a good idea. Can you give me an...

This sounds like a good idea. Can you give me an example of how this is done? Am I to open a recordset and then delete it? Sorry, I'm a bit confused as to how to delete the data and replace it...
Forum: Access VBA August 29th, 2005, 08:35 AM
Replies: 6
Views: 1,776
Posted By amerk20
Replace and existing table with an updated one

I have a very small table (tbl_emp_lcl) that is stored on the client's side of a split database scenario (other tables are stored on server and linked to the client front end). I've written code to...
Forum: Access VBA May 27th, 2005, 12:06 PM
Replies: 1
Views: 3,603
Posted By amerk20
Hi, You can use DoCmd.Maximize This...

Hi,

You can use DoCmd.Maximize

This command has no arguments as it maximized the active window.

Hope this helps you!

Cheers!
Forum: Access April 20th, 2005, 09:52 AM
Replies: 1
Views: 1,918
Posted By amerk20
Access is unable to open database window

I receive this error on a database that was created in Access 2003, but converted to Access 2000. The funny thing is, during the conversion process, I received another error stating "The form name '...
Forum: Access VBA April 14th, 2005, 10:38 AM
Replies: 5
Views: 1,486
Posted By amerk20
Here is the code I use... give it a try: ...

Here is the code I use... give it a try:

Function submit_Close()
On Error GoTo error_submitClose
Call OpenAConnection
Call ADDRecord
Exit Function
error_submitClose:
Dim EMsg, ETitle,...
Forum: VB How-To April 8th, 2005, 10:41 AM
Replies: 1
Views: 2,222
Posted By amerk20
check for directory, or create new if not found

I'm using the transferspreadsheet function in VBA (Access 2003) to create .xls files of several queries. I would like these "output" files to be saved to a directory with the path of "C:\IPDC...
Forum: Access VBA March 14th, 2005, 09:52 AM
Replies: 6
Views: 2,014
Posted By amerk20
And you'll need the following declarations: ...

And you'll need the following declarations:

Declare Sub SetWindowPos Lib "user32" (ByVal hwnd&, _
ByVal hWndInsertAfter&, _
ByVal x&, ByVal Y&, ByVal cX&, _
ByVal cy&, ByVal wFlags&)
Declare...
Forum: Access VBA March 14th, 2005, 09:50 AM
Replies: 6
Views: 2,014
Posted By amerk20
Sorry... I forgot to include very important...

Sorry... I forgot to include very important step. In the Autoexec macro of your db, you'll want to add the following FUNCTION NAME reference: SizeAccess (450,355,25,160)

This should put the...
Forum: Access VBA March 11th, 2005, 10:03 AM
Replies: 6
Views: 2,014
Posted By amerk20
You could do what I do... have the Access (host...

You could do what I do... have the Access (host window) re-size itself upon startup and then center itself on the user's screen. All of the forms (including switchboard) open as pop-ups over top of...
Forum: Excel VBA February 10th, 2005, 05:06 PM
Replies: 1
Views: 1,617
Posted By amerk20
Print preview "unhides" previously hidden objects

I've got an Excel 2003 form that has several ActiveX combo boxes. I have code that hides and unhides them based on actions taken by the user.

My problem is that, no matter what, whenever the...
Forum: Access VBA November 29th, 2004, 04:51 PM
Replies: 5
Views: 1,222
Posted By amerk20
Thanks for the input. I like the idea of having...

Thanks for the input. I like the idea of having a button available to the users to "refresh" the tables. This gives them the opportunity to refresh whenever they like, or when I indicate that...
Forum: Access VBA November 24th, 2004, 01:21 PM
Replies: 5
Views: 1,222
Posted By amerk20
Thanks. That is an option we've discussed,...

Thanks. That is an option we've discussed, however due to performance issues (over the server), it is one we'd like to avoid if at all possible.

That's why I thought if there was a way to...
Forum: Access VBA November 24th, 2004, 12:31 PM
Replies: 5
Views: 1,222
Posted By amerk20
Compare FE table with same BE version of table

Hello,

With my Access "split" DB application, I have the following scenario that I need help with.

Backend is hosted on a server
Client is loaded on each person's local computer.

"Client"...
Forum: Excel VBA August 27th, 2004, 10:28 AM
Replies: 9
Views: 29,524
Posted By amerk20
Hello everyone. The problem of SLOW open,...

Hello everyone.

The problem of SLOW open, save, and close of Excel is actually quite common. The solution is to delete all of your *.emf files. These are temporary files created by excel each...
Forum: Access VBA March 23rd, 2004, 03:35 PM
Replies: 2
Views: 1,951
Posted By amerk20
Thanks for your help. I found that although I...

Thanks for your help. I found that although I loaded the .ocx files onto the new machine, they were NOT registered. Once I went through the regester procedures, all worked fine and good.

Thanks...
Forum: Access VBA March 12th, 2004, 02:21 PM
Replies: 2
Views: 1,951
Posted By amerk20
Problems with MSFlexgrid

I've written an Access 2000 application that uses an MSFlexgrid on one of it's forms. When this application is run on a PC running WIN2000 and Office 2000, all is GOOD.

When it's run on a PC...
Showing results 1 to 20 of 20

 




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