Search results

Your names are confusing, so I'm going to assume that the field you are trying to update is called TIPO_CANALE, and the option group you've created is called fraTIP_CANALE. Add a textbox bound to TIPO_CANALE. If you want, you can hide this textbox. Call it txtTIPO_CANALE. On the Current Event...

Use the DCount function. Check Access help for the syntax.

Excel and Access are meant for different purposes, and as such they have different ways of working with them. One of the big differences is in how they handle data. Go onto this forum or google or whatever and do a search for "Database Normalization" and read all you can on it. That should help...

You need to synch up your text box and your option group using the "On Current" event of the for. Basically, you'll want to use a case statment and look at the value of your textbox, and then set your option group accordingly.

The first thing I would do is unbind the option group to your field. Then I would add a textbox bound to your field, and set the visible property to no. In the AfterUpdate event of the option group, use a Case statement to update your bound textbox. In the current event of your form, set your...

Then why change to a number field? If its an ID "number" you shouldn't need to do any math to it, in which case you would be fine to use a text field instead of a number field.

Try this: Right([filename], Len([filename]) - InStrRev([filename], "\", InStrRev([filename], "\") - 1) + 1)

Try compacting and repairing your database. Whenever I get this error, it usually means that the record has somehow become corrupt.

The name really shouldn't be a primary key - it is not a unique field. Two people could very easily have the same name. The method boblarson suggested is correct. You should create an autonumber primary key for each person, and store that key in the Action table.

Plus, if the user remembers the autonumber (235 in your example), you shouldn't go and change it on them!! If the user is forced to remember an 8 digit number at any point in your database, there is probably a design deficiency you need to correct.

This doesn't directly relate to your question, but may help you get started: http://support.microsoft.com/?kbid=209898

I can't tell if those are tables or queries in your SQL statement, but if they are queries perhaps GMIS_TEST.WORLD is a table in one of those queries? I have no clue...

Try this: =DateEntered - Datepart("w", DateEntered) +1

You need to use a what is called a totals query. You will be grouping by EmployeeID and Sum Days Taken. Check Access help for more info on a Totals Query.

The problem is that your records might contain nulls as well, not just zero length strings (""). Try setting your criteria to be: Like "*" or "" or Is Null That should take care of it.

Or you can set the form's data entry property to yes. This will only allow you to add new records to the form.

Without commenting on the structure of your tables, when Access will not let you enforce relational integrity it is generally because one of the tables has information the other does not. In this case, it is telling you that you have records in resolution (the many side) without a related...

How do you know what record in "captions" goes with what button on your form?

You are looking to use a control called "TreeView." Do some searches for this, you'll find what you need.

That would definitley be a problem. The other thing to watch out for is that when you let Access create a form for you, it names the controls the same thing as the fields. This can create confusion when you are trying to reference one or the other. The best bet is to re-name the controls with a...