Search results

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

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

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

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

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

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

Hello all, I take my database backup every one hour for some critical reasons and during that time i want the close the database from all the users. When i googling i found the below code but i dont know how can i modify this to run for every one hour and where to place this query in my...

Please look into the attachment... My table contains the data like this and i want to filter out the datas where colums G & H are not matching... how to get this...

Hi, In my make table query results, some of the fields are empty as they dont have any datas. while using this Make table Query results, i am not able to filter these fields, i tried Notlike " *" but its not working. Some one suggest me to fix this...

I transfer, users project staus update from Access tables to Excel on daily basis and make graphs with those datas. My problem is i want to project the grpahs with weekly intravels on X axis, but my grpahs shows the legends and values for all the days, is there any way to fix this; I want my...

Is there any way to export data from Access table to excel as a realtime process, like whenever user enters the data in access to update the data instantly in excel file.

In my forms, i need to calculate 30 working days/weekdays from today/everyday, i used DateAdd("w", 30,Date()), but it return only the calender days not the weekdays; How get weekday for period of 30days?

In my excel report, output Graphs are in one location and users data entry file in another location. I linked the datas from the data entry file to Output report file to generate graphs. But the issue is, my output file is not updating automatically, when ever i open the data file only then my...

Hello All, For my daily project updates from all my project members, i have created one form for the users to update the data in the from and to receive the data in access table for my analysis. My form contains the following data ID Date Time Data 1 Data 2 Data 3 now, when a user...