Search results for query: *

That works .. thanks It's Nice to Be Important But It's more Important to BE Nice

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 have a source table .. i want loop through that one .. Update some records in some tables. Add records to a table. Keep the ID inserted in one of the added tables Add records to another table using that ID [PK] so the answer all of the above .. my problem is looping through the recordset. I...

do while not end of recordsetOfSourceTable --- insert calculated values into table1 --- insert more calculated values into table2 --- more insertion statements get the next recordsetOfSourceTable end do while It's Nice to Be Important But It's more Important to BE Nice

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...

Thanks .. One think that you need to drop and relink all of the tables. But dropping and refreshing the link on one table is good enough to get rid sql server logon box. Here is the function I came up with .. you can replace the table accocunts with any table you have in your system ...

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...

SPL, This is a common error when data is missing in the one side table. If referential integrity is enforced, you must fill all of values that has referential integrity on them. Example: Table Employee requires a value from states table and RI is enforced. If you dont supply a value for...

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...

Found .. http://www.tek-tips.com/viewthread.cfm?qid=1119207&page=1 programatically change the reprot caption to get the best results It's Nice to Be Important But It's more Important to BE Nice

I apologize ladies and gentlemen .. the code is posted under this link. http://www.tek-tips.com/viewthread.cfm?qid=1119207&page=1 Keep in mind that you need to programatically change the report caption before you convert the file to pdf Regards Alibaba It's Nice to Be Important But It's...

StumblingThrough .. Any luck finding a solution for this problem. I am having the same exact problem with Adobe 6.0, the save as box keeps poping! It's Nice to Be Important But It's more Important to BE Nice

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...

thanks fly over your humble opinion works. Few Tweaks though. Thanks It's Nice to Be Important But It's more Important to BE Nice

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...

OK thanks .. the solutions take care of it on a form by form basis. This may require lots of work. But what if I want to replace the original message coming from access. How do i do that? It's Nice to Be Important But It's more Important to BE Nice

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...

Thanks Vongrunt, it appears that the data size holds realistic values. However the Indices sizes are very unrealistice. I am not sure what is the unused field shows. But i assume its the space for rows deleted. How do i manage indices and unused space sizes? Thank you again Tareq It's Nice...