Search results

Hi all, I have changed some VBA code for an email within access through outlook. I have used this code succesfully before and it is tied to buttons within my database without an issue. The problem I have now though is the HTMLbody section is coming back with -1 rather than the information it...

Hi all, I am wondering of a way to create a calculator for adding up how much medication someone has at any given time. For example. If Bill collects 28 days supply of medication on a monday morning consisting of... Paracetamol 500mg x 224 (two to be taken at breakfast, dinner, teatime and...

Hi all, I'm after creating a button which will allow me to email my staff a specific file. Each staff member has a file for each month with their timesheet. I'm going to build a form with two variables. Year and month. Once you have chosen them press the button and it will email out the...

Hi, I have a query with a sum that works out a persons annual leave based on the days in the year, the days they have worked and the average weekly hours they do. This can change throughout the year so I have a stepped process that would work out the total before the change and the total after...

Hi all, I want to make a database of contacts with email addresses and telephone numbers. And I want to assign them to groups but I want them to be possible to be assigned to multiple groups. Basically so I can write an email and send it to the group I want to but then get access to send only...

Hi all, I'm after showing a button to cover some other buttons when a combo box has a certain value. I am using this code but am missing something... Private Sub Combo7_AfterUpdate() If "1" Or "2" Then Me.[Command21] = Visible = True End If End Sub When I do it says... Run-time...

Hi all, I have built a simple database (by no means complete) but I am after adding some further code into it. Basically on the form [FrmMain] I have a button that allows me to send a document to a relevant CSU contact. It finds the file name based on the info in the table TblResident. What I...

Hi all, I have a VPN tunnel across 3 locations in work. Due to the tunnel and the setup it is very very slow. I have tried splitting my database and having the backend on the network but it is unusable. I have ended up splitting the database into three and having one at each location. This is...

Hi all, I have two tables. One with a persons name and ID, DOB, GP etc (TblName) and one with the persons ID and medication they take (TblMedication). I have a query that runs a report. The header is made up of the first table (TblName) and the body of the second table (TblMedication). All...

Hi guys, Just wondering how easy it is to add a button to a form with a function to copy a zipped file to another location and unzip it? Cheers, Paul

Hi all, I have been wondering whether it is possible to do something with a database I have. I make time sheets for staff members at work. I currently use a system of a bunch of word documents with a four week template of their hours on and I create a default word document template for the...

Hi all, I'm working on a database for residents at a care home. I've just started and I want to automate a process where I can click a button and see the contact details of a GP. It's all working but I want it to be that if the resident has no GP it will open a form so you can choose a GP. I...

Hi all, I have a database with shifts in for staff. They have a bunch of times in and times out over a four week period. I have gotten an average weekly amount of hours for each staff member based on this but I need another equasion to work out their leave entitlement. It breaks down like...

Hi guys, Massive one this... I have a table with staff in. I have a table with the start and end of their shifts. We have four possible locations and four weeks. So I have four tables for each location. I have a module that can work out hours and deductions based on time in and out. I built...

Hi All, I've got some vba running on a button press. Basically it works like this... I want to add an outlook reminder... I have a yes/no box that is ticked if the reminder is already added which would then mean no further action is required. If it's no it checks the "ProposedProbationPeriod"...

Hi all, I have a button on a form and I want it to do two things based on whether a field is blank or not. I am getting errors and can't seem to sort it. I have attached the code. Thanks in advance... Private Sub Command15_Click() If Me!ProposedProbationPeriod = Null Then Dim outobj As...

Hi, I am using Access 2010 and want to open a new form based on an ID from a previous form. Access makes this very easy to do in the macro builder but I am unable to replicate this in VBA afterwards. The reason behind this is I want it to also run some code to export some info to Outlook. I am...

Hi all, I have a query that has some reminder dates. 10 days before an event and 5 days after. I was wondering if it would be feesable to create an outlook reminder based on the query and if so how would I go about it? Cheers, Paul

Hi, I have a report for giving medication for a patient. The report is complete but it puts one set of medication per page based on the patient ID. Which is what I want. But some patients only have one medication so I am left with a lot of white space. Is there a way to repeat the data on the...

Hi, I have a form where I can add a new resident. It runs off a query that shows ID as null and has a button to add the data and refresh the form and query. I used to drop in OLE files but have since changed it to a linked image file. What I want to do is pull the info from the data that I...