Search results for query: *

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...

Thanks for the help the problem remains that this code returns the id of the unit that I am copying from – I want to obtain the id of the newly created unit? I should mention that unit appears as a subform of another form so that when the new record is created it does not appear since it is...

Thanks Remou If I use "me.nameofunitkey" it returns the id of the record that I am copying from, I guess I could increment this by one to get the id of the new record, but is there a better way, I am doing this via an insert statement so I do not have a reference to the new record to retreive...

When I double click on a record within my data sub sheet form a duplicate record is created. Access seems to allocate a new (auto number) for the key of the new record. I need to get hold of that key for the newly created record. In order that I can connect table units to another related...

My database has two tables, units and components. Units and components have a M:M relationship and are linked through a junction table. I have created a form where unit and components are shown as datasheets. If you click on a unit the corresponding components are shown on the component...

I have created a blank form, I’ve dragged two sub forms onto this, these have a many to many relationship. The two sub forms are shown in data view. I want to synchronize the action of the two sub forms, so that when a selection is made in the first the relevant entries are shown in the...