Search results

gizmogeek please refrain from deleting threads to which others have contributed. Even if you do feel that some of those contributions are counter productive.

You could put a search button on the form. You could either use the button to dump a sting into the search field, or move the code to the button's On Click event. Either way you would need to make some changes to the code involved. As I'm currently on the road, and don't have access to Access...

Perhaps I have misunderstood what it is you are doing. However it sounds as if it is similar to what the sample here is doing. Perhaps it will give you some pointers.

It sounds as if you are working with a continuous form. With the method you are using, all records will be changes to reflect what has taken place on the record that currently holds focus. Have a look at Conditional formatting this should be able to do what you are after.

I'm currently not on a machine with Access, so can't test, however I think you probably need to have some code in the form's On Current event, to set the visible property as appropriate.

Also have a look at the DMax() function plus one and search this forum on the subject you should find plenty of samples and discussion on the topic.

If your button is in the main form and your tabs are on a Sub form you will need to use the correct syntax for referring to those tabs.

I'm not currently on a machine with Access, so can't test, but I believe that; Private Sub AssetNum_BeforeUpdate(Cancel As Integer) Me.AssetNum = CLng(Right(Me.AsstNum, Len(Me.AssetNum) - 1)) End Sub Should do what you are after. Your other option is to have an unbound field and use a...

To strip the first character off use; Right(YourField, Len(YourField)-1) You can then use the CLng() to convert that result to a number.

What's wrong with filtering out records with Null values :confused:

You could use the DLookUp() function, our even bind you form to the query.

The sample here demonstrates one method of managing combo box items.

The first thing you will want to do, is develop a normalised table structure. This tutorial should help you in that process.

Sounds as if your form is unbound? If you are trying to use the combo box selection, as a criteria for a query that is populating your Report. The criteria would need to be in the form; Forms!YourFormName!YourComboName This would then use the first column of your combo as the criteria in your...

Welcome to the forum. If you try and divide any number by Zero you are going to get an error.

It should look like; DoCmd.GoToRecord acDataForm, "YourFormName", acNewRec

When you click the reputation Icon you should get a popup message saying that you have added to some ones reputation. Beyond that you probably won't see anything else. I just had a look and yes your reputation up did get credited, thank you :D If you want to open your form showing all records...

The sample posted here demonstrates the method.

Rather than trying to import your Excel data directly to the final table, why not import it into a temporary table, where you can massage the data prior to moving it to the live table. Have a look at the sample posted here for an example of what I mean.

There a couple of thing you can do to show your appreciation for the assistance you have received. The first you have already done i.e. clicking the Thanks Button :), the other is to click the reputation icon;