Search results

Hi Rhonda I understand your problem of not being able to post the whole database. Just one question, are the queries which bring in the sheets and project numbers append or update ? (Your last response said append) Regards Norman

Hi Rhonda I have tried running your form, I cannot get any duplicates without running it more than once. Of interest though, your results table contains data in the 'sheets' and 'project number' fields yet these do not appear in any of the append queries. Also the questions table contains a...

Hi I have attached a small database which should get you started. Open the form members and go to the record you wish to print 1. Click on the 'id' field and the report will open with that record. 2. Click on the 'Title' field, the reoprt will also open with that record. 1 uses the DoCmd...

Try this link http://www.mentalis.org/tips/tip068.shtml HTH:)

If you use search for "Cascading Combo Boxes" there are a number of replies which have attached samples on this. HTH Norman

Mike This is one I used for a database, it might get you started. HTH Norman

I am using Access 97 and cannot find this error, can you be more specific. Norm

A very similar question was asked during the lasweek. Use search with 'grades' as the keyword and limit the search to 1 week or newer. The thread was by Armin . HTH Norman

Function tbalter() Dim mysql mysql = "ALTER TABLE yourtablename ADD yournewfieldname yesno;" DoCmd.RunSQL mysql End Function Note that this code has no error trapping and is very basic Search help for alter table command for more info HTH Norman

Put Jack's code in and then In the after update event of the combo box Dim rptname rptname = Me![yourcomboname] DoCmd.OpenReport rptname, acViewPreview If you want to print directly use acviewnormal HTH Norman

Hi Set the visible property of RoomType to 'no' In the after update event of the combo/list box or button, whatever is triggering the next stage If Me![YourCombo or listbox]= yourcondition Then Me!RoomType.Visible = True End If HTH Norman

Hi You can find a good example of this in the sample database "orders". The orders form has a combo box which concatenates the first and last names of the sales person and uses the query qrysalesperson to do this HTH Norman

Create a query on the table containing the two fields lets say 'a' and 'b' For the first field 'a' you can get the total by w:sum(a) Seconfd field 'b' the total would be x:sum(b) In the next column y:w-x Substitute your field names for a & b, you can call w & x & y anything you like...

Theprez Thanks for that, it's a lot easier than the access help method!

cadillac search access help for 'dirty' I think this will do what you're looking for Norman

Hi i think that it needs a space before the W of where and also before the O of order Norman

Anauz, Copy of the code would be appreciated Thanks Norman