Search results

I hear you but I'm still clueless how to add the expression =Int((Sum([MondayTimeOut]-[MondayTimeIn])) -.0416666) & Format(Sum([MondayTimeOut]-[MondayTimeIn]),"h"" hr ""n"" min """)

How do I subtract 1 hour from this expression? Thanks =Int(Sum([MondayTimeOut]-[MondayTimeIn])) & Format(Sum([MondayTimeOut]-[MondayTimeIn]),"h"" hr ""n"" min """)

Thank you ... it's working!! DoCmd.OpenReport "rptAssignmentRIP", acViewPreview, , , acHidden DoCmd.OutputTo ObjectType:=acOutputReport, ObjectName:="rptAssignmentRIP", _ OutputFormat:=acFormatPDF...

Not sure I understand. I already have a filter on the report ... [ReloID] = Forms!frmPCSTracker!ReloID ... shouldn't that filter be used when the report is generated? How do you hide? DoCmd.OpenReport "rptAssignmentRIP", acViewPreview DoCmd.OutputTo ObjectType:=acOutputReport...

My goal is to pull a report based on the record I'm working in then to save it as a pdf. I know how to pull a report while in the record ... DoCmd.OpenReport stDocName, acNormal, , "[CaseNumber] =" & Forms!frmCases!CaseNumber ... but I don't know how to incorporate the [CaseNumber] into...

How do I identify the file in the attachment field for the Object Name rather than the report? DoCmd.OutputTo ObjectType:=acOutputReport, ObjectName:="rptAssignmentRIP", _ OutputFormat:=acFormatPDF, OutputFile:="C:\temp\RIP.pdf"

Can I add an Access report to the following e-mail? If so, how? Dim OLApp As Outlook.application Dim OLMsg As Outlook.MailItem Set OLApp = New Outlook.application Set OLMsg = OLApp.CreateItem(olMailItem) With OLMsg .Display .To = "abc@xyz.com"...

I'm at my wits end ... why I'm I getting this error (Object Variable or With Block Variable Not Set)? Private Sub Command415_Click() On Error GoTo errhandlers: Dim oOutlook As Outlook.Application Dim oEmailItem As MailItem Dim rs As Recordset Dim customerEmail As String Dim n As Integer If...

If I have an attachment field with one or two attachments, may I attach them to the SendObject e-mail? If so, how?

Solved. When I only used the main table in the query, only one report was generated. I thought all the tables (main, junction and trainees) had to be shown because of the subform.

I finally figured out to create a many to many relationship. The problem wasn't creating the relationship but getting the Master/Child relationship to work properly (form and subform). Not that I've figured this out, I'm trying to produce a report that only prints one Training Event, which...

Thank you. I added EventID to the Trainee table and recreated the link. It worked. Thank you for the info and the quick response.

I have three tables: 1. Training Table: EventID with other fields 2. Junction Table: EventID and TraineeID 3. Trainees Table: TraineeID and other fields I established relationships (one to many) from the training table to the junction table and from the trainees table to the...

We found the problem and fix. We right clicked the Access icon and then clicked on "Properties." The "compatibility" box needs to be UNCHECKED (run this program in compatibility mode).

Back end is Access. I'm not encrypting other than what Access is doing (default encryption) - no third party project. The back end is on a shared server. Front end is on individual computers. I'm going to have the user reload Access to see if this works. All users have the same Microsoft...

I split a database, which works for most. On one computer the front end opens but when he opens a form with data, he gets the following error: "Your encryption settings are not valid. Re-install Microsoft Access or contact your administrator for more information." I went to...

I'm trying to open a front end database with VBS but I'm having trouble, which I believe is because of the SPACE in the path (Public Documents). See below. Other than renaming the file folder, is there a way I can open the application? Dim accapp As Access.Application Set accapp = New...

After I split my database, the print option from the Print Preview tab is greyed out (no longer available). Why?

If a split a database and placed the back end on a shared server, would the users of the front end need Read/Write access of the folder contained the back end on the shared drive? Note: Users need to add, delete and edit records. I'm trying to figure out a way that the user cannot go to the...

I have several databases. In an effort to make an easy access activation platform, I created a DB that has graphic for each DB, with code to open the corresponding DB, such as ... Dim appAccess As Access.Application Set appAccess = CreateObject("Access.Application")...