Search results for query: *

Thank you both. I will have the users check. jdegeorge got the star, as his answer was more detailed about what I needed. Thanks again, -Larry

Hi. I'm pretty comfortable with many of the features of Access. At the moment I am having trouble with a database I developed for several folks to use. When one person goes in there is no problem, but anyone after that will get an error message: "Couldn't use xyz.mdb; file already in...

It sounds like your imported dates are not coming in as valid dates. Could you bring it in as text and have a query convert it to a date by parsing out the year, month, and day? If you are really only worried about obtaining a list where the date field is null, have you tried...

I don't know of a way this can be done, but I'm not a GroupWise administrator, so I can't say definitively that it's impossible. Perhaps someone who administers a GroupWise system will be able to offer more help. (In my company they can set an autodelete based on message age, but I don't know...

My guess would be that this feature only applies to unopened messages. Once the user has opened it, it is theirs to control. Similar to how mail cannot be deleted/retracted after the user opens it. Is this happening with unopened messages? -Larry

Just a thought, but have you tried a repair? (TOOLS, DATABASE UTILITIES, REPAIR DATABASE) -Larry

I forgot to mention, you will probably need to set the cells' FORMAT property to something that will display the date and time together, otherwise you might just see the date. -Larry

When you do your downloads add another column to the sheet to convert the date into a format that Excel will recognize. The following formula should do the trick, assuming that the value is in cell A1: =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID(A1,9,2),MID(A1,11,2),RIGHT(A1,2)) Then...

Have you tried reinstalling your printer driver? You might be able to find a more recent version on the manufacturer's Web site. -Larry

This is not my "thing", so this response is just a guess. Search your Microsoft Office folders for files of type *.reg. If you find a likely candidate double click on it to run the registration. Hope this helps. -Larry

hyperiest- Why don't you create a query that makes new fields for all the items concatenated in that expression. Your first query would have the additional fields of: MOS:Left([PMOS],3) Auth:Mid([PMOS],3,2) etc., to get the string broken down. Then make a second query based on the first one...

It's pretty straightforward. You'll want a separate report from the envelope, but use the same data source. Start a new report (without the wizard). In design view go to FILE, PAGE SETUP. You'll probably want to set your margins smaler than the default settings. Click on the PAGE tab, set...

From the client (not Internet but the network client): TOOLS, OPTIONS, SECURITY, PASSWORD. If they will only have the WebAccess then this will not work, as the users would first have to have a password. -Larry

Add a new column to your spreadsheet (you could even hide it if you wanted) and use basically the same criteria as you used for the conditional formatting. For example: =IF(a2<10,1,0) would display a 1 if the value in a2 was less than 10, otherwise it would be zero. You could then sum that...

From Microsoft's Support Web site http://support.microsoft.com/default.aspx?scid=kb;en-us;269671 it sounds like it is having problems with your parameters. I would guess that if you created a duplicate query where you hard-coded the parameter values it should work without a problem...

Where I work the GW Admins just let it be known that if you want to be able to access your email over the Internet you must first set a password. It worked pretty well in our case. -Larry

Odd... Perhaps the database has an AutoExec macro that is trying to display or print a report on opening the database. Does it help if you hold down the SHIFT key while you are opening the datbase? -Larry

I'm pretty sure that you do this from Windows. Click START, SETTINGS, PRINTERS to open the Printers window. Right click on the printer you want to designate as the default and choose SET AS DEFAULT PRINTER. -Larry

Look at the Data Source property of the form that the wizard made. It sets up a SQL statement that, in essence, makes the form's data source a query combining the two tables. When you do it yourself you are probably basing the form on a single table. To do what you want either create a query...

Does [tables].[tbl].[Val] work when it is substituted for tbl.val? -Larry