Search results

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

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

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

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

Hi A client has recently upgraded from Office 2000 to Office 2010 and I am struggling to get an auto-mail routine to work that worked in 2000. A scheduled task runs during the evening running the following code from an Access database. Public Function MailStockOut() Dim objOutlook As...

My wife is jetting off to New York for 4 days next Friday with her sisters and mother. Anyone got any tips on things to do and see? I think they are going to see the Empire State Building and the statue of Liberty so far. They are staying at the Edison Hotel, 228 West 47th Street, Between 8th...

Hi, I have a problem returning to a record in a sub form. A user enters data in a subform Frm01FCData which has 12 periods - see attached screen dump. After a value has been entered the following After Update event is run to keep the PGroup value and the Product value so that after the...

I cannot find this anywhere!!! Can anyone tell me how to format a euro symbol using MS-Access 2000? I have the current format set but would really like the euro symbol rather than 'EU'. Curr1: IIf([curr_code] Like "EU*",Format([Local Value],"\EU0.00"),Format([Local Value],"$0.00"))

Hi My wife owns a small cafe - she rents the building from a landlord. We have heard rumours that the landlord is going to 'go bankrupt on paper'. What does this mean and does it give my missus any reason for concern?

Hi, I'm sure I have done this before but cannot recall. Using Windows 2000 I need to expand the list of recently opened files for a third party software package. It is currently set to show the last 5 files opened - I need it to show the last 6! There is no option within the...

Has anyone else come across this problem in MS Access 2000? I have an application that updates from an ODBC source overnight using a macro that is run from Scheduled Tasks. There are several tables that are first deleted using DeleteObject and then re-impoted using TransferDatabase. However...

Hi All - New here. You look like a knowledgeable lot and I wonder if anyone has a better way of solving a problem I have? I can Join a table imported from a telephone management system to a table containing customer information by the 'phone number field. However the customer information...