Search results

Hi guys, I have a situation where clients have certain items issued out to them on a certain regular basis. I have a form which sets these frequencies so for example documents a,b,c are issued monthly,weekly,qtrly respectiviely I also need a log which tracks when and how these documents are...

Yep, Having a bit of trouble with this can you post that code. Very much appreciated Cheers Paul

Hi Guys, It's been a few months since I've used the forum as i've been doing some outlook development work. I've now sarted linking my access program to outlook in a big way. One thing I can't find and I'm not sure how to do is run a check to see if my database is open and running with code...

This is really quick but I'm having trouble with this. Can any one explain in simple terms why a query with joins will suddenly become non updateable... I have some queries I'm sure should work but I'm missing something I'm sure. Hope someone can summarise it simply if that's possible...

Hi guys, Happy easter. (If you're of that persuasion) I'm trying to extract the 1st day of the week for each week number on a report. Ie I have 10 records in week 14, 5 records in week 15 and 3 records in week 16. I now want access to tell me which weeks these are in 'English' e.g. week 14...

Hi guys, ******* QUICKIE ******* I can get a menu bar to run macros, but how do I attach more complex code to the action event of a menu bar. Can you do this? CHeers PAUL

Hi guys, I'm using Access to send email and add appointments to outlook diaries. All works fine apart from when I'm trying to reference an anoth users Outlook folder across a workgroup. The follwoing code gives teh error : "Method or data member not found" My references are set to outlook...

Hi guys I have 3 separate queries which count the number of entries in a data set depending on set parameters. I have a summary query which simply collates the three queries counts and is the basis for a report. Problem occurs when if one of the three individual queries returns no value the sum...

Harry, I have that reference checked... could it be something else??? cheers Paul

Hi guys, I have code which I use to update a set of records. The code used to work fine previously but now I'm getting "Compile error, Automation error" and my DIM dbs As Database statement highlighted by the de-bugger. Do i have a referencing probelem or is it something else. the code has...

Hi guys Is there any reason why a report should loose an OLE chart when published from access to word. How can I get my report to export the chart and the text...Any ideas... Cheers paul

Hi guys, problem that I need to know if it's possible to do. Situation is that I have one access database which updates appointments in outlook and send emails through the outlook account running in the background (Working through a workgroup of a network) What I need to be able to do is...

Hi guys, I have two problems... 1) I have a query report with 8 summation columns for assets is areas ie deposit____equity_____ etc... 343_______231______ etc... I want to create a pie chart showing what proportion of the whole each of these columns makes up. I can create a chart when...

THANKS GUYS.... Things seem to be working OK... very much appreciated... PAUL

I THINK that I just solved this myself by setting the format: AND (Data_Basedata.promdate)= #" & Format([Forms]![Form-basedata-quick-update].[control1], "mm/dd/yy") & "#") Cheers

Hi guys... Similar to my earlier problem... If I put the following SQL into a QEB SELECT Data_Basedata.* FROM Data_Basedata WHERE (((Data_Basedata.Surname) Is Not Null) AND ((Data_Basedata.promdate)=#12/17/2001#)); The QEB changes the date 12/17/2001 to #17/12/01#... Why? Cheers Paul

Practically there Jack! That works as a statement but I use the UK date format. The wierd thing is that the sql statement returns the recordset of my UK dates only when I enter the US format as the control i.e return all records for 10/11/01 will work if I set my control variable to 11/10/01...

CPOD... That was alot of help and I managed to sort out both text and numeric concatenated sql. However I can't get it right for my date fields. I know I've got to include # but I tried below to no avail, constantly getting "List Separator errors" etc. Does anyone have any ideas on the...

I have a record set on which I'm using code with Loop and EOF to through each record and change a boolean tag on or off. This seems to work... Dim dbs As Database Dim rst As Recordset Dim retvalue As String On Error Resume Next Set dbs = CurrentDb Set rst = dbs.OpenRecordset(rsource)...

Raskew... What a guy/gal I new it was simple. My Query understanding is getting better.... Thanks Paul