Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SQLwannabe

    Access update too fast

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

    Make Window Top Most......But..

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

    Stacking Toolbars

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

    Stacking Toolbars

    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!
  5. SQLwannabe

    Bios not detecting hard drive after reformat.

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

    Bios not detecting hard drive after reformat.

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

    Bios not detecting hard drive after reformat.

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

    Dynamicly Setting Data Environment Connection Objects.

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

    Passing Parameters to Access

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

    Passing Parameters to Access

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

    Access and nested joins

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

    Access and nested joins

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

    Nested joins

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

    Access and nested joins

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

    Nested joins

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

    Nested joins

    Thanks Tim, I still need to know how to restrict the hours to only the specified dates that will be entered as variables so as to be able to display on the totals for the current week. Thanks for your help and if you or anyone else can help with the remaining task that would definitely be...

Part and Inventory Search

Back
Top