Search results for query: *

Hi I am trying to get page breaks to insert when printing or print previewing. There are five buttons in the spreadsheet, each attached to a vba script that sets the relevant pages breaks, sets the print area, etc. All works ok, except the page breaks - any ideas?? Here is the code for one...

Hi I am running a script that includes ALTER DATABASE, which requires a user with one of the following roles: - sysadmin - dbcreator - db_owner We don't want to use sa to run the script, but use someone's usual login. Is there any issue with having more than one db_owner for a database. Or...

Hi I am trying to run a stored procedure that requires four value be fed into it, but I don't want to use fixed values, but use values from a table instead and am not sure how to write this out. what I have written is: select value1, value2, value3, value4 from #TEMP1 EXEC stored_procedure...

Hi I am after a couple of bits of help: 1. I want to run a script, which is initiated manually, but it needs to check the Activity table firs to ensure that there are no users logged in, and if there are, then the script won't run and the user will be informed. I know how to find out if there...

Hi Does anyone have any recommendations for books on writing SQL queries? Cheers Anna

Hi all I am trying to update a field in one table with information from another table based on a few restrictions. Table 1: holds the fields ITEMNUMBER and VENDORID Table 2: holds the fields VENDORID and VENDORCLASS Table 3: holds the fields ITEMNUMBER and CATEGORY The restrictions include...

Hi all This one has me stumped!! I have an excel spreadsheet with extensive code running all sorts of functions etc - this is all working fine! I have a button on the front page that allows the user to print preview all the sheets (13 sheets). If you scroll through the various pages in the...

Hi Just wondering how you go about passing a variable that has a value set within a procedure in the objects part of the project, to a userform. I can pass variables from the userform to the procedure okay, but not the other way around. I have tried declaring the variabe as Public (had to do...

Hi Is there an easy way to open a .csv file, and write the information into Excel, without doing the File Import? I want to open a file that has an undetermined number of rows (changes each month), with 7 columns, and write each row into an exisiting Excel worksheet, column by column. Cheers...

Hi all I am trying to get a function to return a value for a cell based on two variables... In basic language, the cell that needs the value is in column "L". In the following example I refer to Row 2. Find the value of cell A2 in the data range (which is in another worksheet), and...

Hi all I am trying to get a function to return a value for a cell based on two variables... In basic language, the cell that needs the value is in column "L". In the following example I refer to Row 2. Find the value of cell A2 in the data range (which is in another worksheet), and...

Hi all I am trying to get a user to make a selection from a combo box on opening the spreadsheet. So far I have: (In Micrsoft Excel Projects - This Workbook) Private Sub Workbook_Open() Port = Range("D5").Value If Port = "" Then MsgBox "error&quot...