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...

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...

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...

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...

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...

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...

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...

...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...

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...

We have a shared DB on the network (slipt front/back ends). Everyone can use the DB seamlessly except one user, who receives the following error when they try and close a form (which has some code). Error 2447: There is an invalid use of the .(dot) or ! operator or invalid parenthesis You may...

I have searched and can't find any posts related to this: I have a form where the user can click a button and it sends an email to a Lotus Notes user. The recipient and body of the text is pre-defined. What I would like to happen is, when the user creates the record, an email of the contents...

Having a bad hair day with a filter. Currently, I have a filter that shows all records with yesterdays date: Me.tblChanges.Form.Filter = "((OpenedDate=date()-1))" This works fine... but now the user would like to see all records between yesterday and the previous 14 days (ugh!). Any...

*Access97* Had a look but can't seem to find anything related. My DB is split on a network. I have a form with a textbox called WHO. The ControlSource of WHO is =UCase(USER()) (USER is a module) - basically, this captures the user's ID from their NT logon session and displays it on the form...

*Access97* I have a form with a textbox called [ImplementationDate]. The user is free to enter a date into the textbox. What I am trying to achieve (unsuccessfully) is a way where the user cannot enter a date unless it is at least 14 days greater than todays date. I have tried...

I want to be able to change a forms RecordsetType property to 'snapshot' to prevent edits. The macro or VB to do this is run from a button on a different form. I have tried this with the a macro but no joy. Trying now with VB. It looks like the form must be open to change the property so I am...

I have a textbox 'Duration' whose control source is =DateDiff("n",[DurationFrom],[DurationTo])/60 All data is stored in a table. This sort of works if the times entered in DurationFrom and DurationTo are nice and round (like 10:00 11:30 which would return 1.5hours) I get problems when times...

Access97: I have a form with a date field. After the date is entered I run a DoCmd.RunCommand acCmdSave and then a requery. The form does not close but stays open for the user to perform another action. My problem is this: When I test the .MDB (no split - just a straight .MDB), no errors...

I have an Access97 DB which does not use security. Through code, is there a way to force users out of the app?