Search results for query: *

Recently I have begun experiencing a pretty significant glitch in MS ACCESS 2002 that is causing me a major headache. When attempting to do a simple import of any type of file (.txt,.xls,.dbf etc.) I receive a quick message box that states "Type Mismatch". When I click "OK" it takes me to a...

I don't write CLIPPER but spent time breaking down CLIPPER and rewriting as VBA last year. This year I need to run an old CLIPPER program but with some tweaking. I took the original .prg file and added the lines I needed but now I don't know how to make an .exe file to run the new code. What...

Agreed. Thanks for making me think about this. Until now there was not a sql db to work off of. It was dBase files that were imported into an ACCESS db that supported the application. Now we are putting it into a sql db and updating each month. I'll wait until the sql db is setup and then...

Here's the layout 1 - SQL DATABASE 2 - Access Front End (ODBC to SQL) 3 - Access Font End resides on the DESKTOP of each user 4 - Only See the VIEWS they are allowed to see 5 - VB Application Supported by their VIEW rights from the desktop front end and the tables that reside there This may be...

Each user will have different views and therefore not sharing the same ACCESS front end.

The database is actually just a GUI tool not the actual DATABASE. Sorry for the confusion. Its a SQL database with VIEWS based on the user rights. They only have read only rights. Each of them ODBC into what they are allowed to see and the application runs off of the linked tables. I...

I have a program that pulls information from tables in MS ACCESS. The database I want to reference is on the DESKTOP of each users local machine. Here is the code: ' Build connection string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Right here I would put the...

Nice! Thanks guys. Much appreciated. All setup...Running as we speak!

Alright I fixed the quotes but now when it opens ACCESS it says "THE COMMAND LINE YOU USED TO START MICROSOFT ACCESS CONTAINS AN OPTION THAT MICROSOFT ACCESS DOES NOT RECOGNIZE" Exit and restart Access using valid command-line options * This is my run line "C:\Program...

Paul --> I am having problems getting this to run. I keep scheduling it to run and then the status says WOULD NOT START...or something to that effect. Here is what my steps are: * I create a new wizard to setup a scheduled task goto PROGRAM FILES and select the ACCESS .exe "C:\Program...

I have seen the process run before in which the run line in the properties of the TASK looks something like this ...point at database and then macro C:\PROGRA~1\MICROS~4\Office\MSACCESS.EXE \\NETWORKDRIVE\FOLDER\accessDB.mdb /x MacroName * When I attempted to replicate this on my machine I...

to run in SCHEDULED TASKS in WINDOWS XP? I know how to use the WIZARD but cannot figure out how to set this up? thanks

I am trying to schedule a MACRO to run each morning after a certain dataset is updated on the network. How would I do this? I am familiar with SCHEDULED TASKS and how to setup programs to run through the WIZARD and have seen other's running MACRO's in scheduled tasks but cannot figure this out...

CCLINT - Understood. It's a giant corporation with a massive amount of account numbers that each have extensive detail. The concept was when a user selects a search criteria they can see all the similar sorted accounts in the same ballpark and their YTD balances etc. I assumed it was over the...

No luck. I had declared i as Double globally. It's really strange. When I trap the error and glance over i it shows 32,768 - which tells me i is not having problems. But when you rollover lstAcct.list the message reads <Overflow>. Hope someone knows or I'll have to reengineer the search tool...

I am populating a list box with roughly 35,000 records. I put in a search functionality that looks for the account number and highlights it for the user. However, when it hits record i value 32,768 in the list index it gives me an overflow error. Is the list box index limited to the integer...

Thanks man!

Well PSU the answer is... shtEntry.ActiveSheet.Protection.Enabled = True There you go! ;)

I have a spreadsheet in my VB application that during run time after error-checking needs to have .enabled = FALSE. However I cannot find this property in code. At design time the I can set the enabled property to false but I do not want to do this. I need the user to be able to use the EXCEL...

Thanks again. Most of the machines ran the .exe programs perfectly. I appreciate your help.