Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.21 seconds.
Search: Posts Made By: isladogs
Forum: Modules & VBA Today, 01:52 PM
Replies: 19
Views: 227
Posted By isladogs
Re: Need help with bitmasking permissions

Perhaps I just didn't read it properly.
However I did understand that what you originally needed was a very big number - hence my suggestion. ;)
Forum: Modules & VBA Today, 01:44 PM
Replies: 11
Views: 130
Posted By isladogs
Re: Writing SQL to open a recordset, then it VBA gets confused...

You have 3 instances of ConcatRelated though the first one (contrs) doesn't appear to be used anywhere.
Which one is failing?
Forum: Forms Today, 12:19 PM
Replies: 14
Views: 144
Posted By isladogs
Re: How to view record from another table in unbound text box in a form

Saledo
Please read my comments in post #3.
There shouldn't be a lookup at table level. Nor a DLookup expression.
Just use a bound combo as I suggested
Forum: Forms Today, 11:44 AM
Replies: 14
Views: 144
Posted By isladogs
Re: How to view record from another table in unbound text box in a form

Which table contains the Gender field for each student?
Forum: Forms Today, 10:25 AM
Replies: 4
Views: 68
Posted By isladogs
Re: Can you call the same query with different parameters for the same report?

You could look at the Student Target Grade Explorer (https://www.access-programmers.co.uk/forums/showthread.php?t=302189) example app if you didn't fully understand either of the last two replies
Forum: Modules & VBA Today, 10:22 AM
Replies: 11
Views: 156
Posted By isladogs
Re: Need help with error: The expression you entered has...

They may have been the same originally but in this case, the copy has got corrupted since. Replace with the original working version or one form another PC ... or decompile as I suggested which may...
Forum: Forms Today, 10:05 AM
Replies: 4
Views: 68
Posted By isladogs
Re: Can you call the same query with different parameters for the same report?

Yes .... but on different occasions ;)
Just filter the report by the required fields and criteria each time
Forum: Forms Today, 10:02 AM
Replies: 14
Views: 144
Posted By isladogs
Re: How to view record from another table in unbound text box in a form

There is no need to use DLookup

Change it to a bound combobox with the combo control source = Gender field in the Reg table and the row source set to the values in the Gender table (or a value...
Forum: Macros Today, 09:23 AM
Replies: 7
Views: 107
Posted By isladogs
Re: How to hyperlink to other subforms on a tab control?

See this link Randomising data for posted databases (https://www.access-programmers.co.uk/forums/showthread.php?t=306745)
Forum: Queries Today, 09:21 AM
Replies: 16
Views: 178
Posted By isladogs
Re: How to make it blank?

No problem.
However you will see that the Doc and myself are giving you slightly different advice.
To my mind, it doesn't matter whether you have existing nulls or not.
You just want all zeroes...
Forum: Modules & VBA Today, 09:14 AM
Replies: 11
Views: 156
Posted By isladogs
Re: Need help with error: The expression you entered has...

Just to add to the comments about corruption. The message indicates corruption in your vba project.

Corruption can take 3 forms
1. Corrupted code in the FE. As each user has their own copy of the...
Forum: Queries Today, 07:26 AM
Replies: 16
Views: 178
Posted By isladogs
Re: How to make it blank?

Previously you wrote:


So all of us answered thinking you wanted nulls to appear as 0
With hindsight your title made it clear!

Now you've written:


So all our advice was misleading!...
Forum: Modules & VBA Today, 07:15 AM
Replies: 22
Views: 309
Posted By isladogs
Re: Login and User Access

Yes.
If you get stuck copy the original table tblUsers into your modified version then edit it as appropriate
The idea is that nobody needs to know the actual password except the person entering...
Forum: Queries Today, 07:12 AM
Replies: 4
Views: 94
Posted By isladogs
Re: select statement moving rows to columns

Indeed a mess but fixable in Excel (see attached)
This is what I did on a copy of your file - try it yourself and hopefully you'll get the same result as me

1. Select whole sheet and Unmerged...
Forum: General Today, 05:36 AM
Replies: 11
Views: 278
Posted By isladogs
Re: A trip down memory lane

Well the thread is 10 months old. :D

At the time I reinstalled it for a reason.
Someone wanted an Access 1.0 file updated to a new ACCDB version for A2013. I was able to successfully convert it...
Forum: Modules & VBA Today, 05:28 AM
Replies: 22
Views: 309
Posted By isladogs
Re: Login and User Access

Yes you have if you have just typed those passwords in tblUsers.
Remember that the passwords are meant to be stored in an encrypted form.
Look back at the screenshots in the original link.
You...
Forum: Introduce Yourself Today, 02:44 AM
Replies: 13
Views: 94
Posted By isladogs
Re: Hello from Fallon, Nevada, USA

Hi Tanya
Thanks for the detailed resume about yourself and where you live.
Also thanks for being a supporter.

Until this spring, I also used to live in Churchill but in my case its on the edge...
Forum: Forms Today, 01:36 AM
Replies: 7
Views: 75
Posted By isladogs
Re: Update code

I would have advised fixing the original issue and continuing to use a datetime field for dates
Forum: Forms Today, 01:27 AM
Replies: 7
Views: 75
Posted By isladogs
Re: Update code

You keep posting new threads with the same code despite changes agreed/implemented earlier.

For example, back in an earlier thread,...
Forum: Reports Today, 01:20 AM
Replies: 7
Views: 97
Posted By isladogs
Re: Listbox in a Report

Well it looks like a form...and it would definitely be better as a form where you would have additional functionality. You could convert it back...

My advice would be to use the appropriate object...
Forum: General Today, 01:01 AM
Replies: 10
Views: 238
Posted By isladogs
Re: bang versus dot

Me.too … or should that be Me!too :rolleyes:
Forum: Excel Yesterday, 03:23 PM
Replies: 14
Views: 167
Posted By isladogs
Re: Userform with search box

I've added code tags to make your code readable. That will help others help you!
In future please click the # button on the toolbar to do this yourself. Thanks
Forum: Modules & VBA Yesterday, 03:20 PM
Replies: 26
Views: 398
Posted By isladogs
Re: Event Buttons Not Working All of a Sudden

If the shift key is enabled, holding it down will bypass all startup code
If its disabled, holding down the Shift key will have no effect.
Forum: Modules & VBA Yesterday, 03:16 PM
Replies: 19
Views: 227
Posted By isladogs
Re: Need help with bitmasking permissions

Tera
Just to observe that using the approach suggested by the Doc, you can easily identify groups of controls to enable/disable, show/hide, lock/unlock depending on user roles.
These can easily be...
Forum: Excel Yesterday, 02:58 PM
Replies: 14
Views: 167
Posted By isladogs
Re: Userform with search box

For info, you could just have zipped the original xlsm file
Showing results 1 to 25 of 500

 
Forum Jump



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