Search results for query: *

I am working on a Windows 2000 box with SQL Server 2000. I have a DTS package that I want to create that I want to run the first of every month. The goal I am trying to achieve is that I want it to automatically name the table I am copying with the day before's date. So, if I was running it...

Hello All! I have a very simple query in Access 2000 that I run a search form off of, with the end result being a report. The form searches for From Date, To Date and GL#. The GL# is entered into the database by the users as 0000-0000-000 (except with numbers of course). But, now they only...

Thank you SOOOO much, Remou, that worked PERFECTLY! You saved the day! TheAceMan1 - homework? Wow... college was so long ago.. I'm a Database Analyst who hasn't used Access for years.

That works, but how about if I had three of them, like membernumber, vendorname and assetnumber? Then how would I state it?

This seemed so easy to me when it came up and a suggestion and now that I have tried actually doing it, I can't figure it out! I have a "search" form and it is a search by last name. I have 5 forms but they all are pulling from one table. So, I have one main table behind this one search form...

Ok, so everything is working great except one little thing. Its not pulling up the EXACT record I want, I know you wanted me to put a "wherecondition" in there but I am not sure how to state it correctly, as everything I have tried doesn't work. So... lets say that Brad Pitt, Tom Cruise and...

Great! Thank you! I think that worked... one more question, how do I get that search form to close after I click on the record I want?

Yay! That worked.. except I have one more question because I'm a dork and forgot to mention, that I am doing a search on a "Member Name" also, so the form looks a little like this: "member name" "formtype" Brad Pitt Back Office Tom Cruise Assets...

I have a button for a search form I made and I am very VERY new to writing in VB. In the “On Click” event procedure, I want to do an If Then Else statement, like this: If [FormType] = “Back Office” then OPEN frm Main Else If [FormType] = “Accounts Payable” then OPEN frmAccounts Payable Else If...

I have a database that I am creating in Access 2000. I have 1 Main table and 5 different forms that provide data to this “Main” table. Lets say the tables are BackOffice, AcctsPayable, Assets, DollarLoss, and FeeLoss. Also, within the Main table, I have a field called “FormType” and that is...

Try these link, these might work on yor 98. http://forums1.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=117595

You can do two things, One, you said that you are getting a new system? when you get the new system, slave the drive that does not work to the new system and you will pull out the important data that you do not want to loose. Two, you can boot the system with the os cd and run repair windows...

Hi, I work for a small credit union. I am trying to create a formula for a report that summarizes our loan underwriters' response times. The data needs to be limited to applications from only 2 out of several underwriters and must contain all status records for those applications that are...

Thank you soooooo much. It worked! ~ Melissa ~

HELP!! I have a report that I have created and am running into ONE problem. I have this field called "StopCode" (which contains many values). I have another field called "StopCodePos" which stands for what the position of the StopCode is.. as in 1 or 2. So, right now it...

Thanks, but that didn't seem to work either. I tried it with a Left Outer Join and a Right Outer Join. I am still in need of help. Does anyone think that it could really be something with my linking? ~ Melissa ~

Thanks for the tip, but it still isn't working.. :( Thank you though. I'll try to figure something out. ~ Melissa ~

I need HELP!!!! I have 2 fields I need information for and the report is showing only info that is from both tables - for example: I have a field for "Joint Names" and "Legal Names" - It's only showing records where both are true. How do I get the records to show that just...

Thank you so much, that worked making a fake page header! Thank you!!!

Thank you so much.. Not what I wanted to hear, but thank you. Also, where do I find that article? (Sorry, I am new to this!!!) :)