Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 410
Search took 0.05 seconds.
Search: Posts Made By: NauticalGent
Forum: Modules & VBA Today, 08:00 AM
Replies: 3
Views: 50
Posted By theDBguy
Re: Syntax Error 3320

Hi John. Try:.DefaultValue = """SEUSQL50\INST01,1437"""


Edit: Oops, too slow...
Forum: Modules & VBA Today, 08:00 AM
Replies: 3
Views: 50
Posted By CJ_London
Re: Syntax Error 3320

try

.DefaultValue = """SEUSQL50\INST01,1437"""

works for me.

Not sure why the comma makes a difference, but it does

edit: as with your single quotes the double quotes do appear as the...
Forum: General 09-13-2019, 05:09 PM
Replies: 18
Views: 407
Posted By Galaxiom
Re: Moving to SQL Server

When I said:


... my aim was not at anyone here, but at Microsoft for making their products guess what the user needs.

(Like trying to type " 2.3 cm" at the beginning of the line in Word and...
Forum: Code Repository 09-07-2019, 05:37 PM
Replies: 7
Views: 234
Posted By Micron
Randomizing Data for Posted db's

We often ask Original Poster to upload a copy of their db but the issue might be that it contains sensitive data. Complete data removal may not allow us to troubleshoot the OP's issue because...
Forum: The Watercooler 09-02-2019, 06:32 AM
Replies: 38
Views: 2,141
Posted By scott-atkinson
Re: What do nuns do?

I saw a film once about Nun's I'm not sure it was very accurate though these Nuns didn't seem to keep their clothes on for very long at all... :eek::p:D
Forum: Politics & Current Events 09-01-2019, 06:20 PM
Replies: 16
Views: 263
Posted By The_Doc_Man
Re: Queen Elizabeth to be evacuated as Brexit riots break out in London

No, you merely understood the 4-year-old's jokes better. They tend to not be so subtle.

But don't ask me to explain. Sometimes I like to keep you in suspense.
Forum: The Watercooler 09-01-2019, 05:53 AM
Replies: 13
Views: 207
Posted By moke123
Re: Yeah baby!

October is mine.

"Alexa, set an alarm for 9/30/19 at 11:59pm"
Forum: The Watercooler 09-01-2019, 03:05 AM
Replies: 13
Views: 207
Posted By Tera
Re: Yeah baby!

https://access-programmers.co.uk/forums/attachment.php?attachmentid=76306&stc=1&d=1567335897
Forum: The Watercooler 09-01-2019, 01:29 AM
Replies: 13
Views: 207
Posted By Gasman
Re: Yeah baby!

You Dog you :D

Congrats
Forum: Politics & Current Events 08-30-2019, 11:50 AM
Replies: 433
Views: 25,160
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Here's a very interesting article on global warming, it seems at the Sun has got a lot to do with it!

Climate change culprit? Short answer: the Sun...
Forum: Queries 08-30-2019, 06:54 AM
Replies: 16
Views: 243
Posted By plog
Re: Are UDFs in queries a bad idea?

I think you're propagating a spam post on another forum. Google the first words of the quoted posted ("111 Power Access Queries/SQL Examples"). The entire text is from a site selling the 111...
Forum: Queries 08-30-2019, 06:27 AM
Replies: 16
Views: 243
Posted By sonic8
Re: Are UDFs in queries a bad idea?

Drawing attention to the bit in red, are UDF’s in a querydef a bad idea?[/QUOTE]
I'd say you need to see this in its context. If you want to provide a wide variety of sample queries for different...
Forum: Modules & VBA 08-29-2019, 06:20 AM
Replies: 16
Views: 290
Posted By Micron
Re: Bang or dot

Perhaps your search term was lacking something, because there's lots on the subject. However, the major difference is that ! provides late bound access to the default member of an object by passing...
Forum: Debates 08-27-2019, 10:36 AM
Replies: 74
Views: 24,108
Posted By CJ_London
Re: Is Microsoft Access a 'proper' database?

we know - he/she has been warned
Forum: Forms 08-26-2019, 10:49 AM
Replies: 49
Views: 736
Posted By sonic8
Re: What makes good design?

Understatement! - You design looks very clean and modern and is certainly in the upper 10% of Access UI designs I've seen.
A small hint: The Top-Property of the controls in the two columns is not...
Forum: General 08-19-2019, 12:27 PM
Replies: 17
Views: 619
Posted By isladogs
Re: Employee System Example V4 Info

To avoid hijacking this, I've just started a new thread What makes good design? (https://www.access-programmers.co.uk/forums/showthread.php?t=306417)
I've moved a few posts across to that thread.
Forum: Forms 08-19-2019, 12:12 PM
Replies: 49
Views: 736
Posted By isladogs
What makes good design?

OK I think we can all recognise bad design when we see it....but what makes good design?

NOTE This follows on from a discussion at...
Forum: General 08-17-2019, 04:42 AM
Replies: 20
Views: 312
Posted By MajP
Re: How to enable a button if any of controls changed

Does not work on unbound forms AFAIK
https://docs.microsoft.com/en-us/office/vba/api/access.form.dirty(even)



Also unbound controls do not have an "oldvalue" property to compare. Have to roll...
Forum: Queries 08-08-2019, 01:39 AM
Replies: 19
Views: 338
Posted By arnelgp
Re: Checking for date

I see.
I don't know whether others have better approach but you will need a function to do that.
copy in new Module (VBA->Insert->Module):

'arnelgp
'find date inside a string
'
'returns...
Forum: General 08-05-2019, 12:45 PM
Replies: 20
Views: 381
Posted By Vassago
Re: Pencil and paper

This thread is going to stay right here as an example of what not to do on the forum. I've given him the boot.
Forum: General 08-05-2019, 09:57 AM
Replies: 20
Views: 381
Posted By The_Doc_Man
Re: Pencil and paper

According to an old joke, I believe he is seeking to settle the dispute out of court.

Billy, the world is too full of grief already to harbor such hatred. While I don't care if you post again, I...
Forum: General 08-05-2019, 09:41 AM
Replies: 20
Views: 381
Posted By Catalina
Re: Pencil and paper

This is a person you cannot not have a reasonable discussion with because he thinks that he is right and everybody else is wrong.

I used to be married to someone like that. No matter what you do...
Forum: General 08-05-2019, 09:01 AM
Replies: 20
Views: 381
Posted By Mark_
Re: Pencil and paper

I wonder what happens when he realizes he has to SHARPEN a pencil or it stops working? Will he get rid of it because its broken?
Forum: General 08-04-2019, 07:33 PM
Replies: 20
Views: 381
Posted By The_Doc_Man
Re: Pencil and paper

I am reminded of that great line from the Christian Bale Batman trilogy. Why do we fall down? So we can pick ourselves up and carry on. If you expect us to write perfect code for you, remember...
Forum: General 08-04-2019, 06:39 PM
Replies: 20
Views: 381
Posted By pbaldy
Re: Pencil and paper

Presumably you won't ask for any more help from those of us with apps that have run successfully for decades so we won't have to worry about it.
Showing results 1 to 25 of 410

 
Forum Jump



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