Recent content by baudouxnorthrup

Hi, did you ever figure this out? I am in need of the same information?

Help, I have created a very nice Access 2000 database. Now, the boss wants me to work in FrontPage, and create a results page to return a report within the database. I am not sure how to do that. I have created db within FrontPage before, but never tried to access a report from a outside db...

I guess I didn't explain really well. I have this look up file that has data: company container product price ABC drum 6240 .005 DEF pack 6118 .007 In my spreadsheet that I want to create the formula it has: company container...

My boss has an excel spreadsheet, and he has created a look up table for it. What he wants me to created a statement that will look at a6 and if it is "xxx" AND if b6 is "bbb" AND if c6 is "ccc", then he wants it to look at d6 and return that value. The problem is...

Is there such a thing as IF Then statements in Access? I am creating a db from an elaborate Excel Spreadsheet. This has a field, probability of success, which is either 100, 80, 50 or 10. The person then used fields to assign 100 a rate of 9, 80-6, 50-3 and 10-0. How do I write an expression...

What do I do with it? Do I put it in a macro in my db to find the UNC?

Rick39......I think the UNC path thing is my problem. How do I find what my UNC path should be so I can send out instructions for others to set up their own shortcuts? This bit of info may be the lifesaver of the day for me. My performance review is at 1pm today. Nothing would be greater...

FancyPrairie, how do I check his references on his PC? I also have my coop who cannot access the linked db.

I created a db for incidents. Because there is alot of users and our managers want to be able to view reports frequently, I created a 2nd db that links the maintable from the original db. In this new db, I created a report that lists current day and 3 subsequent days worth of incident reports...

Thanks to all who responded. I got it to work now and am very happy and very grateful to the folks who responded.

I need to create a query that will give me information for the current date plus the 3 previous days. I tried to use the current date expression -1 AND -2 and -3 but that didn't work. How do I set up my query to return current date, and the 3 days prior to that. Thanks so much!!

I have this database of incidents within a chemical plant. The security folks input each incident into the database and generate a full report for each incident. Every incident report goes to the plant manager, environmental manager and safety manager....so, in essence if we have 20 incidents...

I have my tables: Customers, Orders, Materials, I also have created a mainform that is called orders. In this mainform Orders, I have customerID along with OrderID, and then it lists Matl1, Matl2, Matl3...and so on. In this form I can select my customer and create an order # and then input each...

Okay, I can set this up to the point of creating the subform to capture each item ordered. If my mainform sections are customerID and OrderNo, then the subform needs to be items, but how? When I go to click on subform, it gives me an unbound form and it gets me nowhere. Can you tell I am in...

OK, so now that I have that, how do I set up my form when they order? I keep thinking item1 item2 item3, but in reality I need the report or query to look up item# ...so I guess I want the form to be something like this: order # item item item item instead of item1, item2?