Search results for query: *

I'm not sure what type of job your doing, so I'm kind of shooting in the dark here. A possibility is that the statiscs are not updated. If the job is inserting/updating records or the like, it's possible that your database is growing on those days. Increasing the size of the db and the growth...

Hi I wanted to see if anyone had any suggestions... I'm developing an application that has one form and three user controls that were previously forms. This is because they navigate through the menu option and there is always the feel of a SDI. My problem(s) have been that 1, I'm using the...

Or you can use Outlook Redemption if the code needs to bypass the security patch in outlook for automation.

It works just fine for me. If you are hitting "NO" to the first message box it exits out and goes to the next if statement. But your code is right both ways. If "yes" it pops up "Test", then clears out the combo box. I'm not sure about the requery, I just had a value list in the combo box but...

How long typically should a connection remain in the pool after it has been closed? If I remember right I've read somewhere about 60 -90 seconds. But my connection is hanging on for about 8 minutes! My code is pretty simple, something like this: cmd = cnn.createcommand; cmd.commandtext =...

You're friggin awesome. Thanks! I was really hoping that all of my work in coding the excel file wasn't going to go to waste, which is exactly what will happen if I don't get what you just helped me out with done. Michael

I'm making an excel file in Access. I've have all the particulars worked except for one. I need to have two option buttons created on the spreadsheet. How do I create and code those by code? I've created them in excel with the code to go along with them. So what I want to do works, I just need...

I'm wanting to create an excel file in Access. I pretty much have everything taken care of except for this; that I want 2 option buttons on the created excel sheet that pull data from another page in the excel workbook. What I need to know is how to create the control, but more importantly, how...

OK, for the longest I have been debugging on the fly. But I'm so tired of doing it that way. Sometimes I can debug just by pressing F8 and stepping into the code, and sometimes I get the annoying "ding" you can't do that. So what am I doing wrong that isn't allowing me to debug? Thanks, Michael

thanks to both of you.

Thanks a bunch. I was just coming in to cancel my post... I pulled it up on my laptop and what do you know, me.requery is there. Sorry, I was just frantic when it didn't work. but between these three, what is the difference? Do they all do the same thing with a slight variance?

Actually, let revise what I just stated.. It does work (as soon as I linked the on current event on the form to the code,, duh). But here's the problem. The form's record source is an updatable query. These fields that are populated by the vba code are hidden, but very crucial to the user...

Does anyone know if there is any reason why this code would work just fine in Access XP but not in Access 2000? Private Sub Form_Current() Dim myTime Dim SDate myTime = Time SDate = Date Me![Worked Date].Value = SDate Me![WhenCalled].Value = myTime Me![User].Value =...

Currently I have a front end/ back end over a network that is on about 10 concurrent users. They are using it to call customers, which brings up my problem. I can't have two reps on the same record at the same time. Otherwise, they might both call the customer at the same time, or the first...

As I am using rnd(), I'm finding that my numbers are not so random as they first seem. For example, Int(Rnd()*10) gives me a predefined number string through several queries, but not a random number. For example, when I open the database and run the query {which only has this one field...

I can use DTS to export to Excel, but it looks ugly as all get out. In Access it will export it giving column names (greyed out to distinguish them) and spaced correctly. In DTS it's just thrown it in there. How do I get DTS to format the excel file the right way?

thank you both for your answers, that was exactly what I needed. :)

Ok, so I know how to write a stored procedure, but after I write a procedure that does whatever I want it to do, how do I make it happen? I'm getting more familiar with SQL Server, at least this part and that part and this other part, but I'm missing the big picture. I'm coming from Access...

Hey thanks a lot, the only problem that I'm still having is that when the Access window is hidden, my custom menu still wont work. It will as soon as I restore the Access window though. Any suggestions as to how to get around this? I might just end up having to make the Access window very...

AWESOME. Thanks, you just saved me a ton of trouble! If I could give 2 stars I would!