Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.65 seconds.
Search: Posts Made By: pbaldy
Forum: General Yesterday, 03:20 PM
Replies: 32
Views: 363
Posted By pbaldy
Re: Access 2016

I said 5, and it's a property of the listbox (lstLeft).
Forum: Introduce Yourself 06-05-2019, 04:55 PM
Replies: 5
Views: 86
Posted By pbaldy
Re: Hello From GeneH

Welcome aboard! The official greeters will be along shortly. ;)
Forum: Modules & VBA 05-20-2019, 03:48 PM
Replies: 8
Views: 167
Posted By pbaldy
Re: Do you use any plugin/add in for VBE?

I use MZ Tools and Smart Indenter. I've heard good things about Rubber Duck; a client uses it, but just for indenting.
Forum: Macros 05-18-2019, 04:27 PM
Replies: 13
Views: 205
Posted By pbaldy
Re: subform control correct syntax

By the way, note they all start with "Forms", not "Form".
Forum: General 05-17-2019, 03:10 PM
Replies: 56
Views: 1,355
Posted By pbaldy
Re: How do you save logged in user ID for later use?

Historically I've either put the values on a main menu form that stays open all the time or left the login form open but hidden. I'd try TempVars, but I'm an old dog and that's a new trick. ;)
Forum: Queries 05-15-2019, 01:08 PM
Replies: 8
Views: 210
Posted By pbaldy
Re: How do I concatenate a field from multiple records?

Like this?

http://allenbrowne.com/func-concat.html
Forum: Queries 05-12-2019, 10:56 AM
Replies: 3
Views: 115
Posted By pbaldy
Re: Add up values based on two SEPARATE text fields

Play with this query:

SELECT [SAL2: SALVAGE LOG].[ITEM DESCRIPTION], [SAL2: SALVAGE LOG].[REASON FOR LOSS], Sum([SAL2: SALVAGE LOG].[AMOUNT OF LOSS]) AS [SumOfAMOUNT OF LOSS]
FROM [SAL2: SALVAGE...
Forum: Forms 05-12-2019, 06:55 AM
Replies: 5
Views: 128
Posted By pbaldy
Re: Copy result to table

No problem. I assume it worked?
Forum: Forms 05-11-2019, 02:49 PM
Replies: 5
Views: 128
Posted By pbaldy
Re: Copy result to table

The "you want to store...anyway" bit:

http://allenbrowne.com/casu-14.html
Forum: Queries 05-06-2019, 09:50 AM
Replies: 7
Views: 120
Posted By pbaldy
Re: iif statement in access with multiple criteria

I don't use them, but if memory serves the Date() function can't be used in one.
Forum: Queries 05-05-2019, 09:08 PM
Replies: 21
Views: 341
Posted By pbaldy
Re: Assistance needed in sql syntax while breaking code into multiple lines

You don't want parentheses around each value, you want a single pair around the whole VALUES clause.

...VALUES(Field1, Field2,...)
Forum: Queries 05-05-2019, 09:02 AM
Replies: 21
Views: 341
Posted By pbaldy
Re: Assistance needed in sql syntax while breaking code into multiple lines

Here's a common debugging method:

http://www.baldyweb.com/ImmediateWindow.htm
Forum: Forms 05-05-2019, 07:05 AM
Replies: 2
Views: 108
Posted By pbaldy
Re: Duplicate form content from two tables

How about:

http://allenbrowne.com/ser-57.html
Forum: Forms 04-26-2019, 03:36 PM
Replies: 15
Views: 186
Posted By pbaldy
Re: Search Form error

Gasman is probably asleep. In my experience the requery line isn't necessary; setting the record source will requery the form. Gasman may have had the same experience thus commented it out.
Forum: Queries 04-26-2019, 07:18 AM
Replies: 14
Views: 838
Posted By pbaldy
Re: Dlookup to return previous day closing

My guess is that there are 2 records with the same CloseDate and ID. Is ID not unique?
Forum: Forms 04-18-2019, 09:20 AM
Replies: 16
Views: 314
Posted By pbaldy
Re: Form that appends/adds to multiple joined tables

Post 9 was moderated, I'm posting to trigger email notifications.
Forum: Modules & VBA 04-17-2019, 10:01 AM
Replies: 13
Views: 187
Posted By pbaldy
Re: Error 3061 Too few parameters Expected1.

Happy to help! There are certainly many ways to skin the proverbial cat. I hadn't seen Leigh's function before. Nice, as I would expect from him.
Forum: Modules & VBA 04-17-2019, 08:50 AM
Replies: 13
Views: 187
Posted By pbaldy
Re: Error 3061 Too few parameters Expected1.

Another simple solution is wrapping the form reference in the Eval() function:

tblFileReq.ReqID=Eval('[Forms]![NavigationForm]![txtID]')

The recordset should be able to open it with that in...
Forum: Modules & VBA 04-11-2019, 02:28 PM
Replies: 19
Views: 576
Posted By pbaldy
Re: ConcatRelated

No, you wouldn't change the function, you'd pass the listbox value to it. Something like

ConcatRelated("[Value]","[Raw Data]","[Key] = '" & [Key] & "'", , Me.ListboxName)

I suppose you could...
Forum: Modules & VBA 04-10-2019, 03:02 PM
Replies: 19
Views: 576
Posted By pbaldy
Re: ConcatRelated

Sorry, I've never come close to that so haven't needed it.
Forum: Modules & VBA 04-09-2019, 04:05 PM
Replies: 19
Views: 576
Posted By pbaldy
Re: ConcatRelated

Is Claim ID text or numeric (its data type)? If text:

ConcatRelated("[PROCEDURE_CODES]","[CptTest]","[CLAIM_ID] = '" & [CLAIM_ID] & "'")

Can you attach the db here?
Forum: Modules & VBA 04-09-2019, 10:52 AM
Replies: 19
Views: 576
Posted By pbaldy
Re: ConcatRelated

And what happend? The quotes in Allen's examples are required, so more like:

ConcatRelated("[PROCEDURE_CODES]", "[003_Claim_CPT_Codes]", "[CLAIM_ID]= " & [CLAIM_ID])
Forum: Queries 04-09-2019, 08:22 AM
Replies: 23
Views: 733
Posted By pbaldy
Re: Is there anybody out there who can help me?

That should be possible. Personally I'd have the user enter that value on the form and then build SQL using it and make that the row source of the listbox. You could have the listbox row source be...
Forum: Queries 04-09-2019, 07:25 AM
Replies: 23
Views: 733
Posted By pbaldy
Re: Is there anybody out there who can help me?

Sure, here's one way (a listbox would work the same as a combo):

http://www.baldyweb.com/CascadingCombo.htm
Forum: Modules & VBA 04-08-2019, 01:07 PM
Replies: 36
Views: 708
Posted By pbaldy
Re: Stripping Variable values

I guess repetition is good. ;)
Showing results 1 to 25 of 500

 
Forum Jump



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