Search results

Help! Suddenly and without warning, my Access 2000 database will not compact. When I go to compact/repair nothing happens. Does anyone out there know what may have caused this and what I can do to fix it? My database is growing by the hour and desperately needs to be compacted. :eek...

Hello. I recently inherited a very sick MS Access 2000 database that crashes several times per day. It is ~60 MB in size and has about 30 users in there reading/writing at any given time. We are considering upsizing to SQLServer and keeping the Access front end (linking to the SQLServer...

I am at a loss. I have a very simple query with the following criteria: Field1 <> "ABC". Problem is, in addition to returning records where Field1 <> ABC, it is also returning records where Field1 is not null. I don't understand why my query would exclude records that I'm not explicitly...

Hello. I'm brand new to Excel programming (I'm an Access person) and am trying to make something work but am having trouble. I have a user form with a combo box. I would like to be able to filter records on the data tab based on the user's selection from the combo box. I'd be very grateful...

Hello. I have a very simple select query in Access that I need to import into Excel (so that it can be refreshed from within Excel). During the import, I get the following error message in Excel (although I have seen the same error in Access on other occassions): 'Two Few Parameters...

I am struggling with an IIF statement and am wondering if anyone can help. I have four date fields: Received_Date, Install_Date, Inventory_Date, Last_Logon_Date. I am writing a query and need to create a fifth field called Latest_Date, which will take the most recent of the four dates listed...

I am having some issues with MS Access that I hope someone can help with. I have a report that has some lines/borders in it and when I export the report to MS Word via Access (creates an rtf file) - the lines/borders are not showing. I can create the file to pdf and the lines/borders show up...

I have a query where say: Select Distinct Serial_Number, Field1, Field2, Field3, etc from TableName. In some cases there are two records with the same Serial_Number, but in one record all other data is blank, and in the other record, Field3 has data. I need to run a query that shows me all...

I have a numeric field where I set the field value on my form to zero. However when I run the form in form view, the zero does not display. What am I missing? Thanks in advance!

Hello, I am using Access 2003 and need to turn the mousewheel off in one of my forms. I searched the forum and found some information about the MousewheelHook DLL. I am in a situation where I cannot load a DLL onto my system. I find it hard to believe there is not another way to turn off the...

on a vbYesNo message box, is there a way to put my own text inside the buttons so instead of saying "Yes" and "No" they say something like "Create New" and "View Existing"? Thanks in advance.

Access 2003 has an "on mouse wheel" event. I would like to disable the mouse wheel, but have not found a way to do that. I first tried writing some code on the event that basically cancels the event if the mouse wheel is "clicked". However, the event seems only to fire AFTER the fact (i.e...

Hello. We converted an access 2000 database to 2003 and are getting the following error when opening some forms: "The expression On Open you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives."...

Is there a way to force a form open when entering the database via holding down the shift key. I have my database set to open a particular form via the startup menu. I have two "super" users who go in as developers and bypass the startup menu by holding down the shift key. How can I force a...

Hello. I have a form with a subform. The users like to use the file --> find option to search fields within the main form, which works well. However, when they use file --> find on the subform, the get no results, even if the data they are searching clearly exists. Any suggestions? Thanks...

There are multiple Access databases within my organization. Two of them are 1) a budget application, and 2) a project management application. Each was built and is maintained by a different department. The same people, however, use both applications. There are enough differences in the...

Hello. I have a user who is repeatedly receiving this error message: Run Time has Elapsed -- Application will Shut Down. It then proceeds to knock her out of the database. She is the only person in a user group of about 20, who is having this problem. The events that trigger this message...

Hello. I have a database that sits on a shared drive and is accessed by an average of 10 people on a daily basis. This database is not split (long story). Every so often, when a user logs into the database, they receive a message telling them that the database is locked by [user name] and...

Hello. I have a field defined as text called InvoiceNo. I want the default value to be 00-0000. However, 00-0000 converts itself to 0-0 when I save the field properties. What am I doing wrong? TIA. :confused:

I have a continuous form with two, simple calculated fields (=[field1] + [field2]). Roughly 90% of the time when the form is opened, the calculated fields in the first record display #Error. All of the other records on the form are fine. If I hit F9 on the keyboard to refresh, the #Error goes...