Search results

Steven! I have commented your codes purposely for that reasons only, because in your case if you uncomment the code where it is not necessary, it again enable the checkboxes in the on current event. To check which condition to be true on form current event, just put the break points in your...

Good Eyes:cool:

Because I want my table with as many as good fields in it :p

The bob is great, in Access you must use # # in SQL statement before and after any date entry ;)

Steven, I study your database and add some code on the subform current event. Please check it out and include it to your "Frm Vragenlijst" form. Private Sub Form_Current() '========================== If BodemGoed = True Then 'Als de BodemGoed JA is dan NIET invoer andere van 14...

Dcount Function could solve this: This is an Air code, change the bit of Table1 and EmpID to your table and Field name. Another methode is to Open a recordset and count for the "Present" and "Absent" criteria which is more flixable: this is an air code, sorry for SELECT statement coz I...

Hi Tanya, if you can change your code for SQLText Function to: then see what is happening? This will remove the apostraphe from your ID but still it will not show the result for Id = "O'HARA1" I don't think that any ID should contain with the apostraphe... my suggestion is, if you can...

Hi Steven, Your seems that you are using Radio Buttons or Option Buttons where one option is checked and then others are qray out? can you please attach your db so that i would be able to solve it as per your request. Thanks

This mean that you are also storing data in a table bound to the check boxes. If you want to store the check box to be checked for every new record, then change the default value of the check box to 1 in the table structure Or on your form under the default value property. 0 is the unchecked...

Okay! you can change the code to get the duration for days here: Try to understand the DateDiff Functionalso

Are your check boxes are bound to any field in your database? the field should have the Yes / No data type property to store the check box data in the table.

Hello Venu, This might helphttp://allenbrowne.com/casu-13.html

Hi Yunus! Welcome to the AWF, this link might help to solve your case: Use a multi-select list box to filter a report

this is common for all the versions, you have to change the form name to your formName which you want to close. docmd.close accForm ("YourFormName_tobeClosed") you did not post the code of printing the report... you can go to the code by right clicking on the button then in the event property...

what the code you are using to print the report? can you post the OK button code here? and also the form name you want to close.

Hi Tanya, Welcome to AWF, Did you try to find your record using combo box filtration? the combobox solve this problem for data with the punctuation marks. In access 2010 the combo box will convert your code for find first in embedded macro (which i don't like) but still it will find the record...

in VBA code of the Report Print Button, just write this code after the report Preview code:

Hi acwest, instead of deleting data from from the LoanHistory table from CDCopy table, just consider to change the status of the cd to be "Returned", "Borrowed" etc. Deleting of any record is not a good idea for inserting new records, rather you can make the CD's status to "Returned" &...

Hi, Welcome to AWF There are multiple reasons why records are not updatable? is your query is lying under the above conditions?

you can attach your screen shots here also by clicking on advance button below this post and then by clicking on Manage Attachments...