Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 306
Search took 0.06 seconds.
Search: Posts Made By: Rx_
Forum: Introduce Yourself 03-08-2019, 08:52 AM
Replies: 2
Views: 141
Posted By Rx_
Cool Smoke me a kipper, I'll be back for breakfast

While enjoying my breakfast of kippers vindaloo, my message board alerted me to a question on the site. The Access industry in my area that require any levle of programming have seemed to evaporate....
Forum: The Watercooler 12-20-2018, 12:45 PM
Replies: 2,999
Views: 581,426
Posted By Rx_
Re: What's your best/worst joke?

Forum: Microsoft Access User Groups 05-14-2018, 04:31 AM
Replies: 0
Views: 15,243
Posted By Rx_
Lightbulb Microsoft PASS - SQLSaturday May 19, 2018

This might be of interest to MSAccess programmers that tap into a SQL Server platform to create an application for a small business unit.
Forum: Modules & VBA 03-20-2018, 03:21 PM
Replies: 6
Views: 431
Posted By Rx_
Lightbulb Re: Renaming exported excel file

My preference is to Save As
Instead of opening a New Excel - open an existing then review some of the SaveAs opitions.
Forum: The Watercooler 10-19-2017, 06:53 AM
Replies: 2,999
Views: 581,426
Posted By Rx_
Talking Re: What's your best/worst joke?

Multiple Choice:

I'm reading where the Japanese said that Americans are all stupid and illiterate and lazy. Well, I didn't really read it. I saw it on television. I was lying there on the couch....
Forum: Microsoft Access User Groups 10-06-2017, 08:36 AM
Replies: 0
Views: 3,113
Posted By Rx_
Lightbulb 2017 Oct 10 Access group via SKYPE

More information at: https://accessusergroups.org/calendar/

USA Chicago, Ill Access User Group reminder for our next Access SQL Server meeting, which is Tuesday October 10th.

Microsoft Access...
Forum: Politics & Current Events 09-24-2017, 11:17 AM
Replies: 14
Views: 2,454
Posted By Rx_
Red face Defiant Catalans Block Spain’s Military Boats From Landing; Spain Seizes “.CAT” Domai

Just an observation: Wow, you can't make this stuff up!

Democracy In The EU - Will this return the Franco dictatorship?
There is a revolution going on this week in Spain. The people vs the...
Forum: The Watercooler 06-13-2017, 01:23 PM
Replies: 12
Views: 1,777
Posted By Rx_
Re: My New Job - Shelf Stacking at Tesco's!

Taking Stock in yourshelf is a worthy effort. We wish you the best of luck in your new abandonment.

<Provided by Auto Responder AI - when you don't have time to send a personalized response but...
Forum: Modules & VBA 04-06-2017, 07:13 PM
Replies: 10
Views: 680
Posted By Rx_
Wink Re: API calls make application prone to crash

Don't be discouraged by using API.
Just go to the extra effort of creating documentation for test plans to test, test, test the API. Document the OS and Office versions they were tested on.

Forum: Modules & VBA 04-06-2017, 06:30 AM
Replies: 10
Views: 680
Posted By Rx_
Re: API calls make application prone to crash

Used a lot of API calls in my last environment.
As said, it is necessary to check for 32/64 bit.

The biggest problem comes into the testing of them across various platforms.
Some of my API...
Forum: Excel 03-31-2017, 06:07 AM
Replies: 3
Views: 1,475
Posted By Rx_
Re: Excel VBA: String or variant variable showing empty when it is not

Glad you found the solution. Being specif about the workbook referenced is easy to miss.
Filling in the answer will help others who are searching for a solution later.
Please feel free to use the...
Forum: Excel 03-13-2017, 08:43 AM
Replies: 0
Views: 1,238
Posted By Rx_
Lightbulb Scroll a FreezePanes back to most left column regardless of where Freezepanes starts

Just had to share this, spent way more time than expected for a simple solution. Started a question, then found the answer mid way.

Access code automating Excel where ObjXL is an object that is...
Forum: Excel 02-16-2017, 09:31 AM
Replies: 5
Views: 1,442
Posted By Rx_
Re: code Sorting and Grouping - bold cells with =Subtotal quickly

