Search results

I tried, and for some reason, when I click on the down arrow, nothing shows. The line remains blank. That's why I used the Expression Builder. Could there be something in the way I set up the combo boxes that explains why I can't simply select the table and field? Thanks, Henry

There are two combo boxes. The second, one cboEditPgm depends on the value in the first, cboEditAgy. That part works. What doesn't work is that when I set the record source to the field in the table that needs to be edited, I can't edit it with the combo box. I'm attaching a word document...

I want to allow the user to to edit information in two tables: to add or delete records or to change the contents of a particular field. I'm using dependent combo boxes because there is a one-to-many relationship between the two tables that I want to allow the user to edit.

On a form I have a set of dependent combo boxes. I want to the user to be able to use these to edit the information in the underlying tables. I set the row source in each box to the appropriate table, but when I set the control source to the table I want the user to be able to edit, the same...

I'm truly glad you spotted it. Thank you!

Thank you. I feel foolish, but I'm glad it not something much more complicated. Henry

I’m trying to have a report where the user can specify a reporting period. I set up a form with a command button to run the report and two text boxes for the user to enter the start and end dates. Then I added the following parameter in the date field of the query that feeds the report...

Pat, thanks. That's the answer I was looking for.

In a report I need to calculate a total amount spent for a time period (a quarter) and the remainder available for the rest of the year. If I’m creating a report for the first quarter, then the problem is easy, simply subtract the amount spent from the amount budgeted for the year. The result is...

I'm setting up data entry through a a combo box. The data are names of social services agencies. Some of these agency names have apostrophes in them, for example, Children's Aid Society, or St. Vincent's Services. In testing the combo box, when I come to one of these agency names, I get this...

Pat, Thanks. First I tried my original code, which didn't work when I based the form on a query. When I based it directly on a table it worked. There doesn't seem to be any reasobn for it, but that's what happened. Then I tried the code you gave me. It also worked. As I think about it, I'm not...

Thanks, Pat. Do I keep the requery in the after event, and is the syntax for the after event correct? Is the syntax the same for the current event? This isn't a continuous form.

Pat, thanks. I changed the row source in the second combo box (there are only two) to: SELECT tblAgyPgm.ProgramName FROM tblAgyPgm WHERE AgencyName=Forms!frmCases!cboAgy; In the After Update event for the first combo box, cboAgy, I used: Private Sub cboAgy_AfterUpdate() Me.cboPgm.Requery...

Thanks Liddlem. I tried it , and unfortunately I couldn't make it work. I created a query called qryAgy; I set the parameter to the combo box, and I set I set the cboAgency After Update event to refresh the query with me.Requery. Then I set the rowsource for cboPgm to the query. I was able to...

I need a set of cascading combo box on my form. The user will be entering data about cases belonging to social service agencies. The user needs to enter the name of the agency and then the name of a program run by that agency. The names of the agencies and their programs are in a table called...

Thanks, Pat. That's a great idea. That's how I'll set it up.

Thanks. That clarifies it. Now I have to decide if I want toe user to see all of the records or only the new ones. Probably just the new ones. I suppose I can set up another form to use if there's a need to go back and modify a record that's already in the system.

Hi Pat, I had to create a sanitized version of the database, which I've attached. I created a simplified form with only a few of the fields I want to have on it. When the Data Entry property is set to "yes," none of the records show, and the record counter shows 1. When it is set to "no," all...

HI Pat, I tried creating a new form in a new database. I set the property to "yes" and I still wasn't able to enter data. Then I tried setting it to "no". That didn't work either, although it does in the first data base. There's either a setting which I'm not finding, or my copy of Access has...

No. It's a main form. What I seem to have discovered by trying it is that selecting "yes" results in the "add new records" button being greyed out, and selecting "no' results in the button being active, and I can add records. It doesn't make sense, but it seems to work that way. I'm using Access...