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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.