Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.18 seconds.
Search: Posts Made By: Gasman
Forum: General Today, 12:12 PM
Replies: 6
Views: 151
Posted By Gasman
Re: NOTICE TO ALL MEMBERS : Site Issues

I've not seen any since the reboot Colin.
Forum: Modules & VBA Today, 12:09 PM
Replies: 39
Views: 353
Posted By Gasman
Re: Populate the name of the active control on focus in a form.

Seriously?, we started off with 'Populate the name of the active control on focus in a form.
' and now 255 characters is not enough?:confused:
Forum: Forms Today, 08:20 AM
Replies: 9
Views: 122
Posted By Gasman
Re: Form Event when switching between another windows program and Access

This is the thread I was thinking of

https://www.access-programmers.co.uk/forums/showthread.php?t=305915
Forum: Forms Today, 07:53 AM
Replies: 9
Views: 122
Posted By Gasman
Re: Form Event when switching between another windows program and Access

Could you use the Call Stack to see what events are used.?

Not something I have ever played with myself, but I seem to recall someone mentioning it a while back.?
Forum: Tables Today, 07:45 AM
Replies: 5
Views: 72
Posted By Gasman
Forum: Modules & VBA Today, 07:27 AM
Replies: 39
Views: 353
Posted By Gasman
Re: Populate the name of the active control on focus in a form.

You can set the ControlTooltip property a lot easier.
Same with the Status Bar

https://docs.microsoft.com/en-us/office/vba/outlook/how-to/general/how-to-specify-control-tip-text-for-controls

...
Forum: Forms Today, 07:11 AM
Replies: 3
Views: 44
Posted By Gasman
Re: Table is recieving ID instead of description from form

I would not do it. If that descriptive name changes for any reason, you will lose relationships.

Just retrieve the descriptive name when needed. It is very easy to do.

Plus users should not be...
Forum: Queries Today, 02:15 AM
Replies: 3
Views: 42
Posted By Gasman
Re: Query resulting in 556

Do you have 556 records?
Forum: Modules & VBA Yesterday, 10:44 PM
Replies: 10
Views: 102
Posted By Gasman
Re: Save & new button

If you changed your thought processes and made the button create the New Record, you would get what you want.?
If the record was dirty, you would get your prompt, if not, you would still get your...
Forum: Site Suggestions 09-17-2019, 11:18 PM
Replies: 13
Views: 188
Posted By Gasman
I've already noticed dupes today. Galaxiom has...

I've already noticed dupes today.
Galaxiom has one in this thread
https://www.access-programmers.co.uk/forums/showthread.php?t=306876
Forum: Site Suggestions 09-17-2019, 10:30 PM
Replies: 13
Views: 188
Posted By Gasman
I have just had the issue where the site said the...

I have just had the issue where the site said the message was a copy of a message recently posted, but after posting, one is normally taken to the message, where as I was still in the edit window.?
...
Forum: Excel 09-17-2019, 10:26 PM
Replies: 2
Views: 70
Posted By Gasman
Can't you just use a VLookup and then Paste...

Can't you just use a VLookup and then Paste Special.? All done manually
Forum: Modules & VBA 09-17-2019, 01:22 PM
Replies: 6
Views: 101
Posted By Gasman
Forum: Modules & VBA 09-16-2019, 11:30 PM
Replies: 16
Views: 255
Posted By Gasman
Re: Problem communicating with OLE server or ActiveX Control

You do not appear to have spaces between those absolutely huge strings ?

Try debug.print strSQL4 and see what that produces.
Forum: Queries 09-15-2019, 10:50 PM
Replies: 5
Views: 84
Posted By Gasman
Re: What Report level fields are available to the 'On Print' event

Me refers to the form or report.?
That control is not on your report.?
Forum: Queries 09-15-2019, 10:48 PM
Replies: 1
Views: 50
Posted By Gasman
Re: Retrieve non-bound column from combo box in VBA

See https://docs.microsoft.com/en-us/office/vba/api/access.combobox.column
Forum: Forms 09-15-2019, 01:03 PM
Replies: 11
Views: 3,904
Posted By Gasman
Re: Forms Disappear

I was going to suggest that you list out all the forms in the DB with some VBA, but apparently the Documenter would do that for you as well.

What does that show you.?

Database Tools/Database...
Forum: Modules & VBA 09-15-2019, 08:27 AM
Replies: 26
Views: 461
Posted By Gasman
Re: Import Record count

Does that mean there were 133 records from the previous import.?

If you are clearing out the old transactions why even do a count.?
Forum: Queries 09-13-2019, 11:34 PM
Replies: 15
Views: 274
Posted By Gasman
Re: How to filter a Union query?

Do you even need the second WHERE?
Forum: Queries 09-12-2019, 11:42 PM
Replies: 8
Views: 142
Posted By Gasman
Re: Too Few Parameters Expected 2 Error

Like is no good. ;)

When this has happened to me, it is generally spelling mistakes, as access will not recognise the misspelt data.

Instead of jumping in feet first all the time, why not dip...
Forum: Modules & VBA 09-10-2019, 07:44 AM
Replies: 6
Views: 127
Posted By Gasman
Re: Get User Name Insert into

I cannot get Environ('username') to produce anything except an error message in the immediate window?


sqlstr="INSERT INTO tblUserName (UserName) VALUES ('" & Environ("Username") & "');"

...
Forum: Forms 09-10-2019, 04:14 AM
Replies: 4
Views: 95
Posted By Gasman
Re: Followhyperlink to Different Browser

So pick a browser and run that with the url as a parameter, just as that code does.?
Forum: Forms 09-10-2019, 03:25 AM
Replies: 23
Views: 311
Posted By Gasman
Re: Attachment field and sending email by access

Hmm, I would not have thought that would cause a problem?
I have just tested, in fact Outlook 2007 puts a space after the ; anyway.?

I ensured spaces were either side and the email was sent...
Forum: General 09-10-2019, 12:51 AM
Replies: 32
Views: 513
Posted By Gasman
Re: Run Access VBA code from .bat file

I *thought* all this was linked to another post of yours where you need to alter hardoded file paths in modules on a lot of dbs?

Whilst the link that you first posted shows one how to run code in...
Forum: Forms 09-08-2019, 08:27 AM
Replies: 16
Views: 422
Posted By Gasman
Re: Running out of Memory Errors ....

My computer is now This PC on Win10

You can see it in windows explorer
Showing results 1 to 25 of 500

 
Forum Jump



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