Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 392
Search took 0.03 seconds.
Search: Posts Made By: john471
Forum: Modules & VBA 09-17-2007, 12:48 AM
Replies: 2
Views: 743
Posted By john471
Short of writing the code for you... here is a...

Short of writing the code for you... here is a pointer to get you started...

Use the AfterUpdate event of your check box (ChkGW).

If the user has cleared the checkbox, then clear out the target...
Forum: Modules & VBA 05-31-2007, 05:09 PM
Replies: 3
Views: 1,107
Posted By john471
Thinking more about it this morning, also...

Thinking more about it this morning, also realised that you don't neeed SQL to update the "target" recordset - just use

rstarget.edit
rstarget.fields("RSRC_RATE_ID").value = lngRateID ...
Forum: Queries 05-31-2007, 07:37 AM
Replies: 6
Views: 2,535
Posted By john471
This might work 1) A Union Query (tantamount...

This might work

1) A Union Query (tantamount to appending all the records into one (temporary) table)

2) A totals query based on the Union Query; grouping on the value, and only showing results...
Forum: Theory and practice of database design 05-31-2007, 07:31 AM
Replies: 12
Views: 2,509
Posted By john471
Regrettably, I am not an access god - but I shall...

Regrettably, I am not an access god - but I shall take a stab at helping out...

Think about what entities you have and what attributes those entities have.

The enities become your tables, and...
Forum: Modules & VBA 05-31-2007, 05:35 AM
Replies: 3
Views: 1,107
Posted By john471
In no particular order:- Database...

In no particular order:-

Database Observations
---------------------
Your tables have repeating groups - this is generally considered to be bad practice.
Rsrcrate - COST_PER_QTY, COST_PER_QTY2,...
Forum: Reports 05-14-2007, 05:36 AM
Replies: 4
Views: 2,019
Posted By john471
This might get you closer, but I'm not certain...

This might get you closer, but I'm not certain about the 'date - math' aspect of it. Looking up "DateDiff" and/or "CDate" in help may prove fruitful for you.

The OR construct/useage in Excel is...
Forum: General 03-13-2007, 07:01 AM
Replies: 22
Views: 12,872
Posted By john471
Did the original developer supply the mdb of the...

Did the original developer supply the mdb of the front end, or only an mde ? If you don't have a copy of the mdb, then I don't think there is much hope. However, if you have an mdb I believe one of...
Forum: General 03-12-2007, 11:09 PM
Replies: 1
Views: 608
Posted By john471
Have you stepped through your code in debug ? ...

Have you stepped through your code in debug ?

I think you will find that your code, as written will...

If the ID number entered matches the ID of the first record in the recordset,
update the...
Forum: Queries 02-16-2007, 07:15 PM
Replies: 4
Views: 1,422
Posted By john471
Have you tried setting the "type" of the...

Have you tried setting the "type" of the parameter?

1) Open your query in design view
2) From the Query menu, select "Parameters..."
3) In the Parameter column, type in the name of your...
Forum: Queries 02-12-2007, 05:07 PM
Replies: 9
Views: 997
Posted By john471
Ogg13, So it is becoming clearer you are...

Ogg13,

So it is becoming clearer you are wanting to regularly import data that another program exports. What format does the other app expot to?

The reason for my lengthy post above is that...
Forum: Queries 02-09-2007, 01:10 AM
Replies: 9
Views: 997
Posted By john471
From what I think I understand, MStef has...

From what I think I understand, MStef has demonstrated the converse of what you are asking for:- blanking out repetitions instead of filling them in.

You could use the same technique to fill them...
Forum: Excel 02-06-2007, 09:32 PM
Replies: 13
Views: 18,400
Posted By john471
You are welcome, xltest. Thank you for taking...

You are welcome, xltest. Thank you for taking the time to reply back.
Forum: Modules & VBA 02-06-2007, 05:41 AM
Replies: 8
Views: 941
Posted By john471
P.S. I forgot to mention before.... you...

