Search results

Hello, I'm not exactly sure where to put this so I put it here. Here is my question. I have an existing Work Order database that prints out a Work Order every time we need to produce that item but, each time we print it, it overwrites the previous data: ie; date, quantity ran, quantity ordered...

I have a database that has numerical data in it. I'm in need of a query that will list all like numbered data even if it is Positive or Negative. I just need to know if the numbers match. Example: 1025.00 (1025.00) Have any idea how I would get this? Thanks

Hello all, I have a question/problem and I need your expert advice/wisdom. I have a program that prints out Work Orders. The original person who set all this up made a MACRO to do this. (See image) I need this print command to access an if statement and IF TRUE I need it to print another...

I am trying to find a way to convert an HTML file into either an XML or an ACCESS db. I found a couple programs via google but they are not working as I need. Anybody have any idea? thanks Bottom line is I found a web site that had names and address listed but I want that in an access db to...

Is MS Access 2000 limited to how many computers you can install it on? Or is it a one install program, if you want it on 5 you have to buy 5 copies? What if a company that has not bought a new updated copy of Access still uses 2000, can they get away with installing it on several workstations...

I need to know if this can be done. I have a form that has a print button that prints a printout with all the info for the current record. What I want to know is, if I can make certain text boxes on the printout NOT show up if a check box on the form is checked. ei: If chkBoxOne.checked then...

I have a problem. I have this code on one form and it works fine. When I go from one record to the next, if the flexo box is checked it show the flexo text boxes. If the Flexo box is not checked the flexo boxes don’t show up. I copied it onto a different form, same text boxes and same names...

I found this on another forum I read. ********************************************************** Found this on the TalkBass forums and it made me chuckle. It's attributed to John Cleese: NOTICE TO AMERICANS Britain is Repossessing the U.S.A. A Message from John Cleese to the citizens of the...

I have a Access 2000 database with several forms, the database it just over 5meg in size. The database is on a server with shortcuts linked to the database. I have the following modules installed. modMouseHook.bas - this is to disable the scrolling. MachineName - this is used to get the machine...

Hello I have a question for you Tea drinkers. I am a coffee drinker but I only drink it in the morning. During the winter months I would like to drink something hot but don't like coffee in the afternoon. I have tried some kinds of tea but I find it too weak for my taste. So my question is...

75,000-member strong Campaign for Real Ale.... Fiercely proud of their centuries-old brewing tradition, Czech beermeisters have reacted angrily to claims by the world's largest consumer advocacy group, the U.K.-based 'Campaign for Real Ale,' that the quality of Czech beer is going down the...

Rowling Says Dumbledore Is Gay The Harry Potter author breaks big news in New York. I have not read the books but I was wondering if this information enhances the story? If not then WHY in the world is this relevant information.

In this thread I got some help on how to do a table(Multikey). http://www.access-programmers.co.uk/forums/showthread.php?t=137668 Now I need some help on how to use this table on a form. I need to be able to select several certificates and an expiration date for each employee. John Doe...

I have always had trouble with this and no matter how much I read I cannot get a visual picture of how to do this. So if any of you could show me how this can be done. It would be appreciated more than you can ever know. A company has many employees. Each employee can have many certificates...

Merak IceWarp Mail Server 9 I was wondering if anybody has used this and could give me your thoughts of it. Basically I want to know how hard is it to setup and administer. Thanks

Feel like you need a break from your job? A really, really long break? Count yourself lucky if you live in Finland then. Finnish workers receive the most of any other country -- 44 days off each year (30 vacation days plus 14 holidays), according to a 2007 survey by Mercer Resources, a global...

I have a form that users use to input data for our Work Orders. They also use an excel spreadsheet to do quotes. I would like to be able to open the quote from the Work Order form in Access so I don't have to keep opening excel just to print off the quote. Can this be done? Thanks

I have a report that I want to show on part of a form so the user can see the report in the lower panel of my form. Can this be done?

I need to have a text box show a number that is rounded down. Here is the code I have. This code rounds UP I need it to round DOWN. Private Sub cmdCalculate_Click() txtTotalPacks = Round((txtSheetsRan * [# Up]) / [# in Pack]) This ((2750*2)/1000) = 5.5 needs to be this ((2750*2)/1000) = 5 I...

I have 2 tables that contain the exact same columns. Basically titles and singers of CD's I have I want to make one table out of them. Is there a way to do this?