Search results for query: *

SP: ALTER PROCEDURE ysp_Test (@Param1 int, @Param2 int) AS SET NOCOUNT ON Select * From tblTest Where fldA Between @Param1 And @Param2 RETURN Depending on the values of the parms the recordsource of the form has to be set. Using one inputparm is no problem. But how to use more then one...

Hi, I try to write a query qith some parameters based on a user record in a table. Select * From tblUser Where UserId=@Param1 This gives the parameters for the rest of the SP. As there are a number of parameters I would rather change the querytext then have many queries. Like: if...

Hi, at the moment i'm using a loop in Access, which counts the files in a directory by using the DIR-statement. This works fine, only time consuming. If Nz(Dir(strPKPath & "*pk.doc")) <> "" Then i = 1 Do Until Nz(Dir) = "" i = i + 1 Loop End If I wonder if I could use a Stored...

I need to find the first free number in a series of records. Example: tblTabel.Number contains 2000 2001 .... 2010. But number 2004 and 2007 are missing. How do I find this in an easy way. I will make a loop in MsAccess, but that is not the most efficient, when it is about 50.000 records...

Any sugestion on where to find a free online Programming Outlook Course? I do have a good knowledge of programming MsAcces. So, I prefer a fast way to learn. Thanks, Smitan

Hi, In a MsAccess application we create a mailmessage and send it out using MsOutlook object model. Part of the code: On Error GoTo GetOutLook_Error GetOutLook = False Set objOutLook = CreateObject("Outlook.Application") If Err Then MsgBox "Error" Exit Function...

One of my users is getting annoyed with opening the same 5 shared calendars every day she starts Outlook 2003. Can this be solved by settings/options or by a piece og vba code or macro? Thanks Smitan

Hi, I am working with MsAccess 2000 9.0.6926 SP3. Some comboboxes on my form have a very peculiar way of reacting, i.e. they do not react at all, THE FIRST TIME. When choosing the same value again, the afterupdate is fired and the value shown. It happens every time, no matter how often I choose...

Hi, Writing anppointment in the calendar on the computer that the Access application is running is functioning fine. Now, I want to write an appointment into the calendar of one of the other users. How do I do a thing like that? We are running Exchange 5.5 SP4. Thanks a lot. Have a great...

When reading a mail in my Access application I have no problems with most EditorTypes. When editorType is 3 (olEditorRTF) then .HTMLBody doesn't exist and when using .Body it's empty! How do I get the contents of the 'body' of the mailmessage with the olEditorRTF? Thanks very much Hans

For some reason I have no column names in the query designer. In one database the names show, in another there are no names at all, only this 'All Columns' thing. How do I change the behaviour of my query designer? I need the column names to drag my relations and to choose them to be in the...

Hope this is the correct forum. I have a table with product records. I also have documents relating to these products. After receiving a new document for product XYZ, the document is pointed out and the path/name saved in a table. Any user of my Access application can read this document that is...

Hi, I have problems in getting the information in my subform either sorted or added without an error. Using SQL server 2000, there is NO problem at all, using SQL server 7 it simply doesn't work. Changing from 7 to 2000 is no option for my client. The point is that the records of the...

Hi, I wish you all the best for 2004. A group of users is using a different type of printer. On this printer we would like to have the possibility to choose which papertray is used for a specific report. Generally, for all other users, the default settings are used. Is it possible to send a...

I would like know the date of a file in my Access-project. The DIR command gives me the name, no more. Is there another possibility to get this date? Thanks Hans

FrontEnd (ADP) is Access, BackEnd is SQL-server. When I open the querydesign, no problem. Then I make a copy of my mdf-file (for testing purpose), connect to it with the SAME FrontEnd! When I open the querydesign, and drag a table into it: NO Comlumnnames, only tblxxxx.* Any idea how this...

A field on a form makes the screen flicker when text is entered into it. The field used to be MEMO, in Access, now is ntext 16 in SqlServer. There used to be code behind the field (KeyDown) but I took that away TOTALLY. It unfortunately only happens at my customer, not on my machine. Any idea...

In a form with company info I open Internet Explorer for the user. This may result in multiople sessions of IE. I could hae a flag to control this, but when the user closes IE, the flag is still raised and IE is closed. There must be a way (via API) to check if an aplication is running or not...

Front-end is Access.ADP, back-end is SQL server. I have no problem in getting the data from a table in a second Jet database to be shown and edited in a form using DAO although I would prefer ADO. For som reason it is for me impossible to do the same in a report. In the Form I use: Set...

We are using Outlook from Access in sending internal mails and automaticaly booking appointments to/for other users. Since I installed the security patch for Outlook my users are not so happy with these features anymore. Does anyone know af a good alternative that works neatly with Access in...