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

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

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

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

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

I am sharing a program that connects to a shared network ACCESS DATABASE. Initially the user could not open the file because he did not have some components installed on his machine. "msadodc.ocx or one of it dependancies not correctly registered : a file missing or invalid So I...

I have written a number of VB applications that are supported by a MASTER ACCESS Database. I converted them into .exe files and deployed on the network. They all use ADODC to connect to the ACCESS database and yet some of them work and others return the following error: Component...

I have been approached by a number of member's of my department with questions regarding multiple monitors to help complete their jobs. I have in the past had a LAPTOP working with a 19 inch Flat Panel which functioned as a single monitor over two screens. However they would like to have a flat...

I am attempting to use a variable and find it within a list box that has been populated already and then delete it based on the variable value. All I found so far is listBox.RemoveItem n * The problem with this is that I want to remove the item based on the ListBox.text value AND not the...

I am trying to write a variable to an ACCESS database. I setup the ODBC Connection without problem and part of the app already pulls in data from the database etc. However when I run the app and attempt to write to an ACCESS Table from the VB application I get a RUNTIME ERROR '3251' "The...

I have a program that sends very sensitive Payroll data out to multiple departments. Each department receives 6 files. The program Creates the tables based on department numbers - exports to .txt and .prn files into folders and then I just figured out how to zip them. Now I need to know how to...

New to trying to put together workgroups and network security. I have been able to establish a workgroup on my local machine. When I attempt to apply a new workgroup to an access database on a network drive it does not work? Can anyone give me some direction?

I have written some applications in VB supported by Access. I load two combo boxes - 1) Account Name 2) Account Number The list is a recordset of 34,000+ records. So what I currently have occurring on load is the following: Do Until rst.EOF If IsNull(rst!desc) = False Then...

I have an application I wrote that ties into a very large database. Depending on the account number it retrieves the detail behind a summarized number. So maybe the number is $100,000 for cash. You click on detail and it goes to the ACCESS database and returns all the detail that makes up that...

If I write a complex form in ACCESS how can I then make it into a stand alone desktop application? I know how to write it in VB and then connect using ODBC and make it stand alone...can you do this in ACCESS? Thanks.

I have a program that outputs specific queries from my tables into data files on our network. I have no problem with the VBA to output these files as .txt or .prn files. However, I need to be able to Zip these files once I am finished outputting them to the specific directories etc. Anyone know...

I have setup a system of shooting tables out to text files but would like to send it out as a .PRN file and not .txt file for some of them. What VBA would I use? I tried this but it says file is read-only?! ' Write table for each DEPTNO to text file FIXED WIDTH (SDF)...

I am in the process of replicating a monthly data conversion process which uses CLIPPER code and creates dBase files/tables. I am emulating it as VBA which creates tables in ACCESS. After one of the bigger tables is built I have to do a filter and output data from fields based on DEPT #'s into...