Recent content by Poppa Smurf

First I would keep using your excel spreadsheet. At the same time define your requirements for the database then build your your database requirements. This will save you a lot of time. Attendance are you recording it daily or monthl?

I use an unbound form and do my validation when I press the Save button and before I save the data

Now is this weekly payment before tax and any pre-tax deductions are made? Assume an employee is paid each week regardless of the number of days worked. From this weekly payment you will know the base pay and the overtime worked for that week. Using the extracted data create a query that lists...

I would like to add one general comment regarding averaging. You can not Average and Average. This is mathematically incorrect I would think in the week footer =Avg([basic] + [Overtime]) in the employee footer =Avg(Avg([basic] + [Overtime])) Personally I would total the Employee's weekly...

You could use the Object Dependencies in the Database Tools menu. This will show you where the table is used in forms, reports, queries etc.then it is just a matter of checking the record source.

Hide your subform when the form opens. Then display the subform after the search.

Add the highlighted line of code, you are not calling DisplayImage for the second Image on your report. Option Compare Database Option Explicit Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Me!txtImageNote = DisplayImage(Me!ImageFrame, Me!txtImageName) Me!txtImageNote2 =...

Try making the query as Basilyos stated in his reply. I suggest you look up how to use a query to show totals, then if you have a problem we will try and help you.

You are in your final Access class and you have not used DLOOKUP whilst in the course, AMAZING As previous posts stated use the Internet and search for results. In the "real world" no one is going to solve your problems unless you put in some effort. Your database size is 5MB have you done a...

You maybe able to use the ENVIRON(variable) as follows Sub get_comp_name() Dim compute_name As String compute_name = Environ("Computername") Debug.Print compute_name End Sub This code will print the name of the computer or laptop. But there maybe a possibility the name may change due to a new...

Foe . From your previous posting the users are using the same data for the reports and there is a possibility of more than one user using the same report for different date ranges. Regarding my comment above, if only queries are used for the record source for the reports then there will be no...

You can use the form data source to add new SHOPS or new PROPERTIES but you can not use a form data source to add both.

For reporting purposes have you considered having a database on each users workstation that will handle the data manipulation for reports? This database will be linked to the users front end on their workstation. In your current environment is there a possibility that the users may generate the...

Using the AND to join the three conditions e.g. ([Location]<>"home") AND ([Location]<>"work") AND ([Location]<>"Bank') etc.

Post a zip copy of your database to my email address below and I will do the linking the for you. I will also explain how the linking is done etc and look at your error message.