Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.40 seconds.
Search: Posts Made By: jdraw
Forum: Introduce Yourself Today, 04:18 AM
Replies: 8
Views: 68
Posted By jdraw
Re: Hello from Fallon, Nevada, USA

Welcome to AWF Tanya.
Forum: Forms Yesterday, 05:12 AM
Replies: 2
Views: 57
Posted By jdraw
Re: Combining 2 codes under one button

I suggest that you describe what you are trying to accomplish is 3-4 lines in plain simple English. Readers should not have to guess your intent; nor should they have to work through several lines...
Forum: Introduce Yourself 12-10-2019, 09:46 AM
Replies: 9
Views: 157
Posted By jdraw
Forum: Introduce Yourself 12-10-2019, 09:44 AM
Replies: 5
Views: 52
Posted By jdraw
Re: New Member..Need help

Welcome aboard AWF!
Forum: Queries 12-10-2019, 04:19 AM
Replies: 16
Views: 221
Posted By jdraw
Re: Using Min as Formula in Query to Find Min values from range of fields

RC01,
As Galaxiom has said -you've done quite well to get what you have.
However,
Excel(spreadsheet) and Access (database) are very different animals based on different underlying concepts and...
Forum: Introduce Yourself 12-09-2019, 09:54 AM
Replies: 4
Views: 66
Posted By jdraw
Re: Greetings from Missouri!

Welcome Mike! Glad to have you on board.
Forum: Queries 12-09-2019, 09:25 AM
Replies: 16
Views: 221
Posted By jdraw
Re: Using Min as Formula in Query to Find Min values from range of fields

Might be more helpful if you posted a copy of your tables and relationships.

Are there always the same number of fields to be compared?

Here's a function that may be helpful.
'...
Forum: Tables 12-08-2019, 06:05 AM
Replies: 14
Views: 241
Posted By jdraw
Re: Problem in conversation of date

lumiere,

I recommend you keep 1 fact in 1 field in data storage (tables). If you need to display some combination of fields, then concatenate and do so, but do not concatenate separate fields and...
Forum: Introduce Yourself 12-08-2019, 06:00 AM
Replies: 4
Views: 49
Posted By jdraw
Re: Hey!

latindev Welcome to AWF!
Forum: Introduce Yourself 12-07-2019, 06:32 AM
Replies: 3
Views: 81
Posted By jdraw
Re: Hello from Indonesia

Welcome to AWF Frans! Happy to have you aboard.
Forum: Introduce Yourself 12-07-2019, 06:31 AM
Replies: 3
Views: 110
Posted By jdraw
Re: Hello all. Bob Sweet here

Welcome to AWF Bob!
Forum: Introduce Yourself 12-04-2019, 01:57 PM
Replies: 7
Views: 98
Posted By jdraw
Re: New user from NW US

Welcome to AWF. Glad to have you aboard.
Forum: Introduce Yourself 12-04-2019, 06:55 AM
Replies: 6
Views: 116
Posted By jdraw
Re: Hello from the Southern US

Welcome, Anosmic.

8 hrs!! And you still have some questions?? Well if it's any comfort - been in some form of IT since 1967, and I learn something every day. Welcome to an interesting journey.
Forum: Queries 12-04-2019, 06:40 AM
Replies: 25
Views: 378
Posted By jdraw
Re: How to Split a field from a database in Access

ClearQuestion,
I'm not sure where you stand with this thread. You did ask for help and I agree with Doc and others who have suggested that your first action should be to request your source for an...
Forum: Queries 12-03-2019, 10:13 AM
Replies: 25
Views: 378
Posted By jdraw
Re: How to Split a field from a database in Access

Thanks Colin. I hope the OP hasn't given up. He/she did ask for help.
Forum: Queries 12-03-2019, 08:52 AM
Replies: 25
Views: 378
Posted By jdraw
Re: How to Split a field from a database in Access

Hmmm?? Do you have an option to request the data as a csv along the lines that theDBGuy and Isladogs have suggested? I asked because if this is sensitive data, you shouldn't have to rely on parsing...
Forum: Queries 12-03-2019, 07:53 AM
Replies: 25
Views: 378
Posted By jdraw
Re: How to Split a field from a database in Access

Can you post 4 or 5 sample records as they come in from the csv?
Trying to determine the pattern(s) in your raw data. That is, how consistent is the data regarding format, missing fields etc.
Forum: General 12-02-2019, 10:12 AM
Replies: 8
Views: 128
Posted By jdraw
Re: VBA If Statement

Further to the other responses, if ProjectPriority is a number, why does it have a leading 0?
Forum: Forms 12-01-2019, 06:11 AM
Replies: 20
Views: 9,870
Posted By jdraw
Re: Employee Vacation time tracking

PaulD2019,

I recommend that you create a new post. You can reference this thread and the database if you wish, but it might get more attention/responses if you describe your requirement in a...
Forum: Modules & VBA 11-30-2019, 05:11 AM
Replies: 4
Views: 155
Posted By jdraw
Re: Combo Filter as you type individual record

I think your attempt to streamline the selection of a prefix is convoluted and likely unnecessary. Why not just let the user/data entry person select from the combo directly.
If the value that is...
Forum: Introduce Yourself 11-27-2019, 03:47 PM
Replies: 16
Views: 278
Posted By jdraw
Re: Hello Friends! New member here in Canada

Welcome aboard AWF Allan! We're all here to learn.
Forum: General 11-27-2019, 12:30 PM
Replies: 4
Views: 181
Posted By jdraw
Re: HELP! How to autogenerate jobnumbers sequence

Winnipeger,

Welcome to the forum.

Folks here are quite good at deciphering posts and poster intent. However, your post may require divine intervention. Please describe the "business" you are...
Forum: Introduce Yourself 11-27-2019, 12:18 PM
Replies: 4
Views: 96
Posted By jdraw
Re: Hi from new member

Hi Gray. Welcome. Nice to welcome another Canadian on board.
Forum: Queries 11-27-2019, 09:56 AM
Replies: 28
Views: 448
Posted By jdraw
Re: Range of ASCII values in criteria

Colin,

I saw that Regex was taking longer on the first run, but that subsequent runs were taking significantly less time. I took values from the repeated runs, and closed the queries at the end of...
Forum: Forms 11-26-2019, 06:53 AM
Replies: 6
Views: 150
Posted By jdraw
Re: Search button to search inside a split form

Well it didn’t work! doesn't help readers.

As was mentioned Error 3022 is related to a duplicate record key/index being saved/attempted.
I don't think you would get a 3022 on a Select/Read...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:23 PM.


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