P.S.
I forgot to mention before....

you will want to update your control's value in the form's On Current event.
Forum: Modules & VBA 02-06-2007, 05:36 AM
Replies: 8
Views: 941
Posted By john471
I believe you would need an unbound control (e.g....

I believe you would need an unbound control (e.g. textbox with no control source). You would probably also set its Locked property to true (so users can't edit it).

I expect searching access...
Forum: Excel 02-05-2007, 11:16 PM
Replies: 13
Views: 18,400
Posted By john471
xltest, I realise you probably believe you...

xltest,

I realise you probably believe you are being clear, but your situation/explanation(s) still leave me a little confused.

Here is what I think I understand:

1) You are working in Excel...
Forum: SQL Server 01-22-2007, 05:22 AM
Replies: 2
Views: 1,075
Posted By john471
What version of access are you using ? I had a...

What version of access are you using ? I had a similar issue with AC97 and linked tables to an Oracle back-end. I didn't yet resolve the issue on AC97 but was able to obtain correct results with...
Forum: Modules & VBA 01-22-2007, 12:38 AM
Replies: 1
Views: 668
Posted By john471
File Integrity - obtain checksum

Hi all,

Does anyone have an easy/efficient way to compute a checksum for a text file, in order to store the file on a LAN and the checksum in a (seperate) DB ?

Presently our guys print out...
Forum: Modules & VBA 01-19-2007, 12:32 AM
Replies: 9
Views: 1,276
Posted By john471
P.S. I may well be out of line, 'cause I...

P.S.

I may well be out of line, 'cause I haven't worked with CurrentProject. I'm still stuck in AC97 most of the time. Apologies if so.

John.
Forum: Modules & VBA 01-19-2007, 12:25 AM
Replies: 9
Views: 1,276
Posted By john471
My first (and only) suspicion is (as the_doc_man...

My first (and only) suspicion is (as the_doc_man suggests, without actually spelling it out) that you need a

conn.close

in your exit section. As he also infers, your checks for an open rs are...
Forum: Tables 12-19-2006, 01:20 AM
Replies: 6
Views: 1,178
Posted By john471
A code free way to skin the cat... Create a...

A code free way to skin the cat...

Create a new table

tblRandom
----------
RandomID (Autonumber, Random (not increment))
YourMainTablePK (as FK ??"SKU"??)

1) Delete all records in...
Forum: Queries 12-18-2006, 05:19 PM
Replies: 4
Views: 1,375
Posted By john471
Good luck with it. I still suggest you look into...

Good luck with it. I still suggest you look into normalisation - it will save you headaches in the long run; and the sooner you do it the easier it will be. Add an index to the FK field, and I'm...
Forum: Queries 12-17-2006, 07:06 PM
Replies: 4
Views: 1,375
Posted By john471
Are the fields you listed the only fields in each...

Are the fields you listed the only fields in each of your tables, or are there others? If they are the only fields, then you should consider reading up on database normalisation. Even if they...
Forum: Queries 12-17-2006, 06:58 PM
Replies: 4
Views: 1,375
Posted By john471
The type of query you are looking for is termed a...

The type of query you are looking for is termed a Union Query. MS Access help is reasonably good on this, once you know what to search for ("union query").

HTH

Regards

John.
Forum: General 12-14-2006, 07:54 PM
Replies: 4
Views: 673
Posted By john471
Of course I had the realisation this morning that...

Of course I had the realisation this morning that if 'Person' was a member of 'Group' which has permissions, and 'Person' has a copy of this security file; then 'Administrator' removes 'Person' from...
Forum: Forms 12-14-2006, 01:59 AM
Replies: 6
Views: 926
Posted By john471
It might be more efficient to have the user type...

It might be more efficient to have the user type in the postcode (easier to type correctly than a suburb name), then use a cascading combo box to select the suburb from the list of matching results. ...
Showing results 1 to 25 of 392

 
Forum Jump



All times are GMT -8. The time now is 01:06 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World