Search results for query: *

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

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

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

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

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

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