Home Forum Contact

 Access World Forums Search Results
 User Name Remember Me? Password
 Register FAQ Members List Social Groups Top Posters Search Today's Posts

 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 Re: Noob who knows how to copy n paste :) Boch, welcome to AWF!
 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 User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business

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
 Contact Us - Home - Privacy Statement - Top