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: *

  1. springy2003

    Prolog problem is numbers

    Hi, I have a very simple prolog problem and I am not sure whats wrong. I have to evalute an integer and from this test will pick the right out come. Here is my prolog code. rule(A,B,C,Z) :- A=<6, rule(one,Z). rule(A,B,C,Z) :- A>6, rule(2,B,C,Z). rule(2,B,C,Z) :- B=yes, rule(two,Z)...
  2. springy2003

    JVM arguments for jsp and java serlvets

    On the command line, you can easily add a JVM arguments to a java class by using: java -Djava.library.path -DwhateverArgumentYouWant className Now I want to run this java class via a webserver using jsp. But I don't know how to do this, or how to set up tomcat that allows this to happen. I...
  3. springy2003

    Network Sharing Problems between two computers. Very weird...

    Hi, I have never in my life experienced this problem before. 2 weeks ago, I formatted my computer, and prior to this was hocked up with another computer on a network via a router. So the router address was 192.168.0.1, and the two computers are 192.168.0.2 and 192.168.0.3. Now, the formatted...
  4. springy2003

    Reminders pop-ups on a particular day in access

    Hi, I am not sure if it can be done in coding, but I want my database that I have at the moment to produce a pop-up box every friday. The pop-up box isn't really a pop-up box, but really just a form that just remind the user to backup data. So is there a code that can check the day and if the...
  5. springy2003

    Report Problems - says that invalid expression

    I have a problem creating a report in Access. I have two tables, one is called tblloan and the other one is called tblbook. tblbook has fields, accession number, (a number given to a book for borrowing, so it doesn't get confused with ISBN), Book name and Out. The out is to say that this book...
  6. springy2003

    Changing values in a field from another table

    Hi, I am working on this borrowing system that consist of two tables. One table holds the data for what is availible to be borrowed (tbl_itemstore) and the other table is the borrowing table that shows what is borrowed (tbl_borrow). tbl_itemstore holds the data for what can be borrowed, has a...
  7. springy2003

    Loaning tables help, or could call it bookings help in access.

    I have a problem with access concerning two tables. I want to loan books out, for example and I have two tables, one where the books are stored, and a loaning table. THe books store table, lets call it tblbook has fields name Accession number (unique number), title, and out. The out is a Yes/No...
  8. springy2003

    How to search for a record??

    Hi, I want to know how to search in a form to find a record that I want. For example, if I have a table called tblmembers and the fields are autonumber, name for example. In a form, these are also a field, and I want a button that when I press I enter a search critea like find record number 3 or...
  9. springy2003

    Defaulting values in a form from combo box.

    Hi, I would like to know if this is possible. I have two tables. The first is tblstore and the other one is tbltype. tbltype fields contain an autonumber (primary key) and a text field. so one record could look like 1, book. There are 4 of these. The other table has 3 fields. An auto number, a...
  10. springy2003

    Editing the format of autonumber?

    Hi, I was wondering if it was possible to change the format of the autonumber. So instead for every new record display 1, 2 ,3 etc, it will automatically put a, let say &quot;1&quot; at the begining. So for every new record, you get 11, 12, 13 instead of 1, 2 ,3. Thank you...
  11. springy2003

    updating AMD Duron to Athlon

    Hi, I am thinking about updating my processor in my computer soon from a Duron 1.10Ghz to a AMD Athlon XP in the range of 2600-3000. I was wondering if I have to change the motherboard, or could I just slot the new chip in. Do I need to get a new fan for it etc.. I am also thinking of...
  12. springy2003

    values from one combo box determinds table look ups in the other......

    I am quite new to access so I am not sure on how to go about this, or is it remotely possible. I have a form (frmstore) that is use to enter data into a table that I have created (tbltable). One of the field is a primary key (auto number) and the other two are combo box. In the first combo box...
  13. springy2003

    Protecting sheets in excel using macros

    Hi, I am sure this can be done. I want to be able to protect a sheet, and at the same time, using a password. The current macro I have is as follows Sub Protect() ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub but the thing is, it only protects the...
  14. springy2003

    Counting up characters in excel

    I am not sure if you can do this in excel, but can you count up characters?? For example, Cell A1 value=A Cell A2 value=W Cell A3 value=A Cell A4 value=W Cell A5 value=A Cell A6 value=A Is there anyway of counting how many As there are, and not counting the W. Thank You.
  15. springy2003

    Help need for a small problem in excel

    Hi, I need help on this tiny problem I am having in excel. What I want to do is transfer one bit of information in one cell, for example from Sheet 1, cell A1, to another cell in another sheet, eg, Sheet 2 and cell A1. At the moment, I am using <b>='Sheet1'!A1</b> in sheet 2, A1, but if no data...
  16. springy2003

    Conditional Formatting &amp; range finder help!!

    Hi, I was wondering if you can help me with a problem. It might sound confussing, so bear with me. I want to be able to use conditional formatting without actually selecting it from the Format menu at the top of the page. I know you can record it, but here comes the confussing bit. I want to be...

Part and Inventory Search

Back
Top