Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: Thales750
Forum: Modules & VBA 05-22-2018, 02:31 PM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

I was exaggerating.
The ones that stand out in your mind are the ones that required excessive thought and creativity.

I tend to forget about the mundane ones.
Forum: Modules & VBA 05-22-2018, 12:59 PM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

I think people get used to doing things a certain way.

Until a few months ago, after writing databases in Access since 1996, I had never cared about multi-criteria DLookups. I just used a...
Forum: Modules & VBA 05-22-2018, 12:10 PM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

I'm not saying it needs replacing. And 90% of my forms are bound. But when it comes to extremely difficult business rules. Built in Access will not work in all of those cases.

The real world has...
Forum: Modules & VBA 05-22-2018, 11:04 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

This is why I say in many cases, better to just create new records in DAO. When the complex record is created. Hit the save button and zero chance of something going wrong.
Forum: Modules & VBA 05-22-2018, 11:02 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

That's how I have always thought of it.
Forum: Modules & VBA 05-21-2018, 12:41 PM
Replies: 3
Views: 126
Posted By Thales750
Re: DLookup Multi-criteria

That is way better.

This is a serious Eureka moment. Thank you.
Forum: Modules & VBA 05-21-2018, 12:11 PM
Replies: 3
Views: 126
Posted By Thales750
DLookup Multi-criteria

Can someone tell me what I am missing here please?

Why does this work?

pubSwitchRequestID = DLookup("swrSwitchRequestID", "tblSwitchReport", "swrComplete = False")
pubSwitchRequestID =...
Forum: Modules & VBA 05-21-2018, 12:06 PM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

When you use a DAO RecordSet you can wait until the record set is inserted into a table to make decision about other programmatic events. It's 100% positive. No dirty forms, or maybe a delete or...
Forum: Modules & VBA 05-21-2018, 10:52 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

In cases where editing could be done by multiple Users, than I would use bound popups.

In Data Entry mode, rarely would I use bound popups. Using DAO code allows for data to be pulled in from...
Forum: Modules & VBA 05-20-2018, 11:53 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

I always like that old Troll. He was one of my favorite people.
Forum: Modules & VBA 05-20-2018, 06:06 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

This is Colin?
I know no one is saying that. Gina's version added action Queries. Yours converts it back again? that's cool.
I usually just run it through the debug to get it back to queryDef...
Forum: Modules & VBA 05-20-2018, 05:28 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

Yes and no. DAO code is more flexible than a query. Allen Browne made a code converter which was later modified by Gina Whipp that makes writing SQL code a no brainer.

70813
Forum: Modules & VBA 05-20-2018, 05:17 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

Thousands was an exaggeration. But hundreds anyway. A number that was dramatically reduced by using code.

There are many advantages to having a balance between querydefs and code.

The only...
Forum: Modules & VBA 05-19-2018, 06:45 AM
Replies: 33
Views: 1,100
Posted By Thales750
Re: strSQL in DLookup

Thanks all,

I try to use as much code as I can these days, with QueryDefs running in the thousands.

I guess this is just another example of why you should use code whenever possible. Some...
Forum: Modules & VBA 05-16-2018, 12:53 PM
Replies: 33
Views: 1,100
Posted By Thales750
strSQL in DLookup

If possible to use a SQL Statement in a DLookup.
(not a DLookup in a Query)

How would that be written?

Thanks all.
Forum: General 02-17-2018, 01:34 PM
Replies: 18
Views: 10,839
Posted By Thales750
Re: Memo Field, with date/time stamp

Hey Mark,

First to clarify: I want the curser to be inserted right after the header, thanks for the info.

This situation is unique. Normally, I would not append to an existing field. It's being...
Forum: General 02-17-2018, 07:47 AM
Replies: 18
Views: 10,839
Posted By Thales750
Re: Memo Field, with date/time stamp

Using this Code in the GotFocus Event
Me.MemoField = pubUserLoginName & " " & Now() & vbCr & vbLf & vbCr & vbLf & Me.MemoFieldinserts the above into the Memo Field as a new section.

Is there a...
Forum: Forms 11-11-2016, 07:03 AM
Replies: 4
Views: 264
Posted By Thales750
Re: Default, disapering text.

Thanks Guys.

I did it once before on an unbound Text Box, maybe using On Change and then when "Saving" the form information the code looked for the default text.

When I get around to getting it...
Forum: Forms 11-03-2016, 06:57 AM
Replies: 4
Views: 264
Posted By Thales750
Default, disapering text.

Sorry for not finding this on Google,

Could anyone tell me where to find a routine that shows a descriptive value in a null text box, but once the text box gets focus it goes blank.

Example:...
Forum: Forms 07-16-2016, 09:05 AM
Replies: 2
Views: 291
Posted By Thales750
Re: SourceObject Malfunction

Thank you,

That is what I ended up doing.

I should have returned earlier, and mentioned it.
Forum: Forms 07-01-2016, 06:37 AM
Replies: 2
Views: 291
Posted By Thales750
SourceObject Malfunction

Hey Guys,

Weird Problem:

I have a subform with the SourceObject set in properties.

The first time the form opens, the Subform Control is blank
in subsequent openings it works.

The...
Forum: Forms 06-24-2016, 11:47 AM
Replies: 2
Views: 2,856
Posted By Thales750
Re: Changing DataEntry property of subform

You'll need to add "= True" or "= False" as the case may be.
Forum: General 09-09-2015, 08:57 AM
Replies: 1
Views: 479
Posted By Thales750
Re: No start or End time in linked table using Outlook Calendar

Hey Guys,

Anyone have any ideas about this?
Forum: Theory and practice of database design 06-24-2015, 02:39 PM
Replies: 9
Views: 1,690
Posted By Thales750
Re: Expanded Hover

Yes that record (line) would turn a color. Indicating preselection.
Forum: Theory and practice of database design 06-24-2015, 06:08 AM
Replies: 9
Views: 1,690
Posted By Thales750
Re: Expanded Hover

Well, there are some technological road blocks to overcome. But I'm guessing the super Geeks out in Redmond would be able to solve them, given a certain level of motivation.

So I'm going to...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World