Search results

certs In the On Click event of your command button : Check to see if the files exists and if not then exit the subroutine If dir("F:\folderofinterest")="" then msgbox("There are no certs to print.") exit sub end if If it exists then print the report Put that before your Printfile statement

combo box http://www.candace-tripp.com/pages/access_downloads.aspx Go to this link and scroll down until you see the On Notinlist example. I use this code all the time. Works great. I hope this is what you wanted,

macros In the macro use the setwarnings to off. Also, make sure your Save in the macro is set to Yes. Hope this helps

slider control? Thanks to Rural Guy for the link to progress bars. Has anyone seen something similar for slider control (non-activex) ? Or a slider control on a continuous form? Thanks in advance for any replies.

Joins Your joins in your query qryworkorderreport are incorrect. All your joins are set to "Only include rows where the joined field from both tables are equal". You need to set some of your joins to "Include all records from "Workordertable" etc...... In other words if you don't have a...

Access projects If you have not already done so you may find the mdb's that come with MS Access helpful such as the Order Entry and Inventory Projects.

nyet............

report In the query criteria that your report uses as it's recordsource set the roomid, dateid,timeid (or whatever you call the three fields) to roomid:forms![myentryform].[roomid] and then the same pattern for dateid and timeid. Behind the onclick event of you command button on your...

dups If this table had a primary key say called bookedid set as autonumber and the other 3 fields also set as primary keys can someone confirm that this would still work? Without the autonumber field set as primary key it works.

deja vu all over again a result of a double post?

Query Yes there is, atleast in access 2003 (don't remember about 2000). In design view click on the query of interset to highlight it. At the menu on top go to View, Object Dependencies and a form will pop up to the right. You have an option of two choices...Objects that depend on me or...

Dups You could use a compound dlookup statement where the variable "response" is set equal to the result of the lookup. If the repsonse value is greater than 1 (assuming the update has occurred on your form) then it is a dup and then do an undo.

percentrank To my knowledge PercentRank (or anything similar) does not exist in Ms Access. This link may help? http://p2p.wrox.com/topic.asp?TOPIC_ID=41465

typo? Did you include the and * in the like statement for the date as well?

folders You will need to replace those / as you indicated. If your form uses a query create an expression like Expr1:replace([clientname],"/","-") this will get rid of the / and replace with - or whatever you want to use. That expr1 should be placed on your form and will be used to see if the...

contradiction Aren't you contradicting yourself? You are saying that required is set to No which means a null value is allowed and then you are indicating that the field on the form can not be null?

filters You can use several parameter filters in a single query. The if isnull statements are not necessary. Create text boxes on your form that the user can pick for filtering the data. So on your form you would put a field for date and place that value in the criteria of your query for that...

split I would definitely split that database and give the users their own frontend that contains the Activex calendar and reference. Allowing multiple users in the environment you describe will undoubtedly lead to issues down the road unfortunately.

report Don't know if this will help you but... http://www.thescripts.com/forum/thread208925.html

Calendar Open a form in design view. Click on Insert in your menu. Choose ActiveX Control and then choose Calendar Control. You can use that for your GUI. I'm sure there have been several examples of this in the forum so try searching on calendar control Good luck....