Search results

Thanks for your reply Galaxiom....however, i have sorted this now. It appears as if the query was working (looking at records between the 2 dates) but if it found more than the specified amount, it would return them ALL, not just the ones between the 2 dates. I appreciate it is hard to get...

Hi, can anyone offer me a glimmer of hope on the above? I have tried it today but came across the problem whereby if I enter a 2 dates using the Between...And operator, and 1 as the number of sick days, I end up with all days in the result. It is very perculiar (and annoying!) Any help would...

Many thanks Dave and MStef, that is a great help! I believe I can use this http://www.mvps.org/access/forms/frm0031.htm for the syntax of referring to a control in a query? Thanks, NS

Many thanks boblarson. Do you know if an ASP.NET page will need to be ran from a webserver or would it work from a shared folder? Also, how much knowledge would I need to make a ASP page from a simple query? Thanks, NS

Fantastic MStef, many thanks! I have one more question which you may be able to help with... Basically, I'd like to have a Main form that contains a subform. I would to have 2 boxes on the main form that I could enter 2 dates in (start date and end date). I would like the subform to display...

Quick Question RE: IIF Hey all, I'm sure this is fairly easy but I'm not sure where to start... I basically need a to display a text label on a form when a check box (on the same form) has a been ticked. I also need the text label to hide when the check box is unticked. Any advice would be...

Thanks for the reply Alisa. Out of interest, what is the accepted max number of people for using a FE/BE system? I read that linked tables dont respond well to more than approx 8 users...is this true?

Hey all, I have created a frontend / backend Acces database. The backend holds all the tables and sits on a network drive that all users have read/write access to. Each user has their own FE (not a shortcut to a FE). My question is regarding the best setup to prevent record locks and...

Hey all, What has happened to web forms? I thougth it was a handy feature in 2003. Is there anything I can do to get this feature or similar in 2007? We dont run that Sharepoint thing at work so I can't use that. Thanks, -NS

Many thanks for your reply. I'm struggling with this. Do you know of an example I can download and see how it all works? Thanks, NS

Hi, thanks for the quick reply! By controls, do you u mean text boxes? How would I go about including these controls in the subfrom record source query? Many thanks, NS

Hi all, Tricky one this..... I would like to create a form that displayes records based on a query. However, it becomes a little more difficult when I need the top of the form to display employee info (name, ID etc) but have a Subform showing records of absences relating to that employee BUT...

As a follow on from this...is it possible to return only those records with more than a set amount of absences BUT within a 2 date period. For example, I'd like to create a list of each employee who had more than 2 absences with the period 01/07/09 to 20/07/09. I'm guessing that I just do what...

I'm interested to know how I would go about setting Access to not save automatically?

Thanks for your reply pbaldy. Is there no way I could use an input mask to automatically add the zero at the beginning? Thanks, -NS

Hi all, I'm sure this is an easy question but I cant seem to figure it out. I have to input some numbers into access but all start with a 0. How can I stop access from dropping this leading 0? Thanks, -NS

Ah thanks, that seems to be exactly what I am looking for :) NS

Hi all, I need a query that will allow me to enter 2 dates and then return all records that fall within those 2 dates. All my records have a date (of an employee absence) so basically if I entered 01/07/2009 and 14/07/2009 it would return records such as 03/07/2009 etc. Is there an easy way to...

Thanks for the breakdown, much appreciated!

Thanks, that is a fantastic help. There is only one this I am unsure of.....you say "join this query back to the original table on employeeID". Can you explain what this means? Thanks, NS