Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: Gasman
Forum: General 08-21-2019, 10:47 AM
Replies: 4
Views: 78
Posted By Gasman
Re: Building one same format for a report from different queries

Would it not be easier having one report and filter for location on opening the report.?
Forum: Modules & VBA 08-20-2019, 03:00 AM
Replies: 7
Views: 103
Posted By Gasman
Re: Use a Form Text Box for Email Address in VBA Function

Me only works if that code is in the form or report.?
If you have it in a module you would need to pass in the email address(es)

I generally only use functions when I need to return a value,...
Forum: Forms 08-20-2019, 01:50 AM
Replies: 10
Views: 128
Posted By Gasman
Re: Combo Box Values Dependent on Criteria

Me.Combo2.Rowsource = ="SELECT Dept FROM " & TempVars("DeptVar") & " ORDER BY Dept;"
Forum: Forms 08-20-2019, 01:26 AM
Replies: 10
Views: 128
Posted By Gasman
Re: Combo Box Values Dependent on Criteria

It works if you set the rowsource for the combo in code.? I tested both ways.
I'd also be using it in the AfterUpdate of combo1

As for best practice, no idea, but you are just setting in code...
Forum: Forms 08-20-2019, 12:44 AM
Replies: 10
Views: 128
Posted By Gasman
Re: Combo Box Values Dependent on Criteria

I believe you would need to concatenate the TempVars?


="SELECT Dept FROM " & TempVars("DeptVar") & " ORDER BY Dept;"


I have never tried it in a row source in a form though?
Have you tried...
Forum: The Watercooler 08-19-2019, 12:14 AM
Replies: 17
Views: 416
Posted By Gasman
Re: Google Home Mini Diatribe

Tony,
FWIW, yours has yet to misbehave with me. :D
Forum: Modules & VBA 08-17-2019, 12:04 PM
Replies: 33
Views: 339
Posted By Gasman
Re: SendKeys problem w/Win10

Tried it in code from a form and mine hides/reveals the navigation window correctly.?
Forum: Modules & VBA 08-17-2019, 11:22 AM
Replies: 33
Views: 339
Posted By Gasman
Re: SendKeys problem w/Win10

Not the case at all. Both theDBguy and myself have said it works fine on our computers.?
Forum: Modules & VBA 08-17-2019, 10:35 AM
Replies: 33
Views: 339
Posted By Gasman
Re: SendKeys problem w/Win10

FWIW using theDBguy's suggestion, I can run it in the immediate window on Win10 pro.
I have UAC switched off though.?
The command does not appear to do anything on my computer, but does not...
Forum: Forms 08-17-2019, 09:01 AM
Replies: 13
Views: 171
Posted By Gasman
Re: Unbound Form "RunTime Error 3134"

Care to post the correct statement as I thought you had 5 fields being updated and had 5 values.


q2 = "INSERT INTO [DDL Detail] ([ReadingId],[TimeSlotId],[DDL Reading],[DDL],[DDLF]) values(" &...
Forum: Forms 08-17-2019, 02:06 AM
Replies: 3
Views: 102
Posted By Gasman
Re: How to adjust DLookup box effectively.

Is your field name called strEmpName?

Do not use the Me prefix if the source is on the control either.
Forum: Modules & VBA 08-16-2019, 11:32 PM
Replies: 19
Views: 239
Posted By Gasman
Re: Sending Outlook Emails from Access

I don't think so really:( and stuff like this drives me batty.:banghead:

Good luck with it anyway.;)
Forum: Modules & VBA 08-16-2019, 10:13 PM
Replies: 19
Views: 239
Posted By Gasman
Re: Sending Outlook Emails from Access

Well I would be not having the errant characters in the text in the first place.:confused:

However if you make the body at least as a variable.

Private Sub CmdOpen _Click()
Dim strBody as...
Forum: Modules & VBA 08-16-2019, 09:24 PM
Replies: 19
Views: 239
Posted By Gasman
Re: Sending Outlook Emails from Access

So the text is causing the problem, yet you cannot amend it?
So if you replace the first two spaces with nothing. Then replace the first linefeed with nothing, would that not start the 'pre-typed'...
Forum: Modules & VBA 08-16-2019, 08:12 PM
Replies: 19
Views: 239
Posted By Gasman
Re: Sending Outlook Emails from Access

I am only talking about the very first linefeed?
I am confused now. You say there is an errant character in the body, yet that it is approved pre-type text?

Which is it to be?
Forum: Forms 08-16-2019, 08:06 PM
Replies: 13
Views: 171
Posted By Gasman
Re: Unbound Form "RunTime Error 3134"

I must admit all that red is confusing me? :confused:

O/P stated q2?

As stated by Micron, a simple debug.print would probably show the error.?
Forum: Modules & VBA 08-16-2019, 07:58 PM
Replies: 19
Views: 239
Posted By Gasman
Re: Sending Outlook Emails from Access

I would have thought that would do the same thing?

I was thinking of replacing with nothing, either "" or vbNullString ?
Forum: Forms 08-16-2019, 07:33 PM
Replies: 13
Views: 171
Posted By Gasman
Forum: Modules & VBA 08-16-2019, 07:29 PM
Replies: 19
Views: 239
Posted By Gasman
Re: Sending Outlook Emails from Access

Couldn't you use the Replace function?

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/replace-function

I would expect the character would be CHR(10) or...
Forum: Forms 08-15-2019, 11:42 PM
Replies: 19
Views: 259
Posted By Gasman
Re: Best practice form events

I would hazard a guess at the AfterUpdate event of the control.?
If it is amended another email would be sent.?
I would expect the OnExit to send an email every time you left the control, unless it...
Forum: Modules & VBA 08-15-2019, 11:38 PM
Replies: 7
Views: 164
Posted By Gasman
Re: Auto Numbering

If the prefix is always the same why have it in the number?, why not concatenate it with the number.
Forum: Forms 08-15-2019, 06:45 AM
Replies: 2
Views: 89
Posted By Gasman
Re: For keeps opens in read-only mode "

Look at the code to open the form. Then look at the code in the destination form to see if it does something different depending on how is opened. OpenArgs being passed perhaps.?

Sounds like two...
Forum: Modules & VBA 08-14-2019, 11:57 PM
Replies: 4
Views: 115
Posted By Gasman
Re: Backup .accdb

Yes, you just backup the other file?

Here is what I have used in the past.


Sub CreateBackup(Optional strDBType As String)
Dim strDBpath As String, ext As String, tmp As String
Dim...
Forum: General 08-14-2019, 11:48 PM
Replies: 41
Views: 655
Posted By Gasman
Re: Shutdown PC through Access button

Just insert the code afresh and leave what you do not want at the moment.
It is hardly going to take up a lot of space.?
Then it should work for you as it does for others.
Forum: Forms 08-14-2019, 09:20 AM
Replies: 10
Views: 138
Posted By Gasman
Re: Record locks on a form

You should likely be only giving them an accde FE and not an accdb FE ?
Showing results 1 to 25 of 500

 
Forum Jump



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