Search results

Try the suggestion in the utter access post of resetting the querydefs after relinking. If that works, that is the one for you. Don't even think that you have done something wrong with references - this is definitely a bug in A2010. I know how much time I spent confirming that it is a bug - I...

I just checked on Utter access and someone says that they found a workaround with some code to go throught the querydefs and reset them. Here's the link to the utter access post http://www.utteraccess.com/forum/Invalid-database-Object-R-t1953275.html

I know this error very well. It is a bug in A2010. This error happens when the frontend and the backend are in different folders and you are using A2010. We are waiting for SP1. I believe that you can get around the error by doing a compact and repair. I haven't needed to try the compact and...

The number of tables, queries, forms reports ect looks normal for a large database. You can get that error if you open objects but don't close them properly. Here is an example using a recordset. We call it 'cleaning up'. 'start of example I always clean up in the Exit area with an On Error...

In addition to Gemma's fine answer - Tell us which limits are causing a problem. What is the text in the error messages? How many forms do you have? How many saved queries? How many reports? How many ActiveX controls? How many relationships? Does your app compile? What references are set? Is...

Surprisingly, the name of the tab is not needed at all. Just use the name of the form and subform (if there is one) together with the control name. Do it the same way as a form without tabs.

Here is a link to a sample db that shows an easy way to setup the form to search from multiple textboxes and dropdowns. I personally use this type of search form many times in databases for my clients. http://www.allenbrowne.com/ser-62.html

Instead of putting that code in the report, put it in the record source of the report instead. Base the report on a query. In the design view of the query, put >0 in the criteria row for the column called 'amount'.

Remove the line of code DoCmd.ApplyFilter, " " That code does not do anything useful. See if that stops Access from crashing.

I suggest that the Report button has code like this Private Sub ReportBtnName_Click() Dim strWHERE As String Dim lngLen As Long 'Date field example. Use the format string to add the # delimiters and get the right international format. If Not IsNull(Me.txtStartDate) Then strWHERE = strWHERE &...

Post the code behind the Report and Refresh buttons so we can make suggestions.

I did a quick search and found these suggestions from access mvp Allen Bronwe. Answer 1. To get you started, you will need at least these tables: Trainee: one record for each person Training: one record for each type of training Course: one record for each time a training course is offerred...

First - the label that goes with the attendance is a control on your main form. You can change the caption of that label using code. Me.[NameOfLabel].Caption = Me.[TrainingDateControlName] Second - your tblEnrollment is breaking the basic rules of Normalization. Read up on normalization before...

Instead of creating fields called Volunteer1, Volunteer2, Volunteer3, create a separate table that matches the program ID with the volunteer ID. You can call this table tblProgramVolunteers. This table can have an autonumber primary key called ProgramVolunteerID. The 2 important fields are...

Base the form on a query that combines the data from tblQuotes and the Client's name from tblClients. Put an unbound combo in the header of the form. The combo shows the status. You can use the form's filter to show the records that match the status selected in the combo. Here is some sample...

I believe that Win7 comes with a free virtual machine setup with the Winxp OS. I read this recently from a well-respected mvp - Albert Kallal. I must admit that I have not tried this, but it might help you. Also have a look at this http://allenbrowne.com/bug-17.html

You need just one table for categories. You have a table for Types. Assuming your Types table has an autonumber primary key called TypeID, you just store the TypeID in the Company table and in the Category table. My answer from the previous post still applies to get the correct list in the...

If it is as simple as you describe above, consider putting all the categories into the same table. In the categories table, have a field that shows the type. Then back in your form , your combo can automatically get the correct values for the type chosen in the form. ' suggestions for the...

Use a delete query to remove the ticket ID (from whatever table you appended it to) in the subform's on load event. When you detect that a user has backed out of the subform without entering any ticket details, run the delete query.

Sounds like you are trying to build a search form to display the results depending on what the user chooses. Here is a link to a sample database that I use for my search forms. The important part is how the where clause is built from the listboxes or combos after the user makes their choice...