Recent content by DavSam

At long last and a few additional gray hairs later, everything is working great. The boss was surprised that the project was completed ahead of schedule. Thank all of you for all of your guidance and help; I couldn't have done it without you. You're all the best!!

At long last and adding a few more gray hairs, it's working like a charm (and my wife says I'm not trainable...). Thank you all for all your help, I couldn't have done it without you.

Thanks for the help. Being a VB and Access newbie, how do I run a validation on it? I've noticed a 'validation' option on the form fields, but shied away because I had no idea how to use it.

Hi All, Being a newbie to VB, I'm not sure this is the right area for this post, but I'm putting it out there anyway. I have a REMOVE command button that removes a record from a table when clicked. What is supposed to happen is that when the button is clicked, the record gets removed from one...

Thanks, GP. Good advice. The only reason I was going this route is that the customer already had a system in place, but was using SEVERAL (I do mean several) workbooks to accomplish their tasks. As you can guess, it was getting out of control and they asked me to help consolidate all their...

GaryPanic, Thanks for the help. I got the query working, finally. Now my problem is that the workbook that the query is populating is used to populate another workbook, but I keep getting an error (#NA!), in the second workbook, when I try to use the two workbooks. You're right, I use Access...

NBVC, You are correct. The initial sheet,let's call it query sheet, works fine. The other sheet, in another workbook, is the problem. I'm using INDEX and MATCH to pull in the data from query sheet. For example: IF($B12 =...

NBVC, Yes, I tried that, but when I try to use the other spreadsheet I still get the #NA error in the cells where the info pulled from the first spreadsheet is supposed to go. I have it to where the query gets refreshed when the spreadsheet with the query gets refreshed when the sheet is...

Greetings, I have an Excel query that accesses an Access table to maintain a spreadsheet. In addition, the aforementioned spreadsheet is supposed to help populate another spreadsheet. Here's the problem: for some reason the link betweeen the two spreadsheets doesn't play well with the query...

Thanks GaryPanic. I tried that already without success. I did notice that when the 'Choose Data Source' window popped up that the choice for MS Access97 was not sharable. Even though I chose the other Access choice, it still didn't work. any other suggestions? Thanks again.

HELP!! I'm creating my first database, so I am a true beginner. We are using Access97 and I am trying to link a table to an Excel2003 worksheet. Is this even possible? I have tried using the Query Wizard in Excel with no success and am at a complete loss as to what to do next. Any assistance...

Hello Everyone, this my first post and just so you know, I have VERY limited knowledge of Access. I am trying my hand at creating my first database. Unfortunately, we are still using Access97; hopefully we will migrate to the newer version as we have with all the other MSOffice apps. Please...