Search results for query: *

Using Windows XP SP1 and ACCESS 2002; I have created two buttons on a switchboard, one takes the user to the main menu and the other to the Previous Menu, it is in this last one that i get the following error: Run-time error '2001': You canceled the previous operation. I'm open to other...

Using Windows XP SP1, Access 2002 I need to run from an Access DB a Stored Procedure found on SQL SERVER and append the results in a table in that same Access DB. The stored procedure needs to be supplied with the following parameters User, BeginYear, EndYear; these are determined by the user...

USING Windows XP SP1; SQL 8 I need to create a stored procedure which displays the results of a temp table which is populated by that stored procedure. It's complex form me to write becuase it's my first SP. to get my final results I need to run a couple of querys, lets start with Q1 and Q2...

USING: Windows XP SP1 Access 2002 SP1 What function or code can I use to find for example, 1 in the following string: 8,1,9,11,23 ?

Using Windows XP sp1 and MsAccess 2002 I would like to change a Label's caption, which is on a subform, when the user changes the value in a combo box on a the main form. How can I do this? here is the code I'm using: Private Sub cboMes_AfterUpdate() Dim stMesAb As String Dim...

Using Windows XP SP1 and ACCESS SP1. I would like to sort the records shown in a datasheet form (fsfrDetails) by any column selected by the user. It sounds easy but here is were it gets complicated (at least form me), 1. It is a subforms in the form called frmUnits 2. In fsfrDetails for the...

Using WindowsXP SP1 AND ACCESS2002 SP1. I have a Logon form which opens as the first form of my app., after the User enters his login Id and Password and presses the OK button. I have created a Pop-up form that opens an agreement form where the user has to agree or disagree with the terms and...

Using: Windows XP SP1; Access2002 SP1; I have a form as a datasheet where the following codes resides for every column shown, that is executed when the user doble clicks the cell. Is it posible to put it in a module and how would I call it in my form? The origin form is: frmresumengastos...

Using: Windows XP SP1, MS-EXCEL 2002 SP1 How do I show the current file or active file's creation date. Can this be made into a function a user calls so the information is place in a cell specified by the user. I have found the following code but do not how to get it to show in the SHEET...

FYI - Using SQL Server 2000, Windows XP SP1. - :-) I tying to run the following query but I get the following error message: Server: Msg 156, Level 15, State 1, Line 7 Incorrect syntax near the keyword 'SELECT'. Server: Msg 156, Level 15, State 1, Line 20 Incorrect syntax near the keyword...

Using SQL 8.0, Windows XP SP1 I would like to create a VIEW that outputs all the Job Types a Contractor has worked on. The following data is in a table called WorkOrders: Contractor JobType Amount A 1 20 A 2 30 A 3 50 B 5...

Using: MS-ACCESS 2002 SP1 I need to populate a bounded textbox (SaleDateTime) using the information the User enters in a Calendar Form and a Time Form. The values selected by the user are returned to the following unbounded textboxes: txtFrom and txtTime. I have tried using the afterupate, on...

I am using: MS-ACCESS 2002 SP1 I need to populate a bounded control (SaleDateTime) using the following unbounded controls: txtFrom and txtTime, this after the txtTime control has been populate or changed by the user. I have tried using the afterupate, on change but with no luck. How can I get...

I'M Using: Word 2002 SP-1 Windows XP SP-1 I need to write code to do a specific operation in a Word document. When the file is opened I would like to prompt the user a question he or she would like to print a controled copy of the document. If the anwser is Yes then get the last copy number...

Using CRW 8.5.0.217 I want to display my parameter info in a report. Users need to input a range of values or different individual values. How can I do this? Thanks,

Using CRW 8.5.0.217 Hi want to display my parameter info in a report and took this formula off a post but am getting the follow error message: "A number, currency amount, boolean, date, time, date-time, or string is required here." And it points to this part of the code...

HI, I want to develop a budget DB which will be used by different store manageres at different locations. They can all have access to company HQ server (one of them) in which I plan to put the DB. From what I 've read this is a several step proyect for which I have a confusion for the first...

Hi, How do I code a form so that when a User with a security Level 2 (level set by me in tblUsers) only can see info regarding his store, but when a User with a security Level 3, which is a Manager can see info for all stores? Here is the code for the first part of the question, don't know...

Is it posible to create a module that sets a form's Caption? All forms will have the control: txtTitle which would contain the form's Title, but this title would have to include the date. Up to now I have this code Function SetTitle() On Error Resume Next Screen.ActiveForm.Caption =...

The subject line might suggest my question is simple but, it's part of a work around I have had to do! I want a Text Box value to be equal to the first Row and only column of a List Box. Why I want to do this is because I need to format the value to STANDARD but a List Box does no allow this...