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.

...Exit Function Err_WorkingDays2: Select Case Err Case Else MsgBox Err.Description Resume Exit_WorkingDays2 End Select End Function '*********** Code End ************** This is actually part of a bigger access database but, as it wasn't working in there I created this test database but...

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

...name>!<field name>)) .ActiveDocument.Bookmarks.Add Name:=<bookmark name>, Range = Selection.Range ** continue the ActiveDocument and Selection statements for each bookmark that you have on the Word Document ** Could you please explain if this code is meant to go into...

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