Search results

I'm not really looking to return a specific value from a row...I want to return the entire previous row. Also, there aren't any auto number values used. It's just an employee id and it skips around....it doesn't go in a sequencial number order. So, I can't really use the +1 or -1 thing.

Is there an easy way to pull previous row? Let's say you had a table of personal information. I want to keep historical data but I also want to be able to pull this historical data. The effective date of the row could be anything so it is an unknown. I can get the most recent row...so how do...

I'm doing a calculation within a query...there are more than 2 numbers after the decimal place...can I specify the data type as currency within the query?

Thanks! :) :)

Let's say you have two text boxes...dates are entered in these. I want to display a message box whenever the difference between the two dates is less than 60 days. When I try to use coding, it says I can't reference a property unless it has focus. I'm used to VB where I can do this...

I figured it out...

I can get the combo box to update the list but I can't get it to automatically select the first record in the list every time I change records on the form.

I guess I'm not explaining things right. I want one main combo box to drive the values of the others. I don't want to populate lists, I don't want it to do anything but put a value in there where it equals the main combo box.

I don't show them the ID in the combo box...but when you select the record, the ID is in the combo box because that's the value it needs to write to the table. I would love to not have to put the name on there since it's in the drop down but THE USERS want to see it even after they have...

Yes, I know a combo box can have multiple columns...but only on the drop down. Once the bound value is selected, it is ONLY the ID that shows. They, the users, also want to see the name after they have selected in another combo box. I know this can be done because I have seen it...I just do...

I've searched on this and I found something that worked but it didn't put the actual text in the combo box automatically. I have a combo box that looks at an ID...but I want to also have another combo box that will display the name associated with that ID without me having to choose it too...

How would I do the table thing? Putting my password in a table....?

I want to make it so that I have an Access database dedicated to DB2 tables. I then would like to link various databases back to this database, which holds to DB2 tables. This is because when my password for DB2 expires every 90 days, I only have to go to one place to re-link the tables. Any...

Forgot the file...

I'm not using Access for this but I figured this was a good place to help iron out my logic. I can do the SQL from there.... I have attached an example of the data that I'm getting from my current query. It's in Excel. What I want to do, is find out if ANYONE (noted by their ID number) is...

How might I do this? Say, I save a file as text, but then I want to delete it...can I automatically do that with the click of a button? like, coding a module that runs when a button is clicked that will delete the saved file...

Oh yeah. This was originally hooked up to an old computer and the computer was replaced on the network and now every computer that tries to print to this printer gets this error...even the new one that replaced it.

See attachment please

Well...that got blown out the window. Our client services dept won't allow for Task Scheduler on the machines. Any work arounds?

Okay. If I may, I'd like to pose a few more questions... If I am technically signed on to my computer but the machine has been "locked"....would the scheduler still run. What if I am logged off of the network....would it still run? It's obvious that it wouldn't if my machine was turned off...