Search results

I'm curious as to where the best place to run your daily procedures, whether it be the front-end or back-end or separate 'Control' database, is. We have several databases deployed in several departments that track all manner of things. Each of these databases update differently and using...

I've got a function (shown below) that is called on startup through an Autoexec macro. Occasionally it opens the code window, highlights the "set rs =..." line and pauses. It doesn't show an error or indicate a problem, it just pauses. I can hit the resume button (the play button) and it'll...

I've got a function that iterates through each control on the form and looks for any required fields that aren't filled in. The function worked great initially by doing the check in the module and the control iteration in the form. However, this results in the recordset (table) being opened...

This is searching through a table of ~10,000 records to find whether the user-entered project# already exists, and populate the form if it does. I don't want to use a bound form here, with that in mind is this the most efficient way of searching through the ProjID field? thanks! Private Sub...

I was just curious as to what everyone's rule was for when to create a new module/function versus entering the full code in the event sub.

I'm developing an idea I've got for a self-serve query system that my users can take advantage of. The goal is to eliminate some of the ad-hoc requests that I get and enable them to experiment with different datasets to find patterns, correlations, etc. This is all based in a form and...

Here's the SQL for the query. When I include the IIF statement into the WHERE clause, it doesn't return any records (even though it should). I'm guessing it has something to do with how the statement is organized, but I'm not sure. SELECT Tbl_RMS_Current_Day.[ACCOUNT NUMBER]...

I'm trying to use this if-statement in a query: =IIf([Forms]![frmReportCollateral]![cbAge]="60-119",>59<120,"") It doesn't work, though. I can do >59<120 in the criteria box and it will work, but if i put it in this if statement format then it doesn't return any records. Anyone have a hint...

So here's my dilema... As you can see, the crosstab SQL statement that feeds this query doesn't let me sort the date column headers with anything aside from ascending/descending. This causes problems highlighted in yellow where in 2011, Aug is before the other months. Is there a way around...

I've got a chart based on a query which shows dates from: Short Date Dec 2009 Jun 2010 Dec 2010 Mar 2011 Jun 2011 Jul 2011 Aug 2011 When I try to run a chart off this data, it fills in the gaps between each of the dates (shows Dec 2009, Jan 2010, Feb 2010...). How can I get it to only...

First I'll preface this with I have no idea if this is even possible. I have a personal database that I use to categorize and calculate totals on my bank transactions. As it stands now, I login to the online banking, export a .CSV with the transactions, import it to the database, run the...

I've got a large amount of reports that I generate on a monthly basis. As it currently stands, it is clunky, large, and takes a while to process. It's actually about 90 reports, each Report makes a page in the actual report I present to management. It's a portfolio report that shows asset...

Hey all, looking to run a SAS project from within Access 2003 via VBA. If somone could point me in the right direction i'd appreciate it!

What I'm trying to think out is a way to take a list of bank card transactions and categorizing them from the transaction description provided by the bank. The way I envision this working would be to have a table to hold a list of description keywords. These keywords (such as "McDonalds")...

This is the code i'm using, error line highlighted: Option Compare Database Public Function VerifyAcct(AcctNum As String) Dim dbDatabase As Database Dim rsAcctNumber As Recordset Set dbDatabase = CurrentDb Set rsAcctNumber = dbDatabase.OpenRecordset("CAM_Portfolio_Query", dbOpenTable) With...

I seem to remember a method of telling Access to continue accepting/running commands while an import or some other activity is going on in the background. Unfortunately, I dont have the database I used it in anymore and cannot remember the code. Anyone know what I'm talking about and know the...

HK1 kind of beat me to the punch of uploading something similar, but this is something i've been working on for a week or so now when I have free time at work. In a nutshell, I was developing a solution to having user-level security without using the one integrated within Access. After some...

I've got a control variable that points to different form labels depending on several factors. I use this variable earlier in the code to change the caption of the label with no problems whatsoever. However when i use this same variable to try to change the .OnClick property, I get an error...

Is it possiable to have a replaceable paramater in a "me" command. I'm using a loop and am trying to find a way to do Me.variable to change a series of labels on a form. Is this possible? If so, what would be the proper syntax? Thanks! Guy

Syntax with quotations / DLookup I've been attempting to use DLookup in a function i'm writing and had many problems getting it to work properly. My first attempt after reading the MS help file was: ?Dlookup("[UserName]","tbl_AuthUserList","[UserID] = strUserID") Which didnt work... So i...