Search results for query: *

Hi, In table design view i have a field that is a Yes/No. In it's details the Format is Yes/No. It's default value is No In datasheet view this field is a checkbox (unticked of course) I have written code to create a Table im my database. It Ok. However hard i try, however much reading i have...

Hi everybody, I have a problem to use OUTLOOK. My perpose is to send a message, VIA ACCESS, to deferents users of my Data base. So the problem occurred at the stape of opening the outlook application: Set olApp = CreateObject("Outlook.Application") Thanks to helping me

Hi everybody, I have a problem to use OUTLOOK. My perpose is to send a message, VIA ACCESS, to deferents users of my Data base. So the problem occurred at the stape of opening the outlook application: Set olApp = CreateObject("Outlook.Application") Thanks to helping me

Hi everybody, How can I add a fields in table by using Recordset. I try to use: -------------------- Dim db As DAO.Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("Table1") rst.Fields ????? Append dont work So what is the object how must used in...

Hi everybody, How can I add a fields in table by using Recordset. I try to use: -------------------- Dim db As DAO.Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("Table1") rst.Fields ????? Append dont work So what is the object how must used in...

Hi everybody, There is somebody to show me how to record my dB ACCESS, so that I can present it with a PC which does not have access installed. In fact, I will not want that the others know that my DB is made with ACCESS. Thanks for assistance nadjib

Hi everybody, There is somebody to show me how to record my dB ACCESS, so that I can present it with a PC which does not have access installed. In fact, I will not want that the others know that my DB is made with ACCESS. Thanks for assistance nadjib

Hi everybody, There is somebody to show me how to record my dB ACCESS, so that I can present it with a PC which does not have access installed. In fact, I will not want that the others know that my DB is made with ACCESS. Thanks for assistance nadjib

Hi everyBody, I Want to know how can I change, or accede (from VBA) to the : form -> Propriety -> Data -> Sourrce thanks for asssistance nadjib

Hi everybody, I want to know what is the syntax to create a table with an AutoNumber data type field : because i have a problem with the fellowing syntax: CREATE TABLE Table1 (NumVersion autonumber, Text char(50)) Thanks for the assistance nadjib

Hi everybody I have strange problem withe my form (associated to table). Each modification in the fields of my form is recorded in the table asscoicated, even if i dont specify the recording button in my form. So, I want that my form does not record anything on the associated table if I...

Hi everybody, I have tow problems with My first recordest in my table. This recordest is AutoNumber type. So, At each time when i add a new recordests from an associated Form to this table, the recordest is incremented in the table automatically: 1, 2, 3, ..., n. My problem is I Do not know...

Hi everybody, What is the propriety must I change for the form (associated to the X table) to avoid writing automatically on table X. Indeed, I do not want to record in table X, only when I click in the button of recording. Thanks for the assistance nadjib

Hi everyBody, I Want to know how can I change, or accede (from VBA) to the : form -> Propriety -> Data -> Sourrce -> SQLCODE In fact, I want to make dynamic my SQLCODE Query. So I want change : SOURCE -> SQLCODE = SELECT [Forms name].[fields name] FROM [Forms name];" To 'at each...

Hi everyBody, I Want to know how can I change, or accede (from VBA) to the : form -> Propriety -> Data -> Sourrce -> SQLCODE In fact, I want to make dynamic my SQLCODE Query. So I want change : SOURCE -> SQLCODE = SELECT [Forms name].[fields name] FROM [Forms name];" To 'at each...

Hi everybody, I am trying to make form2 dependent on form1, knowing that: 1- Form1: contains a Combo Box, associated one field of table X 2- Form2: contains a number of fields, among them, the first field must specify what the contents of combo box of form1. What I do: in the...

Hi evreybody, How can I use the InputBOX() (or syntaxe), associated to a drop-down list. Contrary to a traditional method, where the user writes a message, I want that it chooses in the list the value to be turned to the program

Hi everybody Is there sombody to help me to resolve my problem ? How to run my data base without having to open ACCESS ? cordially nadjib