I get lot of spam comments on my Website and I can undertstand the gravity of this issue. I remove them without even reviewing. You may take...
Copy and Paste the following Code into the Form Module with appropriate changes to refer the Controls correctly: Private Sub...
Both the reports in question copied and modified with the suffix 2. rptCCE Employee Development Report - Directors2 rptDegreeByDirector2...
The Products appearing on the Sub-Form are related to the Supplier record on the main form. The products value summary is calculated in the...
Access2007: Click the Microsoft Office Button [IMG], point to Manage, and then, under Manage this database, click Compact and Repair Database...
Run Repairing/Compacting untility at least once in a week. Take a Backup of the database before you run the above utility. You must have...
Create a UNION Query with the following sample SQL: SELECT Table1.Field1 FROM Table1 UNION Table1.Field2 FROM Table1 UNION Table1.Field3 FROM Table1
Modify the SQL as given below: SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(POPDATA.CITYNUM) AS COUNT, DCOUNT("*","POPDATA") AS TOTAL...
You may use the following expression to build the yearly changing number: x = "IAZR-" & UCASE(FORMAT(DATE(),"dd-mmm-yy")) &...
Since, your excel file is also linked to the Access database you may use and Append Query, using Excel Table as source and the Access Table as...
Open the Form in Design View Click on the [End Time] Field Click on the Property Sheet icon on the Toolbar to display the Property Sheet of the...
Correction: ? WeekDay(Cdate("18/12/2010"))
Use the WeekDay() Function to find out the weekend day. ? WeekDate(Cdate("18/12/2010") Result: 7 if the result is seven then it is weekend day....
The sample VBA Code below reads and prints (in the Debug window) the contents of a Memo Field (Notes) from the Employees Table of MS-Access sample...
Re: Archaeological database - Need help with update query: Replace__with___where____= Instead of running an Update Query every time when you find...
Try this Code: Public Function RandomNumbers() Dim rn As Long, j, k Randomize (Timer) For j = 1 To 50 k = Int(Rnd(1) * (9999 - 1000)) +...
Separate names with a comma.
