Search results for query: *

Did you ever find a solution? This has just started happening to us after a migration from 2003 to 2007. Only started when we turned off the EX2003 server. Turning it back on, the problem goes away!

There are probably much better ways to do this but how about creating a recordset based on a query of the salary table that uses the EmployeeID and PayDate from your form as criteria. Then test how many records are in the resulting recordset, zero would mean OK to enter the data, 1 would mean...

Great, Thanks very much.

Can anyone help? I want to find out when a table was created so I can deceide if I want to delete it, testing if it's in the database and deleting it isn't a problem, but I don't know how to find out the date it was created. Can anyone help? Thanks. Dan

I have no idea how I came across his thread (I was looking for some info on Tabledefs) but it's great stuff. This is Tek-Tips at it's finest. Dan

Can I have the Return Receipt option chekced as a default for all new mail I create? Running 5.0.11 TIA Dan

I'm running 97 what's the chances of this working?

FancyPrairie, Thanks for the pointer. I understand where the tread was going and have considered something along those lines. My problem is the database I want to kick people out of is used by many different front end databases, but the worst people for locking the database when I need it...

All, I want to run a compact on my backend database just after 5pm unattended. If a user is linking to the database I want to compact I can't so get an error message. I've developed a method to send a message to the user asking them to log out, the problem I have is this: If two users are...

I solved my problem! When editing the group policy, clicking on View and selecting DC Options you can select which DC to use. I selected the one used by the Snap in and it is now showing me the list from my local DC and editing the copy of the policy on the local DC and replicating it the...

Glenn, Thanks for the info. When I open AD Users and Computers ti shows as being connected to my local DC (Active Directory Users and Computers [Local DC Name]. It is only when I look at the Policy for the domain or OU that the list of policies is obtained from a remote DC. Dan

When I start AD Users & Computers on my WIN2K Pro, and connect to my local DC, when looking at the properties of the domain and selecting the Group Policy tab, it takes an age to display the policies in effect. Under the list it says "This list obtained from" and lists the PDC...

I'm confused! I have a report that in the detail section has a vertical line, and two text boxes with the "Can Grow" property set to yes. In this example, there are two detail records to be printed, one fits the text box fine, the other requires the text box to grow in order to fit...

Checked those settings, I wish it had been that simple, the scroll bars do appear!

I have a listbox that is populated by a query. If I run the query I may get for example 100 results. When the query is run to populate the listbox, it only returns 6 results, however, if I make the listbox bigger, it will return more results! Am I going mad or has anyone else seen this?

I would like an automated way to update the connection documents of some of my users. I want to change an IP address in a connection document but would like to maybe send them an email with a button for them to click that would make the change for them. Can this be done - easily ? Thanks, Dan

Thanks for the reply it gives me a fair indication. I had read that 20kps per user was recommended is 20kps being a little generous? Dan

I have a 128k frame connection between the UK and the US. How many Citrix users could I reasonably expect to connect over this connection? Thanks, Dan

Thanks for the pointers Phil. It's something that we would want to do on a semi regular basis as our raw data is in a mess and whenever we pull the data out for things such as a marketing mail merge, we want to format the data correctly. Unfortunately, the raw data doesn't have a field for...

Jo, I wish! The postcode is located somewhere in the field, not even always at the end. Any ideas? Dan