Recent content by blindlemonray

I am looking at a way of assigning a macro to a button to turn on and off desktop alerts. My thought is to write some VBA to to do this. i know there is some VBA around desktop alerts but I am new to VBA in outlook. Any help greatly appreciated. i am running outlook 2013

thanks for the assistance folks

nailed it. 'Routine to relink the tables automatically. Change the constant LnkDataBase to the desired one and run the sub Dim dbs As DAO.Database Dim tdf As DAO.TableDef Dim LnkDataBase As String LnkDataBase = CurrentProject.Path & "\" & Mid(CurrentProject.Name, 10, 10) & "...

Hi Clapper, nice code but no quite what i was after. I have the tables already linked, but some times we copy and move the front and back end. I would like some code to run so that I don't have to keep manually re-linking the tables to the current location. Cheers

Hi, I am trying to dynamically link tables in my database based on the current file path. I have a front end with a separate backend DB. I would like to ensure when the front end is opened it relinks the tables based on the current file path. I am using the code below but getting an error:- "The...

Hi All, I am trying to figure out why Crystal reports is crashing on me. I have used Crystal reports version 9 and 2013. When working locally it is fine report runs with no issues but when working on a TS session it just crashes. We are accessing a MYSQL database with MySQL 5.1 drivers on...

managed to get it sorted. Applied a service pack from here (http://www.dkreports.com/servicepacks.php) downloaded and installed worked a treat. Seems it was a know issue. Next time I will dig a bit further before posting!

Hi All, I have an issue when trying to connect to a MySQL source. I can connect to the data source, I can add a command to and query the data source. I can even pull the data into the report using commands but when I try and view the tables directly i get "no items found". Any one got any...

Hi DJHunt, thanks for that. So do you know why the macro do not work? I need to try and create a solution for this trouble is no one can tell me why it does not work. Just "it does not work

Does anyone know why Macros do not work on Windows 8? I know that macros have always been a bit flaky in GM 7.6 and I know that "it is not supported" and it does not work. But I was wondering if someone knew why they do not?

Hi, I am trying to put links to or view documents in GM+View. I have looked at Castell Computers solution but its a bit flaky when trying to switch to other Views. Any solutions greatly appreciated. Thanks Jason

Hi All, Working with Crystal 9 Sub report, shared variable in group footer in sub report. Formula is :- whileprintingrecords; shared stringvar rcsahrvarsub:= {@RC}; Sub report is group footer 1a. formula field is on group footer 1b. Formula is :- whileprintingrecords; shared numbervar...

Hi I am trying to create a data access page but when i create it. It does not show any of the data in my table. I can navigate through the records but there is not data in the fields. Help! Please!

Hi, I am trying to export a memo field into dbase iv but when the table is exported all data apart from the memo field comes out. just using right click, export. Any suggestions appreciated.

Hi All, I have trawled the net for an answer to this. When exporting into dbaseIV I get the error "field will not fit in record" 1. Exporting to a new table 2. Field size does not exceed 255 char 3. Even if I delete delete the data from the field message persists 4. is a text data type -...