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 25 of 42
Search took 0.01 seconds.
Search: Posts Made By: timmaher
Forum: Access January 6th, 2006, 11:36 AM
Replies: 8
Views: 6,135
Posted By timmaher
Hi Greg, Many thanks for your reply!!! ...

Hi Greg,

Many thanks for your reply!!!

it seems to stop at the "Option Compare Database" line at the very top of the VB code (happens on any form I open).

Any ideas?????
Forum: Access January 6th, 2006, 08:43 AM
Replies: 8
Views: 6,135
Posted By timmaher
Corrupt DB - You cancelled the previous operation

Hi,

I have an access database (ver 2000). When I open the database, i get an error message

"You cancelled the previous operation"

Also, when I try and open and compile a for, I get another...
Forum: Classic ASP Databases September 28th, 2005, 03:57 AM
Replies: 0
Views: 2,453
Posted By timmaher
Access MDB with a Linked SQL Server Table.....

Hi,

Ive set a up an ASP page which successfully connects to an Access Database. My problem is with a linked table in this database which is held in a Sequel Server Database (ODBC). I have the...
Forum: Classic ASP Databases September 14th, 2005, 10:01 AM
Replies: 2
Views: 1,329
Posted By timmaher
Hi, Thanks for the reply. Could you be more...

Hi,

Thanks for the reply. Could you be more specific in your reply?

Many thanks

Tim

Tim
Forum: Classic ASP Databases August 26th, 2005, 08:10 AM
Replies: 2
Views: 1,329
Posted By timmaher
Using Values from a ListBox

Hi,

Ive set up a listbox in an asp page :

<select name="Specialty" size="1"onchange=msgbox"tim">
<option value="1200">ENT</option>
<option value="1400">Oral Surgery</option>
<option...
Forum: Classic ASP Databases August 25th, 2005, 09:47 AM
Replies: 0
Views: 1,455
Posted By timmaher
Display Crosstab Query Results - HELP?

Hi,

Is it possible to display the rusults of a crosstab query in an asp page???

Ive written the followign script but keep getting an error:

strSQL = "TRANSFORM Count([OP MORR...
Forum: Access August 22nd, 2005, 07:36 AM
Replies: 2
Views: 1,603
Posted By timmaher
Hi, Thanks for the reply. How can I...

Hi,

Thanks for the reply.

How can I check on what my netork rights are???

I tested it again by trying to link to an axcel file held on my hard drive and the same error occured. For info, I...
Forum: Access August 22nd, 2005, 06:14 AM
Replies: 2
Views: 1,603
Posted By timmaher
Linking To Excel - Error

Hi,

I am getting an error "This recordset is not updateable" when I try to link to an Excel file from Access 2000.

I have been linking with no problems before.

Any ideas greatly appreciated....
Forum: Access July 8th, 2005, 05:00 AM
Replies: 1
Views: 3,480
Posted By timmaher
Numeric Field Overflow - Error -- HELP!

Hi,

I am running an append query bit only sometimes I get a "numeric field overflow" error?????

I have a text file linked to access 97. I am running an append query to convert a few text...
Forum: Access VBA June 7th, 2005, 05:21 AM
Replies: 3
Views: 4,794
Posted By timmaher
Hi, Thanks for the reply. Ive tried everything...

Hi, Thanks for the reply. Ive tried everything possible. There is isn't an LDB file. If I try and import to a new database I get the same error message :

"The microsoft jet database engine...
Forum: Access VBA June 2nd, 2005, 10:21 AM
Replies: 3
Views: 4,794
Posted By timmaher
JetComp Wont Work .....HELP!!

Hi,

On trying to open an access 2000 database I get the error : "The microsoft jet database engine stopped the process becuase you and another user are attempting to change the same data at the...
Forum: Access VBA May 10th, 2005, 07:50 AM
Replies: 2
Views: 1,236
Posted By timmaher
Altering a recordsetclone search??

Hi I hope you can help.

I have two list boxes on a form. The first one displays record id numbers for selection (Combo74). On selection of a number the following routine is run:


