Search results for query: *

Hi I am using SQL 2005, ----------------------------------------------------- Summary Maintenance plans are not showing under database engine under the manangement section, so I cannot view or modify it ----------------------------------------------------- I had a few maintenance plans on...

Hi, Ignore the previous thread the title was wrong. Big Problem, hoping for solution soon. Using SQL 2000 A database on SQL 2000 was deleted by a script which dropped and re-created the database. We checked for a backup but it seems the backup failed the night before and there are no .bak...

Hi, I am using Crystal 10. I have a report which shows room bookings. it is grouped by start date of the booking. It shows one day per page, with all rooms bookings for that day and will usually be printed of for a week at a time (Monday to Friday) The user can enter a date range (start...

I am using SQL Server 2000 and have created a stored procedure so that it can be called in a crystal report, I used the stored procedure to possible speed up the report. however it still takes an awful long time to run and resource utilisation on the Server (Processor usage) goes sky high while...

Hi, I'm using CR 9 I have created a manual Cross tab sort of report. I shall explain the report first then explain what I require. My report is set out as below: GH1 User Initials GH2 Payment Type GH3 Invoice Ref Detail Invoice and payment Details (Suppresed with Drill...

Hi I am using Crystal reports on SQL Server 2000 Any help would appreciated, still a newbie. I wrote the following code to present data about laptops booked and in which rooms they are booked. The error I am getting is Failed to open a rowset The column prefix ‘P2’ does not match with a...

I am using Crystal Reports 9 and MS SQL DB. Its a new job and Crystal is new to me, I really need some help. The simplified version of the problem is I have two tables Members and PD Members table has the following Mem_id Mem_Status PD table has the following PD_ID PD_MEM_ID PD_Status My...

Ok, so I have looked High and low to find an answer to my problem. I'm fairly new to using recordsets. Maybe, or more than likely, in the wrong places. I am an Access 2000 Developer. I have a form for entering course details with the underlying table TBL_Course. The form which is used...

Hi all, Access 2000 user. [COLOR=red] The short Question[COLOR=black] How do I get the actual text of a business name from a combo box on the enquiry form to be passed to a combo box on the contacts form, or how do i get it to resolve the id which it picks up from FRM_Enq to a name in the...

This is a copy of thread thread181-580926 I forgot to put a subject line in and so it appeared as "HI, All I am using Access 2000" Which I dont think will be very helpful to anyone when they see it and will not inspire the right responses. Hi all, I am using Access 2000 I found...

Hi all, I am using Access 2000 I found some code which should allow my app to set the app icon when it loads up, assuming that it is in the same folder as the database. The reason for wanting to do this is so that when I distribute the db to other departments their path to the db and the icon...

Hi all, Access 2000 user. I have a form based on a table. form name is FRM_Centre_Enq Table name is TBL_Centre_Enq the form displays all enquiries for a centre. centre details are stored in another table called TBL_Centre The form is filtered to display enquiries for a centre which was...

Hi, I'm an Access 2000 user I have almost solved one problem only to find that i'm stuck on a part of it. Scenario I have a form [studfinder] which finds students, a combo box is used to find students and when the user types in the combo box the form updates to display the record for the...

Hi All, I'm using Access 2000 First i'll mention what I want to achieve and the scenario, then what i have done and the problem. This way if anyone has any alternate ideas it will be easy for them to understand (hopefully) i'll try and explain as well as I can. [COLOR=green]What I want to...

Hi all, I'm Using Access 2000 What I am trying to do is print labels out for students. The fields available for address information are as follows. Address1, Address2, Address3, City, County, Postcode most likley the address2 and address3 fields will not usually have data, however some...

All, I am trying to be more efficient with my code by using global modules. What I want to do is.... I have a form where there are approx 6 text boxes. 5 of them have a tag value of 1 the other text box has a tag value of 6. When the form moves from one record to another, tag 1's become...

MS Access 2000 user, Hi All. I am designing a system in Which I have found that one table may have a compuond/composite key. if I am going to show a relationship between the two tables I need a foreign key in the second table, If my first table has two fields which make the Primary key, how...

Hi All, If I wanted to refer to more than one label say label1 label2 and label3 can I do this by declaring it. i.e. mylabels = label1,label2,label3 or some other way. so that I could change the color of them in one go or change any other properties for all of them in one go. Thanks...

Dear All, I have wriiten generic Openform and close form SUBs in the Modules area, which I call by their names to open and close forms, this saves me having to retype the full code for opening and closeing forms, I have also written variations to the openform where it opens in read only or...

Hi, [COLOR=green] The scene [COLOR=blue] I am using MS Access 97 I have a problem where I have a table which holds information on orders the key field is the requisition number req_no [COLOR=green] The problem [COLOR=blue] When a user adds a record using the form I have created for data...