Posts by chrisxs5

Trying to filter a report by using a form. I went step by step through the instructions via the help screens. So everything is OK until I test the work I did. I get a message that reads

The expression you entered has a funtion that ProgramNameHere cant find

After reviewing my work everything appears to be done correctly, except for my filter criteria. The instructions read

For example, in a Microsoft Access database (.mdb), for a form called Sales Dialog, you would use the following expression to refer to controls named Beginning Date and Ending Date in the query:
Between [Forms]![Sales Dialog]![Beginning Date] And [Forms]![Sales Dialog]![Ending Date]

I of course changed mine to fit my progam and tried

[forms]![birthday report by month]![Month]

The instructions are from date to date. I need a single value.
So did I enter the criteria wrong or something else?

Re: mmmm format not working

Thankyou, that turned on the lightbulb.
I was trying to format the wrong thing in the wrong place.

Re: Create report equally with Data and Subdata

Trust me thats OK. I enjoy the Thomas Edison approach to things. And I really appreciate the help.

Thought my formating was OK but its not. Values are from 1 to 12 set format to mmmm only problem is they all end up as January.

New question assiociated with http://www.ozgrid.com/forum/showthread.php?t=42432

Re: Unloading Custom Toolbars

No problem, someone told me the same exact thing to help me out.

Re: Formatting Chart to Fit Image Box

Setting it to strecth should take of it.

Re: Unloading Custom Toolbars

Try this http://www.ozgrid.com/VBA/custom-menus.htm
Do some searches on add-ins also it will much easier to load and unload the macros you just loaded on every ones computers.

Re: sort birthdate by month then day

That worked great. I already had a query that fit great in. Then I just redid my report and added in some long exp and it all works great. :thanx:

Re: Email from query list

Yes I tried import 'file from program' and tried tha access import I always get errors. Thats when I switched from import to xport.

We will be sending out weekly emails to a query list of email recipients. I would like to load outlook with the complete list of emails(in new message) or export them as contacts to outlook. Adding new as they became available or deleting those who do not want emails. Any ideas?

Re: Export emails from outlookfolder as one TXT file

You can try this

SaveFileAs Filename:="C:\name.txt"

but of course untested.

Trying to get my birthdate report to sort by month then date ignoring the year completely. I have tried alot of ways, how exactly should it be done.

Re: Dropdown list of worksheets

So here is what you can do. (Have never done it)

Write or pull the sheets name to a cell.
Save the names as a range.
Use dropdown set to the named range.

You could even use a validation dropdown.

Re: Converting state abbrev to time zone

Just a note, the function is case sensitive ie tx returns an error and TX returns C.

Re: saving to cd

Are the floppys failing or getting full?

If they are failing then replace them.
If they are getting full then maybe you could split the infromation up
ie. one for fiction, one for thriller, one for biography etc.

Re: Filtering Report or Union

Solved.

I actually found to different methods.
The one I will use is adding a where line to the sql

where emailaddress is not null and emailaddress <> ''

I was trying it with the is not null only and once I figured this out it was smooth sailing, thanks to Norie for pointing to the right road.

The second method is kind of neat
If you right click in the datasheet view in the union query and select
Filter by form it gives you drop down choices to filter by and creates
a new query using that filter. Kind of round-a-bout but it worked just the same.

Re: saving to cd

I am not sure I understand completely but it sounds like you are trying to "save" to a cd which you cannot do. You can save to your hard drive and then burn to cd. If I misunderstood let me know.

Re: Filtering Report or Union

I arrived at calling it union query because that is what some else called it. But pretty much exactly as you thought. I make a query and then select sql in the corner and placed the commands.
I have:

SELECT
contacts.lastname As LastName,
contacts.firstname As FirstName,
contacts.emailaddress As email
FROM contacts
union


SELECT
contacts.lastname As LastName,
contacts.firstname1 As FirstName,
contacts.emailaddress1 As email
FROM contacts


UNION SELECT
children.lastname As LastName,
children.firstname As FirstName,
children.emailaddress As email
FROM children;

Where should, Is Not Null, be placed? I have tried it every where.

Re: Showing an Access form via a button

OK so this is just a thought, Access will let you insert an Excel Spreadsheet (I have never tried this). It is listed on the more tools list on the toolbox. So then why not insert the spreadsheet with the room and then create buttons over the areas you need to access the forms. That way you are always in Access to start out with. Or maybe even create a picture type layout and use that the same way.

Like I said, just a thought, you can use or lose it.

So I have an email report from a union query.
It has

Firstname,Lastname,Email

Not all records have an email acount.
I would like to filter these out. Doesnt matter if they go via the Union or the report. The report would be more optimal because then I could reverse the effect later to see those who do not have an email. But it really doesnt matter how. Thanks in advance.