Search results

Votre message n'est pas poli. Utiliser Google Translate si vous ne comprenez pas. Voici est la version 2010: https://www.youtube.com/watch?v=HiLu6icfuhM

This is exactly right. If you want to do it, you'll need to use unbound controls and VBA to populate recordsets to achieve this. If you're not a sufficiently advanced user to be comfortable with those, then I would suggest either resigning yourself to subforms or popping up a chain of forms to...

Where is it supposed to be getting the value for [tblusers]![AdditionalDutiesRosterAdmin]? You haven't given it a way to retrieve that data. You might try a DLookup, although that can be slow if the table is large. If performance is adequate on the DCount is should be fine for the DLookup.

Save what, exactly?

In my experience, some versions handle that more gracefully than others and it's better to be prepared for the stricter case. YMMV.

You also are missing the closing semicolon at the end of your SQL statement.

Also, if you have the time in your date field, as you do, then to include results from the date input as your ending criteria date, you need to use the DateAdd function to add one day to the end date. This is because dates that are just m/d/yyyy are evaluated to midnight, the very beginning of...

This is exactly what I would do. Populate a temporary local table with your query results and have the additional true/false field in this table only. You can empty or destroy the table once you've completed your output or in the form's close event so that you're not storing unneeded data. It...

I've never tried to do this and am not sure what the purpose of such height adjustment would be, but it seems like the most straightforward approach to this would be to check the number of items that should appear in the list box and then create the form dynamically in code as needed, with...

I'm afraid realistically that means adding a table field to contain what you need to link on.

plog is right. Also, you need to ensure that your primary key from the child table is the bound column on the combo box where you select a child to add to a session and that the primary key from the session table is the bound column on the combo bx where you select a session to add a child to...

You need to link the tblVehicles to the tblModels by ModelID in your query, then link tblModels to tblMake by MakeID. Once you have done that, add the Model text field from tblModels and the Make text field from tblMake to your query grid to display when you run the query. You can deselect the...

The reason you're getting this result is that Access thinks the value 2 is a string rather than a number. As an operator, + will add numbers or concatenate strings. What is the data type you have set for each of these fields you are adding? If it's text, is there a reason for that? You can work...

Additionally, after you've combined those 4 tables into one, you should have a look at having the VesselID be the Master/Child link field between the form with the combo box for selection and the subform where the data is recorded. That will save it to each record automatically when you create a...

The easiest way to handle this is to create a query on the table with the full part numbers and add a field to the query which calculates only the partial part number. Then replace the table that only has the full part numbers in your query with the query you've just built and link on your new...

You're welcome. Good luck with your project.

You can add field validation at table level if your database back end is SQL Server (though it is not a simple process). With an Access back end, the only table level validation is whether entry is required and data type (Access doesn't allow text in a numeric field, for example). You'll...

Grumm has it right. Len() is going to give a numeric result every time, so you should be checking to see if Len >0, not empty string.

The (usually) easy way to deal with this is by adding a statement to your label code of Me.Dirty = False

The short version is, it's fine and your design looks reasonable. The longer version is that it depends to an extent on what proportion of projects would be Industry vs. CSS, as you may get moderately better resource allocation by breaking out the lesser-used fields to a linked table if a...