Search results

Hi, My Query results are in Numver formar like 0 & -1, i have to update this data (using update query) to a table where the field is in Boolean format like Yes & No. How to do this? Please help

Hi All, When i use the following code and call this in macro with Runcode function,i get a error msg stating, " you cancelled the previous operation " please help ExporttoExcel ' '------------------------------------------------------------ Function ExporttoExcel() On Error GoTo...

Hi, I have table with data from 2010 to 2015 by month, in my access graph i have option for the user to select the year and view the graph. I used a Query to do this and linked the query to the graph. Everything working fine when the user select the year graph appears for the right selection...

In My table, i have a field with values 0 and date. i am using replace function to change all 0 to No using the below replace function. But while i do this, the 0 value in date also converting to No. Like the following 25/5/2015 changing to 25/5/2No15 But i want the data 0 to become No...

Hi there, I am developing a dashboard in MC Access 2013 I have 1 main form and 2 sub forms. In main form I use three comboboxes to filter the data and one I click the command button then the Left subform will display the filtered results and rightside subform will display the...

Hi, need your help to fix this. I have to make a query using the following case, I have two tables, in the first table i have the materials and its received date and in my second table i have the month the target date for every month to receive the material. Now linking this two tables, i...

In my form, i would like to sum and dispay the values of datas from two different tables. Table1: MasterTable1 Table2: MasterTable2 I use the below code for one table and its working. Text15 = DCount("[client]", "[MasterTable1]", "[Confirmed]=Yes and [Assigned]=No") But i want to sum the same...

While applying filter in forms, i have 6 fields in the form and i want to display the data even one of the filed is with 0. I used the below code, but this one display the data where all the fileds are 0. I tried or in place of and but still its not working. Private Sub Form_Open(Cancel As...

In my Access forms, i display data by month wise; and i want to give the conditional formating with two condition; If date of today is greater than target date for that month and if got value more than 0 - Red color If date of today is lesser than target date for that month and if got value more...

All, I want to count data from my table ( Table ) and to display result like a dashboard (Desired result ). To count this what is the better way to do it? do i need to write query for every column and then link to final column? i have totally 300 columns to count I am attaching Table & desired...

Dear All, I have attached a file with Table, Current Result & Desired Result. I have a table with Month, A, B to G with True or False check box inputs, what i need is on every month, in each category what is the total False; In the past, i created a count query for each category like A to G...

I have a table with Orders Confirmed with Products A to C for which the orders are delivered or not. I want to see the output with Confirmed orders which were not delivered to customer for each product category; I dont want to do the crosstab query for each procuts seperatly so used sql but i...

Hi there, I have created a Access tool in 2010 and its working fine with the users having Access 2010, but when the user with Access 2007 try to use this they are getting the attached error. When we install 2010 trial version the same file working fine. How to fix these, for budget reason i...

In my forms which i was using ii for more than a month now, i used Me.UniqueID, it was working fine and last week i made changes the Tab Index in my forms and after that i get the Method or Dataformat not found error. So when i remove the line and try to add Me.UniqueID, i don't fine the...

i used the below code in my subform and working fine. but when i link this subform to my navigation form, i am getting runtime error 2487 while closing the navigation form. how to fix this? Private Sub Form_Close() 'Provide the user with the option to save/undo 'changes made to the record in...

Hi All, I am using Access 2010. In my database forms, i try to use Ctrl + F and its working fine. But when i link that form to a Navigation form and tried ctrl + F , i got the following error message, how to fix it. Error msg. You Can't use find or replace now. I also attached the error msg.

Hi, I use Me.Filter & Me.Filteron to filter the data from the table to display in the form, i used this in On Open event & This is working fine. But in the filtered form when the user right click and filter some value and unfilter the search (in the bottom of the form next to search...

In my table, every Job (row) will have maximum 10 activities to perform, in some jobs only 5 activities only performed. For every job which activities to perform will be defined a supervisor using a form and it will be stored in the table. ( i used check box) In my table i have the fields for...

any time, i open a form i want to apply this two filters [Query1].BD=Yes And [Query1].BD_Completed=No i used it in form>property>Data>filter, it was working fine but its often disturbed by the users and filter is not working. How to do it in a more secure way?

In my Access form, users update 4 checkboxs when their work is completed, when this 4 boxed checked then the 5th checkbox will check automatically using afterupdate. Now i have added the 6 the column with date completed, here i want the date to be updated automatically when the 5th column is...