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 TouchToneTommy 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: Davide77
  • Content: Threads
  • Order by date
  1. Davide77

    html table and css

    Hi, I have a general question about table and css. I was trying to format a table by using css styles but i looked around a little bit and it seems that css can work without using tables... does someone can give me a good link on this topic? thank you davide
  2. Davide77

    affecting specific tag from external CSS

    Hallo, I have a form with some <input type="text> and one submit button. I would like to use a background image for the text-input but I don't want to use the same image for the button. The problem is that they use the same tag <input..> and an external CSS will affect all of them. I have to...
  3. Davide77

    Conditional link

    hallo, I have a problem with browser compatibility. I know how to make work things for Explorer or for Netscape, but they won't work togeter. The solution is to prepare two different pages and if the user has a Netscape will see the Netscape page and viceversa. The problem is the script that...
  4. Davide77

    Fixed background in netscape

    Hallo, it's probably an old problem, but how do you make working a fixed background in Netscape? I'm trying to customize a form by putting an image as backgraound of the textareas. Here is the code: <textarea style="width: 373px; height: 89px; border: 0px; background: URL(img/frm_big.gif)...
  5. Davide77

    cell with fixed or variable dimensions: is it possible to control it?

    General description: How to create a table where some cells have invariable dimensions (height and width) and other cells can change their dimensions depending on the content of the table. Actual problem: I have a 3x3 table. In the first collumn two of the three cells are merged (the two...
  6. Davide77

    deleting a folder with an associated file without deleting the file

    Hallo, I saved a lot of pages from the internet and i would like to get rid off the accompanying folder where all the images, stylesheet and so are stored. The problem is that if I delete the folder windows also delete the file. I know that if I rename the file or the folder than they are no...
  7. Davide77

    sending information from a frame to another one

    Hallo, I'm trying to achieve this: one page with a textarea and a frame. In the text area it will be possible to write dome html code and then after clicking a button the code will be displayed in the frame but not as code since as a normal page. You can see an example of this at...
  8. Davide77

    how to count records of query defined in vba

    Hallo, I have a query defined in vba code: Dim strsql as string strSql = "SELECT [Qry_Room].[Room] FROM [Qry_Room] WHERE [Qry_Room].[Day]=" & Format(CDate(giorno), "dd-mm-yyyy") & ";" how do i count the number of record of it? i tried with the dcount: RecordQuantity = DCount(strsql...
  9. Davide77

    error when opening a recordset

    hallo I am trying to open a recordset with a where condition but I get the run - time error 3075 "Syntax error in number in query expression '[Qry_Room].[Day]=10.11.2002'" The code I'm using is: strSql = "SELECT [Qry_Room].[Room] FROM [Qry_Room] WHERE [Qry_Room].[Day]=" & giorno Set rs =...
  10. Davide77

    combos as search criteria: problem with empty fields

    Hallo, here is the problem: I have three tables: tbl_person (name, id, countryID,typeID), tbl_country (countryname, id), tbl_type (typename, id). I made a parameter query that I would like to use to display the result of a search by person name, country name and typename. The criteria for the...
  11. Davide77

    combos as search criteria problem

    Hallo, I have a form with combos for search criteria. The source of the combo are different tables and I made a UNION with "*", "<ALL>" in order to have the possibility to select every possibility for one combo. The problem is that the <All> consider all the fields that are filled in but it...
  12. Davide77

    iff expression problem

    Hallo, I have a parameter query that refers to a form. If the checkbox is checked (0 or No) then it should display the records where the field is = 0 (this field is a count field); if checkbox is not checked it should display all the records where the count fields is <> different than 0. The...
  13. Davide77

    referring to cells depending on their content

    hallo, back with a new excel vba question: how to refer to a cell depending on its content something like: a = .cell(x,Y) WHERE cell.value = "BLABLA" thanks for suggestions
  14. Davide77

    how to refer dinamically to columns in excel

    here is the problem: I'm formatting an excel sheet depending on the quantity of records that are going to be (automatically) inserted. The quantity can change. So I have to count the number of records and use this number in order to select the right cells to be formatted. There is no problem...
  15. Davide77

    using variable in the excel cell formatting

    Hallo I'm trying to format some excel cells depending on some criteria. For example I want that a specific number of rows is set to a certain height. The problem is that the range of rows can change. So I was thinking to use some variables instead of numbers: .Rows("1:3").RowHeight = 36 This...
  16. Davide77

    Storing the value of a query in a variable

    Hallo, I need to use the number of records there is in a query. I made a count query so I know the number of record. The problem now is how to store this number in a variable. I'm using this code: Dim RecordQuantitySQL As String RecordQuantitySQL = &quot;SELECT Count(qry_Room.Room) FROM...
  17. Davide77

    VBA Excel: formatting cells

    Hallo, Does someone know where I can find a complete list of the keywords and syntax used in vba in order to format excel cells, such as: .Columns(&quot;A&quot;).ColumnWidth = 50 .Cells(1, 1).Interior.ColorIndex = &quot;15&quot; .Rows(&quot;1&quot;).RowHeight = 36...
  18. Davide77

    exporting a query/table to excel and formatting it automatically

    Do you have an idea on how to automatically export and format a table from access to excel. Formatting: change colors of specific cells, merge cells and this kind of things. thanks
  19. Davide77

    timetable in a crosstab query

    Hallo, I have a table with 4 fields: Organization, Start_Hour, End_Hour, Room. It is about conferences. I made a crosstab query involving Organization, Start_Hour and Room. The organization as displayed data. Then I made the same with Organization, End_Hour and Room. Then I made a union query...
  20. Davide77

    attachment icon floating

    Hallo, I'm using Outlook 2000. When I attach a file to a message the icon stays in the message body instead of in the footer. Does someone knows how to change this? thanks

Part and Inventory Search

Back
Top