Recent content by Amy35

Thanks Jon! I knew it had something to do with the datevalue just couldn't figure out the syntax. I appreciate the help!

Hello all - It's been a while. I need to update my database, and now I'm rusty since it's been over a year. I need to alter my query for "todays tickets" . When a user submits a ticket, I have a field "Ticket Date" that now also includes the time. So it's a date time field. My query no...

Hi everyone! It's been a while. I've successfully dodged any additional programming for a few months, although now I have a simple, or so it seems, problem. How in the heck do you combine tables? I have an excel file that I tried to import into my Access 2k db to an existing table and got...

some ideas Logically I could figure this out, but couldn't write a lick of code for it. You are right though, it can be done, my PDA does this. Some thoughts: Assign values to MeetFreq; MeetingOrder; MeetingDay and MeetingTime Then perform a calculation based on the value assiged to those...

Thanks! Thank you! It works great. I really appreciate the help! Amy

I've searched the forums and have found info on disabling the shift key in Access 97 but how do you do it in Access 2K? Of course I would also like a way for me to be able to bypass whatever security I set up. Anyone know? I'm not a great progammer so I'm hoping the solution isn't too...

Thanks that was it! can't believe I didn't think of that...guess I'm still on my semi summer vacation mode.

Seems easy enough but! I have a form that displays all open tickets in tabular format. I have used the wizard to create a command button to refresh the form's data. Trouble is it only refreshes the tickets currently shown. So if a new ticket comes in, that ticket will not be included when the...

That is my kind of programming NO CODE! it worked great. Thanks for the trick I appreciat it! Amy

Thanks Tom I actually took a couple days off work, so I didn't get your post til this morning. I changed the color in the control panel and it fixed the flickering. Just in time since this whole db went live yesterday (while I was out...gotta love this place). I really appreciate your help...

Thanks! That was exactly what I was looking for. Wish I was more knowlegable and knew what the heck I just did. It's working great, only thing is when the form first opens, form looks fine then a second late all the labels flicker the forecolor a couple times and then the form looks fine. Do...

Thanks ...how to get it back? How do I get the color to go back after I change it on the mouse move event. I can get it changed when the mouse moves over, but since it's a label there's not alot of events to choose from. How would I get the color back to it's original state when the mouse...

After being agravated at the way the command buttons looked (that dull gray), I changed them to labels. Now I would like the mouse pointer to do something when it is over the label. Either change to a pointer and then maybe an hour glass after it's clicked or change the color on the label when...

Thanks! That worked great...I like when it's an easy fix :) Amy

Suppose I got a little bored and decided to put an image of an American flag on my form. While trying to find an image I found some nice flag wallpaper. Is there a way to set that as your background for your form? I think it would look nicer (perhaps). Is this something that would be...