Search results for query: *

I know how to calculate the dayname of a date field. However from that date how do I then calculate that day in a specific week. Example - (date format dd/mm/yyyy) Datefield = 01/11/2005 I want to calculate 01/11/2005 is the first Tuesday in the month and then calculate the next first...

Not sure why that made a difference but it did the trick. Thank you so much and for your prompt reply. Regards TS

I thought that this would be quite simple but I must be missing something. I have an unbound form with an unbound textbox, I have set the default value of the textbox to =Date() When I then query a table (I am later using this query in an append query) setting one of the fieldnames as...

That worked. Thanks very much.

Thank you for your prompt response. So time needs to be treated the same as a date? How does it differentiate between AM & PM? Would it be #12:01PM#?

I know that this is probably a very basic question but I can't seem to get it right. I want to test data against a time 12.00 midday, sometimes it works, sometimes it doesn't. I think that it is not seeing the AM/PM. Can anyone point me in the right direction. if my start time is say...

Thanks Duane for your input, I may have to look at other options to achieve the desired result. Thanks Bocker, This is the closest that I have seen in access to what I need. It is a long way off but as you said it gives me a place to start.

Duane, I appreciate your persistence with me and apologise for my vagueness. The problem I have is that I have no idea how to go about this. What I want is a form with a month to view and the ability to show several hires at a time over several days/weeks and to make it easier to decipher, it...

Duane, Thanks for your comments. Sorry I didn't give a lot of detail. What I am trying to do is create a database for the hiring of a number of pieces of equipment. Along with that I want to have other fields and info in the DB to store other data relevant to the hire. A lot of third party...

Hi, I am wanting to create a database for scheduling of several items for hire. I am having trouble with the bookings form. I was hoping for something similar to Outlook but with the ability for several calenders for each day/week etc. I have searched the website and can't seem to find any...

Thank you, that did it. I find it difficult to know when it needs the .form and when it doesn't. Regards

Hi, I have code on my close button (on the main form) that is running through a loop to ensure that a particular field is filled on the subform. when it finds an offending record I want it to go to that record on the subform. My loop code is working find and finding the offending records but...

I have created a db and am installing using runtime. The compact & repair does not work. Is there any way around this or does compact & repair only work in full Access?

Leanne, Two years after you posted this I had this same problem and your thread helped me fix it. Thank you have a star.

Had the exact problem as Homegrowth and this fixed it beautifully. Like Homegroth - sure learnt something today. Thanks RoyVidar have a star

ZmrAbdulla Thank you for your prompt response. I had already tried this solution and it still returned nothing, however when I tried it again after your response and I tried it only on one field and deleted the criteria on the other fields it worked, so I need to look at the criteria on the...

I have 2 drop down boxes on a form to identify criteria for the report. What I want is, if the user leaves the drop down blank, I want it to return all results. I tried the <All> option suggested in a FAQ however this does not work with the records that have this particular field blank. I...

Thank you Mark, that is what I ended up doing. I am surprised that there is no easy way to set the size of the report window. Thanks for your time. Regards

Mark P. Sorry it has taken me so long to get back to this. I have been away. I am not sure how your solution is going to help me. My problem is that when the report opens in 100% the window is the same size as in preview so the user has to manually resize the report. Docmd.Maximise causes...

I am wanting to change the window size of a report. It automatically opens to fit to window. I have found some code on the forum to change to 100% zoom and I have tried docmd.maximise. That it not exactly what is wanted. I need it to be the 100% which is good but I want the window to just be...