Search results

Yes the AllowAdditions property is set to Yes. One thing I did notice is that I have an old subform in my DB and it has the same problem. Is this an issue with subforms in Access 97? There has to be a setting somewhere to allow for this.....

When the cursor is in the last field on the line of the subform, I keep hitting the tab button and it doesn't move. It just stays in the last field. Its almost like the subform is stuck in edit mode rather than add mode. But cannot find a setting like that anywhere.

:confused: I have a form with a subform in it. The subform won't allow me to add additional lines. My form has all of the customer information on it and the subform records the customers orders. If the customer orders more than 1 thing, the subform won't allow me to record more than one item...

:confused: I have a form with a text box, which auto-populates with the current date when a particular drop down box says 'Ordered'. I have another drop down box which I want to list a choice of ship dates, like 2 - 4 Weeks, 3 - 5 Weeks. I am having a problem listing the weeks in a drop down...

If you right click on the combo box and select Properties. In the property's window, click in the Row Source property. A drop down button appears and another button with 3 dots at the bottom. With the cursor flashing in the Row Source property, it doesn't say 'SELECT DISTINCT ...'? If not...

:confused: I have a table, ExchangeRate which has 2 fields - a date field and the exchange rate, and it gets updated manually everyday with that days exchange rate. I have a form with a text box and I want to display the most recent exchange rate. How would one go about this ominous task?

In the Row source property of the combo box, a SQL statement is created to show the correct field. If the begining of the SQL statement has 'SELECT DISTINCTROW' , remove 'ROW', so it shows 'SELECT DISTINCT'. Now the list does not display duplicates.

:confused: On my form I have a subform, and on my subform, I have 3 cascading combo boxes, all pulling from the same table. Does anyone know how to or if it is even posible, I am looking to remove all of the duplicates from my 1st drop down box. Other than going through the table and doing so...

:confused: I have my customer table and one of the fields is the Country. I have a text box (txtCurrency) on my form that I want to display the type of currency that country uses. If country is Canada then currency is CDN, if anything else currency is US. I pretty sure I'd use an If Else...

Similar problem :confused: I have a similar problem. It is the same senario except my combo boxes are being fed by a Query. I have 6 columns in my query, 3 cascading combo boxes and then 3 text boxes that will display the only available result of the selection on the last combo box. The...

You say to put this code 'Me.UnboundField=Me.cboActivity.Column(1)' in the .column property of the combo box. I have text boxes I want to display in and there is no .Column property. So where do I put this code?

I have a form with 2 cascading combo boxes and 3 text boxes. It is set so you make a selection from the first combo box and the second combo box only displays items related to the selection in the first. For each selection from the second combo box, I want the 3 text boxes to display the only...

I'm sure there must be a way to turn off the warning in the code, but I know you can turn the warning off in Outlook itself. If you look under Tools, Options, on the Security tab is where you can turn off the warning.

The jdp's table? You say they are in the jdps table, but I don't see that table referenced anywhere. Is what the Me. is? strLinkCriteria = Me.[BRD Type] & "-" & Me.[BRD Number] So it would be Me. = table name? [BRD Type] = a field in the Me. table? [BRD Number, Title, Description] = all...

strLinkCriteria = Me.[BRD Type] & "-" & Me.[BRD Number] I'm trying to figure out what is supposed to go in the BRD Type and BRD Number. Are these 2 fields in the table?

SendObject not available Hi guys, I have been trying to setup Automated Email on a form and have had no luck. I saw the post about creating a macro to send mail, so I tried it and came the closest yet, but still got an error. My form has a bunch of text boxes, couple of combo boxes and a save...

I have a field in a table that updates from a web site automatically. So what is the most recent record now, next week the most recent record will be different. I need to be able to pull the most recent record, at any point in time, from that table and display on a form. Does anyone know?

I have a table with 3 fields, that automatically updates 1 of the 3 fields on a daily basis, exchange rate. On a form I have a text box that I want to display that newest exchange rate from the daily updating table. So each time I open this form, the text box will check the exchange rate and...

I didn't think it was supposed to be this hard! Well it is not working again! I didn't change anything, I double checked and then completely rebuilt the process. Yet still no addidtions. I'm not getting any popup messages or anything. Does anyone have any suggestions?

It works! Thanks everyone!