Search results

is it possible to use WHERE in the Control Source property of a button on a form? Something like this = [Station Status]![Done] WHERE [station Status]![ID] = "28"

Brilliant. That did it. Thanks.

I have a text box on a form that I want to return the minutes remaining between now and a time, in this case 3:40 pm. Here is what I have in the control source for the text box =DateDiff("n",Now(),#3:40:00 PM#) the result is -10,545,100.00 I'm no math genuis but I think this number is...

Changed from this Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("select * from Daily") rec.AddNew rec("Line Position") = Me.Text522 rec("Model") = Me.Listrs1 rec("serial") = Me.Listrs2 rec("ctl") = Me.Listrs3 rec("Hvac") = Me.Listrs4 rec("Run Date") =...

I got it figured out. Thanks guys.

Let me try to explain. We get a list emailed to us about once a week fro what we are going to run. Each order has 4 relevant fields. Model, serial, CTL, and HVAC. We get this as an Excel spreadsheet laid out something like this.. Monday Tuesday Wednesday Thursday Friday M,S,C,H...

So here's what I've got so far. The table he pulls records from gets overwritten every couple days and he would like to keep a record of what he did each day. So back to the original idea of "table -> form -> new table" He opens a form, it asks for his first serial number. it then populates...

So then I just need another field in the original table that stays blank until he updates. Now to figure out how to append 30 records on a button.

Hmmm. Let me think around the problem a bit. Maybe rather than to a new table just append a field to the original table with just a 1 through 30 to indicate what order he actually ran that day. Then sort that in a report to show the differences? Is that what you mean?

Actually in this case it sort of does matter. The records are work order numbers that are imported in the order they are to be run. The supervisor pulls up a set of records based on what his first order of the day is. Sometimes he needs to change the order that things are run in and then save...

Ok. So I have created a form that lists records in a specific order that the user can change. After the user has arranged these records I need to save them to a new table in the new order. There are 40 records on the page and 6 fields per record. Any suggestions as to how to best accomplish...

So...any ideas? Anyone?

Ok, back to the well of knowledge. I have a form with windows media player embedded in it. What I want it to do is play a random song when I open it. So I put a field called Randomizer in the form and added this code. Me.randomizer.Value = Int((60 - 1 + 1) * Rnd + 1) Now How do I put the...

Crap... now taht I stop and think about it it does seem kind of obvious. lol

It will be about a once a week occurence but as I said I'm fairly new so I'll have to do some looking on that but at least now I know it's somewhat possible. I can import it to one table then make an append query to rearrange all the data in another table if I'm understandig correctly.

Heres a little more data. I have this.. DoCmd.TransferSpreadsheet _ acImport, _ acSpreadsheetTypeExcel5, _ "Table1", _ "D:\users\shopapps\Documents\SL57 Line Load .xlsm", _ False, _ "b4:h63" That works, but I also need...

OK, I have a question I need to import the data from an Excel spreadsheet but only certain cells. Is there any way I can call out a range of cells in a query and tell it what fields in a table to put those records in?