Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 67
Search took 0.03 seconds.
Search: Posts Made By: pr2-eugin
Forum: Queries 06-17-2015, 08:16 AM
Replies: 5
Views: 723
Posted By spikepl
Re: Elimiate records with dates in the same month

WHERE Not (Month(Start)=Month(End) AND Year(start)=Year(End)) ?
Forum: Modules & VBA 03-24-2015, 07:08 AM
Replies: 5
Views: 1,221
Posted By plog
Re: Get Previous Installment Date

I think I have it, but the Harry one is throwing me--I think you just mistyped it. For Harry, the term is Quarterly, the first payment is 22/2/2015, wouldn't that make the next payment 22/5/2015? And...
Forum: The Watercooler 11-20-2014, 06:43 AM
Replies: 26
Views: 1,153
Posted By namliam
Re: Accounts/Maths Problem - How will you solve this?

How about sharing the pain?

Going halfsies on the difference, i.e. not 18 but 24 days for the leaving people
Forum: The Watercooler 08-07-2014, 02:10 PM
Replies: 21
Views: 798
Posted By vbaInet
Re: Rollback - SQL

Probably a start:


paul VARCHAR2(4) = "idiot"
nitin VARCHAR2(5) = "innocent";


Forum: Modules & VBA 08-01-2014, 06:34 AM
Replies: 10
Views: 891
Posted By vbaInet
Re: Form uneditable except for one control

I'll make one up. Something like this:

dim dctCtl as dictionary
dim ctl as access.control

set dctCtl = new dictionary

' to add to dictionary
for each ctl in me.detail.controls
if ......
Forum: Modules & VBA 08-01-2014, 04:32 AM
Replies: 10
Views: 891
Posted By vbaInet
Re: Form uneditable except for one control

You're not missing anything Paul. AllowEdits will block all controls, so you would have to cycle through each control within the Details.

Or you could use Conditional Formatting.
Forum: Modules & VBA 07-15-2014, 01:30 AM
Replies: 13
Views: 4,647
Posted By JHB
Re: Runtime Error 3000

Do you have some pointers which indicate when a record gets add to the database, (if yes I would delete the "newest" one), or did you get all 37000 records into the database yesterday?
Do you make...
Forum: Modules & VBA 07-14-2014, 09:07 AM
Replies: 13
Views: 4,647
Posted By vbaInet
Re: Runtime Error 3000

It might be to do with your innRev or annRev fields. You might need one the CV functions for this. Take both of them out and re-run the query.

I would have actually expected this sort of error on...
Forum: Modules & VBA 07-14-2014, 09:04 AM
Replies: 13
Views: 4,647
Posted By BlueIshDan
Re: Runtime Error 3000

