Recent content by mlstewart

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!

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

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

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

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

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

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

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?????

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

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

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

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

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

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

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