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 46
Search took 0.01 seconds.
Search: Posts Made By: elansolutionsltd
Forum: Access VBA August 3rd, 2006, 07:46 AM
Replies: 4
Views: 4,419
Posted By elansolutionsltd
The reason that your checkboxes are all greyed...

The reason that your checkboxes are all greyed out is that they have no values assigned to them, either by your code or in the Checkbox.DefaultValue property. As they are unbound, Access will always...
Forum: Access VBA July 7th, 2006, 02:31 PM
Replies: 1
Views: 1,491
Posted By elansolutionsltd
Auto Indent

When I was writing Access script in Access 95 (God! Am I that old?) there was a great utility that auto-indented the script to insert a tab sdpace on the lines between if...EndIf, Do.. Loop etc...
Forum: Access VBA February 26th, 2006, 08:17 AM
Replies: 3
Views: 1,887
Posted By elansolutionsltd
Many thanks Bob, you've saved my phone ringing at...

Many thanks Bob, you've saved my phone ringing at 2 a.m. with an irate user telling me "your programme's fallen over". Now they will know they have to perform houskeeping before they run.

Cheers!
Forum: Access VBA February 25th, 2006, 01:17 PM
Replies: 3
Views: 1,887
Posted By elansolutionsltd
Free space on disc

Due to some strange managerial decisions, I run a process on a 200Gb USB drive. However, the process eats a lot of space as it is used to unzip some huge text files before processing the files into...
Forum: Access VBA February 14th, 2006, 01:56 PM
Replies: 2
Views: 1,473
Posted By elansolutionsltd
ALike

This is so basic that I'm almost embarrassed to ask, but I b******d if I can find the answer.

I have a piece of SQL in a small module that sets the RecordSource of a form depending on a value...
Forum: Access January 18th, 2006, 12:50 PM
Replies: 5
Views: 2,710
Posted By elansolutionsltd
The Microsoft Knowledge Base Article ID : 287655...

The Microsoft Knowledge Base Article ID : 287655 gives you lots of scenarios similar to that you are seeking
Forum: Access VBA January 18th, 2006, 07:20 AM
Replies: 5
Views: 8,322
Posted By elansolutionsltd
Table Exist?

