Search results

Thank you Verymuch Mstef, Its working fine in my Query. Will it wont work with maketable? I tried its not working.

I am using access - 2003. Please find the attachements for example. AS IS - The query with problem TO BE - I am looking for the output like this

All, In my table, i have datas with 6 digits and 7 digits, when i run the query, i want all the results in 7 digits, which means, for all the 6 digits datas, i would like to have one space in front of the data - How to do this in Query ?

Hi, I run the access tables back up every 4 hours. During that time i want to automatically close the access files from all the users. Presently i use the following which close only the forms, but the Querys linked with the forms are not getting closed. Could some one guide me, how to close...

In one of my application, when i create a macro, the application create the VB script, but i dont know how to loop this.. for example, i want run this for 30 times, at the moment, i run this for 30 times, can someone help me how to loop this. [PCOMM SCRIPT HEADER] LANGUAGE=VBSCRIPT...

I created the access files in Access 2000 - But now we moved to Access 2003 - But when i try to edit or create forms in the access files created with 200 version, access takes the properties of 2000 - not 2003. For example, when i create the command button, it looks like the 2000 button not the...

In the Form View, for the better look for the user, How can i remove/Hide the attached part of the form. thanks, Prabhu

I have a problem with one Access file with the subject error. I am not even able to open this file; Please help !!!

I am using ODBC tables in my Make-table query and it was working fine. But recently i am facing " Could not find field ' Description ' " error msg whenever i close db2 file. I surfed in google and understood that the change in office versions may cause this error but i have not changed my...

Thanks for your replies. But is there any other way to do in query... i am not good in VB programming :(

Hello all, In my table i have mutiple criterias in one column like HE00, V00, -00 , STAT, VSTAT, HESTAT, -STAT, and lot more... I want to categorise my databaser like the following if its HE00, V00 and -00 then i want to give the category like NP Like STAT, VSTAT, HESTAT, -STAT then i...

Bob, I tried, but its still giving me the result as #error.

Hi there, I want to Format the date column from YYYYMMDD to DD/MM/YYYY or YYYY/MM/DD. I used FORMAT([something],YYYY/MM/DD) But its giving me #error. When i check the source table date column is with text property; i cant change the source table. I need to change the date format to...

Thank you John, It worked for me.

Hello, I compare two tables to find the differences and when the difference is nothing is there any way to get the result as mentioned in the attachement. Please help...Its giving me a hard time...

Thanks David, But do i need to enter in VB module? I am new to access and i manage access with Query only. Is it possible to get it with query. I tried entering this in Query field and but i didnt get the result.

Hello, When there is no data in the query result, How to give a default value like ZERO Thanks, Prabhu

Namliam, could you please provide little more information on how to do this?

Hello, My query which runs every day morning at a scheduled time takes data from a ODBC table, but this ODBC table asks password everytime when i access the table. Is there any way we can enter the password automatically by system. Please suggest...

dbDamo & boblarson, than you so much for both of your inputs. Its really helped me a lot. Boblarson, i agree your point. I dont have any option with me since its a very much critical data. there may be some otherways to do this as you said. But i am not familiar with this, all i know is very...