Access
thanks for the replies. I will have another shot at it using your suggestions.
Thank you
User Profile
Collapse
-
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... -
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,... -
Hi
Thanks for getting back to me, I will give it a try shortly and let you know how I get on.
thanksLeave 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...Leave a comment:
-
-
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... -
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
No activity results to display
Show More
Leave a comment: