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

    Can't get MS Access to quit

    Thanks Hap, I am afraid you maybe right. I didn't develop this crazy application, but I do know how important it is to close recordsets. When I have time, I will have to go through the whole thing and try to isolate where the problem is. I hate having to fix other people mistakes. Thanks...
  2. Poobear1929

    Can't get MS Access to quit

    Thanks guys, but I inherited this problem. All users no matter what version of Office or Windows they have, all have this same problem. I run Windows XP and Office 2003 and my users use Windows 2000 and Office 2000. It is the strangest thing. I have tried a button that tells the application...
  3. Poobear1929

    VBA Code help, updating data

    Thanks Guys for the answers, however that was actually my first game plan to have an update query I could call from my import code. However, the query didn't want to work right, it would tell me what I was doing wasn't up datable. I think so of it may had to do with the fact I was trying to...
  4. Poobear1929

    VBA Code help, updating data

    Hi, I must be making this much harder than what it is, but I am having problems try to write some code to update data in a table through VBA code. Here is what I as trying to do. I have a process where I Import data from another location. It gets dumped into a temp table, from there is gets...
  5. Poobear1929

    Can't get MS Access to quit

    Hi, I am having a devil of a time trying to get MS Access to quit. I have an Access application that uses a work group file for the security, I don't think that is the cause but I just want to throw that out there. Anyway, when I go to exit the database appears to close, but then an empty...
  6. Poobear1929

    Problems with listbox and Crosstab queries

    Thanks Skip, I guess I am still confused. I didn't think I needed to use additem, since I am not asking my user to update the listbox. I just want to display a crosstab query in the listbox, I may have three columns or 5, or 6 is all just depends on the data. I just didn't know if there was...
  7. Poobear1929

    Problems with listbox and Crosstab queries

    Hi Skip Thanks very much for the fast response you rock! The only problem now is with me, I am just a little confused where in my code would I put your code? Could look at my first post and tell me where to drop it in? Thank You so much!
  8. Poobear1929

    Problems with listbox and Crosstab queries

    Thanks for the quick response. The icount worked great and I was able to make the columncount dynamic. Now the only problem is the columna are being displayed in I believe alphabetical order. However, since my column count is dynamic I can't be sure which column my primary key will turn up...
  9. Poobear1929

    Problems with listbox and Crosstab queries

    Hi, I am trying to populate a listbox on open event based on a crosstab query. Here is my code. My question is, can I can I make the number of column dynamic based on the results of my crosstab? Second, how can I get my columns to display correctly. Any help would be great! Private Sub...
  10. Poobear1929

    How to create custom paper size of 11X17 inchs for a report

    Can anyone answer this question of mine. I would like to define the size of paper for my report. My users need it to have it print to 11x17 inch paper and display it on print preview. I have it opening up in landscape just fine, but my users now want it on 11X17 inch paper. If and one has...
  11. Poobear1929

    how to insert list box when using Continuous Forms layout

    I would like to use Continuous Forms layout on my form. However, for each record I want it to have its own list box. For instance, I have a date picker. The user picks a date and all data all the records for that date appear. However I want to display more information, for each record that...
  12. Poobear1929

    How to update data on a form after using ActiveX control

    I am not sure how to word this, but I have an drop down menu that is actual an ActiveX Control calendar. I can't figure out how to requery a sub form after the user selects the date from the calendar. Basically I want the user to be able to see data this has the same date that is selected from...
  13. Poobear1929

    How to open a report into a word template

    I was wondering if it is possible to open a report in word using a template. Some of my formating on my report isn't making it when I publish it in word. So is there some code I could use telling access it open it in word using a specific word template. Or if anyone has a better idea on how I...
  14. Poobear1929

    Formating time for just minutes and seconds

    I am trying to format a feild in a table that will accept only minutes and seconds. Like a stop watch. I need access to see the values as minutes and seconds so I can do calculations in other parts of my database. I tried the nnss like the helpl file suggested, but when I input a time of 12:30...
  15. Poobear1929

    Need help writting a query to return the two highest values

    Thanks, I plugged both of those into my query, but it just returns one date. I need to have two date colums, one for the most current date, then the second at the next date after the current date. How would I rewrite these to give me Member ID,Current Date, Second Date? Thank You
  16. Poobear1929

    Need help writting a query to return the two highest values

    I am trying to write a query that will return the two most current dates in a table titled Fitness. Here is what I have so far. It will return the most current date, but I can't figure out how to get the next date after that. SELECT Fitness_Test.Member_ID, Max(Fitness_Test.Date) AS MaxOfDate...
  17. Poobear1929

    need help updating or adding data to a record using VBA

    I need some help, I would like to either write a SQL statment in module or run two queries I built. I think the SQL statment is the way to go though, but don't have much expeirence with it. Here is my problem, I want to add a record to a table if a certain condition doesn't exist. For example...
  18. Poobear1929

    What is the syntax for datediff for date and time

    Thanks,I will try this. Poobear1929
  19. Poobear1929

    What is the syntax for datediff for date and time

    I am trying to calculate time using datediff. However I want to know the hours to the tenth between two dates. The dates I have in my database are date and time together. example Start 1/01/04 10:20:34 Stop 2/01/04 9:20:34 Now I want to know the time between the times. This example would...

Part and Inventory Search

Back
Top