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 strongm 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: *

  • Users: mlstewart
  • Order by date
  1. mlstewart

    Grouping data from different fields together

    Thanks for the suggestion. The database I am working on will only keep track of one individual which eliminates the need for for the Employee ID field. Other than that, you've given me a great start on re-doing my tables. I really appreciate your help...you definitely deserve a star! Thanks!
  2. mlstewart

    Grouping data from different fields together

    The sample data I gave in the original post actually has nothing to do with the data in my table. I used that sample info so that the data would be easier to work with. Anyway, my table stores data related to an idividual's jobs for one year. The individual travels from one job site to another...
  3. mlstewart

    Grouping data from different fields together

    Thanks for the reply. The database is actually more extensive than the example I am using. In the table, there aren't any dates. Only a Month field which will contain January-December. Also, it will only be for one year so you don't have to worry about whether it is 2005 or 2006. I already...
  4. mlstewart

    Grouping data from different fields together

    Here are my fields: Month Desc1 Desc2 Desc3 Amt1 Amt2 Amt3 Desc1 goes with Amt1 Desc2 goes with Amt2 Desc3 goes with Amt3 All of these are saved in one record. In the table it will look like this with several records: Month Desc1 Desc2 Desc3 Amt1 Amt2 Amt3...
  5. mlstewart

    Office XP Developer error - Needing NT SP 4.0 ver. 6 or later

    I just found a "Work Around" on Microsoft's webpage for the problem I am having. Here is a link if you are interested in checking it out: http://www.support.microsoft.com/?scid=kb;en-us;837150&spid=2533&sid=210 Thanks!! ML
  6. mlstewart

    Office XP Developer error - Needing NT SP 4.0 ver. 6 or later

    The computers have Service Pack 2 and just today went and installed any windows updates and office updates available. Thanks!!
  7. mlstewart

    Office XP Developer error - Needing NT SP 4.0 ver. 6 or later

    ok, I attempted to download to service pack but it wouldn't let me!!!???
  8. mlstewart

    Office XP Developer error - Needing NT SP 4.0 ver. 6 or later

    My question here is.. Why will someone with a computer with Windows XP that doesn't ever connect to a server need the NT service pack?????
  9. mlstewart

    Office XP Developer error - Needing NT SP 4.0 ver. 6 or later

    I was hoping someone knew a way around this. Both computers that are giving the message are fairly new computers so I was suprised by the message. I was hoping someone knew more about the packaging wizard and knew something I could include when I packaged the database that would prevent this...
  10. mlstewart

    Office XP Developer error - Needing NT SP 4.0 ver. 6 or later

    I've packaged a database using Office XP Developer. It installs perfectly on some computers but on a couple of computers it won't install because it says that the user needs NT 4.0 Service Pack 6 or later. Does anyone have any suggestions or know a way around this? I'm a XP Developer beginner...
  11. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    Well, I fixed the =Trim problem I was having. I simply took Trim out. Instead of typing =Trim([StreetAddress]&", "&[City]&" "&[Zip]) I typed =([StreetAddress]&", "&[City]&" "&[Zip]) and that is working perfectly now. However, I still haven't figured out why I can't save the database as...
  12. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    RoyVidar, I used your suggestion and it took care of the compile error. That must have been the only problem because I am not getting any compile errors at all now. However, when I try to save it as a MDE, I get the message "Microsoft Access was unable to create an MDE database. Any ideas on...
  13. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    Here is an example here: This is the code for a button that closes the database. All I did was create the button and used the Macro builder for the OnClick property to create the Macro and the only thing in the macro is Quit which is set to exit. Private Sub EXIT_DATABASE_Click() On Error...
  14. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    That is my problem - it isn't compiling correctly. I haven't had time to set down with it to figure out what is wrong and try to fix it. I am a little confused because before compiling everything worked perfectly. But when I try to compile it get compile errors. I've got some time this...
  15. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    The package is installing the the reference to the other database I was refering to. This is very new to me so I am learning. Thanks ML
  16. mlstewart

    =Trim problem

    Ok, I will try that. I will let you know it turns out. Thanks, ML
  17. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    Currently I am distributing an mdb file because when I try to save it as an mde file I get a message saying that it can save the file as an mde. I haven't had time to fiddle with it to figure out the problem. I've got other security features set up so that the user can use the shift bypass as...
  18. mlstewart

    =Trim problem using the packaging wizard in XP developer edition

    I posted this question in a different forum yesterday but have had only one reply. I need help fast with this one so I am posting in here as well. I've included the only reply I've gotten as well. I've created a database where I use the Trim feature quite a bit (especially in mailing...
  19. mlstewart

    =Trim problem

    No, I am not sure. That was my first time ever using it. Do you have any suggestions or advice? Thanks, ML
  20. mlstewart

    =Trim problem

    I've created a database where I use the Trim feature quite a bit (especially in mailing address). Everything was working perfectly. I packaged the database with a run-time version of Access using the packaging wizard in the XP developer's edition. Now, it is like Access doesn't recognize...

Part and Inventory Search

Back
Top