Search results

> In an organization's Membership Database, I am having a problem with the queries that generate invoices. > The invoice type is generated by the following query field: InvoiceType: IIf([Members]![RenewalMonth]=Month(Now())+2,"FIRST NOTICE",IIf([Members]![RenewalMonth]=Month(Now())+1,"SECOND...

Thanks! That worked perfectly for what I needed. I guess I understood the Left/Right/Mid/Len functions but didn't realize you could combine them in that way. Thanks again!

Is it possible to capture all but the left two characters of a text field when the text strings are of differing lengths? Details. I am working with Product numbers for a company where Product numbers vary in length. When products become inactive, they remain in the database (out of...

Not too difficult to do this: Add the following field to the query: Month([Date]) where [Date] is your date field. Then, in the criteria line of that field add the following parameter: [Enter Month]. What this will do is prompt the user with "Enter Month" when they run the query, and will...

Sorry, should have been more explicit. Field: Year([InvoiceDate]) Parameter: IIf(Month(Now())=1, Year(Now())-2,Year(Now())-1 Field: Month([InvoiceDate]) Parameter: IIf Month<>1 I want to return every month except the current month; If the month IS January, I want to return all...

Need to capture the correct months of data for proper sales reporting. There are two scenarios: 1) It is January and we want to view the entire previous year's data (have year parameter working correctly already); or 2) It is not January and we only want to capture data for the previous month...

Just wanted to let you know that your code worked perfectly. Thanks Kevin

Thanks I'll give that a try.

I have a "New Member" form that is not bound to a table, but is the basis of an append query that adds records to a table (set up this way to enable various combo boxes which are filtered by queries). Is there a simple way, other than closing and reopening, to clear all fields on the form? Thanks

I'd love a copy of the code for this. Thanks! brucesilvers@geocities.com

Have you tried adding the action "SetWarnings" (Argument=Warnings On: No) to the beginning of the macro? That should turn off all warning messages. [This message has been edited by brucesilvers (edited 05-11-2001).]

sorry i didn't include email in earlier post. brucesilvers@geocities.com thanks!

Why not simply go to Options on the Tools menu and select Compact on Close from the General tab. This way, anytime any user exits the database, it gets compacted. This is great when you have multiple front ends - you don't have to keep track of their compacted states because you know they'll...

See reply in General section.

Here's a workaround I used once. If you like the background color of your form onscreen, but want only white for printed, do the following: Create a box, size it to cover the entire form and set it's background color to the color you want. Set it's "display when" property to Screen Only...

I seem to recall that in Access 97 the name of a particular switchboard would be displayed on that switchboard. Now, in Access 2000, it seems that the switchboard displays the database name on all switchboards in that database. How can I get each switchboard to display its name as you move...

I do that quite a bit, too. The way I've handled it is to first import the table manually through the New Table dialogue. Then, I set the field properties for the table (which is where you can set the Prime Key). Next,I create the queries I need to clean up the data and/or append the data to...

I had the same problem. Check out the Modules & VBA forum and look at the message titled "Skip function if table is empty." It would be quite simple to use it on the query that feeds your report rather than a table.

Is there a simple way to create a dialogue box that will display messages as a module runs? To be more specific: I have modules that perform data import and formatting functions which can be quite lengthy. I'd like to create a dialogue box that will display which action is currently running...

Could you give us a hint as to what that demo involves? Is there an easy way to do it without complicated code or creating a table to hold the weekday text values?