Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.21 seconds.
Search: Posts Made By: theDBguy
Forum: Modules & VBA Yesterday, 09:21 AM
Replies: 29
Views: 234
Posted By theDBguy
Re: RgExp.Pattern

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
Forum: Forms Yesterday, 09:00 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

Hi. Glad to hear you got it to work. Colin and I were happy to assist. Good luck with your project.
Forum: Forms Yesterday, 08:53 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

Okay, 32 is a space character. That's probably why the Trim() function worked. So, you could try the following now.


=Trim([PATH]) & [FILE]


What do you get?
Forum: Forms Yesterday, 08:47 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

Don't enclose 31 in brackets. Simply try it this way:


=Asc(Mid([PATH],32,1))
Forum: Forms Yesterday, 08:20 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

If both those tests failed, then it's not a line feed or a carriage return character. Just as another test, take one of the paths and count the number of visible characters in it. Then, try the...
Forum: Modules & VBA Yesterday, 07:57 AM
Replies: 29
Views: 234
Posted By theDBguy
Re: RgExp.Pattern

Hi. Just curious, could you try this code (https://thedbguy.blogspot.com/2016/02/extract-email-address.html) but use the pattern I gave you earlier? Thanks!
Forum: Forms Yesterday, 07:39 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

I'm thinking maybe there's a line feed character in there? Try expanding the Textbox to show two rows. Does that help?
Forum: Forms Yesterday, 07:35 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

Hi. What do you get with either of these?

=[FILE]

or

=IsNull([FILE])
Forum: Forms Yesterday, 06:56 AM
Replies: 30
Views: 202
Posted By theDBguy
Re: Concatenate two fields....

Hi. What does [FILE] contain?
Forum: Queries Yesterday, 06:17 AM
Replies: 6
Views: 79
Posted By theDBguy
Re: 2-Month Warning before Expire Dates

Hi. Does your field name actually contain parentheses? Right now, your expression is looking for an exact match. Try using <= instead of just = to see if it will make any difference.
Forum: The Watercooler 11-10-2019, 09:06 AM
Replies: 40
Views: 418
Posted By theDBguy
Re: the NZ() function

I would say Access was designed for Power Users - not necessarily for programmers. Just like Word, Excel, PowerPoint, and Outlook have VBA languages but the average user won't ever probably use them.
Forum: The Watercooler 11-09-2019, 12:58 PM
Replies: 40
Views: 418
Posted By theDBguy
Re: the NZ() function

Either you've been very lucky or you're really good. If you're able to plan everything and control all situations, maybe you won't need to use it. However, in some cases, you may want to use it to...
Forum: Forms 11-09-2019, 11:11 AM
Replies: 13
Views: 162
Posted By theDBguy
Re: Confusing problem, various error messages

Hi Regina. There might be an easier way rather than using OpenArgs and modifying the RecordSource. For example:
DoCmd.OpenForm "FormName", , , "FieldName=" & Nz(Me.ControlName)
Forum: Modules & VBA 11-09-2019, 06:56 AM
Replies: 15
Views: 221
Posted By theDBguy
Re: only numbers function

Hi Linq. Thanks for the assist. Perhaps use a Beep rather than do nothing? Just a thought...
Forum: Modules & VBA 11-09-2019, 06:23 AM
Replies: 15
Views: 221
Posted By theDBguy
Re: only numbers function

Hi. You could try using the KeyPress event to silently reject/ignore non-numeric characters.
Forum: Queries 11-09-2019, 06:18 AM
Replies: 6
Views: 91
Posted By theDBguy
Re: Query Calculation with Row Value

Can you use the DLookup() function?
Forum: Modules & VBA 11-08-2019, 05:12 PM
Replies: 7
Views: 127
Posted By theDBguy
Re: Recipient.Resolve method

Hi. Glad to hear you got it to work. Cheers!
Forum: Modules & VBA 11-08-2019, 09:39 AM
Replies: 29
Views: 234
Posted By theDBguy
Re: RgExp.Pattern

Hi. I'm no expert on Regular Expressions but I am guessing the first of that expression is probably correct. This part:
^\d{11}\/Now, I am thinking since you have an OR situation after that part,...
Forum: Modules & VBA 11-08-2019, 08:23 AM
Replies: 7
Views: 127
Posted By theDBguy
Re: Recipient.Resolve method

Hi Tera. I know you have seen this thread (https://access-programmers.co.uk/forums/showthread.php?t=305766) before, but have you looked at the code posted by sxschech about resolving names? Just...
Forum: Modules & VBA 11-07-2019, 07:22 PM
Replies: 11
Views: 179
Posted By theDBguy
Re: Function for auto dropdown for all combobox

Hi. Does that mean you have figured it out, or does it mean you are going to figure it out? If you have figured it out, you might consider sharing your solution with others. Just a thought...
Forum: Modules & VBA 11-07-2019, 12:50 PM
Replies: 10
Views: 143
Posted By theDBguy
Re: Problem with critera on report

Hi. Glad to hear you got it to work. We were all happy to assist. Good luck with your project.
Forum: Modules & VBA 11-07-2019, 11:49 AM
Replies: 10
Views: 143
Posted By theDBguy
Re: Problem with critera on report

There are other solutions, but try it this way too:
...Nz([T_age],0]) Between...
Forum: Modules & VBA 11-07-2019, 11:15 AM
Replies: 10
Views: 143
Posted By theDBguy
Re: Problem with critera on report

Hi. You could try it this way.
DoCmd.OpenReport "rpt_one", acViewPreview, , _
"[T_age] Between " & Nz(Me.Text74, 0) & " And " & Nz(Me.Text57, 999) _
& " and [T_career] LIKE '" &...
Forum: Modules & VBA 11-07-2019, 08:13 AM
Replies: 58
Views: 719
Posted By theDBguy
Re: Linking SQL Server tables with VBA

Okay, I sent him an email. Let's see what he says.
Forum: Introduce Yourself 11-07-2019, 07:56 AM
Replies: 2
Views: 63
Posted By theDBguy
Re: Hello!

Hi. Welcome to AWF!
Showing results 1 to 25 of 500

 
Forum Jump



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