Search results

the first thing to check is the "On Click" event of the button's properties... see if there's actually anything there If the button was renamed or something else changed, that may cause this type of problem...

that's an excellent tip... I have one additional question about this, however. Do the 2/3rd columns in question have to be displayed on the listbox in order for the reference to function, or can they be "hidden" from the user...?

If you want the field to not return #Error, then all you can really do is plan for and address that error... i.e. missing information or invalid parameters, etc.

no problem, I'm glad you like it... I had a couple of folks ask for an Access 97 version, so here it is... Name Search - Access 97 (sorry about editing such an old message... same problem, updating the urls for my new webspace)

On the AfterUpdate property of the combobox, use the DLookUp command to pull the start and end dates from the table and write them into the two other fields. This would still be done through code, but it would look at the table's data as you eluded to: Forms![FormName]![FYBeginDate].Value =...

I've done several of these before where I have multiple conditions, but I've never gone above 3-4 I THINK. Maybe post the statement, & we can take a look at it... Usually when I do this, I'm checking <0 =0 >0 Here's a sample of one I have in the stuff I'm working on right now...

Sure thing... I'm going to post it here, let me know if you have any problems downloading it or running (it's Access 2000-based)... it's just a quick sample of the name function I mentioned without a bunch of extra stuff... so it's extremely small & easy to download... Name Search - sample...

Excellent point, Jack... I tackled this issue just a few months ago on a project... I was originally requested to add some kind of "autofill" to detect duplicate names for registration forms. This as THEY described it was next to impossible, so I did the following: On the data entry form...

I'm completely stumped on this, any help would be greatly appreciated. I don't currently use switchboards, I prefer menu-driven commands, as I can keep them consistent throughout my database, etc. I would like to be able to run VBA from a menu item instead of creating a macro for each custom...

Hi all, I was wondering if there is way to built an event based on whether or not a specific button/text control has the focus on that form. I wanted to add the ActiveX calendar to a series of forms... but as my space is limited, I created a single pop up form with the calendar control that...

The Solutions.mdb database has an example of this... <A HREF="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp" TARGET=_blank>Microsoft Access 2000: Building Applications with Forms and Reports </A>

For starters, I would temporarily eliminate the query criteria and simply build the query itself to pull the information you need correctly. This way you know the query itself starts out solid. Once the query is giving you the results you need, then start looking at the criteria portion. The...

base you parameter limits on a form instead of a parameter inquiry, then you can fill out all of the fields on the form and run the query... the limit would be =Forms![formname]![controlname]

If this is a person's height, the following should be a pretty safe bet (if not, : 0\'00\";;_ ...good luck

Is your table recognizing the yymmdd field as a date already? If so, you should just be able to write the query expression NewDate: Format([Birthday], "Long Date") If the Birthday field is saved currently as text or another non-date value, I would probably do something like the following...

yes... just start with SELECT TOP 10 & the rest of your statement... If your doing sums or other calculations, just use the GROUP BY function on the Person.

I'm assuming your payments table accepts multiple payments per account... you need to create a query which groups by the account or other unique identifier on the payments table. Also, cross-reference or add the total you referred to, then create a new column that has this as the expression...

Hi all, I was wondering if anyone knows how to write a property that changes a row color inside a list box based on a value within that specific row. What I have is a list of overdue orders on a form, the user can print the entire list (the report displays orders which are overdue by >13 days...

You can try something like the following, either on the query of the report itself to get the results you need (just replace controlname)... =IIf([controlname]= 1,"X", IIf([controlname]="",0, "Incorrect Value Given")) This first expression also handles any value in your control that is not...

Hi I think the expression you're trying to create would need to look like the following (almost exactly as you worded it): = (([AMOUNT OWED]*.239)/12)*[FIELDNAME]) replace 'fieldname' with the name of the field that contains the no. of months in default as you suggested... If the number of...