Search results

You're saying when you made the selection in the combo box, the box did not show blank? I just tried this sample on another machine with Access 2000 and it still acts up. I'm wondering if this is a bug in my version of Access and it needs further updates downloaded. I thought I had all...

I've never seen this before. I have a form bound to a non-updateable query. There is an unbound combo box in the form footer. When the form contains no records, the combo box display goes blank after you make a selection. I checked the After Update event of the combo box and the value...

I only want to update one table, and have the other fields auto-fill based on the matching record in the other table. I can't use VBA to auto-fill unbound text boxes because this is a continuous form and when you change one, it changes for all records. I have tblSalesPromotions which contains...

I have changed my original post as it was probably too wordy. Could someone please tell me if what I am trying to do is even possible so I can then move on and stop trying to figure it out? Thanks.

I am going to retype this as perhaps my original explanation was too wordy. I need to display data from 2 tables in a continuous form. Sure I can do this with a query and a join, but the user needs to be able to add records to the form as well. When adding a new record, only one field need be...

Actually I'm not using a SQL statement but an actual query object. I am using VBA to concatenate a string from the listbox to use as the criteria for the query. From there I open a report which is based on that query. The SQL for that query currently looks like: WHERE (sometable.somefield) =...

I tried to search for an answer but the results were too broad and some of my words were excluded from the search because they were too common so I was not getting anywhere. I have 2 questions: First, I have a form set up where a user selects query criteria from a multi-select list box. My...

Thanks, looks like what I need. I tried out the example and it worked. Now I just have to incorporate it into my report. Shouldn't be a problem.

I don't want to actually display that value, rather I want to be able to use it in an event procedure. I would like to resize the subreport footer based on the number of records in that subreport. You ask why? Maybe there is a better way than what I am thinking... this is a 2 column report...

I am working on 2 column report/subreport. The rows in the subreport are autonumbered with a running sum over group. I am looking for a way to find the total number of records in each subreport in the On Open (or other) Event. I tried Me.CurrentRecord but I get an error because it appears...

Access did automatically set it up as a one to many relationship. There is no code tying the 2 tables together. Both tables contain an index field to tie them together and it is set up that way in the master and child field links. In the table containing the main title of the CD the index...

Is it possible to print text both horizontally and vertically on the same report page? I'm referring to printing a vertical line of text where the letters are oriented 90 degrees to the horizontal text. Doing this with a picture insertion would not work because there would be a need to...