Search results

Yeah but, no but, yeah but..... Yep - thort about using a query but it always seems a pain going backwards and forwards when maybe a one liner would do it. It works a treat for the sequence (which could have been done in a query)....

I have some very simple code on a button on a form to sorts my data by company name. But as some of my data is for friends, I want to be able to add a line in that looks at the "Category" field and only includes those that are a "business". Can I do this.....?? So some sort of filter...

Doh Tried that first so either there isnt one or I used the wrong keywords :rolleyes:

I want to send a variable e-mail to a number of people based up the data in my table. How do i get the email address data from the table/query into the To;- address in the outlook email ??? I am using access 97. :confused:

yep - here the thinking behind it I am monitoring a machine that records the speed every minute when it is running. There are no records for when it is stopped. Excell is excelent when the timeframe is days to show the gaps but doesnt work with minutes. So i decided to create two tables...

I wan to create a table with a date / time starting at a specific time and then added a number of records with each record being a minute later than the first. The starting point could be hard coded or by user entry and the loop would run for a certain number of times ..... Any ideas on how...

how about this then Thanks I have set up a table with minute intervals for a number of days (loads of records) and then used a query to link the times when the machine is running. Painfull but does show a bar for the speed every minute. Is there an easy way to set up a table with default...

I have some machine data to display showing running speeds. This is logged every minute when the machine is running but not when stopped. how do I display a bar graph with a timescale along the bottom of minutes showing gaps when the mchine is down. :confused:

How do I put a date into a number format i.e. 34567 - I want to create a sort / grouping field in a report using date and another number (345) to create 34567.345

mmmm probably expalins why I could work not it out. Not sure how to do it within Queries Unless I can create a new field that is used both for grouping and sorting and add this to each record. That gives me a thought - not very elegant but

I want to group records by a field but sort the groups by a record WITHIN the group. The example is that I wish to group the interviews I have had by the company and then sort these by the most recent individual interview so that the most recent Group for the same company is at the top. hope...

but :eek: errr oopps :rolleyes: the year bit helps but The original question was to try and get the graph to show how many records per week. Which suggests that the "period" on the graph could be any length and that there may be weeks with no records. Anyway I've now got a list of how many...

Closer Thanks that gets a week number but how does it tell which year it is ?? and how to get a zero reading for any weeks with no records. and on the graph I need to show a "date" ie. a Monday. Getting closer

and..... Is there a calculation that totals by week ?? If so whatis it and where does it go in the query?? :confused:

[FONT=Arial] I have a table with a number of records. Each record has a date in it. I wish to display a graph showing how many records were created each week. What is the easiest way to do this ??

Getting closer 1) got the hang of this bit. Do you know how to put a carrage return into the text - is there a special character?? 2) The [] made no difference - it still truncated the long e-mail address. 3) This puts an Access report as an attachment - do you know how to attach a file...

I have a summary form with multiple records. I open a "detail" form and update the information but when I close the "detail" form and return to the summary form the old data still shows. If I close and reopen then is refreshes. How do I ensure that the lastest data is shown on the summary...

Nearly 1) More text in the body - could even be a Word document or txt file etc. 2) i've added the [ ] 3) In the DoCmd.SendObject acSendReport, YourNameOfTheDocument, "PreferredFormatYouChoose",strEmail, , , "E-mail message", "Adrian" Is the "YourNameOfTheDocument" an access report or...

Ouch Thanks but the list is errr miles long and loads of the content goes zipping over my head. However I've got this far:- Private Sub Text36_DblClick(Cancel As Integer) Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("qry E-mail")...

I have a database with a number of names and e-mail addresses. Based on a query to select a sub set of these, I want to send out an e-mail to them all - but with limited "mail shot" features - such as "Dear xyz" rather than a general "Dear Sir," What is the best way for access to fire off...