Search results

I have a Teams table that seems to have an intermittent problem. Records in the table randomly seem to be lost or sometimes data within the record gets switched around with other records! For example, yesterday I had two certain records: Team 9a, Team 9b. When I went into this table, there...

Yes, the Nz functions are already in the Access queries and these queries run fine. It's when I try to import these queries using Excel that I get the error message.

Try starting from Excel and importing from Access: In your Excel Worksheet, select Data ->Get External Data->New Database Query->MS Access Query->(Connect to your database) ->(Select the query that you've written). If this works the way you want it to, you can have it automatically refresh...

I have several crosstab queries which use the Nz function to place a zero in any Null field, which work fine. However, when I attempt to import this data in Excel, I get the error that the function Nz is not defined. Is Nz just unrecognized by Excel? If so, how can I get around this problem?

What I have is a main form with a subform datasheet. When the user clicks an Option button on the main form, I need for every record in a certain field on the datasheet to go to "0". So far, my code is: Private Sub Option33_Click() If [Forms]![frmsparesite].[Form]![Option33] = True Then...

I have a crosstab which has three row headings: Kit #, Date, Team. These are sorted ascending by the kit # and sort fine. The column headings are based off of a part listing and the intersection value is the Sum of the number of parts in each kit. By default, the column headings are sorted...

I have a db in a shared environment. Sometimes, but not always, when multiple users are working in it, the database will replicate. I will see a replica database for every person using it; i.e. if 3 people are using it, then there will be a db1.mdb, db2.mdb, and db3.mdb as well as the original...

Right, I have it set up that way, but the "Find" feature would only search the ID field and not the Name field. However, I figured out the problem. In the Toolbar, under Options, Edit/Find, you can change from Quick Search to General Search and it will search the needed field.

I need to allow users to 'find' records based on the Team Name combo box. The problem is that the bound column is not the Team Name, but the TeamID Autonumber which is not visible. How can I allow them to search records by Team Name without their having to know the TeamID?

I have a db on a shared drive in A2k which tells me about 3 or 4 times a day that it must repair itself. I have set it to automatically compact and repair every time it's closed and no users have complained about errors with their data, but I'm still nervous. I have looked through these...

I have created a form with subforms using an Auto-Form wizard. However, when it first loads up, I get the following message with "Error$" highlighted in the code window: Cannot find project or library. Is there a reference that I'm missing here? And why would it Goto error in the first place?

Access is kind of bad about sorting. If you have a table set up for the days of the week, then add another field to the table, set its data type as Number, and then number the days in Ascending order (Mon=1, Tues=2, etc.). Sort the table or the query that is based on this table Ascending by...

I have a form that simply will not close. When I hit the close button for the form, it stay put, when I hit the close button for the database, it stays put, and when I try to go to the code in design view, it does nothing. I've tried a compact and repair, but it doesn't seem to do anything...

I have developed a fully functional database in Access 2000 that seems to run quite well on its own. However, my users all have 97 so I have made a few test copies and converted them down. The conversion process seems random, one converted just fine with no error messages, another converted...

Well, yes, all of my forms have quite a few controls on them. Also, I have a Switchboard which has a Command button that gets you to the Data Entry screens. This Switchboard remains open. I suppose having more than one Form with VBA running both of them could possibly be causing this error.

When I enter a lot of records into my data entry forms, I often times (but not always) get the following error message: The instruction at "(string)" referenced memory at "(another string)". The memory could not be "read". The first string is always the same combination of letters and...

Alright, so now my users are saying that they want lengthy, detailed column headers in my subdatasheet. The only problem is that there are quite a few column headings and doing so would have the form be way too large to fit nicely on the screen. Is there a way to increase the height of the...

I have been searching through this forum and understand that the Nz function should be used to handle nulls in a crosstab, which is exactly what I want. However, where in the query should this function be placed? Can I do it in query design or should it be expressed in the SQL statement? For...

Well, let me rephrase that: The form doesn't entirely fit on the screen, but the part that I want the user to see does. Maximizing won't work as it still Recenters. I'd like for the form to stay put exactly as it is when the user tabs through the fields, but let the user have the option to...

I have a form that's pretty large but just does fit on the screen. I'd like for it to remain centered exactly as it is no matter where the user clicks/tabs on the form. I have set the Autocenter and Resize properties to "No", but it doesn't seem to do anything. I will be having users copy...