Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: ridders
Forum: General Today, 02:12 PM
Replies: 0
Views: 1
Posted By ridders
Drag & drop objects from one database to another

After almost 20 years using Access, it amazes me that I still find out new things all the time...

When I want to copy objects to a new database, I have always done so by importing or exporting by...
Forum: Modules & VBA Today, 01:32 PM
Replies: 6
Views: 150
Posted By ridders
Re: Progress indicator while creating Word document

You asked about 3 different solutions - text on screen, status bar text & progress bar.
I gave you code for the first two of those & suggested where to look for progress bars

What else would you...
Forum: General Today, 01:28 PM
Replies: 6
Views: 185
Posted By ridders
Re: Always getting a Security Notice for regular accdb files

No it won't .... but its easy enough to add both folders to your trusted locations list!
Forum: Forms Today, 01:27 PM
Replies: 7
Views: 103
Posted By ridders
Re: Drop down menus

Why is that hard ... those menus are listed by default without you doing anything!
Or you can choose SHORT menus....where you only get File, Home
OR you can add extra menu items ...using ribbon...
Forum: Tables Today, 01:17 PM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

All you need to do is copy & paste the query SQL into your database!

SELECT tblFacilityRegister.ID, tblFacilityRegister.SenderID, tblFacilityRegister.ReceiverID, tblFacilityRegister.ScannedBy,...
Forum: Modules & VBA Today, 01:02 PM
Replies: 2
Views: 31
Posted By ridders
Re: Could do with some cursor help please

I also can't see any reason for involving ADO at all

This query SQL should give you the record count:
SELECT Count(Tbl_DataTest.EnterName) AS RecordCount
FROM Tbl_DataTest LEFT JOIN Tbl_Employee...
Forum: Forms Today, 12:47 PM
Replies: 7
Views: 103
Posted By ridders
Re: Drop down menus

So you are building a database in Access and it should have the Access menus...Sounds easy enough....:D
Forum: Forms Today, 11:05 AM
Replies: 7
Views: 103
Posted By ridders
Re: Drop down menus

I got befuddled with:
Forum: Tables Today, 11:03 AM
Replies: 20
Views: 136
Posted By ridders
Forum: Forms Today, 11:00 AM
Replies: 2
Views: 38
Posted By ridders
Re: Sql issue in ms access

You are missing a comma separating 2 fields at the end of a line
Corrected version with added comma in RED:

strSql = "UPDATE Attend SET"
strSql = strSql & " Attend.AttType = " & TypeAttend & ","...
Forum: Tables Today, 10:50 AM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

Well that proves I'm no genius ...as I've no idea what you're talking about ....;)
Forum: Tables Today, 08:11 AM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

@alkaheem
Did you see my working solution in post 5?

It will work just as well with number datatypes for your key fields
By all means restructure your tables if it improves your database .......
Forum: Tables Today, 06:46 AM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

I'm no more a genius than DJT... But perhaps more stable. :D
Forum: Tables Today, 06:23 AM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

Wrong. It's a yes. Look at the example I posted

P.S. Congrats on reaching 5000 posts
Forum: Tables Today, 05:52 AM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

Sorry - it should have been 3 copies of tblUsers! I've corrected my original post



Which is why I didn't suggest that method! :)

Using 3 copies of the users table means the query is...
Forum: Tables Today, 04:34 AM
Replies: 20
Views: 136
Posted By ridders
Re: How to join two tables with relationship

Try using an outer join from tblFacilityRegister to 3 copies of tblUsers linking one of the FK fields each time
Forum: General Yesterday, 03:03 PM
Replies: 5
Views: 117
Posted By ridders
Re: Color Coding in VBA

Now you know the theory, please see the attached for a simple colour converter utility

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=69421&stc=1&d=1516489413

Use the...
Forum: Modules & VBA Yesterday, 09:19 AM
Replies: 6
Views: 121
Posted By ridders
Re: Rogue Column in a csv file

Hi Dave
Yes I've had the same issue and for the same reasons
Imports that worked fine for months or even years failing due to Access interpreting data 'helpfully'
My solution is to use a two stage...
Forum: Code Repository Yesterday, 06:36 AM
Replies: 0
Views: 64
Posted By ridders
TIP: Add colour to queries, listboxes & comboboxes

NOTE:
This is similar to the ideas in a thread I posted recently at: https://www.access-programmers.co.uk/forums/showthread.php?t=297618

The idea in this post was explained by an Access newbie...
Forum: Code Repository Yesterday, 06:13 AM
Replies: 0
Views: 36
Posted By ridders
How to show rank order in queries

NOTE:
This is based on a thread I posted a few weeks ago at
https://www.access-programmers.co.uk/forums/showpost.php?p=1560423&postcount=1
I've copied it to the code repository so its easier to...
Forum: General 01-19-2018, 05:55 PM
Replies: 1
Views: 68
Posted By ridders
Re: how to put letter in the quick access bar

Click the small down arrow at the end of the Quick Access Toolbar then click More Commands.
In the Customise window change the list to All Commands and look to see what is available

If as I...
Forum: Queries 01-19-2018, 04:28 PM
Replies: 3
Views: 90
Posted By ridders
Re: Assigning Rank in a Query

I use a function called Serialize to do ranking
Please see this link for further details: TIP How to show rank order in a query...
Forum: General 01-19-2018, 12:34 PM
Replies: 6
Views: 90
Posted By ridders
Re: Unable to make ACCDE

Have you tried opening the database using the shift key bypass so that no forms are opened?
See if that allows the Save to ACCDE to work
Forum: Forms 01-19-2018, 12:14 PM
Replies: 7
Views: 257
Posted By ridders
Re: Link PDFs and other docs to database

You can use the Shell command to open any external program from Access.
You just need to know the file name and path.

Do a forum or google search. You will get lots of results
Forum: General 01-19-2018, 06:30 AM
Replies: 1
Views: 60
Posted By ridders
Re: custom ribbons in access 2016 not displaying

Hello and welcome to AWF

Creating ribbons isn't easy even for experienced Access users unless you do it regularly.

Suggest you download a ribbon creator utility such as that Gunter Avenius
Its...
Showing results 1 to 25 of 500

 
Forum Jump



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