Search results

  1. M

    All Reports crashing in access 2003 on a win 08 box

    I have found a solution to this problem..... It was a HP print driver that became corrupt. It just happend to be the default printer for all users. Once the driver was re-installed everything worked. Microsoft error reporting is AWSOME!!!!!!!
  2. M

    All Reports crashing in access 2003 on a win 08 box

    Hi, I have a access app that runs via XP run-time in a windows 2008 server terminal server environment. I have access 2003 installed on the win08 box for administration. All of the reports that are in my app started crashing yesterday(even when I try to access them thru design view). I get a...
  3. M

    Password strength and lockout

    I need to be able to enforce password strength rules to require a 8 character minimum and a lockout after 3 failed attempths to log-on to an access database. I am familiar with the system.mdw features but am unclear how to do this with the controls that access provides(do I need a 3rd party...
  4. M

    Comparing a Date/Time field to system date

    I think that logic will work but I have one more issue, the text box that I need changed to a red background is part of a form that is bound to a query. So there may be multiple records with diffrent dates. I need to flag specific records that meet the criteria but not the ones that don't...
  5. M

    Comparing a Date/Time field to system date

    Hi, I am trying to compare a value in my databse produced by the date() function, short date format, to one that is exactly 24 hours after the value recorded by the date() function. If the value in the database is 24 hours prior to the current date(), I need to flag a text box a diffrent color...
  6. M

    help with insert into statement

    hi, I am trying to insert a few values into my companies database using an insert into statement. Everything goes well untill I try to insert a value into a field name called # Refills, no matter what syntax I use it will not allow me to insert the value into the field .... Is it something to do...
  7. M

    Access closing after holdind down scroll bar button...

    Hi, I have a weird problem involving a text box that is bound to a memo field in my database. The control at first seems to work fine but when in run-time if you enter data in the text area, and then after entering text hold the scroll bar(only if you press and hold, just tapping does not...
  8. M

    Using and object to pass values between forms

    No, I tried that and it gave me an error stating that an object is required.
  9. M

    Using and object to pass values between forms

    I need some help with this problem as I've tried to resolve it for hours. First let me startout by saying I am using access 2000. What I am trying to do is to pass a string value from a combo box on a form to a Text box on a sub-form of that form. I have tried to create a class(consisting of...
  10. M

    permissions on backend file

    I am running a FE/BE access 2000 database that requires compact and repairing about once a week. I have recently seen utilities online that could automate the compact and repair feature of access to fire off every day. The problem that I am running into is that every time a compact and repair...
  11. M

    access lock files on backend

    I work for a company that runs an access database split into a front end and back end. This database works fine when used in a small environment(3 to 4 workstations), however when put into a larger situation(7-10 workstations) we seem to encounter many problems. These range from getting lock...
  12. M

    Switchboard problem

    Hi, I have recently developed an access database on a machine running office xp professional. Everything works fine when I test it on the machine it was developed on. The problem occurs when I copy the database(and interface) to another computer which the billing depatment will use. This...
  13. M

    Logging the control that caused error on form

    I am wondering if it is possible to log to a table the control on the form that caused an error. I already have an error routine that records the form name, user, and error string associated with the error that occured. Thanks
  14. M

    updating combo box

    I am writing a application in access to facilitate medical records. In this application under a patients antibiotic history I have 8 combo boxes that pull any one of 100 antibiotics(a patient can be on multiple antibotics at the same time) that are in a base table, this works very nicely except...
  15. M

    writing checkbox values to a textbox

    thanks for the tip, but how do I set it up so I can use multiple checkboxes and one text area ie. to make a list of the checked boxes in a text area. with the code you supplied It will overwrite each time i check a checkbox.
  16. M

    writing checkbox values to a textbox

    I am having a slight problem sending the caption of a label to a text box, based on the value of an associated check box. It puts the value I desire in the text box, but gives me the following error: Run-time error '2115' The macro or function set to the BeforeUpdate or ValidationRule for this...
  17. M

    combo box (using a selection to search a database)

    thank you dcx693 I tried the code you sent and it worked. I really appricate it.
  18. M

    combo box (using a selection to search a database)

    I have an access database that on my interface I use a combo box to allow a user to scroll to the record he or she desires and when clicked it populates the appropriate fields on the form. Everything works just fine except when the name highlighted in the combo box has an apostraphie (') such...
  19. M

    Error numbers and descriptions

    I have created a routine in VB that loggs erros to a table. the only trouble is that I can't seem to log the error description into a a table. no problem because I will put the descriptions in their own table and link them by err.number. My question is then how to I go about getting all the...
  20. M

    error handling- writing to a table

    Thanks Mile, but I am a little lost. could you possibly post the code for the adodb.recordset, and the .addNew method?????---As you can tell I am a new programmer fresh out of school! Thanks so much....
Back
Top Bottom