Search results

Yep they messed with it when they (MS) tried to suppress DAO and claim ADO was the way to go (A2000). The wizard has been cranking out inappropriate code ever since .... For what its worth, the .EOF is how you check for a successful match in an ADO recordset, but .FindFirst is not a valid...

First note ... the Format a value is displayed as, has nothing to do with how the value is stored. What are the data types of Hours1,2,3 ... if the datatype is Number/Double or Number/Single, then you will not get your times to work right with out a little coersion, simply because number...

>> What matters to me the most is that the UI is clear and easy for users to understand << Again 100% agree. For me and the situations I have been in, functionality and intuitive flow, has won out over eye candy in every circumstance.

>> I don't like the idea of "fancying up" the application << Hello Banana... I 100% agree. My apps have a UI built from all the "standard" things available to the Office applications. The most I venture "out" is to a TreeView or ListView activeX control, which are avaialable through a...

How bout some snazzy form design ... The attached image is the sample image from the code found here ... http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=586440&fpart=1#Post586440

Hello! ... Congrats on your progress! ... ...Hmmmm .... Look real closely here ... And ([Stylist ID])= " & (Dates.StylistID) = "" The string that will be return from that is ... And ([Stylist ID])= True ..Or .. And ([Stylist ID])= False This is happening because you are concatenating the...

First off ... you really should not be storing a "Date" field along with a "Time" field ... or variables for that matter. You see, to Access (actually several) applications and databases and Date/Time datatype is a number. In VBA and JET | ACE its equivalent to a Double. The number is the number...

In VBA you have ... MkDir - make a directory RmDir - remove a directory FileCopy - copy a file Name - rename a file Kill - delete a file SetAttr - set a file attribute Dir - "list" your directory (read the help on this to explain what it does) GetAttr - retrieve file attribut info CurDir -...

what application are you using? ... Excel I presume ... what version?

>> isn't there a chance that the last record could have just been added by another user? << Only if your recordset is an dbOpenTable recordset, which is the default if it can be obtained (ie: Local Table as the source of the .OpenRecordset). Otherwise the only way to see additions made by others...

>> Remember to grab the Record ID before the update command, as this moves the cursor << Just a point of note, on this important, and accurate, comment. While it is quite valid to use Evan's approach when JET|ACE (ie: mdb|accdb) files are the back end, it is not so good if the back end is...

>> Does this mean, perhaps, that I have problems with my indexes? <<\ Not necessarily ... you may be looking up info on a non-indexed column, and in those cases, a custom solution may edge out the inherent functions. Example: DLookup("SomeField", "SomeTable", "SomeIndexedField =...

missinglinq ... I assume your response was for evan ... since we pretty much agree on the use of DLookup(), but even with speed and technology, I like to be efficient, so .. as stated above .. I have been in scenarios in which DLookup() was just plain slow (SQL Server back end, 3 million rows...

>> You need to use Option Explicit. << I think that gets an "Amen Brother!" ... from me! ...

>> You're talking about three methods, all of which work, each one using one line of code! << I suggested 2 methods ... and NEITHER of them uses code! ... :) The .Column method is best simply because it opens a the table (recordset) ONCE to get the data in order to poplate the combo, so the...

>> I certainly would not use dlookup unless i had to - VERY slow. << I have put my foot in my mouth with that kind of statement too. It is a very generalized statement that I have found not to be true in MANY more cases than I care to admit. Basically, the domain aggregate functions are, in...

There is really no need for the AfterUpdate code ... you an just set the control source of a text box to the expression ... = DLookup("DescriptionFieldName", "QueryOrTableName", "[ReportName] = '" & [ComboboxName] & "'") But ... there is even a BETTER way... set your rowsource of the combo...

WOW ... Thanks Paul, I am humbled by your kind words! ... :) ----- canberry ... Give this a shot, and see if this will work for you ... SELECT DISTINCT vAnguilla.*, vECIslands.MERCHCIF FROM (SELECT *, 0 + MerchantNumber As vMerchantNumber FROM AnguillaFdms) As vAnguilla LEFT...

You can do somthing like this ... SELECT vtblStudents.studentID, vtblYearReport.* INTO studentAll FROM (SELECT *, 0.0 + pin As vPin FROM yearReport WHERE pin Is Not Null) As vtblYearReport LEFT JOIN (SELECT *, 0.0 + pin1 As vPin FROM student) As vtblStudents...

I do like the use of the Format() function, but it is a fairly taxing function, so I use the following to round in A97, as it is about 60% faster ... which is probably imperceptible with a single calc, but when evaluation 10,000 or 100,000 rows of data, the difference will become evident...