Recent content by PietKruger

Thank you for your reply. It will be for a time clock system. Time in / Lunch out / Lunch in / Time out. I want to create a report that could be used as a payslip. i have 2 tables: TABLE 1 Id EmployeeCode Date TimeStatus and EMPLOYEE TABLE Id EmployeeCode EmpName EmpSurname HourlyRate please...

I am trying to create a "punch card" system in access. Does anybody have an Example or sample that i can use? Your help would be appreciated.

Hi, i am clueless. I own a small coffeeshop and would like to create an access database that could help me with the timesheets of my staff. They are paid per hour and their hourly rates vary. I would like my employees to click on buttons that captures the following: Date Shift Start time Lunch...

Hi, thanks for your quick reply. The database will run on a stand alone pc. i don't know anything about FE / BE. could you please explain? I'm new to database designing. Piet

Hi, Is it possible to have a query that shows only records for the current date and when you click on a specific record it opens in a form ready for editing? The query would serve as an index of transactions for the current date. Please help. Piet

Hi, I want all the tables of my database to export to a zip file when the users exit the database. this will serve as a sort of a backup of the data. Is this possible? if so, how? Piet

Uncle Gizmo, Thanx for ALL your help!!!!! Piet

I've downloaded your database and "played" with it. I imported your Module into my database and tried to modify your code to work for my database. I just got a lot of errors. I am so frustrated with myself. I feel so stupid. I've read the help file and it confuses me more. i quess to many new...

Hi, I have a form called bookings with a few text boxes. My database will be operated with a touch screen. as soon as the user click on one of the textboxes the frmkeypad opens. I struggle with the following code: I need the Value of txtnumber on the frmkeypad to be stored in the field of the...

Never mind, i managed to fix the prob myself Thanx anyway

Need help with backspace button I tried to change the code for the clear button to only remove the last character entered into txtnum Private Sub cmdCLR_Click() strNumber = Left(txtNum.Value, Len(txtNum.Value) - 1) txtNum.Value = strNumber End Sub it gives me a compile error...

Thanx thanx for your help. EXACTLY what i needed. Regards Piet

My database will be operated with a touch screen. I have a form with a few text boxes. I want the text boxes to open another form (numberpad), allow the user to enter values and when they press the "enter" button on the numberpad form, it should close and enter the value into the textbox. How...