Search results

Thanks for all the great help once again! I will now plod through. As an old DataEase user I sometimes find Access so frustrating when you have to do such basic things. (DataEase has a cunningly named option, "enter a record in" that does this so easily) That's progress for you.

Sorry I am being stupid here but... In the append query, the only options I have are Fields Table Sort Append to Criteria or The options you have quoted only appear in the update query for me. I want to append to the field [action] the text "report run".

Must be my lack of knowledge of Access but how do I append in this way. The only way I have been able to use append is from one table to another. In this case I have a table called tbl_audit with a field called action and a field called date_actioned . I need the field action to by appended with...

Hi Rich. the problem with the update is that it only changes the one record. I want to create a new record in my audit table every time a button is pressed. I would like it to record the date using date(), who clicked the button using currentuser() and a text item such as "report has been run"...

Thanks for all the help, got it working at last!

Many thanks Pat, will give this a try. Does this command work across the database or is it form specific e.g., can I set it in an opening menu and it will work for all forms? Having switched it off, why would I want to switch it back on?

When you run an update query it normally gives you a warning message that can be disabled under TOOLS/OPTIONS/EDIT. This works fine on a PC with the full Access on, but try as I might I cannot get the warning to be disabled in run time versions of my database. Any suggestions as to how I can fix...

I have a dbase with a number of fairly simple but time critical reports (need to be run weekly, monthly etc). What I would like to do is set up an audit table with 3 fields to record when a report was run, by whom and which report. As the various reports are run a record should be created in...

Excellent, thank you very much

oops that should be 03/08/2002 (UK calender)

Just can't find the answer to this in the help. How do I show the actual day as text based on a date field value, eg date field says -3/03/2002, I would like a box to show "Monday"

Thank you all very much for your help. I finally tracked the problem down to my having a letter date field on the letter on the right of the letter but in line with one of the address fields that may be blank. So, of course it couldn't shrink. Will just have to redesign my letter so that no...

Well, I've checked and they are blank, got no data in them at all but still no joy even with field properties on the report set to can shrink and grow

I had tried creating one unbound field on the report carrying the following but I still get the blank lines =[address1] & Chr(13) & Chr(10) & [address2] & Chr(13) & Chr(10) & [address3] & Chr(13) & Chr(10) & [address4] & Chr(13) & Chr(10) & [address5] & Chr(13) & Chr(10) & [post_code]

sorry rich could you...er..expand a bit on the posting please.

I am using Access to produce letters. There are 5 address fields and 1 for postcode/zip code. Not all of my records have data in all the 5 address fields but all have a post code. In these cases the address on the letter has a gap between the address and the post code which I would like to be...

What a wonderful place this is! Many thanks all, I am glad the simpler solution prevailed as the DAO stuff had me trembling

I was kindly helped out here with a problem I had wanting to put a print button on a form so that it only prints the record on screen. The code I ended up with that works is as follows Private Sub printbutton_Click() DoCmd.OpenReport "rpt_each_property2", acPreview, ...

Many thanks for all the help, Pat cracked it! Oh for my easy days with DataEase.

Hi gurdiga, tried that and still no joy. I went to a record where both date1 and date2 had been filled in and I deleted the contents of date2, (which could happen on this system) but it would not let me passed the validation