Recent content by richard05

  1. R

    Run Time Error 3709: The Search Key was not found in any Record

    Yeah it was originally a text field. Cheers for the other suggestions, it was frying my head to why wasn't working.
  2. R

    Run Time Error 3709: The Search Key was not found in any Record

    SOLVED: Changed the data type of the field, which sorted the issue.
  3. R

    Run Time Error 3709: The Search Key was not found in any Record

    Hello I have a problem with the following code, and hope if someone could give me some guidance, to where I am going wrong. Basically I am looking to filter the variable "YearsInJob" by allowing user to enter a value less than or equal to whatever value is entered into the textbox. If Not...
  4. R

    vs.net download

    Here a Link to free Visal Studio 2005 sp1 not completely sure if works, but worth a try. http://download.cnet.com/Visual-Studio-2005-SP1/3000-10250_4-10618634.html
  5. R

    Java Script help

    Here is a similar working piece of code of what you are looking it to do <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>Store prompt input in...
  6. R

    Query: Retrieve Invoices between certain dates

    I did try to use the public function but the following error message kept coming up: The SELECT Statement includes a reserved word or an argument name that is misspelled or missing, or punctuation is incorrect Here is the code that I entered: SELECT [Capital Expenditure].[Invoice Number]...
  7. R

    Query: Retrieve Invoices between certain dates

    Thanks for posting back so quick, however the function statement is not going as expected. I have also tried to use CASE statement as well however error message keeps appearing as syntax error SELECT [Capital Expenditure].[Invoice Number], [Capital Expenditure].[Order Number], [Capital...
  8. R

    Query: Retrieve Invoices between certain dates

    Hey was wondering if someone would be able to direct me down the right path I am trying to tie invoices within a date range as so: Year 08 = 1/4/08-31/3/09 Year 09 = 1/4/09-31/3/10 Year 10 = 1/4/10-31/3/11 So far have managed to match invoices within year 08 as can see from the "WHERE"...
  9. R

    Login form help

    When you mention case select, am I suppose to lay as shown below, (not to familiar with case select) DoCmd.Close acForm, "frmLogon", acSaveNo Select Case employee Case Richard DoCmd.OpenForm "Main Menu" Case John DoCmd.OpenForm "Capital...
  10. R

    Login form help

    Basically I have used a login template that was off the internet, I am trying to alter so different form opens per different user such as the admin will go straight to the main menu page (which is currently at now for all users as can see from code below) and then for a lower level user it...
See more
Back
Top Bottom