Search results

Whats preventing you from perfoming the calculations after the transfer or output into excel?

Without table structure I cant quite get specific but it should follow this pattern I believe. query the recordset for that attendee info and date. exisitingrecord = "select " & table.Attendee & ", " & table.date & " into TempTable from table where" & table.attendee & " = " &...

I see what your saying. Its closer to each table represents a specific type of equipment and those related Calibration types and points. Still looking to see if I cant find something to pull the data from each table quickly tho..

You have [subform].[date] in there twice. basically it looks like your statement is comparting the [subform].[date] to the [form].[attendee] and the [subform].[date] to the [subform].[date]. appears your trying to compare the same box to itself. Are you trying to compare the date in the...

Ive done very little with controling excel from access in VB but my first thought when i look at the code I do have it to call excel as an object. Dim AppExcel As Object Set AppExcel = CreateObject("Excel.Application") AppExcel.workbooks.Open FileName or AppExcel.Workbooks.Activate FileName...

I think part of the difficulty you will have here is the variety of email clients out there. Are you targeting a particular client that should be the default?

VBaInet has the best idea I can think of for gathering all that informatoin into one place. I think you would have to compare dates and concatenated equipid/calid for comparisons. As far as the intervals, once that data is collected it could be compared to another table that contains the...

Quite a task is right.... Questions. Each table has multiple CalIDs if I understood you correctly. Does each table contain multiple EquipmentIDs or is it just one ID per table? Exactly what type of information are you looking for on #2? What sets the interval between calibrations?

You could call an update query for that serial number and to update that particular field. There might be a little code that would call that query and set the variable for the serial number. Atleast point you in the right direction. Might be able to find and toss some code your way in a few.

Try this Ive had problems with and in if statements... nest it seems to work Public Function FINDACCT(ID As String) As String Dim r As Range For Each r In Range("L:L") If r.Value = 1 Then If r.Offset(-1, 0).Value = ID Then FINDACCT = r.Offset(-1, -24).Value...

I think i see apossiblity of the issue.. whats a snip of data look like?

This looks closer to a function used in Excel. Are you using this in Access or Excel?

Much thanks!!! I have used this forum quite a bit for information but was unable to located that anywhere!!!! -JP

I am haveing to create a report from scratch in VBA. Yes I know its not the easiet or effective way to do it but for this task it is what I have to do. The issue I am having is getting the report header to show so I may access it. The best I can gather form hours of searching is that this...