Search results for query: *

I am new to sys admin (being given the job by default) and a have what maybe a very basic problem. We have two employees leave the company, and two new ones start. In Active Users & Directories I have: 1. created accounts for the new employees and their outlook email accounts etc. are working...

I have developed an Access DB, with a separate front and back end, that uses the Access Runtime available from the Access Developer Extensions in Visual Studio 2005. It works fine in our HQ, and as a stop gap solution I was considering installing it on our server so that 3 guys in remote office...

I have the following code in the After Update event of a combo box on a form. Private Sub jobNumber_AfterUpdate() If (<<condition 1>>) Then MsgBox "Please choose different job Number" Me.jobName.SetFocus Me.jobNumber.SetFocus Else .... End If End Sub I want to keep the focus in the...

Is it possible to hide a field in a table? I have searched tek-tips and google and can find no answer to this. I want to do this as I intend to distribute an mde to external parties and there are fields I would rather them not see. I realise I could create a new table and hide the table, but...

After struggling with some code I am looking for the reasoning behind why the following occurs. I have a bound combo box (employeeId) with the limit to list property set to Yes, and the bound column = 1. Entering a erroneus value prompts the "not in list" error message as expected. But by...

A current conundrum I have is with an existing Access database that is used in our office, with a local version in use in a satellite office. The satellite office does not have access to the network in the head office. A requirement has become apparent to merge/import the data tables from the...

I have a combo box that has SELECT DISTINCT MONTH(startTime) FROM tblHours as the rowsource. This is great, but only shows the month number e.g. for January shows 1, February shows 2, etc. How can I get a 2nd column in the combo box to show the month name e.g. January, February, etc. I know...

Ok.....will try to keep this brief. User enters start and end dates onto form (frmJobHours). Report (rptJobHours) shows records between those dates. Text box on rptJobHours (called remainingBudget) has a calculated value equaling total budget minus total of expenses in all records on report...

I have read loads of the threads on this subject but can find no solution to my particular problem. I have a report rptJobHours that contains a subreport rptExpenseItems. I wish to update, on the activate event of the main report, the recordsource of the subreport dependant on the values of 2...

Small problem, and I know the solution should be simple. I have form called frmExpenses This has a sub form called frmExpenseItems. In frmExpenseItems is a textbox called totalAmount. In frmExpenses when user clicks command button, I want to send totalAmount value to an Excel spreadsheet...

I have 3 images in my header frame. I want to 'justify' align them so that: the 1st image is left aligned. the 2nd image is centred. The 3rd image is right aligned. I know the align attribute in the img tag is deprecated, so would prefer not to use it. So 2 questions... 1. Can I do this...

I have designed a db to record employees clocking in/out of various jobs during their working day. One table (tblHours) holds the job number, work type, employee ID (all of Number type), clock-in and clock-out times (all of General Data type). This database has just been put into use in the...

The group detail of my report contains all the employees' details - e.g. name, start time, end time and a text box named "hours" that subtracts start time from end time. This is all OK. In the footer for this group I have a text box named "employeesHours" The value for employeesHours I want...