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 derfloh 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: HacH
  • Order by date
  1. HacH

    Do I need to create relationships in my database

    Thank you vacunita, I have included all the foreign keys into the tables but just wondered whether it would be useful to create the relations before or do this when setting up the queries. You have made a very good point about maintaining integrity. This answers my question. Thank you for...
  2. HacH

    Do I need to create relationships in my database

    Hi, I know this is probably a silly question but I'm trying to develop my first php/mysql website and have setup the database tables using phpmyadmin. Do I need to create the relationships in mysql or do I do that when I write my queries and build that into the queries? e.g I have a user...
    • HacH
    • Thread
    • Replies: 2
    • Forum: MySQL
  3. HacH

    Calculating working days (NetWorkdays) not working in Access

    Thank you PHV and dhookom. I spent days trying to figure out the issue but didn't find anything on the net that indicated issues with the date format. All working now.
  4. HacH

    Calculating working days (NetWorkdays) not working in Access

    Yes, I'm using UK date format of d/m/y. Is this the issue? If so, how can I convert dates in the code to US format prior to passing to the loop? Sorry, I didn't realise the issue with files. Please find below details of my test database. My test database has 2 tables and a query, as...
  5. HacH

    Calculating working days (NetWorkdays) not working in Access

    Hi, I'm having an issue calculating networkdays in Access 2007. I've read a number of threads on this forum and the VB forum and tried the sample code but cannot seem to deduct the holidays from the given dates. Please find link below to my sample Access 2007 database that I've created with 2...
  6. HacH

    Email Access 2007 Report as PDF Attachment to multiple recipients

    I have been struggling with this over the weekend but I will try and go through the link you have provided. Thank You.
  7. HacH

    Email Access 2007 Report as PDF Attachment to multiple recipients

    Hi, I have read a lot of posts in this forum but still cannot get my head around this so please forgive me if I'm asking a question that has already been answered. I have a report that provides detailed information (similar to an invoice) for multiple customers. Each customer has a unique ID...
  8. HacH

    Help with formula relative cell refernce

    Hi, Thanks for the reply. I would expect the following results, based on the data provided above: ID Grade Point ... 11 pb1 7 11 pb1 7 .. 12 ps2 3 12 ps2 2 12 ps3 2 34 pt2 9 .. 34 pt2 4 34...
  9. HacH

    Help with formula relative cell refernce

    Hi, Can somebody please help me? I have some vba code (below), which looks at all the blank cells in a selected range and populates them filling them upwards. This works fine, but I need to add an if statement to check that the ID of the cell being filled up is the same as the cell containing...
  10. HacH

    Synchronize Access DB with Excel

    Hi, I am trying to automate the process of importing data from an Excel file into Access. I am aware of the manual method that you use from the File > Get External Data options. The name of my Excel files is always the same, however the number of records in the file vary from week to week. I...
  11. HacH

    Add MS Word letter to Access Form

    Remou, Many thanks for your help on this. It's all working now. Thanks very much Mamoon
  12. HacH

    Add MS Word letter to Access Form

    Hi, Sorry about the confusion. I have read the other thread (FAQ702-2379) and have followed all the instructions. If you look at this thread, at the start there is some code, which creates the Word document and adds the text into the bookmarks. I have have made the bookmarks etc in the word...
  13. HacH

    Add MS Word letter to Access Form

    Remou, Thanks very much for your help on this. This may sound a little dumb but where do I put this code, into a module? Thank you Mamoon
  14. HacH

    Add MS Word letter to Access Form

    Hi, I'm not sure if this is possible in MS Access but any help would be much appreciated. I have created a simple form for Access. It contains contact info e.g. name address, email, telephone no etc. I know it is possible to create a mailmerge in Word. However, I was wondering if it is...
  15. HacH

    [b]Excel number format[/b]

    Hi, This may be a very basic question but it's really getting to me now as i've spent about 2hours trying to figure out what is wrong. Usually when I type a number into my excel spreadsheet e.g. 1 or 2 or 550 etc it appears in exactly the same format. However i'm not sure what setting i've...
  16. HacH

    Headings in word 2003

    Also have a look at the following as this will provide the correct structure to your headings: Format > Bullets and Numbering > Outline Numbered This allows you to select the style of numbering to use. e.g. 1 heading 1.1 sub heading 1.2 sub heading 2 heading Thanks, Mamoon
  17. HacH

    Error message in sub-form (Can't assign value to object)

    Jeff, I'm not 100% sure about what you mean by "record sources of the subforms" as I am fairly new to Access..The sources in the subforms are from the two original forms that I have developed. The first forms is "Frm-AtRiskDetails" and the second is "Frm-ContactDetails". The third form which...
  18. HacH

    Error message in sub-form (Can't assign value to object)

    Hi, I have developed a simple Access database which has two forms. I have also created a third form, which has a tab-control and the two original forms as sub-forms on it. The forms seem to work okay on their own however when I try to input a new record from the sub-form it outputs an error...
  19. HacH

    Excel - Compare two workbooks and copy data

    Hi, I have two MS Excel sheets, both with similar data but not the same. One sheet contains all employee records e.g. employee no, surname, firstname, grade, pay, hours worked etc. The other sheet contains sickness data and has details of employee number, sickness days, type of sickness etc...
  20. HacH

    Searching data in the current form (Access 97)

    Hi, I have created a a form and would like to insert a search facility that allows the user to select from a list the name/id of a person from within the form. This should then update the form fields with the selected record. I tried to use a list box but when I select a name from this list it...

Part and Inventory Search

Back
Top