Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: jdraw
Forum: General 11-18-2019, 04:46 PM
Replies: 8
Views: 144
Posted By jdraw
Re: Adding a 'dummy' field to an historic database and updating it

Here is a link to a generic database structure relate to Legal Case management (http://www.databaseanswers.org/data_models/case_management/index.htm). You may be able to adapt to your needs.
Good...
Forum: General 11-18-2019, 03:41 PM
Replies: 8
Views: 144
Posted By jdraw
Re: Adding a 'dummy' field to an historic database and updating it

In general terms (make something up if that's easier) what is a Case? What is an incident?
Can a Case have 0,1 or possibly many Incidents?
Forms are not the big issue in my view, it's what are the...
Forum: Introduce Yourself 11-18-2019, 06:25 AM
Replies: 6
Views: 106
Posted By jdraw
Re: Hi folks

Hi vbprgmr. Welcome to the forum.
Forum: Introduce Yourself 11-18-2019, 06:22 AM
Replies: 3
Views: 69
Posted By jdraw
Re: hiii

Welcome to the forum. Further to Doc's comment, we're all here.
Forum: General 11-18-2019, 06:20 AM
Replies: 13
Views: 209
Posted By jdraw
Re: Duplicates that have no value

kitty77,

We know nothing of your application nor query(s) based on this thread. Since it is your database, you know more about the subject matter and the environment you work in.
What is the...
Forum: Queries 11-18-2019, 05:43 AM
Replies: 5
Views: 110
Posted By jdraw
Re: Item database with BOM lists

Niels,

Read through all of this post that deals with Parts and Assemblies (https://www.access-programmers.co.uk/forums/showthread.php?t=303214&highlight=assemblies). It is a less complex set up...
Forum: Queries 11-16-2019, 10:17 AM
Replies: 42
Views: 462
Posted By jdraw
Re: User Defined Function in SQL Select

So, for clarity, bCredit is a boolean variable declared within a module?
Please post the code for fDocSign .
Forum: Modules & VBA 11-16-2019, 06:26 AM
Replies: 23
Views: 306
Posted By jdraw
Re: Module needed for "random 6 string" search

Here's a sample function from a couple of years back with an example of alpha then
5 numerics
'---------------------------------------------------------------------------------------
' Procedure...
Forum: Queries 11-15-2019, 12:09 PM
Replies: 42
Views: 462
Posted By jdraw
Re: User Defined Function in SQL Select

I'm with the others --uncertain of your requirement -- but it seems that for presentation you could multiply by -1 to negate a value. However, the logic involved between the table field and the form...
Forum: Queries 11-15-2019, 09:38 AM
Replies: 42
Views: 462
Posted By jdraw
Re: User Defined Function in SQL Select

Remember, the form must be open in order to access the value.
Forum: Introduce Yourself 11-15-2019, 09:36 AM
Replies: 2
Views: 72
Posted By jdraw
Re: Hello

Welcome to AWF, Mike.
Forum: Modules & VBA 11-15-2019, 09:32 AM
Replies: 15
Views: 238
Posted By jdraw
Re: Hangman Style Search

Yes, I thought there may be some miscommunication. I was just offering that link as another approach to code underlying "Hangman" for reference.
Glad the issue has been cleared.
Forum: Modules & VBA 11-15-2019, 08:47 AM
Replies: 15
Views: 238
Posted By jdraw
Re: Hangman Style Search

Interesting -- still asking me for a password???


https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=77469&stc=1&d=1573836214
Forum: The Watercooler 11-15-2019, 08:06 AM
Replies: 47
Views: 687
Posted By jdraw
Re: Is OOP actually useful?

Another link re Implements -this from M$oft
(https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/implements-statement)

It mentions VB in the sample code, but it is...
Forum: Modules & VBA 11-15-2019, 06:49 AM
Replies: 15
Views: 238
Posted By jdraw
Re: Hangman Style Search

Sorry about that. I didn't realize it was password protected. Should have checked- sorry.
Forum: Modules & VBA 11-15-2019, 05:20 AM
Replies: 15
Views: 238
Posted By jdraw
Re: Hangman Style Search

murray83,

Here is another hangman game for Access from the forum (https://access-programmers.co.uk/forums/showpost.php?p=588851&postcount=6). It's from an older post, but may contain some code or...
Forum: Introduce Yourself 11-15-2019, 04:59 AM
Replies: 4
Views: 66
Posted By jdraw
Re: Hello!

Yeng, welcome to AWF.
Forum: The Watercooler 11-14-2019, 06:47 PM
Replies: 34
Views: 362
Posted By jdraw
Re: Enough!

Regarding Italy and the Equator (via Google)

Italy is located 3,259.92 mi (5,246.34 km) south of the North Pole. How far is Italy from the equator and on what hemisphere is it? Italy is 2,960.43...
Forum: The Watercooler 11-14-2019, 02:00 PM
Replies: 34
Views: 508
Posted By jdraw
Re: what does your username mean?

John,

Perhaps it was Naughtical Gent??
Forum: Forms 11-14-2019, 01:24 PM
Replies: 28
Views: 289
Posted By jdraw
Re: Inserting current from open form to another form.

Can you show us a graphic of your tables and relationships (relationships window)?
Forum: The Watercooler 11-14-2019, 01:22 PM
Replies: 34
Views: 508
Posted By jdraw
Re: what does your username mean?

Mine is a little less obvious, but same genre as Steve R., James Bailey, James Harris....
Forum: The Watercooler 11-14-2019, 12:49 PM
Replies: 47
Views: 687
Posted By jdraw
Re: Is OOP actually useful?

Another view of OOP and its future. (https://www.quora.com/What-will-replace-object-oriented-programming)
and yet another Access/vba/inheritance reference...
Forum: Introduce Yourself 11-13-2019, 05:47 AM
Replies: 4
Hey
Views: 79
Posted By jdraw
Re: Hey

Welcome aboard Petr.
Forum: General 11-11-2019, 05:43 PM
Replies: 26
Views: 284
Posted By jdraw
Re: Import/Export Data Tasks

Thanks dbGuy I found 3 other (different) import specs
with
?CurrentProject.ImportExportSpecifications.Count
3

?CurrentProject.ImportExportSpecifications(0).XML
<?xml version="1.0"...
Forum: Modules & VBA 11-11-2019, 04:35 PM
Replies: 10
Views: 159
Posted By jdraw
Re: Change certain Excel row 1 cell values

Chuck,
I'm not an excel person, but I'd try it on a copy of your spreadsheet. I would add it just before the wb.save line.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02: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