Search:

I have a cool database I created because I am the secretary of 7 stamp clubs in my area. Decided it would preferable to have one DB to handle the overlap.

Couple things I need to do is to write...

Does anyone have a good (easy) workaround for the absence of Application.FileSearch in Access 2007?? :confused:

In my Access procedure, I am going to have future input updates. The mainframe guys cannot understand that I want the same name month after month.

My idea is to setup a “File Open” event and...

Instead of stacking everything up, you might use “Tabbed Documents,” go to Office icon at top. At bottom of menu, choose Access Options | Current database and the radio button for Tabbed Docs.27623
...

My favorites are anything by John Walkenbach such as “Excel 2010 Power Programming With VBA.” His Dummy book is good too. Also look at “VBA and Macros: Microsoft Excel 2010” by Bill Jelen.

Perhaps the best advice is to record a macro in Excel; then take it apart and analyse it. There will be lots of extraneous instructions and you cannot record a loop.

There are excellent books on...

Check your SQL WHERE clause:
WHERE (([OpenDate]<Now()-90) AND ([CloseDate IsNull]))

I have been using a recordset to define a chunk of data I want to work with. We have decided that a temp table would be better so we could query against the smaller piece.

I have forgotten the...

I am such a dummy. :wacko: Went back and looked again; since it returned so few records, I thought it was wrong. Doing exactly what it should do.

I am trying to write a SubQuery to find the records that are not in a range. It is bringing me the records that match, not the rest. Seems like the NOT function isn't working.

SELECT...

I re-installed MZ Tools. Had it before I rebuilt my PC.

I haven't used wizards in years. I sometimes go into a system that someone else has built and see the evidence all over the place. Looks...

I think I need to dig deeper. I hate macros. VBA is the way to go.

I finally found it. Go to Access Options | Object Designers and scroll to Forms Control and choose “Aways Use Event Procedures”

[attachment=89998:event_procs.jpg]

I think I could do this in previous versions.

When I add a control; say a button to a form, I want the code to default to VBA and not a macro. When I tell Access to convert macros to VBA, it...

My predessors at this company used a lot of Access macros. I need to change one but I have been exclusively VBA for years.

Is there an equivalent for DoCmd.SetWarnings False in Macro Lanaguage?...

Using Access 2007. The XXX was representing an instruction I could not find.

Been a while since I used OpenArgs.

==========
On one kind of report, I need to set one label to background shade;...

Sometime in the past, this database was written with 10 similar reports; each highlighting one label by shading. The only other difference is the Titles. Changing the titles in the Open event of the...

I have a form that was formerly using bound fields but the client wanted a SAVE button. I converted to unbound fields and the save works.

When they come back to the field and choose an Employee, I...

I wrote a function in Access 2007 that pulls the values from a swarm of queries and displays in my report. This part is working OK except when the Institution Account Number is not found in the...

Word version may be relevant here. If those are the checkboxes inserted using the Forms toolbar (legacy controls), they probably have default names, like "Check1". If they are new Word 2007 controls,...

I have been programming Excel and Access for years but got blind sided with a Word project this morning.

Somebody has already built a 30 page questionnaire in Word but the Checkboxes don't have...

That solved it. When the email popped up, my manager's email address was spelled wrong (she typed it).

Outlook does not recognize one or more names

This code was working yesterday. Do I need to close the Excel file before the attach will work in Access?

What is the syntax for closing Excel? I am using

appExcel.Close...

Thanks Hans --- you saved the day AGAIN

http://windowssecrets.com/forums/images/smilies/thewave.gif