Search results

I've been struggling to get an Excel Pivot table to group data by category, then by period and then give an average period value. After two days struggling with this, I thought I'd try it in Access. Ten minutes later, using two nested aggregate queries, I had exactly what I wanted. DOH! I try...

I've been using Zone Alarm free version on my home PC with XP Home for a few years now. Over the last 6 months or so, the PC has become slower to boot up to the point where I would power up, go and make a coffee, read the newspaper, check the weather on the TV.... and then the PC would be ready...

A short question deserves a short answer: DMax

XP Home edition I was trying to stop the new hardware wizard from kicking in just because the USB plug for my mouse got knocked out. Next thing I know, I'd deleted the mouse and the keyboard in the device manager or whatever it's called these days. Then guess what, I have a non-working mouse...

I have a union query that will run from the SQL design window but if I try and run it from the database window it crashes Access (2003). Any ideas? SELECT [TestLat]-0.5 AS Lat, tblTestData.TestLong AS [Long], tblTestData.TestTemp FROM tblTestData UNION SELECT [TestLat]+0.5 AS Lat...

In trying to help another member of these forums, I have this query:SELECT [Table1].[name], [Table1].[age], [Table1].[telephone], [Table1].[address], [Table1].[postcode], [tbl3].[ImageBMP] FROM Table1, tbl3 WHERE [tbl3].[ImageID]=IIf(IsNull([postcode]),2,1); Basically, the idea is that the image...

I have a domain name, say acme.com. I would like to be able to use an extended domain, say bluebeard.acme.com Can I set this up without having to register a new domain name or setting up a new hosting site?

In this thread, http://www.access-programmers.co.uk/forums/showthread.php?t=97501 Bhanu has used AND in his SQL when I would have used WHERE. Does this matter? I'm aware that WHERE is preferred over HAVING, is there a similar issue with AND? You know I'm not formally trained so please help me...

I'm tasked with updating a db that was created in A97 and converted to A2k. I am using A2k SP3. Some of the tables have a colon in the name, e.g. Tbl:Budget. I thought I would delete the colon and use Name Autocorrect to propogate the changes, but I can't get it to work. I have turned on the...

It takes an age to load up help on my PC at work. It's most noticeable in Access, but still frustrating in other Office apps. Does anyone have any ideas? I run Office 2000 on ME at home, and it's much quicker. I'm running Office 2000 on Windows 2000 Pro. I've applied all the latest patches and...

If you create a table in Access, the default length of a text field (unless you have altered the options) is 50 characters. If you import a file from Excel, the default size for a text field is 255 characters. When you run the form wizard on a table that has a text field of 255 characters, the...

I have already posted this problem and thought I had an answer, but I haven't. I have a report based on a relatively simple query. This is formatted to fit on a single A4 ladscape page. I use conditional formatting to highlight some fields in the report. This all works fine. I want to use...

I have a report based on a relatively simple query. This is formatted to fit on a single A4 ladscape page. I use conditional formatting to highlight some fields in the report. This all works fine. I want to use some of these reports on our website. I don't want them to be interactive, just a...

I'm going mad here! How come I can do hard things, and get defeated by the trivial! I have a simple form with a combo box containing a userID and a user name. This is based on a query. I have a subform based on a parameter query that picks the the value from the combo box and displays the...

I should know this, but I don't! I want to import a list of names into a single field table. The text file looks like this: Appleby David, Atkinson Susan, Blair Brenda, Brown Karen So each record is terminated by a comma and a space. The import wizard expects records to be separated by a...

Reading a post on here has prompted me to post this. It baffles me why lots of users chuck in a spurious Sum() in their expressions. One of my colleagues uses this form all the time in Excel, too. If you write an expression A+B+C this calculates the sum. If you embrace this with Sum(), i.e...

I have a public string variable called strCatname. I am setting this variable from a combo box on a form and passing this to a select query as a criterion. The WHERE clause is as follows: WHERE ((([Tbl:Cats].Name)="""& strCatname &""")); I know the variable is being set in my form with a valid...

My organisation has a simple database created in Access 97 that I need to use. I have Access 2000 on my machine. If I try to open this database I get the usual open/convert dialog box. Whichever option I try I get the same two error messages: The first tells me that an error occured in loading...

I have a data set with a name field that contains names and initials. These are in the form: A B Smith C Jones David Brown I want to be able to extract just the last name, ie Smith, Jones, Brown I don't mind doing this in Access or Excel. It is part of a one off data cleanse. This is easy if...

I think these questions are pretty basic, as I've done much more complicated things before. But now I've got brain fade! I have a form to enter new records in a single table. I want the user to selct a value from a two column combo box that is derived from a different table. Once the value is...