Recent content by mcktigger

Hi All I'm sure this has been asked before so apologies but I can't seem to find the answer I'm needing. I have a continuous form FrmJobsAllocation based on a query QryJoballocation. The user selects a person to allocate each job to then clicks cmdSubmit which changes the status of all the...

Hi I'm working on a db for recording job cards for fleet vehicle repairs. I have a form for creating new job cards with a combo box showing vehicle reg nos. This is based on a query which checks the customer id so only the vehicles for that customer are displayed. To allow for private reg no...

Hi Thanks for the reply. Sorry I was meaning a split db. Clients run Access 2003 so don't expect any problems but was worried about the be running on Server 2008 or 2011.

Hi All Is anyone running Access 2003 on either Windows Server 2008r2 or Windows Server 2011? We're about to upgrade our server and want to know if any issues continuing with Access 2003. Many thanks

Hi Thanks for the reply. I found a solution using: .display SendKeys "%{s}", True This displays the email then momentarily then automatically does the send in Outlook. This avoids the Outlook pop-up warning that is shown when using the .Send option. Thanks

Morning all I'm hoping someone can point me in the right direction with this as can't find a post that answers my question. I want to send automatic emails (without user intervention) when a user changes a record. I know how to send emails where Access launches outlook and the user hits send...

Hi All I have a serious issue with accessing our system. All users are all suddenly getting the same error message "You do not have permission to access C:\ProgramFiles\xxx.mdb. Please contact your system administrator". Nothing has changed on the network with permissions so looks like it is...

You're missing the point. If I remove the pop-up flag then the form will not be a pop-up form will it? The idea is to keep the same design as the rest of the system. Anyway I've put the following in the on double-click event to invoke the hyperlink dialog box. DoCmd.RunCommand...

Hi All Sorry if this has been raised before but couldn't find an answer. I have a form with a hyperlink field and the form pop-up property is set to Yes. When I right click the field to insert a hyperlink the hyperlink options are not available. If I set the pop-up property to no I get the...

Perfect worked a treat. Thanks for your help :)

Hi all Thought I had this sorted last week but a new issue has arisen. I have the following code on the BeforeUpdate event on a continuous form Dim intcount As Integer intcount = DCount("*", "[tblopportunities]", "[NextChase] =#" & [Forms]![FrmViewOpportunities]![NextChase] & "# and...

Hi Thanks for the reply worked perfectly. One day I'll get my head around how the syntax works. :) Thanks again

Hi All I have a continuous form which sale staff use to view and schedule calls. This works fine but I now need to limit the number of calls a member of staff can schedule for a particular date to 15. If someone tries to schedule a call and they already have 15 calls for that day a msgbox needs...

Hi Thaks for the help, I'll give this a try.

Hi All Hoping someone can help with this. I have a quotes table and want to create a report that shows the total number of quotes created, won and lost over a given period per sales person. I thought a cross tab query would work but having trouble with this. The quotes created would be a...