Recent content by SQLwannabe

I've ran into this a lot, and I first started doing what you did which was putting in a delay. But this just didn't seem professional to me, especially if you're desiging programs that someone else will use. What I did was just update the forms manually. Meaning that after I did my database...

I've looked around and found the code to make a window top most, but the code I've found also makes it so it is top most even if you activate another program. I'd like to keep it so it becomes top most when activated, but also allow other windows in front of it if they are activated. How would...

Thanks! I set subsequent toolbars visible property to false and set the alignment to none, and now I can set each of them to appear at the top depending on what frame is present by turning their visible property on and setting their zorder to 0. Walter

Is there anyway to stack toolbars up at the top and use the zorder property to make different ones visilbe depending on what frame is displayed? This way the toolbar will match the frame. Any thoughts or suggestions are appreciated. Thanks!

Well as it turns out I was looking in the wrong place for the problem. The Asus A7V was doing what it was designed to do. It wasn't suppose to be detecting the hard drive at that time. It lets the operating system install and then take over. Turns out my RAM went bad. Swapped it out and now...

I was getting all kinds of weird Windows errors so I decided to just wipe the thing clean and start over. It was my children's computer and they had put junk on top of junk and I thought it best to just start from scratch. I ran Fdisk and erased the current partition and then set a new one and...

I was getting all kinds of weird Windows errors so I decided to just wipe the thing clean and start over. It was my children's computer and they had put junk on top of junk and I thought it best to just start from scratch. I ran Fdisk and erased the current partition and then set a new one and...

I'm using Data Environment Connection Objects for use with my reports in my project. I cannot figure out how to set up the connection to the database dynamicly at run-time using something like app.path. I'm very familiar with setting up a connection string with ADO objects, but DE objects...

I just read the thread "PROBLEM ACCESSING ACCESS QUERIES AND REPORTS FROM VB6" and found the information very helpful. I'm wondering though how to adapt his advice in my application since I'm first going to be deciding on the parameters and then using the query that needs the...

Hello, I got some help with constructing a query on my database that requires 2 parameters and I then use this query as a part of a larger SQL statement in my VB Program. These parameters will change based on what the user does so it's very convenient to just have to change the parameters and...

I'm also wondering if I did want to do this as one big SQL statement how exactly could I embed that subquery into the statement instead of using the query name. I've tried several different types of syntax and can't seem to get it to work. Thanks, Walter

Thanks alot! It works great. If you don't mind I'd like to know how you'd pass the dates between VB and Access to give the user control over what date range they wanted to use? I'm kind of new to VB and Database programming. Thanks, Walter Cantrell

Thanks again for the help Tim. I put in the statement for the date and it now reads ....Project.ChargeNumber = Employee.CurrChargeNum and main.tcdate between #4/2/2001# and #5/8/2001# and i get an error from Access that says "Between Operator without And in Query Expression" ? Not...

I should probably mention that this query is being used in a VB application interacting with Access. Thanks, Walter

I should have also specified that this is being used in a VB program interacting with Access. I may have posted this in the wrong forum and I posted it in the Access forum just in case. Thanks, Walter