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.

bump...anyone?

I tried binding the 1st column of the list box (which is populate from a query) to the control, but I still don't know what commands to use to specifically edit a parameter of that record.

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?

Thanks, did just what I wanted.

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.

Here's my code, and I updated the screenshot above so you can see the queries I'm using. Thanks again. (I know the code shown is excessive but I don't know if its relevant to the issue.) Option Compare Database Private Sub Form_AfterUpdate() CurrentRunsList.Requery End Sub Private Sub...

How would I do this if the list box is in one form and I am editing the table from another form? Thanks.

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

haha thank you, i'm an idiot.

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")

Awesome thanks.

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

Thanks, that fixed it

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?

it will be filled with much longer data that is just test data so far

Here's the screenshot - this is after selecting the "Start Date" combo box. The "Operations" list box is showing up on top. I have tried completely removing the calendar object and recreating it as the last object and I still get the same problem. Thanks for your continued help guys

It just pops up then disappears when the user selects a date from the calander. Is there a way to make it show up on top? If the list box shows up on top there should be a way for me to say that I want the other control on top.