Search results for query: *

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

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

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

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

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

Hello, all. I'm a bit of an HTML rookie so I have the following question: I am outputing a report to HTML and it is working nicely. I notice that if the report is more than 1 page it creates multiple HTML files, 1 for each page. Is that what I should expect? Thank you for any comments!

Hello. I am trying to figure out how to automate a process where a user is importing a spreadsheet into Access. I would be doing fine except that a single field in the Excel file changes every day (it contains the date of the file). I need to merge this data into an existing table without...

Hello all. I have copied an Access2000 DB from one machine to another and I'm now getting a compile error on one of my modules. Here's the offending line: Dim db As Database The error tells me "user-defined type not defined". It would seem to me that I am missing a VB DLL or...

I have a need to try to identify columns that have been incrementally added to a table since its initial creation. I have searched ALL_TAB_COLUMN and related tables but I don't see a timestamp attribute. Any thoughts on how I might accomplish this? Thank you!

Does anyone know if there is a way to sort the results of a cursor? When I include an ORDER BY statement in the cursor SQL, it seems to be ignored. The records seem to be returned in the physical order that they occur in the database. This is not necessarily the order they were entered or any...