Search results for query: *

no problem. will do.

I need to have a cell populate the subject line in an email. Here is what i am currently using to email the spreadsheet via button. ------------------------- Private Sub CommandButton2_Click() ActiveWorkbook.SendMail Recipients:="name@company.com" 'each individual file should be save to a...

Thanks for the help, I will give it a go and let you know!

I have a database and want to be able to delete all the entries in the tables with no prompt. table1 table2 table3 tried various ways with no luck. What has worked was this DoCmd.DeleteObject acTable, "table1" but this deletes the actual table and I do not want to do that, just the data in...

Ok I have been running a query off the date (for weekly, monthly, yearly checks) for an entry to find out if techs are doing there calibration checks for a certain area. What I am finding is that if you calibrate a piece of equipment twice in one month it shows up twice and causes the total to...

I will give this a try and let you know thanks

I am going to count the entries. just below on the report will be a querie that show the number that should be done. This will show that 100 of out 105 are done. I am using the date field and a yes/no box for the other part.

I am looking to show data just for each week of the year (52), one week at a time. The report will most likely be grouped with a button (12 for the year). For example Lets say the date is Jan 15th. The 1st button will run multiple queries for Jan. This will include the weekly queries (even...

Back from vacation... Any ideas how to do what this (last post).

I am looking at jan thru dec, and mon thru sunday. Going off the first monday of the year. What I would like to do is enter a date for the first monday of the year, roughly 52 weeks. I am not too familiar with while loop (but this may get 52 weeks of the year) that is how i am trying to break...

When using the datepart function or the above code cranebill described to get a weeks worth of info similar to the way between Date()-(7) works? I have tried a few ways but no luck. This also would solve my 6month issue etc... (cranebill, On the combo box, I see what you are saying)

That is where I have a problem as my sql experience, well calling it limited is being nice. I will try though. If you have a starting point that would be great. Also, is there a way to key off the week, or is it possible to convert the date into a general number the way excel can to get data...

Yeah I will use a button to populate a page/report. Here is a little background info. My corp (GP) has yearly boiler audits when encompass many areas. What I am trying to build is a page/report so the Utilities superintendent can go a check to see how each of the areas are coming along on their...

Ok That works out great. Still have a couple of issues. Is it possible to have more than one date in table1 and key off just one date, cause if I do it pulls all of them in the query. Here is what table1 looks like MonthlID MonthlyDate1ID 1 1/1/2006 2 2/1/2006 3...

I am trying to run a query that would use a date in a simple table that has 12 entries, the date for the first of each month. I want to use that date say 03/01/06 from the table and run a guery to find the entries in another table that have dates in that month. I get how to use between...

Unfortunately the text will never be the same and may be empty at times.

Is it possible to pull a specific date range from a table of dates to see if there was an entry made weekly. tblFieldTag FieldTagID WeeklyCheck (yes/no) MonthlyCheck (yes/no) tblFieldNotes FieldNotesID (autonumber) FieldTagID (This is a required field) FieldNotesDate FieldNotesText for...

Maybe this might help Is there a way to run a query or thru vba for example to get data (date) based on a given time frame 1 month for each month and not have to put in the date field in a text box?

Sorry here is what I meant. This is from a prior db searching between dates on a form that shows the query Between [Forms]![SearchfrmBeforeDate]![Text11] And [Forms]![SearchfrmBeforeDate]![Text22] expected results would be for unbound text11 '01/01/2001' and text22 '0/02/2001' this would show...

I am trying to make a report that will query for specific times of the year what has been done and what has not been done. It would key off the checklist and and type of check. tblFieldTag FieldTagID WeeklyCheck (yes/no) MonthlyCheck (yes/no) YearlyChekck (yes/no) ValveChecklist (yes/no)...