Search results for query: *

I found it ..thanks.

I have done a lot of searches here but couldn't find my answer. I appolgise if it's been asked before. Does XP operating system include the system.mdw file? if so where should it be located. I tried searching after I installed Access 2000 but could not still find it. Here's my problem, I have...

Thanks Ronni, I'll give it a try and let you know how it works... I think I understand what you mean but will only be sure after I try it. Tekay

I am using system.mdw on a network drive to handle security for my access database in access2000. Users login when using any of my databases so I can track their changes. Some users, have other databases in their local machine that do not require login. However, when they try to access these...

Thank you guys very much..you have given me a lot to work with now. lespaul, nice! Golom, I do not know how to write codes, that's why I was asking for a template. I like you suggestions about the stock db and the sold db etc. I know how to do those and I also know how to do the sales table to...

Is there a database application template for access 2000/02 to sell unique items? I need to setup a database to sell unique items#'s (like plots of land) and to make sure that I do not sell the item to more that one person. Also, after I sell the item, how do I lock the entry so it does not...

Thank you guys. I finally convinced our Corporate guys that what I was suggesting to them all the time was the culprit. Yep, it was the anti virus. According to CA, when etrust scans the MDB file, it 'tags' the file to say that it's done. My guess is that Access tries to make sense of that tag...

I have 2 backend database files that are getting corrupted every 1/2 hr or so. This has been going on for the last 3 weeks or so. What has changes is: (a) Corporate installed E-Trust Anti virus (b) Corporate installed a ton of Microsoft patches. I have the databases over the network being...

Tom, You wouldn't believe it, with your righ guidance and while trying to make an error free sample database to send to you, I finally got it! It was indeed a sub-report that was required along with multiple queries. There is stil hope for us part-time developers yet! of course with you guys...

Tom, That's what you get from us 'part timers'. I can understand the reason for your dead end. If you don't mind, I will find some time later today and reconstruct the database the way it works now..sorry, I tried to keep it lean so as not to send you a huge file. I'll make sure it all runs...

Tom Can't thank you enough..have sent you an email with more details. Tekay

Here you go Tom, Thanks for sticking with this for me..I am starting to see that the error looks to be at the query end. Still don't know how to fix it though. I viewed the result of the query and saw the double entries. Thanks again bud! Tekay ----------------------------------- SELECT [Bill...

I have never considered sub reports, don't know the benefit. all this is in one report. Also don't know benefit of union query.. I am just a part time in-house developer with some 'user' knowledge and some desire to make some tools for my job so I am not working with much.. If you can show me...

Tbanks Tom, (my namesake). Actually, I find it very difficult to accuraely describe the problem. But let me try again. I have several cost that is related to one item (itemA) and I have several components that are related to the same item. I created a Query to link all this up and it works fine...

I have been stuck on a report issue that I can't find the answer for. I am working on a manufacturing database. I have an item table that is linked to a b.o.m. (bill of materials) and then to a factory cost quote table. A typical scenario is that itemA will require two or more components from...

He HomeAlone,..I gave you a star..

Thanks guys!.. I tried to reply a few mins ago but it didn't work I used HomeAlone's solution and it worked great.. Tekay

Hi, I have tried posting this before without success. I appologise if I am repeating myself but I am assuming that I did not explain my problem properly befor. I have a Main form that requires a shipped quantity from a subform to calculate what's left to ship. When I initially key a NEW...

Why not create a MAIN MENU button in each of your switchboard menus. That way, when you send the user back to the menu, they take the Main Menu option.. Hope this makes sense from a newbie.. Tekay

Please help..I am stuck at this last juncture to finish my project... Thanks.