Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.77 seconds.
Search: Posts Made By: jdraw
Forum: Introduce Yourself Yesterday, 03:11 PM
Replies: 10
Views: 102
Posted By jdraw
Re: Hello - Old Dinosaur here

Seems like old time - I recall starting with IBM 1620, then PDP11-05 with macro11, PDP11-45 RSTS-E, and RSX-11D ; IBM 360, 370-155... geez --maybe we're all dinosaurs????
Forum: Introduce Yourself Yesterday, 12:11 PM
Replies: 10
Views: 102
Posted By jdraw
Re: Hello - Old Dinosaur here

Welcome to the forum.
Forum: Forms Yesterday, 08:52 AM
Replies: 6
Views: 66
Posted By jdraw
Re: Prevent duplicate entry & Spill Checker

Did you write this code?

You have an orphan Else and 2 orphan End if as Ridders said.

What did you intend this code to do? and under what condition(s)?
Forum: Modules & VBA Yesterday, 06:26 AM
Replies: 9
Views: 74
Posted By jdraw
Re: DblClick list box item to run query

Have you tried this? What result? If error, please tell us the number/description.
Forum: Forms Yesterday, 06:03 AM
Replies: 6
Views: 66
Posted By jdraw
Re: Prevent duplicate entry & Spill Checker

Here is your code with indentation via Smart Indenter. It may help you track down the missing IF.

Note: Each IF should be matched with an End IF

Private Sub Form_BeforeUpdate(Cancel As Integer)...
Forum: Site Suggestions Yesterday, 05:07 AM
Replies: 11
Views: 552
Posted By jdraw
Re: Posts hibernating in moderators area?

10-4 Tony. I have approved a post (or 2) and forgot/didn't know to approve attachment also.
Such a relief, the other possibility was that the OP has just now tested the suggestion.

Thanks for...
Forum: Site Suggestions Yesterday, 04:52 AM
Replies: 11
Views: 552
Posted By jdraw
Re: Posts hibernating in moderators area?

This may be off topic but I recall others discussing old posts showing up much later than the posted date.
I received an email re a response to a post today 17-nov-2017. It was for this post...
Forum: Tables Yesterday, 04:37 AM
Replies: 1
Views: 53
Posted By jdraw
Re: Accessing a Web Service

I suggest you give readers a little more info on what exactly you are looking for.
Please elaborate on "nifty".

Here's a link in this forum that has related info...
Forum: General 11-16-2017, 02:38 PM
Replies: 4
Views: 183
Posted By jdraw
Re: stock control

You may find relevant info from this free youtube video (https://www.youtube.com/watch?v=9HRmSRR29fY).

Also, review posts in some Access forums to get a feel for the issues and questions that...
Forum: General 11-16-2017, 01:49 PM
Replies: 11
Views: 174
Posted By jdraw
Re: Upgrade advice for a retired DB programmer

I don't see any requirements that would make me update. Your Access 2007 can work with mdb and accdb as far as I know.
Forum: General 11-16-2017, 01:43 PM
Replies: 11
Views: 174
Posted By jdraw
Re: Upgrade advice for a retired DB programmer

If you own the copy of Access 2007 on your current machine, and you plan on replacing that machine with a newer laptop and windows 10, you could install access 2007 on the new machine.(if you still...
Forum: Queries 11-16-2017, 06:08 AM
Replies: 12
Views: 145
Posted By jdraw
Re: IIF AND Statements

omo_ekun,

Don't overlook Google or Bing to help with your research.

Lots of SQL info, joins, examples. (https://www.w3schools.com/sql/)

It is always helpful to readers and you if you provide...
Forum: Modules & VBA 11-14-2017, 04:09 PM
Replies: 16
Views: 289
Posted By jdraw
Re: VBA code to check each MS Object object size

Yes, that post by ghudson has been referenced many time over the years.
Forum: General 11-14-2017, 07:31 AM
Replies: 8
Views: 346
Posted By jdraw
Re: Beginner: Sanity Check

Nathan,
I have put some links together in this post (http://www.accessforums.net/showthread.php?t=65220&p=352133#post352133) that may be helpful.
Good luck.
Forum: Modules & VBA 11-14-2017, 07:19 AM
Replies: 16
Views: 289
Posted By jdraw
Re: VBA code to check each MS Object object size

Agreed.
You could do a save to text in a new directory and get all objects and sizes with file explorer. But it's still a approximation. If the user understands the values will/could change, then...
Forum: Modules & VBA 11-14-2017, 06:35 AM
Replies: 16
Views: 289
Posted By jdraw
Re: VBA code to check each MS Object object size

Hi Colin,
I recalled having done this previously. I searched and found this.
I posted this on UA (http://www.utteraccess.com/forum/index.php?showtopic=1938952)years back

Yes there are provisos,...
Forum: Tables 11-14-2017, 06:25 AM
Replies: 3
Aol
Views: 84
Posted By jdraw
Re: Aol

Did you consider just linking to the tables in your second database?

If you are new to database, I recommend you don't DELETE anything without a proper backup.

Can you describe the business...
Forum: Modules & VBA 11-14-2017, 05:56 AM
Replies: 16
Views: 289
Posted By jdraw
Re: VBA code to check each MS Object object size

Just saw this.
I have a proc from a few years back that gets approximate table sizes in a database.
The original was written by a colleague on a different forum/group. I have made a few minor...
Forum: Modules & VBA 11-14-2017, 04:57 AM
Replies: 5
Views: 107
Posted By jdraw
Re: use sql to update(append) new data to it

Please tell us more with some details.

You mention a table, but show us a form.
I would advise against using field and object names with embedded spaces.

It seems you want to add records to a...
Forum: Queries 11-13-2017, 08:28 AM
Replies: 21
Views: 378
Posted By jdraw
Re: Grouping records

?? it' a query. Does it run for 10 records? How did you test it?
Do you have some records with null/empty string or missing data?

Can you post a copy of the database (zip format)? We don't need...
Forum: Queries 11-13-2017, 07:46 AM
Replies: 21
Views: 378
Posted By jdraw
Re: Grouping records

What exactly did you get working?

What does this mean--it's killing the system?
Forum: Queries 11-12-2017, 10:48 AM
Replies: 6
Views: 143
Posted By jdraw
Re: Count by area type query

I used a statecity table
Forum: Queries 11-12-2017, 10:30 AM
Replies: 6
Views: 143
Posted By jdraw
Re: Count by area type query

What do you want as final format/result?

SELECT MAS.COLOR, CityState.State, Count(MAS.COLOR) AS CountOfCOLOR
FROM MAS INNER JOIN CityState ON MAS.CITY = CityState.City
GROUP BY MAS.COLOR,...
Forum: Queries 11-11-2017, 08:10 AM
Replies: 21
Views: 378
Posted By jdraw
Re: Grouping records

Try:

SELECT DISTINCT Tblname.Reference
, Tblname.name
, concatrelated("[item] & ' ' & [cost]","tblname","reference =" & [reference]) AS ConcatField
FROM Tblname
ORDER BY Reference desc;

...
Forum: General 11-11-2017, 06:09 AM
Replies: 16
Views: 477
Posted By jdraw
Re: Selecting all records for TWO tables via an SQL command

Pesky,

Please step back and tell us what you are trying to do in plain English.
You mentioned all records in 2 tables; then told us it was really 3 tables...??

I have a feeling there is a...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:31 AM.


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

Sponsored Links

How to advertise

Media Kit


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