Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: n0nick
  • Content: Threads
  • Order by date
  1. n0nick

    Div height 100%

    Hello! I want to make a web-page with this layout: div1: with=900px, height: 30px; div2: width=900px, height: 100px; div3: width=900px, height: 50px; div4: width=900px, height: 100%; div5: width=900px, height: 30px; Biggest problem is to make div4 height = 100% without getting scrollbars in...
  2. n0nick

    Bosnian characters in PHOTOSHOP CS

    When I write a word that contains one Bosnian character in Photoshop CS and then choose the Font family to "Bradley Hand ITC" ( or some other Font Family ) all characters gets this font family but not this bosnian. I know that this Font family has this character and when i write the same word in...
  3. n0nick

    Difficult SELECT Statement

    I got three tables: ----------------------------------- tbl_depart primary key: DEPART_ID name ----------------------------------- tbl_depart_weekday primary key: DEPART_WEEKDAY_ID foreign key: DEPART_ID foreign key: WEEKDAY_ID ----------------------------------- tbl_weekday primary...
  4. n0nick

    Char Pointer in c++

    I have some questions about char-pointers in c++. I have made a image <img src="http://www.slomic.no/char_pointers.gif"> of what i THINK is happening when i write char c[] = "hello"; char* c2= c; and char c = "hello"; char* c2= c; Is this image correct? How can adress of "c" be the same...
  5. n0nick

    Getting Identity after SQL-&quot;INSERT&quot;

    How can I get AutoNumber that Access made for the new post after a INSERT statement, back to the ASP? Im using ADO objects to connect and get data from Access DB.
  6. n0nick

    HorizontalAlignment with Access VBA

    I create a Excel file and try to alignment text to the middle in the cells for the first row with this code: Dim ExcelSheet As Object Set ExcelSheet = CreateObject("Excel.Sheet") ExcelSheet.Application.Cells(1, 1).Value = "Test" ExcelSheet.Application.Rows(1).HorizontalAlignment = xlCenter...
  7. n0nick

    How to set Cell background

    How to set Cell background in Excel VBA?
  8. n0nick

    Formatting Excel cells from Access VB window

    How can I access a already made Excel file and format its cells from Access VB window? I know how to format Excel cells when I am in a Excel VB window, but how to do it from Access VB window?
  9. n0nick

    Create Excel file, format cells and export data

    I want to do this: 1. Create a new Excel file 2. Format cells in this new file ( fonts, color etc. ) 3. Export data from a SQL query or table from MS Access. I would like to do all this things from Access form. I got a form where user have to fill some information, and when he is finished...
  10. n0nick

    Make and format a Excel file fra Access VBA

    Hello! I want to make a new MS Excel file from Access form, format the cells and then make a output of data from a table to the same file. I know how to set properties of cells, rows and columns when i program in VBA when I am in a existing Excel file. But I have never worked with properties...
  11. n0nick

    SQL query - comparing content of two fields

    want to write a SQL query that compare content of two fields, and if the content is different, content from Table 2 is going to be updated to Table 1. This is working great with this SQL query: UPDATE Table2 INNER JOIN Table1 ON Table2.ID = Table1.ID SET Table1.Adress = [Table2].[Adress] WHERE...
  12. n0nick

    SQL query - comparing content of two fields

    I want to write a SQL query that compare content of two fields, and if the content is different, content from Table 2 is going to be updated to Table 1. This is working great with this SQL query: UPDATE Table2 INNER JOIN Table1 ON Table2.ID = Table1.ID SET Table1.Adress = [Table2].[Adress]...
  13. n0nick

    Sending email with VB

    I tried to send email with this vb command: DoCmd.SendObject acSendNoObject, , , "slomic@snort.com", , , "Test", "Text", False But when i click on the button that calls this command, Lotu Notes opens and edits this email. The field "To" in the edited email is empty, still i wrote...
  14. n0nick

    Primary key of a new post

    Im using Access database on my ASP pages and I have one question: Lets say I got a form for registering new users. How can I get the autogenerated number, called userID ( is also primary key in the table ) that was created for this new user without have to make a new sql query to search for...
  15. n0nick

    Automatic deleting of the data from a table

    How can I make MS Access to automaticly, for example every sunday in the week, delete all data(posts) in one spesific table. Lets say I have one table named Table1 and got fields sessiondID, productID and date. I want that MS Access deletes all stored posts until todays date. Sorry if my...

Part and Inventory Search

Back
Top