Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 67
Search took 0.02 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,220
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: 797
Posted By vbaInet
Re: Rollback - SQL

Probably a start:

DECLARE

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

BEGIN

INSERT INTO tbl_Nitin
Forum: Modules & VBA 08-01-2014, 06:34 AM
Replies: 10
Views: 890
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: 890
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,497
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,497
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,497
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: 713
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: 10,980
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,311
Posted By namliam
Re: VBA What is the Univerisal Short File Path to Documents Folder?

LMGTFY

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,279
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,280
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

Paul

I forgot one of the most important rules of teaching

" nothing is obvious to one who does not know"

I apologise.

Brian
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,131
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,756
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,756
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
FROM
tbl_Clients INNER JOIN...
Showing results 1 to 25 of 67

 
Forum Jump



All times are GMT -8. The time now is 12:09 AM.


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