Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 66
Search took 0.02 seconds.
Search: Posts Made By: JoseO
Forum: Tables 06-20-2019, 09:24 PM
Replies: 10
Views: 394
Posted By JoseO
Re: Inserting into a single column

Nice. Thank you June7 :-)
Forum: Tables 06-20-2019, 08:54 PM
Replies: 10
Views: 394
Posted By JoseO
Re: Inserting into a single column

Thank you, thank you June7, Dbguy, Micron, Galaxiom, and Doc-man

Not only do I appreciate the SQL samples but, more so, the educating part of each of your posts. I want to learn good DB design and...
Forum: Tables 06-20-2019, 04:49 PM
Replies: 10
Views: 394
Posted By JoseO
Re: Inserting into a single column

Thank you Micron. Yes, I have tried UPDATE and INSERT. But when I try them with a WHERE clause it's essentially filling all Null fields in Field1 (first column). I've attached a picture.
Forum: Tables 06-20-2019, 04:17 PM
Replies: 10
Views: 394
Posted By JoseO
Inserting into a single column

Hi,

Ever since I started using Access, I've been told to make use of Tables in order to populate my combo boxes. As such, rather than setting up, say, 4 tables to hold just one column of combo box...
Forum: Modules & VBA 08-20-2018, 10:23 AM
Replies: 10
Views: 317
Posted By JoseO
Re: Proper >= And < Where Condition in VBA

The_Doc_Man, Galaxiom, and, CJ_London -

Thank you all so much for your very thorough explanations/solutions. Much appreciate this forum.
Forum: Modules & VBA 08-19-2018, 07:39 PM
Replies: 10
Views: 317
Posted By JoseO
Re: Proper >= And < Where Condition in VBA

Thank you Galaxiom for the explanation - much appreciated. For fun and giggles, could you show me where those operands need to be placed? Thanks again. :)
Forum: Modules & VBA 08-19-2018, 07:12 PM
Replies: 10
Views: 317
Posted By JoseO
Re: Proper >= And < Where Condition in VBA

Thank you for the prompt reply Galaxiom.


It is my understanding that If i don't specify a time, Access assumes midnight and will not search anything pass midnight unless properly queried. The...
Forum: Modules & VBA 08-19-2018, 06:30 PM
Replies: 10
Views: 317
Posted By JoseO
Proper >= And < Where Condition in VBA

Hello folks,


Perhaps I've been starring at this too much. What I am trying to do with the following WHERE condition is replace BETWEEN with >= And < operands for my date range. I've played...
Forum: Reports 04-18-2018, 02:18 PM
Replies: 5
Views: 334
Posted By JoseO
Re: Pictures side-by-side

Thank you so much ridders. I honest to goodness don't recall the original post answer but I am super thankful for reposting it. Thank you so much! I will examine/explore and report back. :)
Forum: Reports 04-18-2018, 02:07 PM
Replies: 5
Views: 334
Posted By JoseO
Re: Pictures side-by-side

Thank you CJ. I have tried columns before to no avail.

I intentionally did not add more information so as to not bring confusion. But essentially, the four pictures contained in the table belong...
Forum: Reports 04-18-2018, 01:40 PM
Replies: 5
Views: 334
Posted By JoseO
Pictures side-by-side

Hello AP folks,

I hate to resurrect this topic but I am finding myself in a bit of a bind and have been starring at code for days on end now.

In the most simplest of ways to explain it, I have...
Forum: Access Web 02-27-2018, 10:36 AM
Replies: 4
Views: 1,101
Posted By JoseO
Re: The proverbial: Where do I put my BE?

Thank you to all for your valuable feedback. I apologize for the late reply but it wasn't until Ranman256 replied that I received an email notification.

Again, thank you all for your feedback.
Forum: Access Web 02-19-2018, 12:28 PM
Replies: 4
Views: 1,101
Posted By JoseO
The proverbial: Where do I put my BE?

Hello folks,

I got into access about 2 1/2 years ago and I am hooked! Love this program.

I have split DBs here at work with ease due to the network infrastructure allowing me to simply place my...
Forum: Tables 02-08-2018, 02:37 PM
Replies: 9
Views: 442
Posted By JoseO
Re: A quick question in normalization (Access 2010)

Thank you Doc Man - will give it a whirl :-)
Forum: Tables 02-08-2018, 02:35 PM
Replies: 9
Views: 442
Posted By JoseO
Re: A quick question in normalization (Access 2010)

You guys are awesome! Thank you so much Mark, ridders and Doc Man.
Forum: Tables 02-08-2018, 02:31 PM
Replies: 9
Views: 442
Posted By JoseO
Re: A quick question in normalization (Access 2010)

Thank you Mark. I completely agree with your assessment. It does make sorting much easier. The only annoying thing is running reports when the fields are separated.

For instance, if I concatenate...
Forum: Tables 02-08-2018, 02:19 PM
Replies: 9
Views: 442
Posted By JoseO
A quick question in normalization (Access 2010)

Hi -

I know I can develop my db anyway I want but wanted to get some opinions.

Quick question:

Is it best to normalize first and last names? If I have two Joe Smiths, what does it matter if...
Forum: Forms 02-06-2018, 06:00 PM
Replies: 6
Views: 295
Posted By JoseO
Re: Multiple Names from Form

I apologize for the delay in replying Pat. Thank you so much for sharing this! I really, really, appreciate it!
Forum: Forms 02-01-2018, 09:13 AM
Replies: 6
Views: 295
Posted By JoseO
Re: Multiple Names from Form

I appreciate the guidance as well Gasman - thank you.
Forum: Forms 02-01-2018, 09:12 AM
Replies: 6
Views: 295
Posted By JoseO
Re: Multiple Names from Form

Thank you for the fast response Jack. I appreciate it. I'll certainly do as you have recommended.
Forum: Forms 02-01-2018, 09:05 AM
Replies: 6
Views: 295
Posted By JoseO
Multiple Names from Form

Hello -

I thought I would make a simple form to keep track of participants attending weekly meetings. I've run into a bit of dilemma:

In my "Meeting form" I need to be able to add the names of...
Forum: Forms 12-11-2017, 08:47 AM
Replies: 3
Views: 287
Posted By JoseO
Re: Updating number of character in textbox

JHB & MarkK,

Thank you so much for your feedback. I had already tried putting the code in the Form_Current event BUT after doing one more check on it, I realized that I failed to remove the...
Forum: Forms 12-10-2017, 09:24 PM
Replies: 3
Views: 287
Posted By JoseO
Updating number of character in textbox

Hello -

May be I have been staring at code a bit too long.

I have a two textboxes.

In one, the user may enter up to 189 characters. The second textbox acts as a "character reader." As the...
Forum: Modules & VBA 09-05-2017, 08:31 PM
Replies: 8
Views: 742
Posted By JoseO
Re: Single apostrophe in search textbox

Once again arnelgp and Dave, THANK YOU!

I am happy to report that your suggestions worked beautifully. A bit of tweaking here and there on my part but I definitively could not have done it with...
Forum: Modules & VBA 09-05-2017, 10:40 AM
Replies: 8
Views: 742
Posted By JoseO
Re: Single apostrophe in search textbox

Thank you arnelgp and Dave!!

I will thoroughly test the attached. By the time I get home it'll pretty late for you Dave :) I'm not sure where "somewhere out" is for arnelgp so it may be the same...
Showing results 1 to 25 of 66

 
Forum Jump



All times are GMT -8. The time now is 07:27 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World