Search results for query: *

Hi, I created a MS Access 2000 application with several buttons and event procedures associated with them. The file worked fine for a while, but, I think, that after I renamed the file I get the Microsoft Visual Basic error message "Module not Found". Any idea how I can correct this...

Hello, I have an excel sheet with large flowcharts (over 270 text boxes) and need to have a wordcount of the text in these boxes. I know word has a word count (in the properties section), but it does not count words in text boxes. Any help is appreciated. Emile

Hi, I have found already quite some posts regarding this subject, but can not get it to work in my situation: I have an Access 2000 db which queries a table on an SQL server. The DSN connection = "MyDSN". The table contains a user_id (MyUser) and passw (MyPassw). I am looking for...

Hi, I use the DoCmd.Openquery code to run a query via a form/button. The query retrieves data from tables linked through ODBC. To access the data you need to answer a login/password. I would like to take the network user (NT), check whether he is entitled to access the data, if so, open the...

Hi, I want to create a link to a text file in vb (basically replace the "File"-"Get External Data"-"Link Tables" command. Any idea what the command should look like? I use MS2000. Thank you, emikoo

Hi, I am running a vba code in access. I have declared a recordset and am sending out data in an e-mail (MS Outlook) using the "DoCmd.SendObject" command. It works fine for certain records but for others I receive a "Reserved Error 2958" message. Any idea what generates...

Hi, I would like to count the number of empty (null) fields in a recordset. For example: Select a,b,c....,z fom Mytable ; suppose "b" and "d" are empty/null then statement should return 2, if only "c" is null then statement should return "1". Any help...

Hello, I want to check if a character in a certain cell is upper or lower case. For example "A" returns "Upper", "a" returns "Lower". Thnxs in advance, EK

Hi, I have an access file that needs to receive input from external application. I would like my code to determine what the colour and position is of the "pixel" below my mouse pointer (when it is pressed) on the external applications. Thnxs for your help, EK

Hi, I have several access applications that link to tables in Informix 7.2 and SQL Server. Now if users run queries on those tables they sometimes have to enter 2 logid's and password's. Is there any way Access 2000 can pick-up the login from the network (win2000) and connect to tables...

Hi, Is there an easy way to round the values in a MS2000 Access query to quarters (x.25, x.50, x.75 or x.00). Example: 3.17 = 3.00 3.18 = 3.25 3.37 = 3.25 3.38 = 3.50 3.62 = 3.50 3.63 = 3.75 3.87 = 3.75 3.88 = 4.00 Thnxs in advance, EK

Hi, I run a query on an external database, via a "Simba" ODBC client. Now when I enter criteria: #09/16/02#, the query returns rows from 05/28/02... The date format of the external database = YYMMDD, my PC is MM/DD/YY. But I believe the ODBC driver should be able to handle this. Any...

Hi, I have a table containing a memo field (1440 char. long). The memo field contains a sequence of characters, and I would like to do a count on each character. ie: table: Name_id String John AABBCBCACBVB to be converted in: John A 3 John...

Hi, Have seen some postings already about this topic, but none answer my question: Suppose I have a cell (A1) with the following contents: BCCSSFFGGBSGVZ, and I would like to have a count of "B", (2 in this example. Any help would be appreciated...preferably not vba as I have no...

Hi, Can not figure this one out, any help would be appreciated: In an access file I linked a table, via ODBC, to an external database. In the table there is one field ("State")which contains a sequence of 1440 characters. Each character describes the state of an employee during one...

Hi, We run a script using crontab and would like the following statement to be included: In case the date and time stamp of a certain file compared to the current date and time is more then 2 hours, I want to run the script, else quit. Thnxs, EK

Hi, Does anyone know of a tool/application to access CMS data through the web. Something like a "webenabled" CentreVu application. If not we will have to start programming ourselves. I would like to avoid re-inventing the wheel however. Thnxs, EK

Hi, Does anyone see a way to restrict a specific CentreVu user from accessing all reports? I would like to have a CentreVu user who can only access a pre-defined set of reports. I currently have a testuser for whom I removed all user permissions and only gave access to a specific set of...

Hi, I have an sqlplus query which I run from a unix box: The moment I do not add too many columns to the query, the query results are formatedd the way I want: Column1 Column2 etc. 2,0000 50% etc. Now the moment I add "too many" columns, formatting changes to a format I do...

Hi, I have an sqlplus query: The moment I do not add too many columns to the query, the query results are formatedd the way I want: Column1 Column2 etc. 2,0000 50% etc. Now the moment I add "too many" columns, formatting changes to a format I do not want: Column1 2,0000...