ehow.com (http://www.ehow.com/info_12217838_runtime-error-3000.html)

Check your latests records for anything that looks like mumbo-jumbo(a corrupt record).
Forum: General 07-10-2014, 02:22 AM
Replies: 4
Views: 716
Posted By CJ_London
Re: Attachment Fields

Sounds like you need a greater control over the naming conventions the users use and their access to the shared folder.

Why not have a table which defines the file name uniquely using a naming...
Forum: Code Repository 06-10-2014, 07:02 AM
Replies: 17
Views: 11,371
Posted By Frothingslosh
Progress Meters (Including Dual-Bar)

One of the most commonly asked questions I’ve seen on this and other MS Access sites has got to be ‘How do I show a progress bar?’ While Access has a built-in meter bar, upon which I will elaborate...
Forum: Modules & VBA 06-03-2014, 05:56 AM
Replies: 1
Views: 1,115
Posted By Frothingslosh
Re: Need Code to Automate ImportExportSpreadsheets

Crossposted HERE (http://www.accessforums.net/programming/need-code-automate-importexportspreadsheets-44278.html).

Please don't cross-post without providing links to your cross-posts. We answer...
Forum: Modules & VBA 05-28-2014, 12:25 AM
Replies: 9
Views: 1,324
Posted By namliam
Re: VBA What is the Univerisal Short File Path to Documents Folder?


One of the first links I found:

Function GetSpecialFolderNames()
Dim objFolders As Object
Set objFolders = CreateObject("WScript.Shell").SpecialFolders

MsgBox objFolders("desktop")...
Forum: Queries 05-22-2014, 04:09 AM
Replies: 15
Views: 1,280
Posted By namliam
Re: Only if Today=Friday

Shouldnt the "," in the weekday function be a ";" ??
Also the 1 means the week starts at SUNDAY not monday, if you are looking for a friday, then you should be doing = 6 not = 5 ( or change the 1 to...
Forum: Queries 04-23-2014, 02:51 AM
Replies: 11
Views: 2,318
Posted By MarkK
To round any number A to the nearest X ...

To round any number A to the nearest X

divide A by X
round the result of 1. to the nearest one - and here, to round down, you use the Int() function, which just drops the decimal. Other useful...
Forum: Modules & VBA 02-14-2014, 07:22 AM
Replies: 15
Views: 1,085
Posted By Frothingslosh
Wink Re: How to validate three condition, before providing Error Msg

This is how your code should be presented here:

Public Function TempFunction()

'''Non Budgeted Projects need and Variance class
If Me.ID.Value >= 90000 And (IsNull(Me.Variance_Class)...
Forum: Excel 01-07-2014, 09:51 PM
Replies: 7
Views: 850
Posted By MarkK
A UserForm is a Class module provided by VBA. In...

A UserForm is a Class module provided by VBA. In the VBA IDE in Excel, if you right click on the Project Explorer window and hover your mouse over Insert, you can add a UserForm to your Excel VBA...
Forum: General 11-12-2013, 02:27 PM
Replies: 18
Views: 1,772
Posted By Brianwarnock
Re: Iif statement to add value in next column


I forgot one of the most important rules of teaching

" nothing is obvious to one who does not know"

I apologise.

Forum: Forms 06-19-2013, 07:47 AM
Replies: 9
Views: 910
Posted By SOS
Re: sorting missing null values

Yeah, I usually just create a sort field like that in the query itself. To do so in the QBE grid it would be something like this:

MySort:IIf([FieldNameHere] Is Null, 1, 0)

And then set to...
Forum: Modules & VBA 06-13-2013, 02:05 AM
Replies: 15
Views: 1,373
Posted By Galaxiom
Re: Creating and Initialising Custom Class/Object

Either Public or Global work. Public is preferred by Microsoft but who are they to tell us what to do?;)

Some developers like to use Global in Standard Modules and Public in Classes because that...
Forum: Code Repository 06-05-2013, 08:39 AM
Replies: 2
Views: 14,292
Posted By Rx_
VBA Import Excel to Access Table with VBA

PNG - create a table with this design (NOTE: NO Primary Key)
.XLS NOTICE - change the extension to .XLSX (this site won't allow .xlsx extensions to be uploaded - so change it back to avoid an...
Forum: Modules & VBA 06-04-2013, 04:23 AM
Replies: 9
Views: 968
Posted By stopher
Re: Replace characters in one column at once?

How about:

Public Function clean(strInput As String) As String

Dim rgx As New RegExp

rgx.Pattern = "[\.\""\&&\,\-\<\>\*\?\/\\\:\;\_\'\(\)]"
rgx.Global = True
clean = rgx.Replace(strInput,...
Forum: Modules & VBA 05-31-2013, 03:18 AM
Replies: 8
Views: 748
Posted By stopher
Re: turning a variable into Text for an email

The line DIM arrSummaryData() As SUMMARY_DATA suggest it is an array of objects of the class SUMMARY_DATA. So the .strPromoterName is most likely a method or public variable of the class.

The code...
Forum: Queries 04-04-2013, 11:44 AM
Replies: 15
Views: 1,757
Posted By Brianwarnock
Re: Query to get only one record per Client.

I never use sub queries when a simple cascade will do, what you are asking for is actually very simple and standard practice.

First query finds max in group, second joins this info back to table...
Forum: Queries 04-04-2013, 06:13 AM
Replies: 15
Views: 1,757
Posted By jdraw
Re: Query to get only one record per Client.

Here's another
SELECT tbl_Clients.cliID
, tbl_Clients.firstName
, tbl_Clients.address
, tbl_PolicyDetails.policyCover
, tbl_PolicyDetails.policyStatus
tbl_Clients INNER JOIN...
Showing results 1 to 25 of 67

Forum Jump

All times are GMT -8. The time now is 03:34 PM.

Microsoft Access Help
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