Search results for query: *

Thank you Roy, It is clear now why my code did not work. So, am I stuck now with four formatting only? Thanks a lot Pauling

Hi Roy, Thank you for your reply. Yes it is a continuous form. I tried the conditional formatting. It worked fine, thanks a lot. Question: The conditional formatting gives 3 conditions only, suppose I have more. Example, each day of the week in a different color. What to do in this case...

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 =...

Yes PHV, this will help, thanks a lot, it is fine now. Just curious. You know in the criteria you can simply put [Forms]![FormName]![Location]..etc and the criteria will pick up the value in that form field. Can't we do that in the Field line in the query grid in order to have the field...

Thank you PHV for your reply. What if the quantity taken more than one? So, there is no way to put something in the Field line in the Query grid instead of the field name? It is like having a dynamic query. If not, I think it is easier to be done via VBA on form level. Thanks a lot PHV

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...

Thank you Rob, Yes you are correct, I meant Front End. What about VB.net? ASP and ASP.net are good for the web. I want to create an application without the need for IE. The application is for 5 computers. Orders Stores Finance Purchasing Personnel I tried Access ADP, it connects without...

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.

Hi, Thank you for your quick replies. clFlaVA, this is a nice solution, but is there anyway to do it without the textbox? Thanks a lot

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...

Hi, What I tried in the meantime is: 1- I created a table of serial number 2- I created a spreadsheet in excel added 50000 which is much more than our collection 3- I imported the file into Access 4- Named the file as BarCode Store 5- I created a new table and Called it Barcodes 6- I created a...

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...

Hi, Yes Chris, it is URL Rewriting. Dashely, I don't think it will work in URL Rewriting. Thank you

Hi Tarwn, Thank you for your reply, you know that I always value your opinion and take your suggestions into serious consideration. Quote ------ "The only suggestion I have that wasn't mentioned by Chris is to set up (in the Internet Services Manager) .htm files to be executed by the ASP dll...

Thank you Chris, This is about generating a page to look like http://www.mylibrarysite.com/12345.htm Now the page is generated, it does not exist. Suppose a user bookmarks this page on his computer. When the user types: http://www.mylibrarysite.com/12345.htm In the address bar, how can...

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...

Thank you dyarwood, thanks a million Paulin

Hi dyarwood, Then when the loop continues #1 becomes #2 and so on? How to make this Macro available to every excel spreadsheet I create, instead of creating the macro every time. Thank you for your astonishing support dyarwood. Paulin

Hi dyarwood, Would you please explain the following in the code? 1- & HTML_FILE_NAME For Output As #1 2- Print #1, HTML_FILE_CONTENT 3- Close #1 1,1 is equal to A1 right? Thanks Paulin

Hi dayarwood, FANTASTIC Now it is working like a charm, I made little modification for two reasons: 1- I want the files to be saved in a folder 2- The page name already has .htm See the modified code which is fantastic: Sub ToHTML() i = 1 Do Until IsEmpty(Cells(i, 1)) HTML_FILE_NAME =...