Search results for query: *

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

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

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

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

i have a continuous form with 5 fields on it ID medication date perscibed discontinued y/n date discontinued I would like the field date discontinued to only be enabled when discontinued y/n = -1 (yes). I can do this with ease using form current and after update with a single form, but how...

i have a nodata sub (as below), which gives a message if there are no messages, this is fine, but then an error message appears saying that you have cancelled the loading of the form etc. then an [OK]button. how can i stop the report from loading when there are no records without making this...

I have a message box appear for users to enter the data required in order to filter a form, just the standard query message box. Now a user would like to be able to see all the records in the list, as well as being able to select a certain range. What is required to be entered into the message...

Hello, I was wondering how it would be possible to have several whereconditions for opening a report based on a query. I'm using this for a simple search/filter form and i need to be able to pass 3 fields (discipline,userid,date). The below code will open the report costcode 11 and defines the...

just a quick one, what is the command so that the default value of a combo box is the first row of the combo's list? Thanks in advance Regards Samulayo

Does anyone know if it is possible with windows 2000 for a dynamic shortcut to be made to an access db. so that instead of having c:\dbs\prog\prog.mde scripts in unix can use something like this below ..\..\prog\prog.mde any ideas? Regards Samulayo

How would i be able to get personnalised error messages so that if say, Error 3022 (replicate record) appears, instead of giving the long list and asking to either end or debug, it would say &quot;this is a duplicate value&quot; then an OK button which resets the problem (in this case the date)...

I'm creating a timesheet database and the entry of a new timesheet requires the date and week number that the timesheet corresponds to. I know how to find the week for the current date using =Format(Now(),&quot;ww&quot;) in the default value of a field, but i would like the week number for the...

I'm creating a timesheet database and the entry of a new timesheet requires the date and week number that the timesheet corresponds to. I know how to find the week for the current date using =Format(Now(),&quot;ww&quot;) but i would like the week number for the date entered to be the control...

I am creating a timesheet entry database for my company, which will allow users to enter their times worked each week, view previous timesheets, rejected timesheets etc. If we take rejected timesheets as an example, if there are no rejected timesheets, how do i get a message to be shown instead...

Hello, I have two tables (actually more but two in question) one holds data about an operating system module (engineering not computer OS) and the other the info about hazards on the OS cut down view Table1 Table2 OSNo----------<OSNo (one-many) Desc Hazard When filling...

Hi all... Right, the client creates documents with UNIQUE NUMBERS but with DIFFERENT REVISIONS. For Example: 1001 Process Description Rev: D1 1001 Process Description Rev: D2 1001 Process Description Rev: A 1002 Equipment List Rev: D1 1002 Equipment List Rev: A We'd like to...