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!

...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 Files\Access97\Office\MSACCESS.EXE" "\\jh159\share$\JEAPPLICATION\jeDatabase.mdb"\x...

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

...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 am not having success. I think I will write the VB .exe program if I cannot resolve here shortly...

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! ;)

...what the property is. ... Set rst2 = Nothing Set rst = Nothing MsgBox (&quot;Your entry has been approved and can be submitted to the Master List.&quot;) cmdSubmit.Enabled = True cmdError.Enabled = False **HERE IS WHERE I WANT TO PUT SOMETHING LIKE: shtEntry.enabled =...

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