Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 22.31 seconds.
Search: Posts Made By: pbaldy
Forum: Forms 06-14-2019, 08:18 PM
Replies: 11
Views: 4,326
Posted By pbaldy
Re: Calculated Week ending Date

Welcome to the site. Is there a question, or did you not realize this thread was 7 years old?
Forum: Forms 06-14-2019, 12:41 PM
Replies: 2
Views: 68
Posted By pbaldy
Re: multicolumn listbox auto select relevant records

Might be the Is Null. Try the IsNull() function instead.
Forum: SQL Server 06-14-2019, 12:40 PM
Replies: 12
Views: 179
Posted By pbaldy
Re: automated email

I misunderstood too. That's why I asked if the computer could remain locked instead of logged off. I have a bunch of automated imports/exports/emails running as you describe.
Forum: SQL Server 06-14-2019, 07:12 AM
Replies: 12
Views: 179
Posted By pbaldy
Re: automated email

I could be the one who misunderstood. :eek:
Forum: Introduce Yourself 06-14-2019, 07:11 AM
Replies: 7
Views: 111
Posted By pbaldy
Re: Dale in Pennsylvania

Welcome Dale. I have 3 & 1 year old grandkids and they wear me out, and I'm only in charge for short times. Sending energy your way, you'll need it!
Forum: SQL Server 06-14-2019, 07:06 AM
Replies: 12
Views: 179
Posted By pbaldy
Re: automated email

I think the key bit was "if no user is logged in at the designated time that is end of day the email will not get sent.".
Forum: Modules & VBA 06-12-2019, 04:02 PM
Replies: 4
Views: 102
Posted By pbaldy
Re: Create Email Draft With All Attachments From Directory

Is i declared elsewhere? If not it should be, plus see the link below. Were files found to attach? Hit Debug after you get the error and hover over the LBound and UBound items and see what they're...
Forum: Introduce Yourself 06-12-2019, 03:58 PM
Replies: 5
Hi
Views: 66
Posted By pbaldy
Re: Hi

Welcome to AWF! The official greeters will be along soon. ;)
Forum: General 06-12-2019, 07:29 AM
Replies: 8
Views: 112
Posted By pbaldy
Re: Question:Timeout, or similar function possible?

The kind of thing you asked about is certainly possible:

http://www.peterssoftware.com/isd.htm

But as theDBguy said the app should definitely be split properly. That would likely solve your...
Forum: SQL Server 06-12-2019, 07:24 AM
Replies: 12
Views: 179
Posted By pbaldy
Re: automated email

I don't know if it's a permissions thing or an Azure thing, as I haven't used Azure. Can the PC be locked instead of logged out of? I can't recall if the Access db will run at all if the PC is not...
Forum: SQL Server 06-11-2019, 09:04 PM
Replies: 12
Views: 179
Posted By pbaldy
Re: automated email

I haven't used ETL, but I have a number of automated emails sent out from SQL Server. Your requirement is a little vague, but you'll probably end up with a stored procedure run from SQL Server Agent,...
Forum: Introduce Yourself 06-11-2019, 03:45 PM
Replies: 4
Views: 80
Posted By pbaldy
Re: Hello from Mexico

Welcome and buenos tardes.
Forum: Politics & Current Events 06-06-2019, 06:56 AM
Replies: 8
Views: 132
Posted By pbaldy
Re: Remembering D-day

Great post Doc. I don't know anybody who was there, but I have a great deal of respect for military personnel and first responders.
Forum: Introduce Yourself 06-05-2019, 06:32 PM
Replies: 5
Views: 82
Posted By pbaldy
Re: Hello From GeneH

As advertised. ;)
Forum: Introduce Yourself 06-05-2019, 04:55 PM
Replies: 5
Views: 82
Posted By pbaldy
Re: Hello From GeneH

Welcome aboard! The official greeters will be along shortly. ;)
Forum: Modules & VBA 06-04-2019, 05:49 AM
Replies: 6
Views: 16,962
Posted By pbaldy
Re: Undefined function 'XXXXX' in expression

Oh, and if it's a custom function rather than a built-in function, make sure the function is in a standard module, not behind a form/report.
Forum: Modules & VBA 06-04-2019, 05:05 AM
Replies: 6
Views: 16,962
Posted By pbaldy
Re: Undefined function 'XXXXX' in expression

The reference issue referred to earlier:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
Forum: Introduce Yourself 05-31-2019, 05:26 PM
Replies: 3
Views: 87
Posted By pbaldy
Re: Eric

Welcome aboard!
Forum: Modules & VBA 05-20-2019, 03:48 PM
Replies: 8
Views: 166
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: 202
Posted By pbaldy
Re: subform control correct syntax

By the way, note they all start with "Forms", not "Form".
Forum: Macros 05-18-2019, 04:26 PM
Replies: 13
Views: 202
Posted By pbaldy
Re: subform control correct syntax

Here's a good reference on syntax:

http://www.theaccessweb.com/forms/frm0031.htm
Forum: General 05-17-2019, 03:10 PM
Replies: 56
Views: 1,348
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: Introduce Yourself 05-16-2019, 09:07 PM
Replies: 3
Views: 134
Posted By pbaldy
Re: New Kid in Town

Welcome Pamela. Your country is beautiful. I've visited several times as one of my daughters has lived there for a number of years now.

The official greeters will likely be along shortly. ;)
Forum: Modules & VBA 05-16-2019, 10:29 AM
Replies: 23
[SOLVED] ListBox VBA
Views: 579
Posted By pbaldy
Re: ListBox VBA

Glad we got it working!
Forum: Modules & VBA 05-16-2019, 09:26 AM
Replies: 23
[SOLVED] ListBox VBA
Views: 579
Posted By pbaldy
Re: ListBox VBA

As I mentioned before the row source type has to be table/query.
Showing results 1 to 25 of 500

 
Forum Jump



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