Search results

  1. J

    Link Access query to Word document

    Is it possible to link a field in Access to a footer in Word? I have a field in Access that would look like the following; G10E-PRO-001RevA Additional data in access would have the document name, and revision, matching 2 lines of text in Word. I would like the footer in the document to be...
  2. J

    Gridlines that can grow

    I have 10 fields in a report, all with thin solid lines around each field to form a grid (similar to an Excel spreadsheet). Most of the fields will never grow as the data is something simple (date, yes/no etc), however a couple fields are allowed to grow depending on how much text is in them...
  3. J

    automatic calculation of date differences

    Hoping someone can help, again! The project I'm working on is an action list with the following tables; itemnumber - autonumber PK originator - text dateentered - date/time actiondescription - text assignedto - text targetdate - date/time forecastdate - date/time actual date - date/time...
  4. J

    Hyperlinks

    Is it possible to follow a hyperlink to a file without using a file extension? I have links being created based on the name of a file, but because I haven't used a file extension it crashes. I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's...
  5. J

    Opening a form from a form in a different DB

    Is there a way to open a form from a form in a different database? I'm pretty sure it needs to be done in VBA and have seen some code floating around that suggests it can be done, but I'm thinking there's more to it, like maybe one or both of the DB's need to be in a different format? Thanks
  6. J

    Using a subform for multiple entries in main record

    I think I'm on the right track with using a subform, but could use some guidance. I have a form that tracks job assignments, and I need to have the ability to have multiple services assigned to each job. I'm assuming that a subform is the way to go as some jobs may only have one service on them...
  7. J

    Question Problem with Select statement on form

    Kind of a wierd problem using the Select statement on a form; I have it looking up 3 fields, Ordered by the first and bound by the first.the other 2 are being stored in different fields. What is weird is that I need to have the first field entered twice in order for it to show up, which means...
  8. J

    Linked Tables

    Onto my next problem :) I have one DB that is used for creating/storing customer ID's, and another DB that is used for creating/storing job information for customers. I have linked the table from the customer DB to the job DB. There is a table in the job database that holds customer name...
  9. J

    Question Auto generate unique customer ID's

    Hello, hope someone can help me this problem. I am in the process of creating a DB for customer names, job numbers and document numbers, but have run into a problem right from the start. We are using a naming convention of the first 3 letters of the customer name, and 3 numbers after that. Eg...
Back
Top Bottom