Search results

Sweet thank you. I'll get on the normailsation!

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

Fixed it... Private Sub Command15_Click() If Me!ProbationDateAddedtoOutlook = True Then MsgBox "This probation date already has an entry" DoCmd.OpenForm "FrmPrevTrainingRec", , , "StaffID = " & Me!StaffID Forms("Frm3").SetFocus DoCmd.Close Exit Sub Else...

Here is a screen grab with indentation

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

That was it brilliant thank you!!!!

Here's a screen shot

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

I managed to figure it out a different way. Rather than closing the form first you open the new form and then change focus to the previous form and close it. Therefore it holds the value rather than trying to hold the information after you have closed the form. Private Sub ButtonName_Click()...

It's just weird cause if I use embedded macro option it works fine

Ok thanks for your replies hopefully I can get it sorted and when I have I'll post back

Managed to convert the macro to VBA and got this. Don't know if it is helpful? '------------------------------------------------------------ ' Macro1 ' '------------------------------------------------------------ Function Macro1() On Error GoTo Macro1_Err With CodeContextObject...

Run-time error 2467 The expression you entered refers to an object that is closed or doesn't exist. Yes the reason it refers to a different form is that is the working macro from another form that does the same thing. I want the ability to do that in VBA if possible. Thanks again.

Hi, Thanks for the quick reply. The option to convert is greyed out unfortunately. I have tried your code but it comes up with an error. My macro looks like this... CloseWindow Object Type - Form Object Name - Frm2 Save - Yes OpenForm Form Name - Frm3 View - Form Filter Name - Where...

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 got round it by adding the images to the reports by creating a query with the selected info ("C:\Users\RP\"&[First Name]&" "&[Last Name]&".jpg") and pointing to that but thanks for the reply :) 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...

It's your choice whether you download it. 5 people felt it was ok to. Thanks, Paul