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!

Register Log in
  • 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: Phudsen
  • Content: Threads
  • Order by date
  1. Phudsen

    Text Color in Tabular Forms

    Hi, I have a tabular form that is working fine. It has a field called "Gender". The values are M for Male, F for Female and E for Exam. I want to display M in blue, F in Red and E in black. I used the following code: Dim lngRed As Long, lngBlue As Long, lngBlack As Long lngRed =...
  2. Phudsen

    Pickup Field name from the form

    Hi, I we have a Main Library and 3 branches. Let's say that we have a book called "MS Access Unleased", we have 11 copies: 6 Main Library 2 Branch 1 1 Branch 2 2 Branch 3 In my table I have book info fields in addition to the following fields: Qty MainLib Branch1 Branch2 Branch3 When the...
  3. Phudsen

    SQL Server and MS Access adp

    Hi, 1- Can MS Access be a full development tool for SQL Server databases? 2- Is there any development tool built in the SQL server? 3- What is the best development tool for SQL server databases? Thanks a lot.
  4. Phudsen

    Combo Box (Drop Down Box)

    Hi, In MS Access you can filter the drop down box by typing character after character to reach the option. Example: -------- I have a drop down box that is getting Product Names from the database. If I type C it takes me to the first Product in C letter. Suppose I wanted to look for...
  5. Phudsen

    Serial Number (As in Excel)

    Hi, In our library we create barcodes for books. I have created a nice application for typing the barcode and printing it. Recently we needed to add 1000 numbers to the database to barcode new books. Typing 1000 numbers which are actually a series takes time. So, I created the series in...
  6. Phudsen

    ASP to HTML

    Hi, I have a database on journals, each journal has an ISSN number. When the user searches for a certain ISSN the information of the journal get displayed with a link to the subscritpion. It is working fine. The hyperlink will be...
  7. Phudsen

    HTML Code from Excel Cell into Webpage

    Hi, I have an excel sheet which has two columns. Column 1: PageName Column 2: HTMLCode PageName has information like: OurServices.htm which is the name of the HTML page. HTMLCode clumn has actual HTML Code like: <html> <head> <meta http-equiv="Content-Language" content="en-us">...
  8. Phudsen

    Frontpage Hover button

    Hi, Frontpage hover buttons are using Java Applets. In the HTML view I can see the applet and the parameters. Is there a way to add a parameter to the applet to make the button go to the previous page. Is there any good online tutorial to show all possible parameters for the applets? Thanks...
  9. Phudsen

    Use MS Access as Front End for SQL Server

    Hi, I am not the SQL server admin, but I have a database on the server to which I am the owner/admin. When I open the Enterprise manager, I can do everything, create tables, insert data manually. The SQL server uses my intranet login. I created an MS Access .adp file, connected to the...
  10. Phudsen

    IIS on XP stopped working

    Hi, I have Windows XP Professional with SP2 on my Laptop. I installed IIS and ran it, it worked fine, after sometime it suddenly stopped working although it is running when I checked it in Administrative Tools and in the tasks. If I create a new user and started iis, it works fine, but it...
  11. Phudsen

    Javascript sub-menu opens behind the flash animation

    Hi, I have a program called Pop-up Menu Creator to create web menus. I created web menus using it, everything is fine. The menu is placed on the left (content), when clicked the sub-menu opens to the right over the main page. I don't have frames. Everything was fine until I created a flash...
  12. Phudsen

    Apostrophe in a title

    Hi, I have a form that has been working fine until a searched for a title with an apostrophe. The form gave an error. How to avoid that. Suppose I am looking for Penguin's Medical Dictionary . This is the filter code I am using which is working fine for titles without apostrophe. Set rs =...
  13. Phudsen

    Access VBA and the Machine

    Hi, Is it possible to read the machine number using Access VBA? This is to be used as security for the program. Or, how can I make sure that the program "Access Program" I give to Mr. X can not be used by Mr. M? Thank you Paulin
  14. Phudsen

    Bold text within Normal text

    Hi, I have a form which has a combo box. The combo box lists cheque numbers. When the user selects a cheque number, a message will be displayed in a text box down saying that "You have selected cheque number 12345. Please click...etc". The text is written by me, but the cheque number is...
  15. Phudsen

    View ID details on Double Click

    Hi all, I have three tabular forms each one appears on a different condition. I don't have a problem with that. The three forms have a field called SubjectId. When the user double clicks the subject ID he/she will find the details. Do do that, I made for each form, 1 query and 1 forms...
  16. Phudsen

    Shop values form based on a query

    Hi all, I have a table called MovieMaster for videos and shops, example: Some of the fields are: CassetteID Type Shop1 (This field will hold quantity of shop1) Pricy (Price per Unit) CassetteID Type Shop1 Price ----------- ---- ----- ----- 1 DVD 23 20 2 DVD 12...
  17. Phudsen

    Fill textbox then make it read only

    Hi, I have a form with a drop down that has cities. When I select a city, I want the value selected to be sent to the textbox then the textbox becomes readonly. If I change the city again, the value of the textbox changes and it become read only. The Drop down is called "City" The Text is...
  18. Phudsen

    Changing Field Back Color

    Hi, I have a tabular form that lists staff information: StaffID, Name,Email,Mobile,Telephone, Status and some other fields. I am displaying all the data in our department in a tabular form. Is it possible to change the backcolor of one cell after being updated? Example: A staff changes...
  19. Phudsen

    Number or filtered records

    Hi, I have a tablular form that lists all the records in the table. I added some combo boxes to filter some data using this code: Me.Filter = "[Action]='" & Me.cboAction.Column(1) & "'" Me.FilterOn = True Everything is working just fine, all combo boxes are working and filtering records...
  20. Phudsen

    Retrieve Client's Country Name using ASP

    Hi, I have a website at work, this website is in a web folder on the web server. I don't have access to the root of the server. There are few pages that I want to restrict only to the users of the country where I am in. The problem is that we are getting hundreds of requests from outside...

Part and Inventory Search

Back
Top