Search results

We have an Access 2003 front end that is linked to an SQL backend (via DSN). The front end is published across 7 Citrix servers. When users start a session on (say) Citrix Server 1, all queries they run start a session on Citrix Server 7. Essentially, any user that starts a session on Servers...

Perfect. I have used "h" to get the rounded hours

I've almost got this but seem to be a little stuck on the format part. I am performing a simply date subtract in a query Test: Format([OpenedDateTime]-1-[ClosedDateTime],"h,nn") I am trying to format the result in hours and minutes - so 19/05/2008 09:10 - 21/05/2008 15:17 = 54:07 Any...

Thanks Mike.

I Have a simple report that is based on a query. The report is always run on the first of a month and displays data from the previous month. I know that =Format(Date(),"mmmm") in the control source property of a text box will return the current Month in letters (example: July). Is there a...

This is a slight curveball on what I have found on calculating averages so here goes. I have a function that I use in a query - it simply calculates the duration between two dates in Days Hours and Minutes. I have a report based on this query, which returns the results as desired. Is there a...

Figured it out. On BeforeUpdate event of the form Me.[Activity Date] = Now() This way, if someone advances to the next record or closes the main form, the Activity is still timestamped

Hi There, I have a subform bound to a query. I am timestamping what the user inputs into a field (Activity) so have a field (Time) that has a default value of =Time() formatted to hh:mm:ss. Unfortunately, it defaults the time even before the Activity record is created so when the person enters...

I get you but when I select a name from my combobox, the record is created. I've found a workaround.

Played with it but it simply opens a new record for input (you have to open the form first). I actually don't want to create a new record. Just search records already there.

ok, so I have a form with an unbound combox in the header and two bound text boxes in the detail section of the form. I am simply using the form to lookup data (in the two textboxes) based on selections made in the combobox. All working fine except, when I open the form the recordset is loaded...

Gotcha! Very informative and has solved my issue. Certainly didn't know about the drag-drop v cut-paste. I thought I was going mad :-)

I have a form that is bound to a query. On the form, I have inserted a Tab control. When I place controls in one Tab, they seem to replicate across all other Tabs in my Tab Control. I'm assuming this isn't by design else, what's the point in having Tabs. Oh, there are no subforms placed in the...

I knew it would be something really simple! Thanks a lot. You've saved me another sleepless night :-)

It's been a while - good to be back! I have a Priority matrix (see attachment) To calculate the Priority, one would select the Urgency and then the Impact. Example: a Medium Impact Sev2 would have a Priority of 2. What I have are 3 bound text boxes - one called Urgency, one called Impact and...

I have been tasked with producing a Service Catalogue - essentially, a list of services offered by IT to our business customers. The Catalogue is a repository of information related to the service - such as, Service Info, Business Info, Server names and location, DB info, Batch and Online...

Dao Thanks Doc, I will check the References.

...not too much in the archives on this one, so any help appreciated... We have an Access97 MDE with a split backend that is shared over a network. Most of our users have WinNT installed and the Access application works fine. We have a user who has Win2K and Office2k and every time this person...

Cheers! That one turned what is left of my brain to mush... thanks for saving the ounce I have left ;) Right, I will now have a beer in your honour. Cheers!

Unfortunately, this is not giving me the desired result. The groups are recognised but if I input the date to find all records with an exact match of '2003' I only receive two records with dates of '2004' (I know that there is one record for 2003 because I added it). If I only have one group...