Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I have implemented an error handling routine in all of my form, and it seems to work, except that when I try to write to a table I get an error message that states------syntax error(missing operator) in query expression "(the error message)' , '(user)', #(date/time)#, '(Form name)'-----the...

My company runs an acess database and interface within a workgroup framework. Our application is fairly stable, but the only issue we seem to be encountering is that of abrupt network dissconnects. When this happens the backend database locks every user out of the database. Sometimes it even...