Search results for query: *

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

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

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

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

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

Hi, I am trying to produce a table in Access 97. There are 2 date fields, the first is entered by the user and I would like the second field value to be completed automatically with the value of the first field + 3 years. For example Issue_Date = 10/10/2000 then Renewal_Date should =...

Hello all, I am having a problem implementing a logout feature in my website. I have a login page, once the user logs int their userId is stored to a session var as session.addAttribute("userId", userId); upon entry to every page on my site I need to check if user is logged in (has a...

Hello All, I am new to JSP and need to create a user registration and login page. I have little bit of Java experience but not JSP. I am using Access db to hold user detials. Can anyone please help, I have no idea where to start, the work is for my university project. Thanks