Sub...
Forum: Access VBA May 10th, 2005, 07:36 AM
Replies: 4
Views: 2,978
Posted By timmaher
Thanks for all the help guys. Will give them...

Thanks for all the help guys.

Will give them a try.

Tim

Tim
Forum: Access VBA May 5th, 2005, 09:31 AM
Replies: 4
Views: 2,978
Posted By timmaher
Calculating hours and minutes between to dates

Hi,

I'm having some difficulty trying to get to grips with the Datediff function and working out the difference in hours between to dates/times.

Has anyone successfully tried this????

Thanks...
Forum: Access VBA April 21st, 2005, 04:05 AM
Replies: 2
Views: 1,073
Posted By timmaher
Thanks for the reply. I didnt think about a...

Thanks for the reply. I didnt think about a "third party" option!! Sounds like the best way.

Many thanks

Tim

Tim
Forum: Access VBA April 20th, 2005, 04:25 AM
Replies: 2
Views: 1,073
Posted By timmaher
Possible to Create Acc 97 mdb from Acc 2000??

Hi,

I currently have a data warehouse set up in Access 2000. Is it possible, once the warehouse is updated, to run a subroutine to create a small access 97 database and export a few tables into...
Forum: Access VBA March 9th, 2005, 11:28 AM
Replies: 7
Views: 3,610
Posted By timmaher
Hi again, After using a 'pause' the...

Hi again,

After using a 'pause' the following info was displayed in the command window:

c:\Documents and Settings\INFORMATION\My Documents>

which told me that it was trying to start the...
Forum: Access VBA March 9th, 2005, 10:17 AM
Replies: 7
Views: 3,610
Posted By timmaher
Thanks again for the advice. I tried what you...

Thanks again for the advice. I tried what you suggested and ran the batch file from the command prompt and it worked fine. However, when I try and run it through vba (ive got a button on a user...
Forum: Access VBA March 9th, 2005, 06:38 AM
Replies: 7
Views: 3,610
Posted By timmaher
Hi, I attempted your srcipt and I dont think...

Hi,

I attempted your srcipt and I dont think Ive grasped it fully. This is what I have done so far....

1) Ive created the batch file which contains :

@EHCO OFF
REM SETUP FOR FTP...
Forum: Access VBA March 9th, 2005, 05:44 AM
Replies: 7
Views: 3,610
Posted By timmaher
Thanks for the reply. I will give it a try...

Thanks for the reply.

I will give it a try and get back to you.

Many thanks for your time

Tim

Tim
Forum: Access VBA March 8th, 2005, 07:51 AM
Replies: 7
Views: 3,610
Posted By timmaher
Using FTP Commands from Access 2000

Hi I don't know if this is possible. I have an Access 2000 database which imports text files using saved import specifications. These test files are obtained by using ftp from a local server. eg...
Forum: Excel VBA September 2nd, 2004, 05:15 AM
Replies: 1
Views: 7,080
Posted By timmaher
Insert Image Using VBA

Hi,

Does anyone have the code to insert an image (ie, company logo) using vba in excel 97???

Many Thanks

:)

Tim
Forum: Access VBA August 31st, 2004, 04:04 AM
Replies: 2
Views: 2,588
Posted By timmaher
Thanks Mate, Will give it a try!! ...

Thanks Mate,

Will give it a try!!



Tim
Forum: SQL Server 2000 August 25th, 2004, 05:51 AM
Replies: 1
Views: 507
Posted By timmaher
Help Me get Funding!!!

Hi I'm trying to get funding from my employer to study an MSDBA course. To get this I need to give him a business case describing how our department will benefit from upgrading to Sequel Server from...
Forum: Access VBA August 24th, 2004, 09:08 AM
Replies: 2
Views: 2,588
Posted By timmaher
Error "Too Few Parameters - Expected 1"

Error in the following code:

sql = "INSERT INTO SPCCalculator ( [Value], [Date], [Description] ) "

sql = sql + "SELECT...
Showing results 1 to 25 of 42

 




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