Search results

thank you for helping me... its working fine.

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

Thank you... I got another question, when i use < symbol to find out the dates less than today, its giving me all the values, including dates greater than Today also. What is the problem in my approach?

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

thanks, but IS not null - not working

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.

Since InspecDate and StoreNum are always unique, in your table design view, Add one more field Date and keep the " Indexed " as < Yes (No Duplicates) > for the fields Date,InspecDate and StoreNum . hope this help...

thanks, but this is to caluculate the no working days bw two dates, in my case, i need to calculate the 30th working day from today.

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

MStef, Only thing i can say is "GREAT" Nz is working in my query. (Diff of ok, Not Diff1) i am really excited after seeing the reults. Thanks for your quick response.

Could you please change it to 2000 version and send it to me. i am using access 2000 and i am getting the following error msg when i try to open u r file < database is an unrecognized format >

Mstef, thanks for your points. i am new to access, your points solved my issue. i verified those fields and modified, now its working. One more question, in my Qty 2 column if there is no value its showing empty. is there any way we can get Zero when there is no value.

Thank you Namliam, Acutally i am new to access,one of my collegue told me that when we run the queries (big queries) directly from ODBC tables it will take time for the query to give result and he suggested to create the copy of the tables in my local drive or share drive using make table and...

In my query, i use to calculate the difference between two fields. like Difference between Qty1 and Qty 2. I use " Difference : Qty 1 - Qty 2 " . But when ever Value of Qty 2 is more than Qty 1 its giving me the result as 0 instead of giving -value. how to fix it.

Hello all, Please suggest me what is the best way to get the good looking graphical output from access.

Thanks for all your replies. I am trying to make this with ODBC database and it got around average of 1,00,000 records.