Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.86 seconds.
Search: Posts Made By: Gasman
Forum: Forms Today, 01:00 PM
Replies: 24
Views: 206
Posted By Gasman
Re: copy record in subform

Good job arnelgp.
That is what I call 'perseverance'.:cool:
Forum: General Today, 10:19 AM
Replies: 23
Views: 243
Posted By Gasman
Re: Calculate the age

The only comma I see in the output you require is after years ?
Just amend that string in arnelgp's code?
Forum: The Watercooler Today, 08:33 AM
Replies: 33
Views: 485
Posted By Gasman
Re: Distractions, Distractions, Distractions

Sonos too expensive for me. :D

I have the Omnifi DMS1 units all over the house, with music supplied from my NAS box.
I have one in the garage connected to a ghetto blaster as the drawback with...
Forum: The Watercooler Today, 06:04 AM
Replies: 33
Views: 485
Posted By Gasman
Re: Distractions, Distractions, Distractions

Well you could always use it to interrogate the car, when the EML light comes on?
You can also change various settings via software.?

I use a small notebook to connect to my cars. Have used it...
Forum: Access Web Today, 05:53 AM
Replies: 8
Views: 70
Posted By Gasman
Re: Advice on connecting Access to SQL Azure with Dynamic IP addresses

Ah, the DNS service would appear not an option unless you can specify a url instead of ip address.

Sorry. :(
Forum: The Watercooler Today, 05:50 AM
Replies: 33
Views: 485
Posted By Gasman
Re: Distractions, Distractions, Distractions

Minty,

I have to ask.

What use are you going to put it to in the garage?
Forum: Access Web Today, 05:11 AM
Replies: 8
Views: 70
Posted By Gasman
Re: Advice on connecting Access to SQL Azure with Dynamic IP addresses

Sign up for a DNS service?
If you/your customers are happy to renew every 30 days, then the service would be free, but is not expensive anyway.

I use https://www.noip.com/
Forum: Modules & VBA Today, 12:59 AM
Replies: 4
Views: 171
Posted By Gasman
Re: merge pdf files till 5mb size

Well the code you supplied has nothing to do with that.?

I think you would do something like

Initialise filesize varaiable (pdfSize)
Get first file from table

Get filesize using your...
Forum: Queries Today, 12:34 AM
Replies: 18
Views: 144
Posted By Gasman
Re: show record between 2 date in qury

Surely you should be comparing startdate in table to start date in form and likewise end date in table with end date in form, plus the form time elements.?

The BETWEEN is used when you are...
Forum: Queries Yesterday, 12:30 PM
Replies: 18
Views: 144
Posted By Gasman
Re: show record between 2 date in qury

Can you not just add Time to Date?


? timevalue(now())
21:27:47
? cdec(timevalue(now()))
0.894722222222222
? cdec(date)
43755
? cdec(now())
Forum: Forms Yesterday, 11:17 AM
Replies: 20
Views: 198
Posted By Gasman
Re: Conditional visibility based on input

You should be opening the form for


DoCmd.OpenForm "frmClassSchedule"


There is no studentx on that.?:confused:
Forum: General Yesterday, 08:29 AM
Replies: 23
Views: 243
Posted By Gasman
Re: Calculate the age

I just tried it out and it works fine for me?
Forum: General Yesterday, 01:08 AM
Replies: 23
Views: 243
Posted By Gasman
Re: Calculate the age

So use arnelgp's code and then apply your requirements yourself.?
Forum: Forms 10-16-2019, 09:56 AM
Replies: 20
Views: 198
Posted By Gasman
Re: Conditional visibility based on input

Don't do that. Each user should have their own COPY of the front end.
Forum: Forms 10-16-2019, 08:07 AM
Replies: 8
Views: 1,462
Posted By Gasman
Re: Sending SMS to phones.

Guys, this is a 7 year old thread? :D
Forum: Modules & VBA 10-16-2019, 04:14 AM
Replies: 13
Views: 163
Posted By Gasman
Re: Output Open Form to PDF

Well I think you have established that might not be available.?

However I was thinking, if Alt+PrtScn was what you needed, then paste into Word and Export that to PDF.

All in VBA, so the user...
Forum: Modules & VBA 10-16-2019, 03:51 AM
Replies: 13
Views: 163
Posted By Gasman
Re: Output Open Form to PDF

What does Alt+PrtScn give you?
Forum: Queries 10-16-2019, 01:09 AM
Replies: 12
Views: 131
Posted By Gasman
Re: UNION Query syntax Issue

I'm confused now as your initial error message was on the 2017 file.?
Forum: Modules & VBA 10-16-2019, 12:59 AM
Replies: 7
Views: 160
Posted By Gasman
Re: Get path to file (e.g. picture) in android device (e.g. cell phone, tablet...)

I think it depends on how you connect your device.

I select USB file transfer and then the VBA file dialog works as normal?
Forum: Queries 10-16-2019, 12:35 AM
Replies: 12
Views: 131
Posted By Gasman
Re: UNION Query syntax Issue

Try using brackets?

I *think* the A is from the start of the AND ?
Forum: Queries 10-15-2019, 01:18 PM
Replies: 8
Views: 112
Posted By Gasman
Re: Dlook for text with 2 criteria

I would ask, why are you looking up drug name when you are supplying drug name? :confused:
Forum: General 10-15-2019, 01:55 AM
Replies: 12
Views: 130
Posted By Gasman
Re: Whats the best approach too??????

I think that should be 'If the second record does not exist' Colin ?
Forum: Access Web 10-14-2019, 08:50 AM
Replies: 5
Views: 112
Posted By Gasman
Re: Looking for advice on migrating to Cloud

If this ever takes off, you might be able to use this?

https://azure.microsoft.com/en-gb/services/virtual-desktop/
Forum: Introduce Yourself 10-14-2019, 08:46 AM
Replies: 8
Views: 441
Posted By Gasman
Re: Introduction

Yes,
I tend to recognise them now, generally by the vast number of views as opposed to posts.
Forum: Introduce Yourself 10-14-2019, 08:12 AM
Replies: 8
Views: 441
Posted By Gasman
Re: Introduction

That was 5 years old as well? ;)
Showing results 1 to 25 of 500

 
Forum Jump



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