Search results

How do I convert a date time format eg. 12/12/2008 8:00:00 AM to a decimal format? the style where the date part is the number of days from 1/1/1900 or whatever, and the rest is the time? Thanks.

I want to write some code that will change the state of a parameter for a record in a table if I double click on it in the list box. How can I do this?

What command can I use to determine (boolean) if the new record row in my form is selected? I'm using DoCmd.RunCommand acCmdRecordsGoToNew, and I only want this code to run if the current record is not the new record row.

Is there a way to make the data in a control refresh automatically if there is a change in the data in the table? I want a list box in my form to show data as I add records to a table or query. Is this possible? Right now it only works if I close and re-open the form.

I'm having a problem with the Available Furnaces and Current Runs controls. They are populated with queries that take criteria from the control above. So the Available Furnaces is populated with data from a query based on the selection in Furnace Runs, and the Current Runs is populated with data...

Every time this code runs, it returns the number 12, regardless of the time (hour, minute, or am/pm). The same code works correctly if I replace the "mm" with "hh" or "AMPM". Can anyone help? Thanks MinuteCombo.Value = Format(CDate(StartTimeText.Value), "mm")

I know this is a stupid question, but how do I make certain events run when I open the form? How about each time I select a different data row (click the forward/backward buttons)? I need a set of events to run every time one of these things happen. Thank you.

I would like to allow the user of my form to enter a time, and have it bound to a date/time field in a table. What is the easiest way to do this? I saw a Microsoft Date and Time Picker Control, and that does pretty much what I want it to do, although its output is not what I want it to be and I...

I have the "Date" function in my VBA code. It worked as of a few days ago, and I don't think I've changed any code. Now when I try and run it, I get a "Compile error: Can't find project or library" error. Does anyone know why I might be getting this?

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 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.

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...