Search results

Hi I have a report that shows a list of maintenance jobs. Each job has a priority code for example planned maintenance is a P3 and emergency call out is P1. Is it possible to play a sound if a new record is added with a P1 status when the report refreshes which is set to around 5 minutes. So...

Hi I use an Access DB on my windows tablet, can I launch the windows maps app I downloaded from the windows store through a Cmd button? If so how? Thanks

Hi Is it possible to launch a windows app from a Cmd Button. I want to lauch for example windows maps. Thanks

I am currently using the following code on a Cmd button to load my next address on google maps for various work locations during the day. The problem is google maps through the website will not allow me to access the navigation option, I think this can only be done through the app. Sometimes I...

Hi Can anyone help with this. I currently use the following code to save a report as a pdf to my desktop. that all works fine but I need to somehow make sure it saves the report for the record I am on in the form. At the moment it just saves the first record. I do have ID fields on form and...

Hi I use the following code to save a report as a pdf to my desktop. All works fine. At the moment it save the report: rptDevPackPage1 I want it to also include: rptDevPackPage2 but only create one saved pdf with both pages on. In summary save two reports into one pdf file. Is the...

Hi I have a form with the following code on a Cmd Button to view a scanned or saved document for some fire safety certifciates. The scanned docs are saved in a generic Z:\ witht he file name always equal to the relevant property code. I now want to be able to print that same document from...

In simple terms: I have db local on my machine and several others I work on. All my tables are then linked to Sharepoint site so that the data is a) Secure and B) accessible from all machines with live information. The problem I am having is for example with my tblcontacts and frmcontacts...

Hi I have a form called: frmNewWork and a table tblNewWork which I use to create new jobs for then email the report to the relevant team member. At the moment the Cmd has a fixed email address in which I type in the new email address I wish to send to. On my form I have a drop down list with...

Hi Guys This one ive been struggling with for ages. I use the following code to check for dates within 30 days of today for some Fire Certificates from a table called: tblTenancies. This code works fine but I want it to also check the dates in a second field called: GasCheck and obvisously...

Hi Guys Advice on how best to display a link to a PDF file or image from a form. I have a table which contains information about safety records. Within the table I have a field called: GasCheck. This field contains the file path to a scanned copy of a Gas Safety Certificate or PDF document...

Hi Everyone Ok so I have been trying to get this code to work for ages but as a beginner keep getting lost. I have a form that depending what is in a specific field will display a specific command button to another form. I have read through and downloaded some of the following code I have a...

Hi I currently send a copy of an Invoice report using the following code that all works fine: Private Sub Command81_Click() Dim stDocName As String stDocName = "ReportInvoice" DoCmd.OpenReport stDocName, acPreview, , "[ID] = " & Me.ID DoCmd.SendObject acSendReport, "RptInvoice"...

Hi Everyone Not sure if this is possible I use the code below to send an email when a status of a drop down box has been changed, all works great but is it possible to have that email sent without opening Outlook so in other words it runs sending the email in silence? Thank you for any help...

Hi I have a db for some property maintenance. I have some code on the 'on open' function on my Nav form which checks some safety check dates within a safety check table and if a check is due within 30 days a simple alert pops up to remind me. I now want the code to check the dates in two...

Hi Really struggling with this one. I have a database that is linked to share point however if I have no Internet access I am unable to open database unless I put it into work offline mode. Is there anyway I can use a piece of code to create a button that will simply put the database into...

Hi I am looking for some code that I can put into the on click event of a command button to turn my database on and offline At the moment I use the option through external data tab Is this possible and can anyone help me with the code I'm happy to have two command button one for on line...

Hi I have a form which I use as a task manager, my tables are linked to Sharepoint so other members in my office have live data in my database. All working ok the only thing is when we complete a task we select a tick box which then displays a giant green tick to confirm task has been...

Beginner Here I have created a table "QuickCalc" and form "frmQuickCalc" to calculate some developments figures. I have a field "NHBC" with an expression of: =[TotalResale]*0.007. I have this expression in the control source so obvisously it is not saving these figures back to the table. I...

I am a beginner I have two tables: tbltasks & tblsafety Both tables have a date field in, one table keeps tracks of my tasks the other the expiry date of some safety checks. I currently have a timed pop up that looks at dates within a table that are within 30 days from now, if there are any...