Search results

How about... Is there a way I can just put a button on to "refresh" (if you will...) the datepicker control? I'm hoping that it will reload with the custom format as it does when I originally open the form in the first place. Think it would work?? Thanks

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

Well - I'm partway there by sidestepping around the issue. I've built a special table that holds some of the values I need to have in the charts, and an append query to add the new month's data to the table. Now I have a new problem. The graph is not displaying the data on the X axis in the...

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

That works well, but it still uses an input box, so I can't format it to "****". I will remember it for future use, though. Thank you! ;) ~C

I wrote a bit of code in the subform with all the "if" statements that I wanted, and called it on the form's "on current" event. That seemed to take care of most everything.

I'm afraid that I can't make that happen. The MS code generates an InputBox that I don't know how to set. I tried to play with the code some, but couldn't figure out how to format it that way. I can't do anything to the box itself (can't right click or view in design, etc to make changes...

OK - I guess what I need to do is create an input mask like "password" on the input box itself. Help was no help. Any ideas? Thanks

Password Popup Box Not Masked Thanks for the link, Jack! That works pretty slick, only issue I have with it is that the password entered into the popup box isn't hidden by asterisks. It's completely readable by anyone standing around. Any ideas on how I can make it illegible to prying eyes...

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

Got it! Hey - I figured out a way to do it. Not to mention a repair in my code (oops!). Anyway, thanks for the vent space. :p Writing it "out loud" seems to have helped me sort it out. ~C

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

Hmmm...found a possible issue. Any record that had a null in the date field that I want to check causes an error ("data type mismatch in query criteria"). Any ideas how to get around this? Some of the fields are going to be blank as they won't have been done yet.

I tried it again with a fresh query, just using one field along with the new DateValue field, and it worked this time. SELECT tblProcessing2.[4DateStopTime], DateValue([4DateStopTime]) AS 4Due FROM tblProcessing2 WHERE (((DateValue([4DateStopTime]))=Date())); Don't know why it didn't work...

Hey Mile...is this an A2K solution only? It didn't work for me (A97). :( Thanks!

Yes! I got it, and it works slick! Thanks a lot! :D

Excellent. I'll give it a try and see if I can get it to work. Thanks!

Sounds like just what I needed. Almost makes me wish I was still at work to take a crack at it...almost. :D Now, I have to ask a newbie kind of question, though - how exactly do I go about changing that? Thanks!

I do have a date field, too, for each operation. I will try datediff, although I'm not sure quite how to go about joining it all together. I'm a little wonky with getting the code right. :) I had to make the date and time fields separate since it will most likely be difficult enough to get...

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