Search results for query: *

I'm buying a 1TB hard drive to use to store media and backups. My question is which is going to be faster internal or external drives? I'm at work so I don't have any detailed specs. The motherboard is about 7 months old a Gigabyte with 2 seagate 160mb Raid 0 sata drives. Checking inside the...

Using MS Excel 2k. I have a data link to an sql DB on one sheet and when I copy and paste the data to another sheet to be read by a graph the data is not recognised by the graph. It all looks good, the cells have the correct values. If I type the numbers in the graph works fine. Anybody any...

I'm using access 2000. I call the report from a form to preview. If the report is printed I need to run a query to update some records. Any help would be appreciated... even a NO to put me out of my misery. Bruce

Hi Can anybody supply vba code to open a crystal report from MSAccess 2000? I've done this in vb6, is it the same? Many thanks, Bruce

Using Access 2000. In my report in the onpage procedure I have written code to print directly to the page i.e. me.currentx = ... me.currenty = ... me.print recordset.field().value 'draw a box around it 'get the next record This is fine to view in print preview looks great but not printing to...

I'm writing values straight to the report and need to repeat a record to fill some of the controls. The report has 3 text controls and 3 labels and I line up and print the values direct to the page from a recordset with each line on the report instead of going off the page. Any ideas??? Bruce

Is there anyway I can link a crossTab subreport to the main report? Access returns an error saying it cannot find the field in a crosstab subreport. Thanks in advance: Bruce

Is there any way I can query security groups in active directory from a stored procedure in SQL Server 2k??? The reason is I have created a user group in active directory to add members. I have added this group as a user in SQL Server. I can set up 3-4 groups and give them different...

Is there any way of linking Access 2000 to a view in SQLServer 7? brp

I edit and add records in a query but when I go to the same record in the base table and edit the record it returns an error saying somebody else (me) is editing the record and gives me options that don't work it just drops any changes. There are records there from a month ago in the same state...

Is there a way to add text to the page or button from a submit button to tell the user that processing could take a few minutes?? This code displays a message box which stops execution of the code to load the next page. <input type=&quot;submit&quot; Name=&quot;Button1&quot...

Anybody know why this is happening? My crystal report vs 8, accesses data from a recordset produced by a stored procedure in SQLServer 7. A field in the recordset is a text field which can hold 2500 characters. The crystal report processes the data but can't display it, and returns a 'Not...

Hi Is there another way of using an OLEDB connection string in crystal 8 than this: .Connect = &quot;DSN=&quot; & gblSQLServerName & &quot;;UID=sa;PWD=;DSQ=&quot; & gblDBName & &quot;&quot; Thanks in advance Bruce

Hi This message is returned when I access .rpt files from VB. It happens randomly, sometimes some work and some don't, I can't pick it. All reports were created a few months ago and I have changed from Win 98 to 2000 and connect to SQL Server 7. If I open the reports in crystal they work...

I run a report form a VB6 sp5 app. I use DAO and have a global variable with the DB path for the report. It runs fine on the development machine but when I install the program on another machine the report cannot find the database. Is there a file I'm missing with the installation or a line of...