Search results

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

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

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

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

Hi All I know there has been a lot of posts about this subject but I can't seem to find a solution. I have a split DB. FE on each client and BE on network drive. When running the Db in working mode all is well and speed is not an issue. However when I'm updating or adding queries,reports or...

Hi All I have a cmd button that opens pdf files saved on the server. This works fine on a number of PCs but on 1 machine the user keeps getting the warning: Opening server\xxxx\xxxx Some files can contain viruses or otherwise be harmful etc etc Would you like to open this file - Yes / No...

Hi All I have a report with a number of unbound controls which show a default value. The report loads fine and displays the correct values as it should. However I need to change the values on some of the controls but for the life of me can't find / remember where I set the the default values...

Hi All I've just installed Win2Pdf which is excellent for creating and e-mailing PDFs. However what I want to do now is automatically save the PDF with the name of the on screen QuoteId and attach to an email. Currently Win2Pdf requires the user to save the PDF and I want to avoid this. Any...

Hi All I have a linked foxpro table in my db I need to query. In the Foxpro system there is a text field where users put in a date so no validation to ensure that the user has put the date in the correct format (I can't change the foxpro system). I therefore need to run an exceptions query to...

Hi Hoping someone can help with this problem. I have the following code on frmpricing when the record is saved. For Each Ctl In Me.Controls If Ctl.Tag = "QuoteLine" Then If Ctl.Value > 0 Then iProductID = DLookup("[ProductID]", "tblpricelist", "[FormName] = '" & Ctl.Name & "'")...

Hi All I've been trying to figure out this problem for a few days now and getting no where fast. I have an unbound form used for pricing products and services. The form shows sell price, qty, margin etc and the user enters the qty if selling that product. I want to take this data...

Hi I'm trying to check if a timesheet for a certain employee on a certain date has been entered already and if so display a message. I'm using the Dcount function on the after update event on a combo box but keep getting o records. My code is Dim IntCount As Long IntCount =...