Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.66 seconds.
Search: Posts Made By: ridders
Forum: Forms Today, 12:28 AM
Replies: 16
Views: 169
Posted By ridders
Re: Pop up form when item double clicked in a ListBox

See my suggested code in post 4.

Good luck.
I have to go out for several hours but if you need more help hopefully someone else will step in.
Forum: Forms Today, 12:12 AM
Replies: 16
Views: 169
Posted By ridders
Re: Pop up form when item double clicked in a ListBox

Not quite sure what you are asking.

There are three main types of form layout
Single - one record shown at a time
Continuous - all records displayed with one record on each 'row'
Datasheet -...
Forum: Forms Yesterday, 11:46 PM
Replies: 16
Views: 169
Posted By ridders
Re: Pop up form when item double clicked in a ListBox

OK. First create the form to show the tool details you want to see. Do this as a 'single form' layout with one record (tool) visible at a time. If opened directly, you would be able to move from one...
Forum: Queries Yesterday, 10:58 AM
Replies: 2
Views: 58
Posted By ridders
Re: "Operation must use an updateable query" error

There are several reasons for this error which usually occurs when it's not clear to Access which records should be updated. Possible reasons include
1. The table(s) don't have a primary key field....
Forum: Modules & VBA Yesterday, 08:25 AM
Replies: 1
Views: 40
Posted By ridders
Re: MS Access ODBC Call Failed Error

Welcome to AWF

Set the control source for the form to qryDelegates.
Scrap the strsql line and assuming Sys_ID is a text field modify the following line to
DoCmd.OpenForm "frmDelegate", , ,...
Forum: General Yesterday, 06:07 AM
Replies: 17
Views: 287
Posted By ridders
Re: OCX file for Access cadalendar

Yes it works ok if you want to select a date close to today.

However lets say you want to pick 31 Dec 2008. You either need to scroll back month by month until you reach 2008 or use the current...
Forum: General Yesterday, 05:13 AM
Replies: 19
Views: 263
Posted By ridders
Re: Multi user run of a db application

LOL. OK clever clogs, come up with a third method for this scenario!!!! :D


Sent from my iPhone using Tapatalk
Forum: Tables Yesterday, 04:37 AM
Replies: 3
Views: 105
Posted By ridders
Re: Forgot Database encrypted password

Normally you would provide proof of purchase or similar
If you wrote it yourself, that won't apply so you would need to provide some evidence that would satisfy the company doing the job.
The...
Forum: Forms Yesterday, 04:33 AM
Replies: 16
Views: 169
Posted By ridders
Re: Pop up form when item double clicked in a ListBox

You need at least two columns in the listbox.
Unique ID field (hidden) and your Tool description field.

Add code to the listbox after update event or possibly the double click event.
If you...
Forum: Forms Yesterday, 03:42 AM
Replies: 16
Views: 169
Posted By ridders
Re: Pop up form when item double clicked in a ListBox

Surely you would do that by selecting an item from the listbox.
This could then open a form or make a subform visible filtered to details of the selected item
Forum: Tables Yesterday, 03:39 AM
Replies: 3
Views: 105
Posted By ridders
Re: Forgot Database encrypted password

There are ways of solving this. Easy for an MDB file but much harder for an ACCDB.
However, as we've no way of knowing whether you have the ownership rights to the file, nobody here will (I hope!)...
Forum: General Yesterday, 03:35 AM
Replies: 19
Views: 263
Posted By ridders
Re: Multi user run of a db application

There's always at least two ways of doing anything in Access :D
Forum: Queries Yesterday, 03:20 AM
Replies: 2
Views: 58
Posted By ridders
Re: Sort data in Access

Access tables have no inherent sort order.
Queries are used to sort the data into an desired order
Therefore it doesn't really matter how you import the data - unsorted or sorted.
Forum: General Yesterday, 02:48 AM
Replies: 19
Views: 263
Posted By ridders
Re: Multi user run of a db application

Yes its very easy to include as part of a shut down procedure:
a) Check the file size
b) If it exceeds a specified value e.g. 50 MB, instruct Access to run a backup & then compact on close....
Forum: Modules & VBA Yesterday, 02:35 AM
Replies: 24
Views: 314
Posted By ridders
Re: Changing a query Dynamically

Thanks Greg

I no longer sign Access files myself but hopefully Phillip Stiefel (sonic8) will see and possibly respond to this thread
Forum: Forms Yesterday, 02:32 AM
Replies: 17
Views: 204
Posted By ridders
Re: Conditional formatting by group

@arnelgp
If that's an answer to my comment, I knew how to alter it.
However, I didn't feel it was appropriate for me to post an alteration to your example
Forum: Theory and practice of database design Yesterday, 02:28 AM
Replies: 2
Views: 147
Posted By ridders
Re: Access File Security : MDB / MDE vs ACCDB / ACCDE

Agree totally.... though I had to look up the meaning of exfiltrate! :)
withdraw (troops or spies) surreptitiously, especially from a dangerous situation.

For info, I've updated the attached PDF...
Forum: General Yesterday, 02:13 AM
Replies: 19
Views: 263
Posted By ridders
Re: Multi user run of a db application

Yes you can. If its useful, I can look up the code later today. Let me know if so.
Forum: General 09-24-2018, 11:43 PM
Replies: 2
Views: 116
Posted By ridders
Re: Plz help with append data

Are you saying the autonumber field is also empty? Not sure how that's possible

Delete the empty rows using a suitable delete query and compact the database.

Now look at the design of your...
Forum: Modules & VBA 09-24-2018, 11:39 PM
Replies: 24
Views: 314
Posted By ridders
Re: Changing a query Dynamically

Galaxiom
It would indeed be helpful if you could report back exactly what protection adding a digital signature provides for the MDB/MDE format.

It is worth mentioning that, though otherwise more...
Forum: General 09-24-2018, 11:20 PM
Replies: 19
Views: 263
Posted By ridders
Angry Re: Multi user run of a db application

Both of the methods outlined by Pat are easy enough to implement.
Method 2 has the advantage of knowing that all users will always have a fresh copy of the FE.
However, unlike Pat, I always use...
Forum: General 09-24-2018, 10:08 PM
Replies: 17
Views: 287
Posted By ridders
Re: OCX file for Access cadalendar

Plenty. That's why so many people use alternatives.

Just a correction to an earlier comment. The old MS Common Controls mscomct2.ocx is not supplied with Win10 and does not work in Win10 64-bit. ...
Forum: General 09-24-2018, 01:36 PM
Replies: 17
Views: 287
Posted By ridders
Re: OCX file for Access cadalendar

Dick
It also fails for me running 32-bit Windows 10.
The ocx file is not installed with win 10 which is one reason I suggested using an alternative.
Forum: Queries 09-24-2018, 01:31 PM
Replies: 2
Views: 74
Posted By ridders
Re: Crosstab Query with Form Input?

This post was moderated. Posting to trigger email notifications
Forum: General 09-24-2018, 01:29 PM
Replies: 19
Views: 263
Posted By ridders
Re: Multi user run of a db application

My approach is to ensure all FE files are located in the same location on each user's workstation. The network team need to run a registry script to set the location as trusted on each user's...
Showing results 1 to 25 of 500

 
Forum Jump



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


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