Search results

I spent ages finding out how to add more than one attachment to an auto email, so thuoght i would just post the result here to add to the great knowledge base this forum is, hopefully to be of use to others in te future: As obvious as it seems afterwards, simply duplicate the Set...

Hi Today is 5thJan05. Why does Access think it is week 2? and how can i tell it that it is in fact week 1, which it actually is. I am using this in a query to provide a list of week numbers from a drop down box; the user then selects a week and clicks on whichever report they want to see...

Hi I need some sort of Union Join for 2 query results; What i need (and cant get) is this: I have 2 queries: query 1 user record_set_a fred 5 colin 2 tom 0 paul 3 query 2 user record_set_b fred 3 paul 0 harold 2 tom 4 and the result i need is: user reca recb fred 5 3 colin 2 0...

Hi Ok this is going to sound strange but.. One day our Time Recording System was fine. The next day the Access provided Calendar function used in the time recording form shows "Name?" and debug errs out claiming invalid use of period or ! (err 2447 i think). So i reset the references after...

very very very basic question; When constructing a query you have those fields listed on the left: FIELD, TABLE, SORT, SHOW, CRITERIA etc. How do i make TOTAL appear...?

Hi, In the standard Join Properties box you have three option: 1 Only rows where joined fields both tables are equal 2 All records from table a and only those from table b where joined fields are equal and 3 the oppiosite of 2 I have two tables matched on user where the user might have...

I maintain a Time Tracking db for office workers. They log in and select the task, billing code, number of hours per task worked etc. I need a 1 click solution for the users to enter a weeks records at a time - eg for vacation, illness or a weeks training course. Currently they have to enter a...

Hi Ok, guys; probably a simple one but its got me: I maintain a Time Tracking db for office workers. They log in and select the task, billing code, number of hours per task worked etc. I need a 1 click solution for the users to enter a weeks records at a time - eg for vacation, illness or a...