Search results

Yeah I understand. I don't really want to be flashing things on and off when someone clicks on an element though.

I would rather keep it visible for aesthetic purposes. I will also be adding other elements that will be occupying the same screen space as the calendar when it is hidden so i'm hoping to figure out a generic solution.

I have some code written that makes a calendar visible when i click on a certain combo box (basically a pop up calendar control). For efficiency's sake, I put a list box on top of the calendar element. When the code unhides the calendar however, the list box obscures it. I've tried the bring to...

I'm not sure if I'm using it correctly though. I'm just typing Format([DateField], "mm dd yyyy") into the expression box when in the query design view. Is this correct?

I tried the Format() function but it gave me an "Undefined function 'Format' in expression" To clarify, I am just trying to truncate the time of day from the date.

I know this is a simple question, but I'm having trouble figuring out how to do it. How do I format a date/time field in a query from "12/18/2008 12:00:00 AM" to just "12/18/2008"? Thanks.

All of the linked fields in all of the tables have data for at least some, if not all records. If i'm not mistaken the results should just pick up on the records with data correct? This is what I want.

Basically what i'm trying to do is filter down hundreds of thousands of records pertaining to parts on our shop floor into just a couple thousand by using the linking between the tables. Each part in the SVS_DB_VOUCHER table is linked to an employee by his badge/payno. For each master router id...

I'm having trouble with this query that I've built. As far as I can tell, I'm not running into any data type mismatches or anything, but it is returning zero records when I run it. Am I doing something wrong with the joins? All this is is a query to display some data about the productivity of...