Search results

Border Style is set to sizeable, and my buttons still don't show. By the way.....in my original post I meant to say that only my "Close" button appears. I'm missing both the min and max buttons. Any more suggestions??? Thanks!

O.K. My solution also worked for Access Runtime users. I just had to add one line of code to minimize the database window: DoCmd.SelectObject acForm, , True docmd.minimize DoCmd.OpenForm "frmCountryMaintain" I requery the combo box when exiting the maintenance form. Thanks for the help...

Thanks Mile-O-Phile, you are correct in that my main form opens with one filtered record that is fine. On this filtered record is a combo box (cboCountry). Let's say the user wants to modify the country field, but the combo box doesn't contain the new country. At this point, the user clicks...

Some more information that hopefully will help solve my problem: The form (containing the combo boxes with a command button next to each of them) actually opens up to 1 filtered record. So basically I am launching the combo box maintenance form from a button on a filtered form. Could this be...

I have a series of combo boxes on a form. Each combo box has a command button next to it, which allows the user to open a form which contains data in the combo boxes. E.g.: my combo box is cboCountry my country maintenance form is frmCountry I have added a find button on each of the combo box...

Make Min and Max buttons visible on Form I have a form that opens only with the Max button. I would like it to open with both the Min and the Max button. The form contains unbound fields only, which get populated with data and then save to the table. The property settings for the form seem to...

Well, I seem to have found away around my problem by using DateSerial to add 1 day to the Finish date. I would still like to know though, how I would do it using >= Here is how I made it work with DateSerial: If Not IsNull(txtStartDate) Then If Not strSQLFilter = "" Then...

Problem with Dates in SQL statement I have a button on a form, which has the following code behind it: If Not IsNull(txtStartDate) Then If Not strSQLFilter = "" Then strSQLFilter = strSQLFilter & " AND tblShipments.BLDate Between #" & cboStartDate & "# AND #" &...

Thank you for that link, Wayne. That looks like a good solution for my problem. Many thanks, BJS:D

I am modifying one of my reports. It contains fields subforms. Suddenly when trying to add more fields to the report, I get the following error message: "The control or subform control is too large for this location." "The number you entered for the Left, Top, Height or Width property is too...

Thanks to both of you, llkhoutx and SQL_Hell! I will have to say the records got corrupt. BJS.

Thank you for your reply, Nero. I am going to create a database that uses Outlook, and I look forward to trying out your suggestion. Thanks for that! The Groupwise class I am working with requires that you work with the array. The originator of the code, Dimitri Furman, has helped me with...

PLEASE HELP WITH MY E-MAIL PROBLEM!! Can anyone help with this. I am so frustrated, I can feel the tears starting to emerge!

Thanks Nero, but .Display does not work with Groupwise e-mail. Instead I have created an Access form that displays the To, Subject and Message fields. This way the user can make modifications before sending the e-mail. Now I have a new problem: The code uses an Array for the Recipients...

I will check on that tomorrow (don't have access to the db today). But I'm not sure how the format of the field can be an issue, since the values for the same fields appear fine for all the other unaffected records. ???

Thanks for that, but this is not the case. Widening the columns to fit the contents does not solve the problem. The # signs are also in every field for the two records affected. Also I am not able to search for the data that was contained in these fields. I know what the values were, and they...

Users of one of the Access 2000 databases that I support have encountered a problem: 2 records in the table have been overwritten with "###############" in each of the fields. Anyone know what causes this? I found an Article on the MS Knowledge Base (274211), it talks about multiple users...

Here is part of my code, in which I think my problem lies. The code is suppose to create a Groupwise e-mail message, which it does, but my problem is that it sends it right away. I would like it to only create the message and open it, not send it. Does anyone know what I need to add/modify...

Thanks Michael, I did try that, but it didn't work for me. BUT....I got it to read the e-mail recipients names from a table, and assigned those names to a variable. My program now works! It creates a single e-mail, with multiple recipients and attaches multiple documents. Here is my modified...

O.K....I found a sample database that attaches multiple documents to Groupwise e-mail. I've tested it, and that part works great. Now I have a problem getting more than one recipients name in the e-mail. The code uses an Array...I'm not too swift with those. Here is the code, maybe someone...