Search results for query: *

Tried recompiling and this did not work unfortunately. Any other suggestions? Thnxs in advance, Emile

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

ok thnxs for your feedback. I however do want to go through vba coding. I am not familiar with pass through queries. Additionally I want to run the code based upon Windows 2000 logon information (so some will have read-only, other users admin rights). looking forward in receiving some feedback...

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

Did you try to make it a 'make-table' query? I had problems in the past where a simple select query would cut-off a memo field on 255 chr., but simply changing it to a make-table query kept the memo field complete. EK

Rob, You can also create a form with input date an refer the query to the field in the form. In general, my experience is that if you give the "enter date" parameter in the queries exactly the same name (ie [Enter Date:]) the user will only have to enter it once. EK

Rudy, Thank you. After I posted it, had the same idea: Round(value*4,0)/4.00 Thank you for your help. EK

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

John, FYI: Solved the problem. I have a make table query: if I go to design mode and do a preview, it returns the wrong date. But if I simply run the query (and make the table) it takes into account the proper dates. Pretty strange, but problem solved. EK

Hi Ifelsethen, Thnxs for your feedback. If what you say is correct, would it then not have retrieved all the records in the database? 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...