Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.23 seconds.
Search: Posts Made By: isladogs
Forum: Forms Today, 12:00 AM
Replies: 9
Views: 87
Posted By isladogs
Re: RecordSouce from sql

Just going out for a few hours so I can't provide code at the moment.
The following is an outline of one approach you could use as its only one of two tables. Its not the nearest but it may be a...
Forum: Forms Yesterday, 10:57 PM
Replies: 9
Views: 87
Posted By isladogs
Re: RecordSouce from sql

To ensure any example code is relevant, can you explain the MyCompany part of your code. Are you using a fixed table for this and, if so, what is its name?
Or is the table name selected by the user...
Forum: Forms Yesterday, 10:12 PM
Replies: 9
Views: 87
Posted By isladogs
Re: RecordSouce from sql

Whilst you are changing it, I would recommend you get rid of all this unnecessary complexity.
You really shouldn't need two functions GetTitleMatch and SplitIt and the use of query defs to construct...
Forum: Macros Yesterday, 10:04 PM
Replies: 4
Views: 89
Posted By isladogs
Re: Write conflict: I want to always Drop Changes

Agree with DBG.
In a well designed database, write conflicts should never occur.
Identify the cause of the problem and then fix that e.g. by changing settings for record locks (though other...
Forum: Tables Yesterday, 09:38 PM
Replies: 5
Views: 67
Posted By isladogs
Re: table relationships issues

Hi yavuka
Welcome to AWF.
I've deleted multiple duplicate posts which were moderated. This can happen with new members especially if the posts contain code, attachments or (in this case) are quite...
Forum: Sample Databases Yesterday, 12:14 PM
Replies: 3
Views: 3,926
Posted By isladogs
Re: Another countdown timer (with sounds)

Further minor update to fix 64-bit issue overlooked previously
Forum: Modules & VBA Yesterday, 12:13 PM
Replies: 17
Views: 589
Posted By isladogs
Re: Play different sounds as Quick as DoCmd.Beep

Hmm....
I've rechecked this in Access 2019/365 64-bit and it works absolutely fine. The code should be in a standard module ...NOT a form/class module
The only parts in red are those in the #Else...
Forum: Modules & VBA Yesterday, 05:25 AM
Replies: 17
Views: 589
Posted By isladogs
Re: Play different sounds as Quick as DoCmd.Beep

You're welcome.
Whilst add PtrSafe is needed so the project compiles, you always need to use LongPtr for handles such as hWnd or, in this case, hModule.
I've not seen the uFlags variation before...
Forum: Modules & VBA Yesterday, 04:50 AM
Replies: 12
Views: 126
Posted By isladogs
Re: Output Open Form to PDF

Are you really sure that going through these hoops is easier than just creating a report?
Forum: Queries Yesterday, 04:43 AM
Replies: 5
Views: 60
Posted By isladogs
Re: Crosstab and ACCDE

I can confirm the opposite. Crosstab queries work perfectly for me in both ACCDB and ACCDE and do so in all versions of Access I've ever used
Forum: Queries Yesterday, 01:01 AM
Replies: 12
Views: 119
Posted By isladogs
Re: UNION Query syntax Issue

Are there any results for the 2016 table using the WHERE filter if its run on its own?

What happens if you do this in 2 stages?
1. Create qryUnion with no filters
2. Create another query...
Forum: Reports 10-15-2019, 10:52 PM
Replies: 6
Views: 96
Posted By isladogs
Re: Davg in report group footer

Just to clarify, if you used an expression like Date()-[DueDate] AS DaysPastDue in your query, you can't reliably use DaysPastDue in another field in the same query such as your IIf expression.
You...
Forum: Macros 10-15-2019, 10:12 PM
Replies: 8
Views: 104
Posted By isladogs
Re: How much of a performance impact does declaring variables / passing arguments hav

Although originally intended to compare CurrentDB and DBEngine(0)(0), that was the reference I intended.
The highlighted section below hopefully shows the point I was making
...
Forum: Forms 10-15-2019, 01:10 PM
Replies: 5
Views: 79
Posted By isladogs
Re: Set Mouse Cursor not SetFocus

Glad you've found the solution.
Forum: Queries 10-15-2019, 01:07 PM
Replies: 8
Views: 100
Posted By isladogs
Re: Dlook for text with 2 criteria

Try this
DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & "' AND [Chemo_drug]= 0")


However using DLookup in a query will be slow. There may be better ways.
Can you post the...
Forum: Queries 10-15-2019, 12:31 PM
Replies: 18
Views: 271
Posted By isladogs
Re: Appending an auto-increment date to a Query

It did indeed. Now approved.
Until you have ten posts you need to zip attached files.
Forum: Forms 10-15-2019, 12:19 PM
Replies: 5
Views: 79
Posted By isladogs
Re: Set Mouse Cursor not SetFocus

If that's the case, why would you get the jittering loop effect you described?
Forum: Macros 10-15-2019, 11:53 AM
Replies: 8
Views: 104
Posted By isladogs
Re: How much of a performance impact does declaring variables / passing arguments hav

The differences for the example I provided are indeed small as previously stated but I think slightly greater than the Doc suggests.
See...
Forum: Queries 10-15-2019, 11:45 AM
Replies: 6
Views: 86
Posted By isladogs
Re: Yearly odometer reading- subtract from last years

Thanks for clarifying your first post.
I suggest you use a subquery for this using the same method as in this link from Allen Browne's website http://allenbrowne.com/subquery-01.html#AnotherRecord
Forum: Forms 10-15-2019, 11:22 AM
Replies: 5
Views: 79
Posted By isladogs
Re: Set Mouse Cursor not SetFocus

Disable the button on the previous form after it is clicked
Forum: Queries 10-15-2019, 11:20 AM
Replies: 6
Views: 86
Posted By isladogs
Re: Yearly odometer reading- subtract from last years

Hi beancounter and welcome to AWF.
Your post was moderated. Now approved.
Its not clear from your post what exactly you want help with.
Please clarify.
Forum: Forms 10-15-2019, 10:42 AM
Replies: 8
Views: 4,937
Posted By isladogs
Re: Start in the first position the cursor!

You do realise this is a 7 year old thread?
Rather than use complex code unnecessarily, I suggest you move the control or the subform.
Alternatively, disable the control after clicking it.
Forum: Macros 10-15-2019, 10:13 AM
Replies: 8
Views: 104
Posted By isladogs
Re: How much of a performance impact does declaring variables / passing arguments hav

In fact, declaring a variable as public and using it throughout your application can improve performance

For example, if you always use CurrentDB.Execute "SQL statement here", Access has to...
Forum: Modules & VBA 10-15-2019, 09:57 AM
Replies: 17
Views: 589
Posted By isladogs
Re: Play different sounds as Quick as DoCmd.Beep

Hi

You need to do more than just add PtrSafe for your code to work correctly. See below in red

For info, I've updated the API declarations using conditional compilation to work in both 32-bit &...
Forum: Sample Databases 10-15-2019, 09:55 AM
Replies: 3
Views: 3,926
Posted By isladogs
Re: Another countdown timer (with sounds)

Following a comment in another thread https://www.access-programmers.co.uk/forums/showthread.php?t=303151, attached is an updated version of this utility which works in both 32-bit & 64-bit Access
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:25 AM.


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