Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.10 seconds.
Search: Posts Made By: Gasman
Forum: Modules & VBA 06-23-2019, 06:19 AM
Replies: 21
Views: 413
Posted By Gasman
Re: Dsum Not Working

Put all the criteria into a single string, then you can debug.print it and see *exactly* what you are getting.

Your formatting looked OK in previous posts, but you never know.?
Show what is being...
Forum: Modules & VBA 06-22-2019, 05:43 AM
Replies: 11
Views: 189
Posted By Gasman
Re: Access 2007 VBa using Thunderbird Mail

@Doc_Man,

I think they were all for Outlook, not Thunderbird?

@bleakhouse

Separate with a comma.

http://forums.mozillazine.org/viewtopic.php?f=39&t=1363715
Forum: Modules & VBA 06-21-2019, 11:42 PM
Replies: 1
Views: 113
Posted By Gasman
Re: Print labels from a starting position on sheet

I've now decided to just to do it from Excel as it is only for a small project and a few occasions, so will print them manually. :D
Forum: Modules & VBA 06-21-2019, 10:45 PM
Replies: 1
Views: 113
Posted By Gasman
Print labels from a starting position on sheet

Hi all,

Before I try and write my own, does anyone have a snippet of code to enable a label report to start at a certain position please.?

I believe it involves inserting dummy records before...
Forum: Modules & VBA 06-21-2019, 08:42 AM
Replies: 5
Views: 125
Posted By Gasman
Re: Hide Password With *** On Popup

https://www.access-programmers.co.uk/forums/showthread.php?t=132626
Forum: Modules & VBA 06-21-2019, 05:35 AM
Replies: 11
Views: 189
Posted By Gasman
Re: Access 2007 VBa using Thunderbird Mail

See if this helps?

https://stackoverflow.com/questions/39521872/how-can-i-automatically-send-email-from-thunderbird-with-excel-vba
Forum: Modules & VBA 06-21-2019, 03:11 AM
Replies: 11
Views: 189
Posted By Gasman
Re: Access 2007 VBa using Thunderbird Mail

That sounds like a cop out. :D

What problem are you having, as I use 2007 and Outlook as well.
Forum: SQL Server 06-21-2019, 12:49 AM
Replies: 16
Views: 1,066
Posted By Gasman
Re: Access SQL Query -> T-SQL Query Conversion ?

Minty,

The link works for me, and I've printed the page to pdf, but to big to upload here.?
PM me if you want me to email it to you. It is 2.25MB
Forum: Modules & VBA 06-20-2019, 11:14 PM
Replies: 10
Views: 222
Posted By Gasman
Re: Command Button msgbox only works once

@Micron,

I was directing that to the o/p and agreeing with you.

Apologies for the confusion.
Forum: General 06-20-2019, 10:12 AM
Replies: 12
Views: 488
Posted By Gasman
Re: Issues at opening a Excel file

I *think* what theDBguy was asking, was have you tried a simple link in Access.?
Admittedly I am the same person on my PC, but linked Excel files are read only, so linking an Excel file I had open...
Forum: Modules & VBA 06-20-2019, 08:36 AM
Replies: 10
Views: 222
Posted By Gasman
Re: Command Button msgbox only works once

Fair point, but if it was Null or now "", then you want to exit immediately after the message.?
Forum: General 06-19-2019, 10:53 PM
Replies: 7
Views: 254
Posted By Gasman
Re: Detect where clicked in text Box

If you used .selstart as the starting point, could you not look for a CR/LF and then select everything in between.?

Lot of work for just a drag of a mouse I would have thought though.?
What if...
Forum: Forms 06-19-2019, 08:11 AM
Replies: 21
Views: 309
Posted By Gasman
Re: UnSure how to get New Comment (Blank) to the Top

No, the FE should have the same name for all users.
They can call it what they like, but when you apply any updates they would not work, so best to keep to same name.
Forum: Forms 06-19-2019, 07:31 AM
Replies: 21
Views: 309
Posted By Gasman
Re: UnSure how to get New Comment (Blank) to the Top

That first pic.

Would you have a status called "In Process"?
If so the quotes are missing for some reason.?

Anything like this will need to be corrected.
Forum: Forms 06-18-2019, 11:32 PM
Replies: 21
Views: 309
Posted By Gasman
Re: UnSure how to get New Comment (Blank) to the Top

I read it as Compiling and the compiler is saying Syntax error.?
Fix the syntax errors.
Forum: Modules & VBA 06-18-2019, 11:29 PM
Replies: 10
Views: 222
Posted By Gasman
Re: Command Button msgbox only works once

Test for "" as well as that is what you set the control to?

Or use

If NZ(SOTV,"") = ""


HTH
Forum: Forms 06-18-2019, 12:20 PM
Replies: 21
Views: 309
Posted By Gasman
Re: UnSure how to get New Comment (Blank) to the Top

Do all users have their 'own' copy of the front end?
Forum: Tables 06-18-2019, 12:16 PM
Replies: 8
Views: 152
Posted By Gasman
Re: Table adding records to another table

Might be less process intensive if you save the last retrieved number and retrieve all records with a number greater than that, and update at the end.?
Forum: Forms 06-18-2019, 07:39 AM
Replies: 15
[SOLVED] Clerk Lock
Views: 299
Posted By Gasman
Re: Clerk Lock

I would not even give that a thought. You will only create much more work for yourself. At the best 3 different forms and even that would be a lot more work any time you changed one of the forms.
...
Forum: Forms 06-17-2019, 09:56 PM
Replies: 1
Views: 97
Posted By Gasman
Re: Rudementary form & table questions. NOOB! Be gentle...

Bearing in mind my signature, I would probably do something like this.

Have a table/form that holds the details of the deposit with data like, date, branch etc.
Then I would have a...
Forum: Forms 06-17-2019, 09:36 PM
Replies: 4
Views: 138
Posted By Gasman
Re: send email

Well the error message is clear enough.?

Your table/query name starts with "frm".

If that was in my system that would indicate a Form not a query.?
I start my queries with qry and my tables...
Forum: Forms 06-17-2019, 04:45 AM
Replies: 4
Views: 72
Posted By Gasman
Re: Open form resets a list box

How does it actually work?, as you have the value in stConNum and use stWhere to filter, yet that is not set?
Forum: Forms 06-16-2019, 10:36 PM
Replies: 4
Views: 138
Posted By Gasman
Re: send email

Firstly, you need Option Explicit at the top of all your modules. I could not find various variables like gDummy ?

You don't say what the problem is, but the code in Red might be the cause.?
...
Forum: General 06-16-2019, 10:26 PM
Replies: 10
Views: 337
Posted By Gasman
Re: Date() as year only

If you click Show All Actions button you then see it.?
Forum: General 06-16-2019, 08:57 AM
Replies: 18
Views: 585
Posted By Gasman
Re: Data Protection Different Levels

Doc,
He is just adding pretty much that line to other topics. Presumably just to get his 10 post count.?
Showing results 1 to 25 of 500

 
Forum Jump



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