** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
New forum feature - post voting and best solution
Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

This new feature looks great to me! :)
We now have 3 forum themes
Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Minty's latest activity

Minty replied to the thread Create a new table on SQL server from a form with VBA.

You can probably use a pass through query along the lines of; SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE...

15 minutes ago
Minty replied to the thread Assist requested. Providing a Query with criteria from a field on a form..

This suggests that the missing query parameter is mistyped with regard to what you think it should be (presumably it's a reference to...

Today at 8:53 AM
Minty replied to the thread Slow Search on Subform.

I guess we should be asking what the issue is that required you to use a subform? Is the subform linked to the main form in any way?

Today at 8:43 AM
Minty replied to the thread Data disappearing from report..

What happens if you simply (temporarily) comment out that code? Whilst I can't see why it would be causing a problem either, start at...

Yesterday at 6:51 PM
Minty replied to the thread Sebseb538 introduction.

Hi Seb, and welcome aboard AWF!

Yesterday at 6:35 PM
Minty replied to the thread Fill in table fields automatically from dropdown.

You shouldn't (and can't) do what you want directly in a table. Tables are for storing data, not interacting with. Stick with your...

Yesterday at 6:34 PM
Minty replied to the thread Add Working Days, excluding We & hols. Function is mixing dd/mm.

I found the best way was to actually dive in with a specific task in mind. The real secret to success with a new thing like VBA is to...

Yesterday at 5:47 PM
Minty replied to the thread Slow Search on Subform.

By adding the wildcard to the beginning of your search string you are rendering the Index on either field useless. Do you have to...

Yesterday at 8:57 AM
Minty replied to the thread Just saying hello.

Welcome to AWF Javier!

Yesterday at 8:52 AM
Minty reacted to davidcie's post in the thread Spurious 'SELECT [Id] FROM [Table]' with Like.

Well, sorry to spam but after writing all the above I had a hunch I could try re-writing the query and... voila, we have a solution to...

Monday at 3:13 PM
Minty replied to the thread Spurious 'SELECT [Id] FROM [Table]'.

That's a really interesting find, thank you for posting back about it. I've only had limited use of GUID fields, so not experienced the...

Monday at 3:13 PM
Minty reacted to SurreyNick's post in the thread Thank you and au revoir with Like.

Yes, I have been most fortunate and I say without reservation that it made all the difference to what I was able to accomplish. Other...

Monday at 12:47 PM
Minty replied to the thread Spllited Database risk over LAN Network challenge ,please how to Secure?.

I think it would be easier to let the users only use the database with a touch screen.

Friday at 3:55 PM
Minty replied to the thread Fitness Tips in this time of Pandemic.

@Jon Buy a set of clubs and join in. It's definitely the most frustrating hobby I have ever had.

Friday at 3:20 PM
Minty replied to the thread Access Running Slowly.

I wouldn't worry. On a Friday it will only be someones recipes for the weekend :eek:

Friday at 3:17 PM

Show older items

Home
Members