Go Back   Access World Forums > Search Forums

 
Showing results 1 to 14 of 14
Search took 0.02 seconds.
Search: Posts Made By: Solo712
Forum: General 06-08-2019, 10:48 AM
Replies: 4
Views: 4,342
Posted By isladogs
Re: Disable the Ribbon & Office Button 2007

You can instead run the code in the load event of your start up form.
You may need to remove the application window to get rid of the Office button in 2007.
Have a look at my example database...
Forum: General 11-27-2017, 10:56 PM
Replies: 3
Views: 1,150
Posted By arnelgp
Forum: Modules & VBA 11-09-2017, 08:27 AM
Replies: 18
Views: 1,067
Posted By Gasman
Re: Statistics about the code

Why the discrepancy in tables Colin?
Yours has two less tables, but more fields and records?
Forum: Modules & VBA 11-09-2017, 07:43 AM
Replies: 18
Views: 1,067
Posted By isladogs
Re: Statistics about the code

Thanks for doing that
Just realised your code doesn't count queries - easy enough to add them ...

I tried my monster database again using your code & left it running
Almost 18 minutes later, I...
Forum: Modules & VBA 11-09-2017, 01:42 AM
Replies: 18
Views: 1,067
Posted By George Moore
Re: Statistics about the code

Hi

This will give tell you anything you ever wanted to know about your VBA project

In addition to modules, this will count code hidden behind forms and reports.

You will need to close/open...
Forum: Modules & VBA 12-22-2015, 09:58 AM
Replies: 10
Views: 650
Posted By sneuberg
Re: Navigate to record from index violation

Thanks for catching this; however, the criteria Me.NewRecord =False and DCount > 1 doesn't work. DCount can never be greater than 1. The unique index the OP has on the fields won't allow it. I...
Forum: Modules & VBA 05-19-2015, 10:31 AM
Replies: 4
Views: 825
Posted By BlueIshDan
Re: Searching Subfolders To Open Files Using File Names

I don't know how much this can help but you can try this function I wrote, and maybe the link on this post may help you even further.

Follow this link....
Forum: Forms 03-21-2015, 12:02 AM
Replies: 22
Views: 1,424
Posted By MarkK
What you can do if you make your own nav bar, is...

What you can do if you make your own nav bar, is navigate to the the end of the recordsetclone to get your recordcount. This saves you navigating in the actual recordset, which your user will see...
Forum: Forms 03-20-2015, 02:37 PM
Replies: 22
Views: 1,424
Posted By spikepl
Re: Navigation Issue with RecordsetCount

This is a known feature that .RecordCount>0 is not indicative of teh actual count until you do .MoveLast so as to make sure the entire recordset is loaded. RecordCount=0 tells you there are no...
Forum: Tables 02-19-2013, 02:26 PM
Replies: 10
Views: 1,381
Posted By Galaxiom
Re: Autonumber error

I don't see any advantage with that routine over simply using a DLookup.

BTW The loop to find the named field is clumsy and quite unnecessary as it could be achieved with:

rst.Fields(fField)
Forum: Modules & VBA 12-21-2012, 04:37 PM
Replies: 8
Views: 6,954
Posted By John Big Booty
Re: Converting numbers into Roman numerals

Check out this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=22934).
Forum: Forms 12-08-2012, 06:33 AM
Replies: 12
Views: 2,922
Posted By nanscombe
Re: Formatted strings in a Listbox

It may be because you are using the listbox as a "Value list". Since each column is separated by a comma it is probably using the commas in the currency as a column breaks.

Budget for 2012 : 680...
Forum: Forms 11-26-2012, 12:45 PM
Replies: 2
Views: 2,890
Posted By Mr. B
Re: Single-select Listbox drives me nuts

When the multi-select property of a listbox is set to "None" you do not have to iterate through the list to obtain the selected value. The selected value is simply the value in the listbox.

You...
Forum: Reports 05-12-2001, 07:10 PM
Replies: 3
Views: 3,414
Posted By RedSkies
You question got me curious so I was checking out...

You question got me curious so I was checking out a couple other bulletin boards.

This code was posted on Tek-Tips by RHicks whom I've seen post on this forum numerous times as well (and he's...
Showing results 1 to 14 of 14

 
Forum Jump



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