Search results for query: *

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 =...

Found a round about way for you to do it. Use Task Scheduler to schedule the bat file to run whenever you need it to. Open notepad and write: C: cd\{path} xcopy info.log &quot;{path}\info.txt&quot; /s Where the 1st line indicates the letter of the drive where the log is stored. 2nd line...

Why don't you use a batch (*.bat) file to do the closing of db1 and open db2 and then just stick a button to run the bat file on the open db2 button. I use this method to allow the user to make backups. off the top of my head i cannot remember the close command. All you need is to write it in...

Does the output HAVE to be in access, if the guy just wants to view the output outside of access, then why dont you create a report from the required query, make a toolbar with an save as button, and save the report as a snapshot. this file can then be viewed using microsoft's snapshot viewer...

Hello DPye Thought i'd lend a quick hand, just change the random generator line from this: strApprovalNumber = strApprovalNumber & CStr(Format(Int((99 - 0 + 1) * Rnd + 0), &quot;00&quot;)) to this strApprovalNumber = strApprovalNumber & CStr(Format(Int((9999 - 0 + 1) * Rnd + 0)...

i make my own mainbar to replace the file one and set each form to use that one, use the start-up settings to turn off most access to stuff, turn off the ability to bypass autoexec and make an mde. And of course access security/permissions thing if required There's probably more ways to secure...