Search results for query: *

Thanks for your help, ShackDaddy and TechSoEasy. I have tried your suggestions but when I try to delete the SMTP address from the old user it won't allow me to do it, saying it is the primary address. Should I switch the primary address to another one (the only other one says X400), and then...

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

Gary, Mark Thank you both for your suggestions, they are both better than the code I currently have. I had completely forgotten about the Required property, I can now think of more places in my DB where I can use this. However I am still curious to gain answers to the 2 questions I posed in m...

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

PHV Don't know why MONTHNAME won't work in the rowsource. It works in code module, just not in rowsource. TheAceMan1 I see your point, however... startTime is a field from tblHours which is a date stored in "General Date" format The month is stored as part of that field, obviously. All I...

mstrmage1768 Brilliant...works perfectly. Obvious really, should have thought of that. Thanks Gavin

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

Aaah! Yes! Good point... To try and explain fully what I am trying to do with this report would make this thread very long and boring. I think I'll leave it here and have a rethink. Thanks for the advice though... Cheers Gavin Closed Thread..........

Mobyduck I agree with your logic, my problem however is how to reference the first and last records in the report. i.e. in your code where you state me.recordstart and me.recordend Cheers Gavin

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

Remou Sorry, just seen your last post about the On Open event of the subreport after writing my previous reply. Will try that tomorrow (It's 17:15 my time and time to go home for the day...) Cheers Gavin

OK Cheated slightly.....but got it working In the RecordSource of the subReport I now have the SQL statement as follows: SELECT * FROM tblExpenseItems INNER JOIN tblExpenses ON tblExpenseItems.claimNumber = tblExpenses.claimNumber WHERE...

Remou Thanks for the advice. I will try to use a query in the subreport, that picks up the dates from the parent report. I don't think in my parent report setting the recordsource for the subreport will work in the OnOpen event as the FromDate and ToDate do not get loaded/set until the...

Ooops... Damn! Makes no difference, still getting same error...

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

Vragabond Thank you! That has been bugging me for ages. Your solution works just the way I wanted. Cheers Gavin