Search results for query: *

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

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

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

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

I have a Word Form, which I protect then save it. But when anyone opens it. It opens unprotected and therefore cannot use it as a form unless they protect it. Can anyone suggest any solutions

Hi All, I have a database with lots of forms and reports. But I have one user who cannot open one report and one form. This is not machine specific, it is user specific. The database has not been created with any user level security. If I open the database any machine with any other user the...

Hi, I have some code that enters a set of values into a table, but what I want to do is check to is the value is already in the table so I can avoid it being entered twice. I thought dlookup might work but it does not seem to do what I need. I don't know whether I am getting the code wrong or...

Hi All, I am trying to pass a value to a SQL statement by way of an inputbox, but I can't seem to get it working. I cannot seem to pass the value from the inputbox into the = part of the sql statement. Can anyone point me in the right direction? Dim strCode As String Dim sSQLdelete As String...

Hi All, this is the code I am using and I have trawling the forums to try and find an answer but I am stumped. I keep getting error message "too few parameters. expected 1" Can anyone help... Pleeeeeeeeeease! Dim rst As DAO.Recordset Dim sBodyText As String Dim strSQL As String strSQL =...

Hi All, I am trying to send emails via Access but when i run my code the email opens puts in all the correct details, attaches the report but stops short of actually sending the email. I still have to click send. My code is :- DoCmd.SendObject acSendReport, "User", acFormatSNP...

Hi All, I am having some issues where when i open a standard GM report is increases the mem usage up to 180,000+. Does anyone know why this would happen? thanks Jason

I have several tables in a query. One table contains a memo field. when the table is queried instead of showing the tables contents it shows ?. I have tried quering just the table on its own and it shows the results as normal (i.e. the text from the memo field is displayed). Any ideas?

Does anyone know if it is possible create a dynamic file shortcut? I have a file that is output with a new date every day and would like users to have a short cut to it, but the file is output with current date on it. Any help appreciated.

Hi, I started a thread a little while ago but did not get a solution (thread68-1246464). I want to create a chart that shows when a caller in on the phone. The information I have is caller, time call made & length of call. What I want to show is something like a barcode effect, the axis by...