Search results

Are you running Windows 10? I had a similar problem but running this fix on the server solved it. https://support.microsoft.com/en-us/topic/access-reports-that-databases-are-in-an-inconsistent-state-7ec975da-f7a9-4414-a306-d3a7c422dc1d?ui=en-us&rs=en-us&ad=us

I encountered a similar problem. The work around in the link did solve the problem for me. https://support.microsoft.com/en-us/topic/access-reports-that-databases-are-in-an-inconsistent-state-7ec975da-f7a9-4414-a306-d3a7c422dc1d?ui=en-us&rs=en-us&ad=us

Many thanks. This is exactly what i want to do.

I would like to change the source object of a subform to a report. I have tried the following, which works when using forms. stDocName = "Rpt_DOI_Summary" Forms!Frm_MainMenu.SubFrmOption.SourceObject = stDocName Forms!Frm_MainMenu.SubFrmOption.SetFocus I get the...

Try .HTMLBody. You will need to enable Microsoft HTML Object Library in VBA References. bdy = "<img src=" & "pathandfilenameofyourreport" & " alt=""Logo"" title=""Logo"" style=""display:block"" width=""1240"" height=""1000"" />" .HTLMBody = bdy I have just completed a mass mail system and...

Try a href Something like : Dim myfilelink As String myfilelink = "<a href='" & "C:\dev\deviationdatabase.accdb /cmd frmDevReq" & "'>Click Here To Open</a>." .HTMLBody = "Dear Someone <br>" & "Somthing that requires your review " & myfilelink Be careful with single and double...

I don't see why not. As arnelgp says select the on format event in the detail section. Code could be something like If Me.YourControl = YourConditions Then Me.Line1.Height = 1110 Else Me.Line1.Height = 0 End If Here if YourControl = YourConditions the height of the Control Line1 =...

Redemption does indeed still work.

Why not use the 'Line' option in the design section of reports?

Thanks for the advise. I do not collate addresses but send one mail per address.

Thanks for the reply. I did try mailchimp. I have set up an export to csv function so a mail list could be uploaded. However when I uploaded the mail list of 400 mailchimp would not allow me to as there was a high possibility the mail would be bounced back as spam! I used my app and sent...

Hi All Using Office 2013. I have just finished a Mass Mail App for a client and I wish to hand this over next month. It allows the user to create header and footer text and embed an image to the body of the email. The mail is send via Outlook (Currently I am allowing Programmatic Access but...

Has anyone else encountered this error after upgrading to Windows 10? https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d The workaround does work, I didn't need to stop and re-start the NET SEVER...

accde of course (head slap!!). In my defense it is a very old App that has run for 15 years with no problems - 'if it's not broke don't fix it'. Many thanks.

Thanks for the reply Doc. 1. No the App is not split. 2. The task runs with Admin privileges. 3. This is the interesting one. I got a user to open an App on the server that it not used by any user. I then opened the App on the server and found a broken reference, it was looking for 15. So...

Long shot. Anyone else encountered this problem. Access 2010 is installed on a server but Access 2013 installed on PCs on the network. My client recently updated the PCs to 2013. There are several apps that update via Task Scheduler but one often falls over, this is used by users on the...

Thanks that did the trick. Odd though I have other similar routines that work fine without defining a path, guess I was just being lazy. I shall use this method from now on.

Bit of long shot. I have written a routine that allows the user to change a customer trading status in another piece of software though a 'gateway' utility the software company provides ( see screenshot attached ). This worked fine until I added some code that e-mails any sales orders...

Try removing the [] brackets. Forms!frmDepartmentReview.SetFocus Forms!frmDepartmentReview!cboDepartment.SetFocus

I have had similar problems. Try setting the focus to form first then set focus to control Forms![frmDepartmentReview].SetFocus Forms![frmDepartmentReview]![cboDepartment].SetFocus