Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.27 seconds.
Search: Posts Made By: pbaldy
Forum: Introduce Yourself Today, 11:47 AM
Replies: 3
Views: 6
Posted By pbaldy
Re: Hello!

Welcome Mike!
Forum: Macros Yesterday, 07:42 AM
Replies: 10
Views: 96
Posted By pbaldy
Re: Skip Append Query if 0 Rows

I'll get out of the way.
Forum: Macros Yesterday, 07:35 AM
Replies: 10
Views: 96
Posted By pbaldy
Re: Skip Append Query if 0 Rows

I'd test in the macro, not in the query. Actually I'd use VBA, as would most of us here. I think you can test a DCount in a macro, you definitely can in VBA:

If DCount("*","Query1")>0 Then
...
Forum: The Watercooler 11-11-2019, 07:54 PM
Replies: 6
Views: 119
Posted By pbaldy
Re: from version 1992 to version 2016

There was no "1992":

https://www.fmsinc.com/MicrosoftAccess/history/features.htm
Forum: Modules & VBA 11-11-2019, 04:16 PM
Replies: 10
Views: 116
Posted By pbaldy
Forum: Modules & VBA 11-11-2019, 03:50 PM
Replies: 10
Views: 116
Posted By pbaldy
Re: Change certain Excel row 1 cell values

Try this shot in the dark:

wb.Cells(3, 1) = "Cust ID"
Forum: Forms 11-11-2019, 10:27 AM
Replies: 6
Views: 155
Posted By pbaldy
Re: Opening forms

What exactly did you try? It could look like:

Me.Podrzędny21.Form.Filter = "KW = '" & Me.KW & "'"
Me.Podrzędny21.Form.FilterOn = True
Forum: Forms 11-11-2019, 09:50 AM
Replies: 6
Views: 155
Posted By pbaldy
Re: Opening forms

As answered elsewhere:

You can set the Source Object property of the subform control to the desired form. Then you'd either set the record source or filter or use a bookmark to go to the desired...
Forum: Modules & VBA 11-11-2019, 09:17 AM
Replies: 58
Views: 745
Posted By pbaldy
Forum: Modules & VBA 11-11-2019, 09:14 AM
Replies: 58
Views: 745
Posted By pbaldy
Re: Linking SQL Server tables with VBA

It fails as I would expect. RTE 3151, ODBC connection failed.
Forum: Modules & VBA 11-11-2019, 09:01 AM
Replies: 5
Views: 134
Posted By pbaldy
Re: DoCmd.OpenReport (Where condition with array)

That would be a lot to scroll through. The technique would look like:

http://www.baldyweb.com/multiselect.htm

I suppose you could let them type into an InputBox or textbox and check their...
Forum: Introduce Yourself 11-11-2019, 08:36 AM
Replies: 4
Views: 77
Posted By pbaldy
Re: Hi from Switzerland

Welcome Moritz!
Forum: Modules & VBA 11-11-2019, 08:34 AM
Replies: 5
Views: 134
Posted By pbaldy
Re: DoCmd.OpenReport (Where condition with array)

I wouldn't rely on users entering in the correct format, I'd probably use a multiselect listbox. To go your way you'd use InputBox and use the resulting string:

DoCmd.OpenReport "kan_Utilities",...
Forum: Tables 11-11-2019, 08:20 AM
Replies: 16
Views: 300
Posted By pbaldy
Re: what's the best backend for a split DB?

User CP/Edit your details/Custom user title
Forum: Queries 11-10-2019, 09:13 AM
Replies: 4
Views: 98
Posted By pbaldy
Forum: Forms 11-10-2019, 09:12 AM
Replies: 13
Views: 168
Posted By pbaldy
Forum: Modules & VBA 11-09-2019, 10:02 PM
Replies: 5
Views: 125
Posted By pbaldy
Re: DLookup in VBA code

Happy to help!
Forum: The Watercooler 11-09-2019, 09:16 PM
Replies: 40
Views: 427
Posted By pbaldy
Re: the NZ() function

You and me both. :rolleyes:
Forum: Queries 11-09-2019, 09:13 PM
Replies: 4
Views: 98
Posted By pbaldy
Re: Choose between 2 columns based on another field in query

Try this shot in the dark in a new field in the query:

CurrentStatus: IIf(DateEffective >= date(), EffectiveStatus, PendingStatus)
Forum: Modules & VBA 11-09-2019, 08:54 PM
Replies: 5
Views: 125
Posted By pbaldy
Re: DLookup in VBA code

Your parentheses look out of whack. Take out any not directly required for a DLookup(). They aren't necessary with only addition and subtraction.
Forum: The Watercooler 11-09-2019, 05:09 PM
Replies: 40
Views: 427
Posted By pbaldy
Re: the NZ() function

If you mean not letting users have direct access to tables, nobody here would disagree. You realize data macros run when data is manipulated in a form, right?
Forum: The Watercooler 11-09-2019, 03:20 PM
Replies: 40
Views: 427
Posted By pbaldy
Re: the NZ() function

Why would you consider data macros stupid? They're a tool; like any other, they have their place. I haven't used them, but I've used SQL Server triggers, which data macros are very loosely...
Forum: Forms 11-09-2019, 03:14 PM
Replies: 13
Views: 168
Posted By pbaldy
Re: Confusing problem, various error messages

I'm not clear on the situation. If you want the form you're on to add a record, you can use GoToRecord to go to a new record. If the form isn't open, you can use the data mode argument of OpenForm.
Forum: Forms 11-09-2019, 01:50 PM
Replies: 13
Views: 168
Posted By pbaldy
Re: Confusing problem, various error messages

Sure, here or in a new thread if appropriate.
Forum: Forms 11-09-2019, 12:43 PM
Replies: 13
Views: 168
Posted By pbaldy
Re: Confusing problem, various error messages

Oh, and I bracketed your field name, though it may not have been necessary. I wasn't sure if the accented letter would be seen as a symbol.
Showing results 1 to 25 of 500

 
Forum Jump



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