Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.09 seconds.
Search: Posts Made By: Minty
Forum: SQL Server Today, 08:32 AM
Replies: 9
Views: 82
Posted By Minty
Re: Access SQL Query -> T-SQL Query Conversion ?

But won't the query about the query, need another query, about the first query....... :D
Forum: SQL Server Today, 03:53 AM
Replies: 9
Views: 82
Posted By Minty
Re: Access SQL Query -> T-SQL Query Conversion ?

@Galaxiom - I have seen that in the performance analyser, good shout.

The only fly in the ointment is that the server concerned is the main data-warehouse for the business, and finding one query...
Forum: SQL Server Today, 03:14 AM
Replies: 9
Views: 82
Posted By Minty
Re: Access SQL Query -> T-SQL Query Conversion ?

Actually this might help ; https://www.microsoft.com/en-us/download/details.aspx?id=54255
Microsoft SQL Server Migration Assistant 8.2 for Access

Going to have a play.
Forum: SQL Server Today, 03:00 AM
Replies: 9
Views: 82
Posted By Minty
Re: Access SQL Query -> T-SQL Query Conversion ?

@NG I hadn't actually - in fact I was very lazy and didn't think to Google for a convertor for some reason.

Give me a slap...
Forum: SQL Server Today, 02:09 AM
Replies: 9
Views: 82
Posted By Minty
Question Access SQL Query -> T-SQL Query Conversion ?

Hi All,

Before I reinvent the wheel, has anyone written a text convertor that would take most of the pain out of moving a massive bunch of Access queries (25 databases with probably at least 500...
Forum: General Today, 01:28 AM
Replies: 2
Views: 46
Posted By Minty
Re: Ole error

I think we'll need a little more to work on, what is the code behind the button?
And which line does the error happen on?
Forum: Introduce Yourself Today, 01:20 AM
Replies: 7
Views: 66
Posted By Minty
Re: Hello

Welcome to AWF !

The official welcomers will be here soon, and make you a nice cup of tea with biscuits.

YNWA ! ;)
Forum: Forms 06-17-2019, 05:56 AM
Replies: 14
Views: 175
Posted By Minty
Re: Problem when editing date in a form.

It looks like it's a sharepoint / webapp?

Hence no design view.
Forum: Modules & VBA 06-14-2019, 07:02 AM
Replies: 7
Views: 133
Posted By Minty
Re: VBA to open report based on listbox dropdown and button click

Yes but its not as easy for end users to see / use.
Forum: Modules & VBA 06-14-2019, 12:56 AM
Replies: 18
Views: 353
Posted By Minty
Re: Extracting content from an ACCDE Database

I have the same layout and process for moving employees into a training schedule.
It's an older database but I should be able to get into it to extract the basics given some time.

I'm sure...
Forum: Modules & VBA 06-13-2019, 05:32 AM
Replies: 18
Views: 353
Posted By Minty
Re: Extracting content from an ACCDE Database

@Dave - What I meant was what does it do in terms of it's functionality, not the code.

Could you screen shot it and add some words of wisdom describing it's purpose?
Forum: Modules & VBA 06-13-2019, 01:57 AM
Replies: 18
Views: 353
Posted By Minty
Re: Extracting content from an ACCDE Database

What does this listbox do that is so clever?
I'm sure between us we could recreate it some how?
Forum: Forms 06-13-2019, 12:45 AM
Replies: 14
Views: 175
Posted By Minty
Re: Problem when editing date in a form.

Without seeing the database this will be hard to diagnose from your description.

As it's new if you compact and repair it, then zip it you should be able to upload it here for someone to look at.
Forum: Modules & VBA 06-13-2019, 12:25 AM
Replies: 7
Views: 133
Posted By Minty
Re: VBA to open report based on listbox dropdown and button click

You could populate your listbox with all reports in your database automatically ;

Make the listbox rowsource this;

SELECT MsysObjects.Name
FROM MsysObjects
WHERE...
Forum: Forms 06-12-2019, 12:37 AM
Replies: 6
Views: 73
Posted By Minty
Re: Tab Control can handle Split Forms from qry?

That is certainly possible, and doesn't sound like a split form, more like different datasheet sub-forms embedded on a main form.
Forum: Forms 06-12-2019, 12:25 AM
Replies: 6
Views: 73
Posted By Minty
Re: Tab Control can handle Split Forms from qry?

Not sure I get your question clearly, can you mock up a picture?

Split forms are notoriously fussy to work with and difficult to program events on correctly, you may be better with an alternative...
Forum: Modules & VBA 06-12-2019, 12:22 AM
Replies: 11
Views: 156
Posted By Minty
Re: Not finding end of the file in loop

I'm pretty sure this line

myrec1.MoveNext

Should be outside the if myrec1.EOF section. i.e before the Loop command.
As if it is EOF it won't move to the EOF so the loop won't stop.
Forum: Forms 06-11-2019, 06:43 AM
Replies: 14
Views: 166
Posted By Minty
Re: Form has no active record on opening

I had a weird issue with the OnCurrent event not firing yesterday.

In the end I copied the code, deleted it, saved and closed the form. Compact & Repair then reopened and created a new OnCurrent...
Forum: Forms 06-07-2019, 01:52 AM
Replies: 8
Views: 117
Posted By Minty
Re: Using SelStart with a ComboBox

I suspect it's the input mask over-riding the normal behaviour.

Why do you need it? Shirley a combo is already presenting the data as you need it?
Forum: Politics & Current Events 06-07-2019, 01:35 AM
Replies: 8
Views: 138
Posted By Minty
Re: Remembering D-day

I've been to the Normandy area many times, on my way to Le Mans 24Hr and to play golf, and on those trips have had many visits to places like Omaha and Gold beaches, Arromanche...
Forum: Queries 06-06-2019, 02:32 AM
Replies: 3
Views: 96
Posted By Minty
Re: Difference between fields on subsequent dates

Glad to have helped.

Bookmark Allen Brownes site - it's a wealth of great tips and samples.
Forum: Queries 06-06-2019, 01:37 AM
Replies: 3
Views: 96
Posted By Minty
Re: Difference between fields on subsequent dates

Have a read here - it's a sample about meter readings !
http://allenbrowne.com/subquery-01.html#AnotherRecord
Forum: Modules & VBA 06-05-2019, 02:19 AM
Replies: 2
Views: 90
Posted By Minty
Re: Variable MySQL driver version in connection string

Have a read of this to get the drivers on a machine;
...
Forum: General 06-05-2019, 12:28 AM
Replies: 27
Views: 329
Posted By Minty
Re: Convert MsAccess report to PDF and save it in specific customer path

@OP - See post #21 we are all suggesting the same thing.

Create a form with cmd buttons to either preview the whole report, or select a specific record and export it.
Forum: Queries 06-04-2019, 07:20 AM
Replies: 9
Views: 174
Posted By Minty
Re: Simple query to calculate totals from 2 different tables

Your tables are a little confusing - they seem to have the pretty much the same data in them?

You can't filter them with the current relationship because they are only joined on the aircraft...
Showing results 1 to 25 of 500

 
Forum Jump



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