Recent content by Samulayo

Thank you for your replies, I have decided to proceed by having a the user enter the data to a temporary table and using the DSum() command on that, and when the user presses 'submit' the data will be written to the main table using an append query. Regards Samulayo

I am producing a time recording database for a large company and have a front end installed on each computer for accessing the backend data. The front-end timesheet entry is basically a single record form with a continuous record subform linked via a replicationID produced on the first form. I...

re: godawgs Sorry I didnt make explain correctly, I implied I was using =sum([field]) or =dsum([field]) But I just used =sum() to explain the function I was using Sorry if i caused any confusion. Regards Samulayo

I have a continuous add records form, and require a box in the form footer that will add up the value of one field for all of the records shown. Im able to achieve this on a report using =sum() but i cannot get =sum() or =dsum() to work on this form, The textbox just shows 'Name?' Any help would...

I'm using the MS access security system and I was wondering if anyone knew of a way to create a form to delete a user from a workgroup or just move him to a no access group. Thanks to some direction from JeremyNYC I am able to add a user using the CUser function from Microsoft and assumed this...

Thank you very much, I shall try this out over the next couple of days to see what I can produce. Have a star for your trouble Regards Samulayo

I'm using the MS access security system and I was wondering if anyone knew of a way to create a form to add a new user to a workgroup and add him to a certain group. How easy it is to do this using Access 97? Regards Samulayo

Hello all, I have two queries called active and timesheet, which shows the current active personnel and a list of all accepted timesheets respectively. I would like to be able to produce a query/report that would show a list of all active personnel who have not submitted a timesheet for a...

Overview: to have variable rates for generating a report in Access 97 Detail: I am designing a timesheet organisation database, whereby users can enter their timesheets for the week etc. in one FE, and then the administrators can review the timesheets, accept/reject them, and produce reports...

Overview: to have variable rates for generating a report in Access 97 Detail: I am designing a timesheet organisation database, whereby users can enter their timesheets for the week etc. in one FE, and then the administrators can review the timesheets, accept/reject them, and produce reports...

Thanks for the replies. I have found no real way to do this, so i have decided to use the method of highlighting the record that is discontinued, the code for which i believe was writen by bill powers. Regards Samulayo

Sue, the use of a batch file to close the database would result in the same situation as if someone had just pressed the [x] close access window button. Any error messages _should_ be displayed before the window closes. Any unsaved records would (unless you use an update query or similar) just...

Damn it, I suspected as much. Thanks for the heads up before I told anyone about it. Regards Samulayo

Hey, this is my first star, don't take that from me! Also it requires the least amount of time/effort to do and maintain. Regards Samulayo

Right to clear up that confusing title: I use the bellow code in access 2000, but now require to use it in 97. Private Sub Form_Current() Dim ctl As Control On Error Resume Next For Each ctl In Forms!<Formname>.Form.Controls With ctl If .Tag =...