Search results for query: *

Greetings all... I am developing a front-end app in Access2000 and I'd like to set up the main window (Access itself) to be a certain dimension - regardless of user screen resolution. I'm not sure if this is possible... ??? I have users who's resolution is as low as 680 X 480 and high as...

Greetings All, I'm trying to do the following in my application. I have an external Access2000 db for my backend and an Access2000 db for my frontend (w/plans of migrating in the future). I'm having difficulties trying to perform the following (after much reading from...

Good day... I hope someone can assist me in resolving my problem in executing a function within Excel's Analysis Toolpak for VBA Add-In in my Access database (2000 using ADO). I've followed some examples from the net, but I end up with the following problem/error: Cannot find DEC2BIN macro...

Good day... I have the following problem with Excel's Analysis ToolPak functions. I am trying to use the functions within Access2000. I've look on the net for assistance and thus far, I can't seem to reference the Add-In excel file that contains these functions. I do not have Admin...

Greetings. I'm new to ADO and I'm trying to implement the following function which will determine if TName exists as a table. The function crashes in one of my database; works well in all others!! Does anyone have a clue/idea/comment to my problem? I've tried creating a new db and importing...

Greetings.... I have the following problem. I have an account on a UNIX server that has SQL (SQL-PLUS); I created a front end using VB.net... But I cannot connect to the UNIX/SQL server to access the data!!! I'm not sure what information I need in my connection string... but I'm open to...

Greetings.... I have the following problem. I have an account on a UNIX server that has SQL (SQL-PLUS); I created a front end using VB.net... But I cannot connect to the UNIX/SQL server to access the data!!! I'm not sure what information I need in my connection string... but I'm open to...

Grettings. I hope someone can help me understand what I'm doing wrong!!! I have the following code: 1) tblMainTable is a linked table 2) I want to copy tblMainTable to tblMyTable - both are in MyOwnDB.mdb (can I use CurrentProject instead??) Public Sub MakeMyTable() Dim cnnMine As New...

Hello. I have the following test subroutine where table tblTEST has field MsgID (numbers). This test sub emulates a problem within my code. I'm trying to dynamically filter an open recordset. My filter relies on the "MsgID] IN ( ... )" syntax used in queries; however, when this...

Greetings, I have a macro/VBA that I'd like to do automatically either when opening or closing of an Excel spreadsheet? Can anyone help? Thanks - Lorentz

Greetings. I'm trying to write code that will detect if a user selected more than 1 cell in a column! I tried using the Selection action - this allows me to determine if more than 1 cell is selected. However, I don't know how to get which cells are selected from this? Can anyone help me...

I recently upgraded an Access97 database to 2000 and tried to deploy the application. When all was imported (tables/queries/modules), the error 'The Microsoft Jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell ilts name and the path name...

I'm looking for a function that will return the number of files and/or directories in a specified path. I'm sure there is windows API that I don't know about. Thank you in advance for any suggestions. - Lorentz

I'm trying to create a combination stacked/clustered chart. Below is sample data: Jan Feb -- month LA SF LA SF -- city Proposed 2 4 1 2 Actual 1 3 2 3 -- cat. I am trying to get a chart that clusters the data into...

Greetings, I'm new to VBA and found out how to create user-defined objects. Now I'm trying to create a properties collection for my new class. I've got all my properties (Get/Let) defined within my class module, but I'm not sure how to create the properties property (?) for this class...

I have a database that uses filters to display data on forms and reports. Now I need to send the filtered data to an Excel Spreadsheet. I managed to do this two ways: 1. Using a recordset and sending the data to an Excel object; but this method is SLOW and I've tried to optimize the method...

I have a form in my database that is bounded to a table (tblApps). The header on this form has two controls where users enter data and then press a command button (cmdSubmit)to filter the form to populate controls in the form's detail area. One of these controls is a listbox which has a...