Search results

I have a table in which we put clock in and clock out times for employees that tracks weekend coverage (plus all other relevent ee info). I have done a query that calculates the hours the ee is at work, which is functioning just fine, but in order to properly calculate "paid hours" I need to...

This is making me nuts. I have scoured this forum, and tried everything I've seen as far as writing this event, but it's still not working. All I want to do is take items in the list of information in the selected row of a combobox and pass it to a text box. I'm stuck with Access 2007, and if...

I keep getting this error whenever a particular table is linked (including after splitting the database): '|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. I cannot, for the life of me, figure out what is going on with...

OK, I should be able to figure this out, but I'm getting frustrated... I also haven't been able to find the answer via the search feature or MS help, so I'd be overly appreciative if someone could slap some sense in me with an answer to this. All I am trying to do is write an IF expression in...

Hey there, folks, Got one I need some help on. Perhaps one of you has tried something like this before... I need to create a tool that will allow me to do the following: 1. Search an Outlook email box for all emails that have a keyword in the subject line that I have chosen from a drop list...

Hello again, All, Don't know if anyone has run into anything like this before, but I figured I'd throw it out there. Our company recently put out the word that A97 would no longer be supported or even supplied on terminals in the future, so I converted all of our dbs to Access 2000. Currently...

Ahhh, yet another problem. I have a form with 2 subforms. They are both linked by ID - an autonumber key field. The top subform, "processing," works just fine. As I navigate through the records, the processing form reacts just fine. It is the second subform, "reprocessing," that is the...

Hi all, I've got another one for ya... I did a search, but must be choosing poor keywords because I can't find the answer I'm seeking. Anyhoo, what I need to do is use a bit of information garnered from a database to fill in a line of fields on a form at the click of a button on a different...

Hi, I'm doing *something* wrong here. What I need to do seems simple enough, but I can't seem to write the code correctly. When my form opens, I need it to check the date/time in a certain field and if it is over 48 hrs, pop up a messagebox indicating this. BUT... This is only valid if there...

Hey all, OK - long story short: Complex form with several datepickers. All set to a custom format to show date AND time (MM/dd/yy hh:mm tt), drop the selection in a bound textbox and disappear when no longer needed, after which the locked textbox which was hidden beneath the datepicker...

Hey there, I am having a bit of a problem figuring this one out. Wonder if any of you brilliant minds can help me. :o I have a small db which I just built and I use it to calculate defects per million by month for six different manufacturing cells. I post charts on a monthly basis showing...

Hello All, I am having an issue with the DTPicker control. Here's the scoop: I have several of these controls on a subform and they are all set to the custom default (format: 3 - dtpCustom) of MM/dd/yy hh:mm:tt I also have "on current" code that tells the form to hide the controls if they have...

I have searched in vain for the answer to this problem, so here goes... I am building a db here at work that requires users to start a record with certain information about a job, then later, add to that record. There are a *LOT* of fields, so I have split things up into 3 tables. So far, so...

Hi, I need a little assistance. I have a db that requires entry of the time of day that someone does a specific job. These are timed issues, and have "stop" times as well as "start" times. Both are entered on the form into text boxes. How can I code the "stop" time box to be more than 2 hrs...

Hello All, I am in a pickle here, and could use some of your sound advice. I have a multi-user Access 97 db that was just introduced to the users recently. It is housed on one of the network servers here, and is set to open as "shared" for the default with no locks. It is a duplicate of...

Hi, I've got a strange one here and I could use some assistance. I have a database in a multi-user environment run on several terminals. Someone has entered code somewhere on one of these terminals that causes one of the user's last name to change to a gibberish word when he selects it or...