Recent content by ugly

have 3 tables: event, type, venue. A venue can have many events over time, an event will be of a certain type. So relationships exist between the 3 tables and this is represented by FK's. I wish to populate a user form with data such as a list of all available venues, all available event...

I'm overlaying text over various background textures: paper, cardboard etc. I want the text to look like an integral part of the background are there any tweaks to make this possible -thank you

My document is a 48 page (A4 each page) this will form a magazine. Numbering starts at page 1 on the third page. I exported this as a 3mm bleed PDF on top/bottom/inside/outside. Opening the PDF, page 3 is a solid blue bleed, page 2 is a white page but had picked up a blue edge presumably from...

This has been really helpful thankyou. Can I just reiterate(for others who might have a similiar problem) to combine two or more classes within a div you include the classes within the same speech marks with a space inbetween them- to combine two seperate classes called .bigtext and .textcolour...

Various elements within my page have borders applied to them. This varies according to the div and could be top or bottom or right or left. So the position of the border element can vary. What is constant is the colour and width of the border element. I have tried to define these within the...

Many thanks yes I was using 31 on a month that doesn't have 31!!! Thanks!

Hi Thanks for you help tried this but still failling Dim daystr As Date Dim daystr2 As String daystr2 = "11/02/2008" daystr = CDate(daystr2) MsgBox day(daystr) is failling here mismatch error

Unable to split date string in access? I need to split a date that is in the the form of a string, they must be declared as strings and not dates. The problem is that I cannot extract the day using day(dateStr), month(dateStr) and year(dateStr). These funtions produce a type error 13 type...

I am creating a 4 page booklet. For test purposes I only want to print Pages 2 and 3 (the centre fold). I select File>Print booklet>Range:2-3 instead of printing 2-3 indesign moves the pages to 1 and 2 ie the centre fold is split in half??

The code on adds a new record to my subform. I want to make that new record the active record.

The press of a button adds a new record to my subform (this form is in datasheet view). I want to make this newly added form the active record ie with little black arrow alongside its row-how can this be done?

when I copy a record I also copy dependant records in a related table.(I know how to do this). I just want to insert this code on a copy method for the datasheet row

I select a row RC and select copy, when the record is copied I need to perform another action in code.

My form is shown in datasheet view, I would like to intercept when the user copies a row, is this possible and how is it done

I have set up a recordset to return a query-If I write-it works fine Set ms = db.OpenRecordset("Select keyFK from authcomp where AuthorIDFK = 2 ", dbOpenDynaset) If I write it like this it does'nt work Dim holder As Integer holder = 2 Set ms = db.OpenRecordset("Select keyFK from authcomp where...