I frequently use SysCmd to check whether a form is open or not and it works very well. However, is there a variant of SysCmd that can tell me whether a table exists or not within the current (or even...
Forum: Access VBA January 12th, 2006, 06:11 PM
Replies: 4
Views: 7,273
Posted By elansolutionsltd
Many thanks, Bob. Works like a dream and...

Many thanks, Bob.

Works like a dream and catches both ODBC and 'normal' linkages. You've made a fast-ageing programmer very happy
Forum: Access VBA January 12th, 2006, 07:15 AM
Replies: 4
Views: 7,273
Posted By elansolutionsltd
Finding linked tables

When scrolling through the TableDefs collection using a For Each..Next loop, is there any way of identifying if the current table is linked or local, and if it is linked, reporting what it is linked...
Forum: Access VBA January 8th, 2006, 12:29 PM
Replies: 6
Views: 11,512
Posted By elansolutionsltd
The code you need is DoCmd.RunSQL "SELECT *...

The code you need is

DoCmd.RunSQL "SELECT * FROM Employee WHERE [Name] = '" & "My Name" & "';"


"My Name" could equally well be a variable

Sometimes Access in awkward and you might need to...
Forum: Access VBA January 3rd, 2006, 08:13 AM
Replies: 1
Views: 4,552
Posted By elansolutionsltd
Unzipping gz files

I have an application which processes data that is received in zipped files with a '.gz' suffix from our mainframe. Normally these files can be unzipped manually using WinZip, but it takes longer to...
Forum: Access VBA November 11th, 2005, 06:25 AM
Replies: 7
Views: 2,094
Posted By elansolutionsltd
Works perfectly. Thanks very much, you have no...

Works perfectly. Thanks very much, you have no idea how much this helps.

Spikey
Forum: Access VBA November 8th, 2005, 05:39 AM
Replies: 4
Views: 1,467
Posted By elansolutionsltd
This is probably too late, but the following link...

This is probably too late, but the following link SHOULD take you to a form on the AccessWeb where the full syntax of using subforms is tabulated. I have found this invaluable and keep it as hard...
Forum: Access VBA November 8th, 2005, 05:30 AM
Replies: 7
Views: 2,094
Posted By elansolutionsltd
Sorry, but I cannot get this to work. I have...

Sorry, but I cannot get this to work. I have tried 'Dim'-ing the variables as either nothing ( = a Variant), directly as a Variant, and even as an Object, but the programme fails to recognise the...
Forum: Access VBA November 4th, 2005, 08:08 AM
Replies: 7
Views: 2,094
Posted By elansolutionsltd
Renaming remote mdb file

I have a database which controls the operation of 15 others. At times the remote databases grow too large and need compacting. Rather than doing this manually, I want to programme the master database...
Forum: Access VBA September 9th, 2005, 02:34 PM
Replies: 3
Views: 1,925
Posted By elansolutionsltd
Whilst I have no doubt that the code will work,...

Whilst I have no doubt that the code will work, isn't it simpler to use the Split method and just count the number of lines in the resulting array using Ubound?
Forum: Access VBA September 9th, 2005, 02:24 PM
Replies: 1
Views: 1,142
Posted By elansolutionsltd
Exporting Charts

Don't know whether this is Access or Excel, but here goes.

I have a database which manipulates over 1 million records per day. I produce charts of the summarised data created using the Form, Chart...
Forum: Access VBA September 8th, 2005, 03:45 PM
Replies: 9
Views: 139,923
Posted By elansolutionsltd
I knew I had some code lying around. Try this ...

I knew I had some code lying around. Try this

Dim fd As FileDialog
Dim objfl As Variant
Dim filnam As String

... other code .....

Set fd = Application.FileDialog(msoFileDialogFilePicker)...
Forum: Access VBA September 8th, 2005, 03:34 PM
Replies: 9
Views: 139,923
Posted By elansolutionsltd
You need first to Open a reference to the...

You need first to Open a reference to the Microsft Office 10.0 (or later) library and this allows you to use

Application.FileDialog(msoFolderPicker) or ...(msoFilePicker)

If you follow the...
Forum: Access VBA July 26th, 2005, 11:36 AM
Replies: 9
Views: 3,824
Posted By elansolutionsltd
re: If Len(txt)then .. This is how it was...

re: If Len(txt)then ..

This is how it was explained to me once, and it appears to work.

The If statement tests a condition, the result being True or False - so far nothing startling! However,...
Forum: Access VBA July 1st, 2005, 02:34 PM
Replies: 5
Views: 2,077
Posted By elansolutionsltd
A simple, non-hightech answer is to save your...

A simple, non-hightech answer is to save your Excel file as as .txt (or .csv) file and then when you link to the text file, you can click on the Advanced button and it allows you to import any column...
Forum: Access June 28th, 2005, 04:27 AM
Replies: 2
Views: 1,666
Posted By elansolutionsltd
Someone far more advanced than I will probably...

Someone far more advanced than I will probably say that this is rubbish, but I have come across this problem too (in an Access2000 project - I have not seen it in 2003, yet). I solved it by not using...
Forum: Access June 27th, 2005, 02:29 PM
Replies: 1
Views: 1,155
Posted By elansolutionsltd
Unless I've missed the point completely, I think...

Unless I've missed the point completely, I think you have almost answered your own question. The way that most people generate simple SQL strings (if they're honest) is in Query design, view the SQL,...
Forum: Access VBA June 24th, 2005, 06:12 AM
Replies: 3
Views: 1,586
Posted By elansolutionsltd
I can't really see why you would need to do this...

I can't really see why you would need to do this either, but the code you would need is

DoCmd.RunSQL "CREATE INDEX A on [table-name] (field1, field2, ....) [WITH PRIMARY]"

where A is the name...
Forum: Access VBA June 24th, 2005, 06:03 AM
Replies: 0
Views: 2,670
Posted By elansolutionsltd
dbSeeChanges

I have two problems. The first is quite simple, the second I suspect is not.

1. I have a forecasting database which uses an inflation factor chosen from a combobox. The box itself displays the...
Showing results 1 to 25 of 46

 




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