Search results

Remove the line that says SetFocus and it should be right.

Here are a couple of functions that people use to get around that problem. Function CityStZIPNat(varCity As Variant, varState As Variant, varZIP As Variant, varNation As Variant) As Variant On Error GoTo Error_Handler CityStZIPNat = varCity & (", " + varState) & (" " + varZIP) &...

Use the Before Update event of the control if you want to force the user to validate the SKU before moving on to other fields. The advantage of Before Update is that it allows you to cancel the update if you have a duplicate or whatever and that leaves the cursor back in the control. However...

If you have a form open, you can use the form's methods instead of using a recordset. Then you can use FindFirst with the form's recordset clone and set the form's bookmark to the same record that is selected by FindFirst. You use the form to navigate the records showing in the form and leave...

It has taken a lot of time to confirm that the table from the attached database called Furniture 3 is the only object that can be saved to A2007 format. No matter what I tried to remove any A2010 properties on the form and report, it would not save as A2007 format. I have attached the database...

When you say 'I just see the tables in crystal select the field and that is all. ' What is crystal? Whatever crystal is, it must be the reason you are having some trouble with the report. When you select different data, it probably doesn't fit correctly with what the report is expecting.

In the append query, find the sql and go through the sql and remove the bit which says [Forms]![Orders].Tag

Hi to both DCrake and DebsLucy, I have spent over half hour with the database trying to get it into A2007 but no luck. I removed the calculated field in the table and the character '@' in the field format property of most of the fields - the '@' appears for fields that have been imported from...

Would like to help - i have never heard of Pervasive database. i will assume it is an access database. Access reports do their own thing with grouping and sorting. They often ignore any grouping and sorting in the query that feeds the report. Are saying that after you set the grouping and...

Add in a test to see if a selection has been made from the listbox. I see that your listbox is operating in single select mode (and not multi select mode) so we can use the IsNull check. Private Sub lstSchedule_Click() If Not IsNull(Me.lstSchedule) Then DoCmd.Requery...

The combo setup looks right. I wonder if the query for the row source is returning the 3 fields you expect. Create a separate query for the ID, building and apartment and check if it gives you 3 columns.

As Paul says, you can't use RunSQL with this. You don't need to use Runsql, the code you have already adds a new record to the table. The code you have written to add a record to the table is not a query at all. To make it clearer, just remove the RunSQL from the code or macro and see if that...

This happens when your combo box is bound to one of the fields in the form. Combo boxes for searching need to have nothing in their control source - we call that an unbound combo. So delete the control source for the combo and see if that fixes the error.

I agree that the print preview options do not seem dangerous. The reason that most developers like to 'lock up the database' by removing all default menus is to prevent users from changing any queries or editing data directly in the tables. An accde does not lock up the tables or queries. In...

Are you developing this database? I ask because those of us who develop databases for others to use, learn very early that turning off the option for full menus is necessary when restricting how users interact with the database. My preference when developing is to have full menus allowed and...

Access rich text is not as full featured as Word. You can use the rich text formatting controls on the ribbon to find out which rich text features are supported by Access. You will see that Strikethrough is not supported.

I’m sure you will get lots of interesting answers to this question. 1. Lots of subforms. Use a tab control to manage the subforms. You can set it up so that you load the appropriate form in its Subform control only when that particular page of the tab control is clicked. This makes your database...

Sounds like a syntax problem. You need the name of the subform control, (not the name of the subform inside it). Try =Me.[SubformControlName].Form.[ControlName] Note: replace my object names with yours. If you have spaces and/or odd characters in your object names, you will need the square...

There is a great little search sample database that does what you want with 3 or more combos here: http://www.allenbrowne.com/ser-62.html

In addition to your code, when you want to copy the value from the previous record, it is always a good idea to use the Default Value property of a control. The benefit is that you can set the default property of a control without dirtying the record and user can cancel that new record without...