Search results

I think from your post that you want to return the [Value Date] field if it has a value, otherwise return the words "SOONEST VALUE". the snippet below will do that. IIf(IsNull([Value Date]),"SOONEST VALUE",[Value Date])

I assume you have a List Box control with a source set to 'Value List'. If you do, then you can iterate through the items and remove them. While ListBox1.ListCount > 0 ListBox1.RemoveItem (0) Wend Or you can simply set the Row Source to a null string. Me.List4.RowSource = ""

There are benefits to a database that just aren't available in a spreadsheet. Especially if you want to report on previous calls to companies and see their pass/fail history. Access is also a better solution when you want more than one person to edit/add information at a time. You would...

The SELECT statement in my previous post is really just a sample query you could use and modify to get any reports etc that you may need when you want to work with minutes and seconds rather than just seconds. You don't need to use it in the form at all, but try and use it as a new query, just...

start & end time would work if you don't need to pause. To be honest though, working in seconds is easier as it can be a pain to work with time values especially if you want to group and sum them for any reports. You can easily sum seconds and then display them in a query. The sample below...

I had a look at the database you uploaded the other day and put a breakpoint in the code behind your Save button so I could see what was happening. The error is being triggered because you are trying to save a value like 0:10 in a number field. As an aside, I could not compile your database...

gjh, If you don't want the timer to start when the form opens, you need to set the Timer Interval in the form properties screen to 0. You then need to decide when to start the timer. This will depend on your business requirements. One option would be to start the timer when you select a...

Thanks, Glad I could help.

Depending the the precision you require, can you not just use the form timer event? It is not 100% accurate, but I suspect you will get a fairly good result if you only want seconds. The code below assumes you have a form with start, pause and stop buttons, plus a textbox to display the...

As a stating point, you query needs to look something like this (as the link from Bob's post shows); UPDATE PastForecast SET PastForecast.Noun = pastforecast_Append1.noun, PastForecast.[Date] = pastforecast_append1.fcstdate, PastForecast.Fcst = pastforecast_append1.fcstqty...

If gemma-the-husky suggestion does not work, I'd check with your IT guys at work, because they may have beefed up security. I have seen a similar thing when we migrated from Office 2000 to 2003. It was a windows security setting and it used to apply to databases copied from 'unsecure' sources...

The previous code could exist behind a button. That button is located on the form were you enter the details of each report (that is the main report, not each instance). You would set values for frequency, start/end dates, report type, staff member responsible for report and any other details...

A couple of options iff the top of my head: ONE: When you click on the button, you could store the ID value in an invisible textbox, that is used in the underlying query of the report eg WHERE LocationID = Forms!FloorPlans!txtLocationID Onclick: txtLocationID = [ID] 'replace with the...

The VBA simply creates the records in tblReportInstances. Each record represents a future report that needs to be created. You could add a whole bunch of fields to tblReportInstances that help manage these reports. For example, you would add a field to identify the staff member assigned to...

You only have 2 fields in your query, so column 5 does not have anything in. You want [Address]=[AddressLook].[Column](1) - which would return the Site field.

And if you look at the original question, that is exactly what is requested. Also, Gkirkup does not state that there are any groupings - just that the count of records should be between two dates. Which would leave us with this query SELECT Count(tblYes.ID) AS CountOfID...

I like the idea of not having to store each instance of a report being run, but I have never discovered a way that can do that and still let you forecast future workload and also track if the actual report was completed on time. In the past I have had similar scheduling systems, for Tasks or...

You nay need to check for Null on both fields seperately. iif(NZ([ItemAmount]),0)*iif(NZ([txtRecItemPrice]),0)

Not sure if you can make it smaller, without really understanding what it is you are calculating with the equation. Is there no way to embed your IFF's into a query first and then use the result of the query? For question 2: You could add a 'wrapper' IIF(expression=0,1,expression) to the...

Robert, You actually want the Sum of these fields, not the Count. If you look at my previous post, you will see that Count(ID) would give you the total number of records, whereas SUM(IIF([Fieldname]=-1,1,0)) would give just the sum of values in the field - in this case every Yes is assigned a...