Search results

Dropdown Filter Forms I’m working on building a form that has the ability to create and print a report based on the filter’s you pick. Example: Say you have a form with five dropdown boxes Dropdown 1: VP’s Name Dropdown 2: Manage <-at this drop down you will only see the Managers who...

Hello everyone. I’m looking for some advice on the best way to automate a database to do two things. 1. A very quick repair, just to make sure everything is in line. 2. An automatic Compact and Repair. 3. Make backups within a created folder “example (My Documents) Ultimately I would like it...

I’m looking for a Microsoft Access Database that is made to work very good with Microsoft Outlook. The main reason for this database will be for customer contact information and day to day communication with the customer. I know Microsoft access has a very simple temple like this but I was...

Why am I getting this error message? Invalid bracketing of name This is what I have: Feild Name: 2ndQty Table: Temp This is what I tryied - [Temp_ElectronicCustomers.RcvdQty] and [Temp_ElectronicCustomers]![RcvdQty] Corey

Thanks for looking at this for me. Below are the three query's query1: SELECT Temp_Summary.CustNb, Min(Temp_Summary.OrdrNb) AS FirstOrdrNb, Min(Temp_Summary.Class) AS Class_1 FROM Temp_Summary GROUP BY Temp_Summary.CustNb ORDER BY Temp_Summary.CustNb, Min(Temp_Summary.OrdrNb); query2...

I think we almost have it completed. I have attached a small sample db. Could you please review and let me know why I'm getting the error messages and I'm not sure why it's not working Thank you

Under "Class". If there is a 15 then it's a electronic item

but how would I handle the code "Where tblOrderDetails.ProductID In(.....);

Hi again Pat, Thank you for helping me figure this thing out. I attached a spread sheet to help myself and you “if you need to” visualize what the data I have looks like and what I'm shooting for. Thanks again. Corey

Pat, Thank you very much for walking me through this. I'm not understanding what the ProductID stands for, and the last line in the 2 query: "Where tblOrderDetails.ProductID In(.....); <---- the list of IDs you are looking for"

I have a list of customers that I am trying to find out which ones have purchased Electronics first, and then show they’re next purchases. I’m hoping I can get some help or some ideas as to how I can do this. I have a list of some 9000 customers. The attached list shows what the data looks...

Hello everyone I’m trying to find a way to convert a UNIX timestamp to the standers universal timestamp. At this point I can’t even make sense of the UNIX time stamping system. I would like to be able to use Microsoft access to do the conversion. Does anyone one a why to convert the UNIX...

Hello everyone. I’m looking for some help being able to let the end user enter there own dates. I currently have it set up in a query like this “[Please enter date]”. I would like to let them be able to enter a start date and an end date. Can anyone help me with this one? Thanks Corey

Thanks Rickster

Hello again. I’m trying to find a way in a query to remove any data except for numbers Examples NET 90 NET 10 NET 10 DAYS NET 110 NET 15 Any help would be greatly appreciated Corey