Search results for query: *

You are missing a few arguments in the Docmd command. In your code declare the sql above as strSQL. then say Docmd.runsql and the required arguments

Declare a Static Variable and add to its value

Depending on what email software you use and its configuration, you could write a procedure using the "send object" to email records selected. Check Access Help for "Send Object

A related question to this thread..... How do I remove the ability of users from holding down the SHIFT key when firing up a MDE version of a database. In other words I want to disable AllowByPass key Would appreciate any help.....

Four years ago I was bankrupt, broke and you guessed it, divorced. Four years later, I have quadrupled my income...every year, am extremely happy with where I am, work about 16 hours every day, have no stress, and love every minute of my days. My simple prescription...for every choice that I...

A text box will only display one record, unless of course you set the sub form to continous to display all records for that date. An alternative would be to write a VB function to display the names of the staff that are present on a particular date. The argument in the function would be the...

DoCmd.ApplyFilter , Me.AccessType = "PRP" Change to docmd.ApplyFilter,,"AccessType='PRP'" See if that works

I agree with Duane. It would be more efficient to create a table with the "ranges" and write a function. Nested IIf functions may be a problem for users to maintain. Also creating these values in a seperate table will allow users to modify/add/delete entries depending on the...

What do I need to know as this will be my first contract type of job? Make sure that output specifications are discussed with your client before you start devlopment. Develop user teams with individuals that will actually be using your end product. Make sure that their are specific milestones...

[Forms]![Frm_Center_Summary_Grant_Totals].[awardwordvariable]) Put the criteria section of the dlookup function above in quotes as you did with the domain or table name.

Depends on what information you are passing to the new/next form. If you could be a little more specific perhaps I could address...

Thank you, Neil....Will try and let you know

On the "On Open" event, try this actX.value=Now()

Thank you for the response. In the present stage of development I am using the switchboard manager. The switchboard manager does allow me to attach a function name to a command button, but not a procedure. Any suggestions....? Thanks

Is there any way we can set a procedure to a switchboard button? Would appreciate any help. Thanks

Thanks. If one of the linked databases contains only images, do you have any suggestions for reducing the size? Thanks

I have often been told that an ACCESS db will stop functioning at about 2.0gb. Is this true? Would appreciate any help with this

Paul, Thanks....discussion always helps. The 3,4 and 6 month rolling sum and averages can be computed by using the .MovePrevious after using the .MoveLast. The function computes an int3Sum, int4Sum, and int6Sum in a Do Loop and then calculates an average using .Recordcount. Thanks for the...

Totalfor3Months/NumberofRecordsin3Months. The table that I have set up appends records into fields that list the 1)Number of units sold 2)The month number 3)The year number The three or 4 month average is calculated by computing the most current last 3 months, or 4 months and dividing by 3...

Hi, I am looking for an easy way to write a function to calculate 3 month and 4 month rolling averages. Would appreciate any help Thanks