Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ugly
  • Content: Threads
  • Order by date
  1. ugly

    polpulating field lists

    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...
    • ugly
    • Thread
    • Replies: 1
    • Forum: MySQL
  2. ugly

    Integrating text and background

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

    unwanted strip of blue

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

    How to define and apply a global border width and colour

    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...
    • ugly
    • Thread
    • Replies: 2
    • Forum: Adobe
  5. ugly

    Unable to split date string in access?

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

    problem printing booklet

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

    setting new record as 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?
  8. ugly

    intercepting copy row action in datasheet view

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

    query cannot see integer value

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

    Finding key for newly created record

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

    copying over sibling records in datasheet view?

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

    Synchronizing two sub forms with a many to many relationship.

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

    cannot include two M:M relationships within same form

    My db has three tables: drawing, unit, and component. A unit is based on a drawing and a unit has components. Drawing to unit is M:M as is unit to component. I inserted two junction tables and that appears to work fine. I want to show data from all 3 tables on the same form by using the form...
  14. ugly

    populate list box dynamically from selected value

    My form has two combo boxes, combo6 and combo7. Combo6 contains a list of values when the user clicks an entry the following code runs. I have previously created a stub query called duff. All this works fine the query opens with the correct returned results. What I would like to do ideally...
  15. ugly

    dynamic query failing

    My form has two list boxes. The user selects a value in listbox1, based on this value I would like a dynamic query to pull in the values then to populate listbox2 with them. I inserted the following code into Listbox1’s Click event Private Sub List1_Click() Dim hold As String hold =...
  16. ugly

    subform not showing

    Using the access wizard I created a form that shows units, I chose Datasheet view in order that all records could be viewed at once. A unit can have many components - so I included a sub form within my main form that gives visibilty of the components within each unit. The problem is that when...
  17. ugly

    failing to delete record

    This piece of code picks up a value from a list box and writes it to myString (that works ok). I then want to use this value to delete a corresponding value from my table called drawings. The last line in this code is failing? Thanks for any pointers. Dim myString As String Dim strSQL As...
  18. ugly

    sub form still showing

    I have a form that includes a group of 3 radio buttons. Three subforms sit on this main form and I have set their visibility property to false so that they don’t show at start up. The visibility of the subforms is controlled through the radiobuttons , I coded each radio button as follows...
  19. ugly

    To return highest issue letter within a group

    My table consists of two fields, doc and issue. The data looks like- Doc101, A Doc102, A Doc102, B Doc103, A Doc103, B Doc103, C Doc103, D I am trying to construct a query that returns the highest letter issue for each doc group. So in the case of the above data my query would return Doc101...
  20. ugly

    design issue

    My data base consists of two table: units and components. A unit can contain many components. Units require three fields to uniquely identify them, I used these three fields to form the key, I then included the same fields within components in order that I could create a one to many...

Part and Inventory Search

Back
Top