Recent content by HacH

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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