Search results

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

someone help please...

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.

Well, not me, but when the users do this, i have a risk that they may update the wrong data. so i want to control this, is it possible

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

Thank you but I can't base the query, because i use the same query for two different forms and the filter criteria is different for two forms.

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?

Thank you CJ, i tried as you said, but its not working. Check 110 is auto update, in this case for the date update, which event should i use?

Breaking my head Private Sub Updatelast() Me.Check110 = Me.Check88 And Me.Check90 And Me.Check92 And Me.Check94 And Me.Check96 And Me.Check98 And Me.Check100 And Me.Check102 And Me.Check104 And Me.Check106 And Me.Check108 End Sub this is my code. I have used afterupdate in all the checks from...

Hi, you are right, i tried and i get the dates when i check the box. but when i uncheck the box the date is not disappearing, is there any way to fix this.

Private Sub check110_After Update(Cancel As Integer) If Me.Check110 = "Yes" Then Me.Text125 = Now() End If End Sub I tried like above but it was not working. and For check 110, input is automatic. i.e. user check field 107,108,109 then 110 will be updated automatically. I have used...

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

Thank you!!! it's working!!!

Hi, I am using the following 2 codes in my forms before update event, Ist code is to warn the user if he dont choose any one of the check box and it will give the msg box only when the user not selected any one of the check box, and i want the second code not to run and display the msg when...

Hi, I have three check boxes in my form and i want the user to select any one of the check box, if not, i want to display an error msg? How to do it?

Thank you!!!