Search results for query: *

I have a form containing a tab control. Inside one tab is a subform. I'm having a devil of a time getting the subform to fit nicely without scroll bars appearing. One further catch - my subform has a header, detail and footer and I need all to be fully visible with no gaps between them. I...

Are any standard SQL as opposed to Jet-specific ??

How get just date part of datetime column in SQL?

I set columnheads to YES but where do the column headings come from? how do I specify them?

MS Access help (what a pathetic thing!) talks about field names and captions but there is no caption property ??? I need the column heads to position automatically based on the column widths.

I should have mentioned the original form is a subform, so do I have to put: {Forms]![mainform]![subform] ??

I'd rather not build a crippled system as performance is very high on the criteria of what will make this system successful. So I'd like to do it right the first time rather than have to go back and change and retest everything again.

I have a form with a list box and a FIND button. When this button is pressed it leads the user thru a series of other forms to select records. I build an SQL and want to load it into the rowsource of the original form. I'm using this code but it is not finding the form...

I'm developing what is turning out to be a huge system. My main tables are full of id's which refer to other tables. In my processing I have a constant need to convert these id's to full descriptions. Some of the less voluminous data I keep in global collections. But I have some bigger tables...

Thanks Roy! It worked like a charm. Who'd have thought it would be so simple.

Well its not that simple. My illustration was greatly simplified. The report is much more complex than that and I have several groups of repeating items.

Thanks. I found a piece of code that does the 'to' addresses in a different way it uses a property called 'recipients'. How do I get an email address in the 'CC' list?

I found the answer. I had 'Auto Resize' set to YES. I set it to NO, then any change in the window size was retained.

I'm confused by this advice. As far as I know no subform is involved. This is a continuous form and there is no 'height' property. The form has a header, detail and footer but increasing those does not do what I want. I need to show more of the repeated rows. When the window opens, I have to...

Roy Vidar's ingenious idea seems like it should work I will try it. The reason the Activate event did not tigger is because the original form is a subform, at least that's my guess. I have not have the time or inclination to investigate the vagaries of when and why events trigger. Thanks for...

I was hoping I could just reset the default value rather than having to respecify it, but thanks. My default values are kept in tables so its a pain.

I have some continuous forms for editing tables. They always open with only one record showing and I have to drag the bottom border down. How can I get them to open with a greater height so they show more records?

I have set a Default Value for a combo box. The user has made some other selection. Now I need to reset to the default value without specifying it again. How? As usual MS Access help is useless.

Specifically I need to know how to include multiple emails in the MYITEM.TO = assignment I know all about listboxes and recordsets. My emails are actually in a collection and I loop thru the collection.

Thanks, thats great but I need an example that sends emails to multiple addresses, do I just connect them with semi-colons?