Search results for query: *

Hello all I have a query that I want to export to an existing excel spreadsheet. The spreadsheet is all formatted and coloured up, and I just want to put in the numbers from this query. I cant do this with docmd.OutputTo - as it only allows you to create a new spreadsheet or overwrite an...

Hello all I have 4 stored procedures that each require a multitude on input parameters. I am feeding these in through a form in VB as follows: cmd.CommandText = "sp1" cmd.CommandType = adCmdStoredProc Set prmNTAddedBy = cmd.CreateParameter("NTAddedBy", adVarChar, adParamInput, 50, Me.Name)...

Hello all About a year ago, I made a few simple ASP.NET pages in dreamweaver to view, edit and delete records from a SQL server database. Im trying to get back into it now, and thought id take a look at the pages again. Ive opened them in DW MX, pressed F12, explorer opens, but it just shows...

Hello all I want to run a SQL update statement in VB that will loop and update a column in a table with first 1, then 0, then 1, etc... So the table will have: ID Loop 1----1 2----0 3----1 4----0 5----1 Hope that makes sense! Cheers J

Hello all I have a form with a list of contracts populated by a function. What I want to do is to use conditional formatting (the database is an ADP), to highlight any duplicated contract numbers. Anyone got any idea if this can be done? Cheers J

Hello all In ASP you can display continuous data on a form with alternating colours for the rows... so the first maybe red, then blue, then red, etc... Anyone know of a way to do this in an ADP? Cheers J

Hello all I have a stored procedure which requires an input perameter, Contract_No. I want to run this from VB, and pass in a number from a form. I know how to do this in a normal access query, but the stored procedures dont seem to allow where clauses to input perameters. Any ideas? Cheers J

Hello all I have 2 stored procedures that run a bunch of updates/appends/deletes. The first SP runs a few updates (each with rollback transactions), then calls the second procedure. I need to rollback whatever this second SP does if it fails, and rollback all transactions in the first SP. The...

Hello all I am emailing a report to someone in snapshot format, which shows all of the records in the underlying query. What I want to do is email a report for each record in the query, as opposed to sending them all in one query. If that makes sense! Anyone? Cheers J

Hello all Ive read somewhere on a thread that you can get VB.NET to run data imports/deletes etc (Like SQL DTS does) fairly easily. Can anyone point me in the right direction for tutorials or code? Cheers J

Hello all I have a few pages of VBA code behind a button on a form, that I want to be able to run from another button on a different form. I havent used Public classes or whatever, so im not sure how to reference the code from a different procedure. Anyone? Cheers J

Hello all I have an excel spreadsheet with Dates and totals running down in two columns. In another workbook I have the dates running right in row 1 and the totals below them in row 2. What I want to do is to carry on the formula I have in row 1 that looks at the next row in the previous...

Hello all My mates USB ports have never worked on his pc, he keeps getting error code 26 invalid data whenever he uses it or tries to install it. He's bought a PCI USB card, and he still gets the same thing. Any ideas? Cheers J

Hello all Just an easy one, ive forgotten how to to a fuzzy search in a SQL string. The code I have so far is: cmd.CommandText = "SELECT [First Name] + ' ' + [Surname] as EmployeeName FROM dbo.qryEmployeeDetails Where [First Name] + ' ' + [Surname] = ('" & Username & "') " I want to find all...

Hello all I have a SQL server with about 10 databases on it, and around 200 users accessing them through MS Access front-ends. A few of the users have worked out that they can create a new Access front end, create a link table to SQL server, and run their own queries/update tables from their...

Hello all As the title suggests, I want to export a query I have in an ADP, to an Excel Spreadsheet. I dont just want to data to appear in its plain form, I want it to go into a template ive already created. It there a way that I can export a query to a specific Cell/Group of cells in a...

Hello all I need to grab the name of a control on a form for error logging. I have the form name (me.form.name) outputting to a table, and I want to output the button name too. Any ideas? Cheers

Hello All I have a form in an ADP, with two ActiveX Calendars, and a subform based on a function. This function requires two parameters, @Startdate and @Enddate. (Can you se where this is going?) I want the user to be able to select two dates from the calendars, and the requested information...

Hello All I have a DTS package which runs an excecute process task to open an access macro, which sends an email, and then closes down. When excecuting the DTS package, the macro runs perfectly. However, when scheduled as a job, the process hangs and times out. The SQL server agent is started...

Hello all I have a chunk of code that counts records in a few queries and whacks the answers into 3 variables. The code then runs a macro which emails three reports. Fairly simple stuff. What I want to do is to reference the variables created, and only send emails in the macro if this variable...