The macro recorder won't replay a Group and Subtotal. It requires a custom macro update with a custom Array. I will try to post that here when I get a break today.
Forum: Politics & Current Events 01-07-2017, 03:58 PM
Replies: 40
Views: 11,578
Posted By Rx_
Exclamation Why do you thinkd Brexit and Trump happened? Watt's Up With That?

Why do you think Brexit and Trump happened?
Is it a one time thing? Is it a trend?

As a fan of observing the Brexit, the outcry across the pond indicates that the "People are Revolting", as...
Forum: Site Suggestions 01-05-2017, 07:14 AM
Replies: 20
Views: 6,118
Posted By Rx_
Re: Unsolicited Advertising

B.T.W. I did notice that I get 1 single advertisement per page now, as a Gold Member.
Did I miss a renewal? would be glad to renew if only to provide a Thank You via tax deductible membership.
Forum: Access World News 01-05-2017, 07:06 AM
Replies: 73
Views: 12,066
Posted By Rx_
Re: Site changed to secure

On win 10 - IE - never noticed any problems - have yet to attempt upload.
If it makes any difference, Denver is a Mile High - that implies our OS are not Metric.
Thanks for all you do Jon!
Forum: SQL Server 12-27-2016, 05:08 PM
Replies: 1
Views: 2,341
Posted By Rx_
Question Table based function using Row_Number() in SQL Server fails Linked Table connection

A view with no unique data (part of a cube) didn't have unique columns to select with the Linked Table Manager.
So, we used the Row_Number() function to create unique values in the view.
Forum: Excel 11-03-2016, 05:19 AM
Replies: 5
Views: 920
Posted By Rx_
Lightbulb Re: POS Spreadsheet for a coffee business

Access won't run on Apple. But the new small business Citrix would allow Access to run on just about any platform over the Internet. It is most likely more than a small coffee shop owner wants to do....
Forum: Excel 08-31-2016, 01:07 PM
Replies: 8
Views: 1,229
Posted By Rx_
Re: Best data link provider to import and link access table into excel

If you haven't had a good drink lately, then you are worrying too much!
It probably doesn't make any difference.
As a purely personal preference, ODBC comes in many great forms. Eg. ODBC, SQL...
Forum: Excel 08-25-2016, 09:21 AM
Replies: 8
Views: 1,229
Posted By Rx_
Re: Best data link provider to import and link access table into excel

Are you planning to:
import it with a wizard?
Write VBA Code to find the excel file at a some location and import it over and over
Use a Linked Table to permanently link to one Excel...
Forum: SQL Server 07-19-2016, 03:53 PM
Replies: 6
Views: 2,061
Posted By Rx_
Re: How to Upload E-files from ms access to sql server and download it

Lets break the questions down to bite-size.
1. You upsized
2. The linked tables from the FE to the BE are working?
3. Explain the needs to change design SQL Server (give us some examples)
Forum: Excel 07-06-2016, 06:05 AM
Replies: 5
Views: 705
Posted By Rx_
Arrow Re: External Data Refresh

The version of the Publisher can cause this.
By default Excel saves a hidden table of the link values for calculation purposes. In some scenarios the values for the external links may not be the...
Forum: SQL Server 07-05-2016, 03:14 PM
Replies: 4
Views: 1,604
Posted By Rx_
Lightbulb Re: Sql server as backend for Access application

Just a suggestion from someone else who has done this many times.
Instead of making the total move all at once and risk being off line a day or more figuring out why...
Break it up into...
Forum: Introduce Yourself 07-05-2016, 01:07 PM
Replies: 10
Views: 849
Posted By Rx_
Shameless Plug for my 300th Thanks!!

Thanked 299 Times in 274
SO CLOSE - When I get 300, I can cash them in and retire?
Forum: Politics & Current Events 07-04-2016, 07:11 AM
Replies: 8
Views: 3,446
Posted By Rx_
Re: Vote for Brexit the Sequel - Scripts

The US Administration has used the EU to stop trade with Russia.
Hillary Clinton calls Putin "the new Hitler" along with the many other news stories released that typically end up being exaggerated...
Showing results 1 to 25 of 306

Forum Jump

All times are GMT -8. The time now is 05:08 PM.

Microsoft Access Help
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