Search results

Hi there, My exercise is to split a thousand or so email addresses down to managable groups of 100 [ISP prefers this too] I have easily created the query to extract the email adresses and used sendobject to get them to outlook. But what I need is an idea of how to select them in groups of 100...

Hi, after resourcing my Runtime 3075, I've now backed into this one. I'm trying to check a condition that a user has a previous certificate type and then pop the User to show the condition. Print is a yes/no field, ID fields are numeric. Have I got this right? Appreciate any help it's almost...

Hi, I have a report I produce for renewals. I would like to be able to change the way the output is sorted. Currently I enter a date range for when I want the renewals, this then becomes the top sort order for the output. I.E. letters are outputted by date range. I would now like to be able...

Hi, I have a working pop-up calendar, courtesy of the samples database. I am currently employing it in a Leave Records Table. Application date, start and end dates all on the double-click event. For the EndDate I also have code in the Before and After events. I run calculations to see if...

Hi, this is more of a planning problem. I'm stuck on a method of attack!. I have a multiple tab form, with subforms on most tabs. The main form populates from a multiple set of querys, rendering the main form un-update-able. Most the data relates to an Employee. The subform in question records...

Hi, I've done a bit of research, problem not found. I have a tabbed form running from a multiple linked query. I am using the Toolbar filters and right-click options to do basic sorts. It filters okay, sort of ...:rolleyes: I get a parameter input box asking for the EmployeeID, which is...

Thought this would be a good solution, but having trouble with the syntax. =DLookUp("[StartDate]","[tblJobHistory]","Me.[EmployeeID] =" & tblJobHistory!EmployeeID & " AND Min([tblJobHistory]![StartDate])") I am getting the dreaded #Name? can I use the Min command like this? Any help...

Hi am having a problem with my weekday formula (kindly provided by the forum) thanks:) However I am using it in a Select Case and it doesn't appear to be working. I have tracked it from a breakpoint and it just bypasses the checking. My code Is: Select Case Me.EndDate Case...

Hi, I have found the answer to most of my problem, thanks to previous posts. I am using the Undo command on a Date field. However it seems that my code is maybe not staying on the event to action the undo. After it runs the Focus goes to the next field Me.LeaveDays and the value is...

Sorry if this has come up before, I have been chasing dozens of threads that are so close, I've still not got it!:o I have a form that is used in edit mode and add mode. When used in edit mode it has a combo box in the header that does the usual bookmark search in the after update event, and...

Hi, Am looking for someone to talk about how Annual Leave might be calculated, given that an Employee can have a different entitlement over their employment with a company. Mainly interested in calc'ing a daily entitlement, and not getting involved in any Payroll side of things. Much...

Here's a sticky one? (maybe...) I have a number of aggregate totals from several queries all linked to the Input Query and all Nz'd as 0's From the image enclosed the totaling text box (top right left) is calculating the value in the properties box. The value should be 3.52 + 5 - 8 = 0.52...

This is either a no brainer or falls into the calculated field syndrome. My HR database stores Employee job history records. I display the current job (condition Null EndDate) in a subform. I would like to store the Division ID of this Job in the Employees Record, to make it easier to create...

Hi everyone, I have refined my query from previous threads to involved a module function. This calculates more acurately no of working days between dates and takes into account a holidays table. (All credit to Arvin Meyer on the module:) ) However because the Leave Year starts at the 1 July and...

Hi everyone, I appreciate all the responses to Posts, I have certainly learnt a few things since joining. Thanks I have a form that calcs leave values for an employee. These calcs work fine on the form. So I thought I could use them in a report. I take it that the DSum function on a query...

Hi again, This might be a simple answer, but I have tried several event properties, the last in the OnCurrent of the main Form. But most of the calcs work most of the time, and occassionally I get an 'Error 2001'. I have a couple of years VBAing, so still a teenager?? I am curious as to...

Hi Everyone!, appreciate if I could get some expert help. A little background: I have an Employee form/table that links to a JobHistory subform/table. The subform shows relevant details for the Emps current Position/Job by way of the EndDate of the JobHistory not being complete (Null). This...

After a scary recovery I have a new problem: Intially I changed the 'Data Entry' property on a subform, in a multi-tab form :eek: My tabs all dissappeared. (My Bad!:o ) Now that I have recovered I get a message when I close the form, asking do I want to save the changes to the design of the...

Has anyone had this problem? I originally created several text boxes and named them so that I could move the result of a vb calc to them. I moved the boxes (cut & paste!, mistake) to the footer (created in detail) and they lost their name values. Their names show up in the properties field box...