Search results for query: *

hi i would like to build a stored procedure that takes a number as an input. Say starting check number. For each row that the SP returns. I would like to increment the check number by 1. Sample Iput: @StartingCheckNumber = 2345 Exec sp_Check_nums will produce Payee...

i need to loop through a recordset or a table. Do some calculations on each row and append the results to multiple tables. What is the recommended approach to do this on the server side. I know cursors are slow and the answer should be stored procedures. How do i loop through the recordset. How...

I have an application with ms-access 2000 as its front end and sql server 2000 as the backend. I have created an ODBC system data source name DSN. Each Time I open the database I am prompted for SQL Server login. I need a way to store that information in the database without the users being...

I am using Access 2003 with Adobe Acrobat Pro 7 to automatically convert ms-access reports to pdf. It work fine except for 2 issues: 1. I dont like to see the dialog "Creating Adobe PDF" Is there is a way to turn that off with VBA? 2. I can prevent Adobe PDF from launcing by going to the...

Hi, I have an access 2000 database that have some reports that I like to archive as adobe pdf reports. I need to automate the process using vba. I found code on the internet that works with old adobe writers and previous versions of access. Any clue to where I can find an updated code for my...

Hi, I have an access form that has multiple records. One of those records is a check box. User check the records that they need to process and uncheck those they need to leave alone. I have two buttons on the same form. One to check all of the check boxes and one to uncheck all of those boxes...

Hi, How do I customize access default error messages. For example when a user enters does not enter a required field access produces the message: "You cannot add or change a record because a related record is required in table .." I want to change that specific error or alert to a friendly...

In MS-Access Project. Which one is faster? Using the add method: r0.Add r0!field1= 'blah' : : : r0!fieldn= 'blue' r0!update or calling a stored procedure that is built in SQL Server that is doing the same thing. Given that mutliples insertions are done for different tables for...

I am listing all of the queries that I have in my database. I am trying to distinguish action queries from select queries. I am listing the queries without a problem and append them to a table. I just dont know how to list the Query type as well. Here is my code .. Thanks For Each obj In...

The size of the sql server mdf and ldf files, after the upsize, is 15 times as big as the original access database size???? and I cannot shrink it either .. any clue why? A suggestion was to convert all of the nvarchar to varchar. This didn't help at all. Any ideas please? Thank You Tareq...

The size of the sql server mdf and ldf files after the upsize is 15 times as big as the original access database size???? and I cannot shrink it either .. any clue why? Thank You It's Nice to Be Important But It's more Important to BE Nice

Is it possible to recover accidently deleted records using transaction log? Thanks Tareq It's Nice to Be Important But It's more Important to BE Nice

I am constantly changing the field definition in my database. An Example would be a chargre number for an employee. The charge field combines: Timsheet id + Job Id + job title + Sub Contract Number + title + Contract Number and title. I change this definition across all views most of the the...

I field information for database tables stored in a table. i want to get that information to update a database with the same structure. the main purpose is to update the description of the columns or fields. Here is what i wrote: Commented Lines Have Problem. I dont know how to make the string...

How do I list All Fields for each table in AllTables Collection? I know this question was posted before. I just cannot find the thread Thanks Tareq It's Nice to Be Important But It's more Important to BE Nice

DECLARE @IncomingCurrency AS MONEY SET @IncomingCurrency = 12345.6789 BEGIN DECLARE @ToStringIncomingNumber as varchar DECLARE @LenString AS INT DECLARE @DPtPosition AS INT DECLARE @X10000 AS INT DECLARE @REMAINDER AS INT DECLARE @FinalDbl AS DECIMAL --DECLARE @HAORHO AS...

Hi, i have 3 copies of the same web site running the same server. Each site is connected to a different copy of an access database. The sizes of the databases are 10, 20 and MGs. The ASP pages connected to the first 2 databases are loading fairly quick. The last one loads ok only in non peak...

Hi, I have upgraded our web server from a Win 2000; IIS 5.0 to Win 2003; IIS 6.0. I have noticed a huge change in performance? My Questions are: 1. Does IIS 6 or windows 2003 require more hardware resources? 2. Is there is a certain procedure to check and tune the web site performance...

Hi, I am in the process of upgrading my backend to sql server. I have moved the tables and some of the queries successfully to our sql server. I have linked the access front to it. However, any little use of the front end inflates the the size of the mdb file quickly . I have tried to compact...

hi .. this maybe an easy solution: i want to convert this simple access query to sql view: select qty, price, qty * price as total_without_tax , total_without_tax * .045 as TaxTotal, total_without_tax * TaxTotal as GrandTotal from ordersTable; I need to use the aliases and not recalculate the...