Search results

If you are doing this on a form: Set your text box to: =DCount("YesNoField","SourceTable","YesNoField = True") (Obviously replace the field & table names)

You can use the "Format" & "Input Mask" properties to achieve this. Format: mm/yyyy Input Mask: 00/0000;0;_ hth Brad

Dave (Oldsoftboss) posted some good code to facilitate similar tasks here: http://www.access-programmers.co.uk/forums/showthread.php?t=75795

Hmm, you must have missed the word "search".... ;) Office Developer Edt has the Access Runtime package that I mentioned. Note: This does NOT package the db as an exe. It simply gives your user a Runtime Version of Access (Similar to Word Viewer / Powerpoint Viewer etc). More info on the...

Short answer: It Can't! Long answer: Search for "Access Runtime" & Office Developer Edition

Steve, You should be able to qualify your CRITERIA portion of you dlookup as text. Sounds like you normally use the ID Number (number), however when you use text, you need to qualify it as such. Post you Dlookup statement, and I will see if I can assist. In regards to storing the assett...

Glenn69, What you are trying to achieve is, to my knowledge (limited as it is), not possible. You may want to rethink your logic.... Assumptions: - Someone is manually scanning documents onto PC at the moment - ALL pages have a barcode - You are under budget constraints As you may have read...

You need to replace cboComboName with the name of your combobox. =YourComboBoxName.column(0)

I have created a hole for myself :mad: I had a simple treeview control Main menu. This form functioned correctly, without issue (So why did I touch it?......) The form was named "Sw_TreeView". I simply renamed the form "Sw_TreeViewMenu" Now, when I attempt to open the Sw_TreeViewMenu...

Try changing the list box to a combo box. You can use the following in the KeyDown event if you wish to display the options on selection / key entry: me.ComboBoxName.Dropdown hth Brad.

Assuming that your combo box has column(0) (first column = Vendor ID ) bound but hidden, you could use for following in a text box for display: =cboComboName.Column(0)

By using Docmd.openquery ""strSQL" - you are implying that strSQL exists as a query object. However, it is only a string. Thus you need to use DoCmd.RunSQL "strSQL" Also, why not use bound text boxes to remove the need for coding? hth

If you are referring to a "Tabbed Control", then I am afraid the Forrest does not exist ;) You can set the background type to "Transparent", which will make the background of the Tabbed page match the form. However, this will still leave you an issue with the actual tabs themselves. You can...

We may have to agree to disagree on this one paul. In my basic understanding of db structure, your proposal violates data storage procedures. Also: Going back to NavyGuy's original issue, is it very difficult to calculate the required "result" from a flat data record. (I would be interested...

ha.. There's one of them now ;)

How's that assignment coming along? I am still at a loss as to why your "educator" has an aversion to VBA. Coding behind the buttons is the correct way. Macros do not allow for any error handling. As discussed in previous posts, I would seriously question the VBA ban. I know of a few forum...

Not wanting to open a can of worms . . . but How is the "calculated" field known when entered? The input is of raw data. ??

Paul: Not good practice to store values that can be calculated. NavyGuy: I have had a bash at method 2 that I mentioned. Using this method, you can exploit DMin / DMax etc etc in order to present the results as you wish. You will see by the attached sample what I mean (I hope). (Access...

DMin & Dmax are used to locate the relevant value from a range of records, not from a number of fields in one record. Haven't really needed to achieve your required outcome. Will have a think (that hurts though) about the issue and get back to you if something comes to mind. As an aside...

Depends on your design... Are the five scores in the one record or in seperate records? ie: Result1, 7.06, 8.25, 4.37, 4.98, 7.39 OR Result1, Try1, 7.06 Result1, Try2, 8.25 Result1, Try3, 4.37 etc etc