Search results for query: *

Several things: - the data is intended only for management (so I can't open it to the world) - some people have read access to the folder for other reasons - I'm not the network admin so I don't have total control over user changes that might impact this Your question makes me think I...

Hello. I have not been able to find a thread with a solution to my problem. Issue: I have an Access 2003 MDB on a network drive. I have set up network access to specific users who need to use it. Occasionally a person with read-only access will open the MDB, thus locking everyone (including...

Thank you for the replies. Interestingly enough, I have both grouping and Excel lists being used in this workbook. There are several worksheets in the workbook and it seems that Custom Views are not allowed on all worksheets if any of them involve grouping or lists. Thank you for the quick...

Has anyone encountered an issue in Excel where the "Custom Views" selection under the "View" menu is grayed out? It seems to be worksheet-specific because it is available on other worksheets I use. Any help would be greatly appreciated. Troy

Thank you, Dave. I will evaluate the options you suggest. Troy

Hello, everyone. I did a quick search and didn't see a similar question out there so here goes... I have an Impromptu pick list with several dozen values. Users typically select 1 item or all items. If the user selects all items, Impromptu builds a giant "IN" statement that is very...

Problem solved. I just found that the table description cannot exceed 255 characters. Right click/properties on a table to see the description. It accepts more characters than 255 but issues this error. Interesting... Thank you to Jim and any others who read my post. Troy

Jim, the table doesn't contain any data. I get the described error when I open the empty table. The issue has to be something with the table properties. My source DDL also includes field comments but they all seem to be complete too (i.e. not truncated). I'm just concerned that users of...

Thanks, Jim. Here is the layout of a table with this error: UID - Number - Long Integer SERVCODE - Text - 50 length STARTTIME - Date/Time TIMESTAMP - Date/Time This error is mystifying. If I create the table manually, it is fine. I wish I could figure out what...

Hi, everyone. It's been a long time since I've posted but now I'm back with a question. We use a third party tool written in VB to create an Access MDB out of an Oracle DDL. It seems to work pretty smooth except for this one thing: Several of the tables that are created give the following...

I experienced similar problems which caused me to quit using Netscape many months ago (I'm an Opera user now). I have a memory monitor in my Systray to monitor free RAM. When I would go to certain types of web pages, the RAM would mysteriously drop to zero and I would have to reboot. This...

Do your "like" columns have data values that match and represent the same things? You can join a table with a "State" column with one with a "ST" column if they both have values like "AL", "AK", etc. I'm not sure if you're asking a SQL question...

I frequently have this problem too. I have an autoexec macro running startup code. If I close the database (but remain in Access) then open it up again the autoexec doesn't seem to work. If I close again and reopen then it works fine. In other words, the autoexec works every other time. If...

I would make the query "totals" query then set the "Total:" row in the QBE grid to "First" or "Min" or "Max". Troy

I had the same problem recently. Unfortunately, in my case the MDB could not be repaired and I had to rebuild it. My research into this said that it is risky to compact an MDB that is on a network drive. If there are any performance problems on the network, corruption can occur. The solution...

You need to have Adobe Distiller. You can use it just like a print driver to output your data to a PDF file.

Yes... "-1" means "Yes" and "0" means "No". You might want to convert the data in Access before exporting. Perhaps with a query statement like "Iif(checkfield = -1, "Yes", "No")

One option is software such as Speed Ferret. It allows you to do global find and replace throughout various Access objects.

Thank you, Jim. I've used the domain functions to populate controls on forms but I hadn't thought about using them in my code. I suppose I could construct my domain criteria clause to produce about any result I need (since I don't always need MIN or MAX). It doesn't do any harm to get the max...

Hello. I frequently find myself needing to retrieve a value from a table that I will use as part of a SQL statement that I am building in code. For example, I might need to pull the max date from a certain field then use that in a Where clause to pull all records with that date. In Oracle...