Search results

Click Tools > References from any module in design mode and check for any "MISSING:" references. These should be resolved - either remove the check mark or browse to find the library - then re-compile. Hope this helps,

Here are some third-party tools that may help make your command buttons a bit more interesting: A shareware version of Button Painter for MS Access is available at this web site: http://www.peterssoftware.com/bp.htm Some simple colored button examples that can be copied into your application...

Select case xg_GetScreenResolution() Case "800x600" MoveSize the form to location xy Case "1024x768" MoveSize the form to location xy Case Else End Select Hope this helps,

This error can occur when there is a misspelled name of a function or macro in your OnClick property (not OnClick event procedure - there's a difference). Check the OnClick PROPERTY to see if something invalid is there. Hope this helps,

Here's some code that might help: http://www.peterssoftware.com/c_scrres.htm Regards,

You'll probably need the Winzip command line support add-on: http://www.winzip.com/other.htm Using this add on, the ShellWait module from Dev Ashish's site (http://www.mvps.org/access/api/api0004.htm), and the FileCopy statement you can zip up files and move them to different storage media...

The BeforeUpdate event is a place to do data validation, and cancel the update event if the data fails validation. It's too late to change the value here because the update is "in process". Try using the OnLostFocus event instead. Hope this helps,

There should be "Link Child Fields", and "Link Master Fields" properties for your subform control. These should match up the key fields on your master and child forms. If the user is changing control values, and you want the appropriate subforms to appear/disappear, or requery, then use the...

Instead of a search form, have you considered using Access' filter by form feature? Hope this helps,

Try creating an .mde file. (Make sure to save your .mdb file!) Hope this helps,

Where did you put that code?

It's true. The report has to be in design mode in order to add a control to it. You could have an invisible control ("No data" label) that you make visible at some point. Don't know if this is what you are after. Hope this helps,

The example file downloaded from the site below should help you get the file from the Internet site to your local computer: Internet Data Transfer Library http://www.mvps.org/access/resources/downloads.htm Hope this helps,

Try this: DLookUp("[PriceAmount]","tblPrice","Market=" & [Market] " And [PriceDate]=#" & #01/01/2004# & "#") Hope this helps,

That's just the way that listboxes work. You might want to try using a datasheet subform or continuous form subform instead of a list box to get word wrapping to happen Hope this helps,

Try putting this code Me.cmdYourOtherButton.Visible = True in the command button OnClick event procedure. Substitute "cmdYourOtherButton" with the name of your other command button. If you're new at creating event procedures, please see Access help under "creating event procedures". Hope...

The Dir function doesn't return a True/False value. It returns an empty string, or the name of a file or folder. So try this: If Dir("C:\leads_folder\daily_declines\dailydone.txt") <> "" Then Kill ("C:\leads_folder\daily_declines\dailydone.txt") retval = shell("...

Are you getting an error message? What is it? Try putting msgbox statements around your DoCmd.OpenQuery. Do the msgbox's display when you click the command button? Hope this helps,

You may want to try sending the e-mail message by automating Outlook since an attachment can't be included with SendObject: http://support.microsoft.com/default.aspx?scid=kb;en-us;209948 Hope this helps,

Try this: WHERE ( ( ((IndustryCurrentEnvironment.UpdateDate)>Date()-30) OR (((IndustryOutlook.UpdateDate)>Date()-30)) OR (((IndustryPositives.UpdateDate)>Date()-30)) OR (((ParentCreditFundamentals.UpdateDate)>Date()-30)) ) AND ( ((IndustryCurrentEnvironment.AnalystName)="John Smith")...