Search results for query: *

Hi everyone, Here is my code line: DoCmd.SendObject , , , strToDefault, , , "Permis de conduire invalide", Me.txtMessage, 0 When it's executed, il does open Outlook, my email is there but I get an Outlook warning saying...another application is trying to send an email, and asks me to autorise...

Hi everyone, Thanks for the replies. It did help. I am still faced with a problem...since i am inserting my records through Access, it appears to me access is not supporting a default bit value of (1) or (-1) from a SQL table. When i insert a record through SQLQueryAnalyser, i have not trouble...

Hello everyone... I have an already existing table with records in it. On column of the table is of data type Bit with no default value. I now have to put a default value on that column so that it is [True] or = 1. When i put 1 in the default value property of this column, and i try inserting a...

Hello everyone, I have found a way around my problem. I still do not know how to directly pass an input parameter to a graphic report using a Microsoft Graph object, but what i have done is put my data in a table specifically created for this report and create a view of this table as the...

Hello everyone, I 'm using Access 2000 with SQL 2000. In my ADP project, for a report i am using a Microsoft Graph 2000 chart. The data source is a procedure which requires one parameter. My problem is this, i cannot find where to set my parameter which would actually be coming from a combobox...

Hello everyone, I 'm using Access 2000 with SQL 2000. In my ADP project, for a report i am using a Microsoft Graph 2000 chart. The data source is a procedure which requires one parameter. My problem is this, i cannot find where to set my parameter which would actually be coming from a combobox...

Hi everyone Do not bother instead of dropping my table by executing my instruction on the SQL side, i dropped it using VBA which then resulted in making my table disappear right away. Here is the code i used: DoCmd.DeleteObject acTable, "logbookDbase" insead of...

Hi, Application (Access project) - Database (SQL Server) I execute a procedure that drops a table completely. CurrentProject.Connection.Execute ("drop table dbo.logbookDbase") Now if i look at my list of SQL-Server tables through my access table list, the table still show even though i dropped...

Hi everyone, I need to pring a subtotal. I must print it in one of 2 available columns depending of data in the record. Exemple: if CP = "C" then 1 2 3 4 5 | | | | | (print here) | else | | | |(print here)|...

I need to print bills, some may only have a few records in the detail section, how can i make certain that my detail section is fixed to a certain height so that my page are always full and that my other section of the report print always at the same place. Thanks for any help! Sylvie