Search results

How about duplicating the form and making it not data entry? Exit the first form, open the second and it will display all data in the table.

Bob is correct. Two main reasons, one, you are storing redundant information and two, suppose someone manually changes a value in one of the fields you are concatenating? Because the concatenation result is saved in the table, it is now incorrect. However, if you use a query then it will always...

If you have a report linked directly to a table and don't apply any filtering in your report it will print every record from your table. I usually base my reports on a query so I can apply filtering if required more easily. Create a query based on the table you are reporting on and then you...

When you say you tried putting null instead of "", do you mean you wrote: If Me.RecordCreator = Null Then If so, try the following: If IsNull(Me.RecordCreator) Then

OK, assuming you need to have the [Approval] text box to become blank after something is entered into the [coordinator name] field then try the following: In your Form's OnCurrent Event use the following: If IsNull(Me.[coordinator name]) Then Me.[Approval] = "No" Else End If Then, in the...

In your coding for the button's OnClick event - add this line after the code has updated the text box with its new value: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

For question 1, you can use the requery method on your combo box. This could be triggered by the GotFocus event of the main form, so when you have completed entering your new customer information and the main form gets the focus back, the combo box can be requeried and will display the new...

In your query, in the criteria section for Room put the following: Like "*" & [Enter Room Number] & "*" This will do a wildcard search on the room number which they will be prompted to enter when they run the query.

Also, can each Cause be related to more than one group?

Can each group have multiple features in it? I may have misunderstood your original post!

Are you wanting to change the data in the table itself or just the way it displays on a form or report whilst keeping the original data?

I would use an after_update event on the first Check Box: Private Sub Check0_AfterUpdate() If Me.Check0.Value = True Then Me.Check2.Value = True Else Me.Check2.Value = False End If End Sub

In VBA: MsgBox "The current database is located at " & Application.CurrentProject.Path

I think I would look at something like: tblFeature FeatureID 'Unique ID FeatureDesc 'Description of Feature tblGroup FeatureID GroupID GroupDesc tblCause GroupID CauseID CauseDesc tblCorrectiveAction CauseID CorrectiveActionID CorrectiveActionDesc Pretty much how you have set it out in...

Is there any link between the three queries?

I'm not 100% sure but I think that if you do the =([SumOfAccruedTime]/3600)*[RateChargable] calculation in your query, rather than on your form, you should then be able do a sum of the query expression. So, in your query, if you add an Expression in such as: Total...

OK, there are several parts to the update process. 1) You need to pick a folder on your network which will hold the master (or latest version) copy of the front end database and which each of your users can access. 2) In this folder, you need two .mdb files. One will be the latest version of...

Matt I have no idea why your shortcuts may be behaving as you say. However, have you thought about automating your Database updates? I have 3 databases which are used by my department, each one has a Front End stored on the users PC and a back end which sits on the Network and holds the data...