Search results for query: *

I would like to select a date on a calendar and go back 75 days from the date selected and show every Tuesday, Thursday and Saturday in the 75 day range. I would like to see the actual date of each Tue. Thur. & Sat. Please advise and thanks. I am using MS Excel 2003.

I am wanting to use criteria in a query that will allow me to filter data based on a date range like: >25 days but <50 day. I possibly would like to see data that is more than 25 days old but less than 50 or more than 50 and less than 75, etc. This would be based on a "StartWaterDate" field...

I am trying to track vegetables that I will be planting in my garden. I will plant some vegetables. I have a StartDate and HarvestDate and EstimatedHarvestDate Fields. I also have a field named GrowDays. This field states how long it takes for each vegetable to mature i.e. 75 days or 58 days or...

I am a tennis coach at a local college. What I am trying to do using access is: I want to enter my players names, classes and class time. That way I can find out when a player is available for practice. I do not know how to accomplish this. Classes start at 8am and end at 5pm. They are usually...

I need to create a table to store tennis match information. I then need to create a form to enter the data. I can do all of this but I am having some issues with my thought process. There will be multiple matches (10?) during the season. For each college match there will be 6 singles matches and...

I am a College tennis coach. I am in need of a query that will show me all of my scheduled matches for this Spring. I can do that with my "Team Schedule Table". What I really need is to be able to show all of may scheduled matches and then the dates that I do not have a match scheduled between...

The SQL Code below is a combination of 3 queries. The 2nd SQL Code below is one of the 3 queries that make up the 1st SQL Code. The PossibleCause Field of the 2nd query criteria is "out of stock". The combined query below is based on a date range. I have been asked if the dates in the...

Below is the SQL code I am using on a query. This query is counting Safes, UnSafes, Totals and then giving the pct of Safes. It kind of works. My issues are as follows: Everthing that is being counted are yes/no Check Boxes so the totals are showing up as -17 or -22 etc etc. I would like for...

Below is the code that I have on a comboBox AfterUpdate Event. It runs a query and uses the value of Distinct Behavior for the criteria. The Distinct Behaviors dropdown is based on what is slected from a Dropdown from a Distinct Categories ComboBox. What I would like is to run a specific Query...

Below is the code I have on a print command button on my form. No matter what printer I have selected the form will only print to a certain printer? It used to print to the selected printer and now just to one printer. Any advice or suggestions? I have added a new command button to print current...

I had an earlier posting and kind of added close form to the other posting but am making it its own post now. I have a Calendar Control on a form DateFrm see code below: I cannot close the DateFrm from the CalEnd_Exit. Any advice on how to accomplish this? After the code from the Calendar...

I currently have a query that requires me to input a date. Because the query is attached to a table that has the date as 2008-01-31 I need some help. I am trying to select the date from a Calendar 11 control and the Calendar inputs the date as 1/31/2008. What I want is as follows: I click a...

Below is the SQL I have for a query. One of the Fields is Replaces. I need this field and here is my question. If this field has anything but xld I would like for it to show as blank. Can this be done? If so, how can I accomplish this? SELECT ECNPartstbl.[Part #], ECNPartstbl.Resp...

In Access 2003 you can have a form open and Click: File Send To Mail Recipient as Adobe Pdf. That works good. I have been asked to see if we cannot accomplish the same thing from a Command Button on the Form. Anyone got any ideas? I have researched and searched and have not been able to come...

I have a query (A) that when run requires a date to be entered. No Problem there. That same query is part of another query and when Query (B) is run it wants the date to be entered again because Query (A) is part of Query (B). Is there a way to not have to enter the date for Query (A) when Query...

I have a table with Part Numbers and a Qty. The Part Number can be in the table multiple times with different quantity's. What I would like is to have a query that will show the Part Number one time and total of all the Different Quantity's. I am stumped. How can I total up the Quantity for...

I would like to update certain fields on two different tables from one form. I would like to have a dropdown to select a part number and then update related fields to that part number while not adding the part number again to the tables. I just want to update certain fields of that part number...

Can anyone tell me why my Excel sheets will no longer maximize? It just started happening and even if I hit the maximize button the sheet will not maximize.

Below is the code I have for a query in my database. The top one is how it starts out and the bottom one is how it ends up. My understanding is this is a known issue in ACCESS. My problem is how to fix this so I do not have to keep going in and removing the brackets everytime I have to change...

I have four databases and email reports from each one of them utilizing command buttons and code. My question is: Can I be in one database and send reports from another database? I hope that makes sense.