Search results

You only need to supply a date value for d0. ByVal is not an argument of the function it just determines how the argument (or value) is passed. It would look like; IsDST(05/19/2014)

You need to use Sorting and Grouping in the report itself. Trying to sort at the query will not produce reliable results in a report because any existing sort rules in the report will override anything you attempt in the query.

There's not really enough information in your post to answer the question. It could be import errors (i.e. a Data Type mismatch or something). It could be the joins in your query that are excluding records from the original data set. It could be something else. Are you getting any error...

I'm a little unclear here because it sounds like you are talking about an Access database table up until your last statement where you state that you attempted to export an Excel file. Are you working with Access? Excel? Some combination of both? If you are working with Access, and assuming...

First, I can't be sure, but it sounds like you are working directly in the table. If that's the case, you shouldn't be. Tables are for data storage only. User Interface functionality is handled at the query, form and report level. To answer your question in a general sense, yes, there are...

Not sure if it will help but there is an old (from 10 years ago) article from Doug Steele about working with MP3 files. You may be able to adapt this to open an MP3 file on another machine, not sure. You can find it here. Scroll down the page to the link titled "November 2004: Sounds good to me...

Sorry it took me a bit to get back to you on this, been busy at work. My original advice last year was based on having a very small, static list of possible values. With a larger and/or dynamic list like yours, I would not use quite the same approach. It's cumbersome because, even if you get the...

Did you get this resolved or are you still in need of help?

Have a look at this sticky

You're evaluating LNumber with your Select Case, however, you never actually supply a value for LNumber (at least not in the posted code). You declare it as a Sting variable at the beginning of the sub but supply no value so when you try to evaluate it with Select Case it is Null, meaning none...

So does your table have 2 fields or 40 fields? Are you perhaps confusing rows with fields in your second quote above? You'll need to clarify your original post and maybe provide a few more details.

@spikepl Point taken. Didn't read the op closely enough on the first pass.:o

Not necessarily. Sometimes we just lose track of threads. Glad you got it worked out.

What is the data type of SprayCfuelC? If it's text then you need string delimiters. Also, you don't really need all the parentheses. It looks like you built the SQL with the QBE. The QBE seems to be in love with unnecessary parentheses. CurrentDb.Execute "UPDATE ProcessData SET...

If each record has a Date value along with the Results value then you can just return all records where the Date value is greater than the Date value of the most recent record where Results was equal to W. Example; Where [DateField] > DMax("[DateField]", "YourTable", "[Results]='W'")

Glad I could help.

The function has a required argument that you are not providing when you call it. The function header reads; Function ConvertToLetter(icol As Integer) As String The item in red is a required argument, so when you call it you need to supply the value for this argument; Private Sub...

If you already have the table names in the bound column of your first combo box, and assuming that the Row Source Type of the second combo box was set to Value List, then you could use code like the following in the After Update event of the first combo box. In the following example you need to...

Depending on exactly what it is you're doing, you might be able to use an IIf statement in the calculation, something like; IIf([SomeField] = "Yes", YourCalculationHere, "") Or, you might use DAvg DAvg("[SomeField]", "[SomeTable]", "[SomeOtherField] = 'Yes'")

If you're attempting to do this in code then post the exact code that you're using. Also post the exact names of the combo or list boxes involved an an example of the row sources.