User Profile

Collapse

Profile Sidebar

Collapse
chicane
chicane
Last Activity: Jan 26 '10, 11:03 AM
Joined: Dec 8 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • chicane
    replied to Microsoft Access - Parameter Query
    Access

    thanks for the replies. I will have another shot at it using your suggestions.

    Thank you
    See more | Go to post

    Leave a comment:


  • chicane
    started a topic Microsoft Access - Parameter Query

    Microsoft Access - Parameter Query

    I am currently writing a query in Access. I need to set up a parameter query for three fields which are called Status (text field), Authorised (date field) and Legal notices (date field).

    I need to set it up so that the user can enter info into each of the fields and run the query from that but I also need to set it up so that if nothing is entered into the parameter boxes that it needs to return all results.

    I have set...
    See more | Go to post

  • chicane
    started a topic linking to mdf database

    linking to mdf database

    Hi

    I was wondering if anyone can give me some help/advice on the question below.
    I am working in visual studio 2008 express.

    I have an access database called engineers.mdf which I have saved into the App Data folder in my website. I now need to develop a web page so that users can use this page to insert new data in to the engineers database.

    To be hones I am not sure where to start with this,...
    See more | Go to post

  • Hi

    Thanks for getting back to me, I will give it a try shortly and let you know how I get on.

    thanks
    See more | Go to post

    Leave a comment:


  • Hi there
    Thanks for your response. I don't think I was clear in my post or I haven't explianed it very well.

    You mentioned in your response that the Minimum Value will be 2009/12/23 but this wouldn't be the case if someone submitted the request on a different date, how is the code set so that it works off the Current date that the form is submitted, so that it can be calculated off any date?

    Thanks again for...
    See more | Go to post

    Leave a comment:


  • chicane
    replied to Query with Outer join
    Hi
    Thanks for the link I found it very helpful.
    See more | Go to post

    Leave a comment:


  • chicane
    started a topic Range Validator Visual Studio Express 2008

    Range Validator Visual Studio Express 2008

    I am using VS2008 and I trying to use the Range Validator for the following:

    I have a text box that a user will input a date into for an appointment - the date entered must be at least 7 days after the request has been made (current date) but less than 90 days into the future.

    I have set my range validator to Type = Date and Control to validate = Textbox11

    I am now lost where the rest of the code goes to achieve...
    See more | Go to post

  • chicane
    started a topic Query with Outer join

    Query with Outer join

    Hi

    I have the query below:

    select * from parts where pnum
    not in (select pnum from supply where
    pnum is not null);

    I now need to write the same query but with an outer join?
    I have tried various things but can't get it to work.
    any suggestions would be appreciated.

    many thanks
    See more | Go to post
No activity results to display
Show More
Working...