Search results

Close the main form. Edit the sub form directly and make the background transparant. Then edit the main form, select the group inwhich the sub form resides, (detail) and change that background also. I haven't tested this, but if both places are transparant, is should work.

I wanted to say that once a user clicks on a button, they have updated the text box from which they are coming. Access will not allow the focus to leave a box unless the rules for that box are satisfied and the update was sucessful. Therefore, if you can click on a button, you have updated the...

How does delay1 get updated? There is something else going on here. My suggestion would be to go the the properties of the form and locate the event "OnCurrent" This kicks off when you move to another record. Put your code updating delay2 in there. Then watch delay1 and see, not just how it is...

You can build a form in landscape and get about 22 inches out of it. The horizontal scroll bar is on the form. So if the graph is twenty inches wide and the form is only eight inches wide, displaying eight inches of the graph, as you move left or right you will see the other sections of the graph.

Remember, each box has many options, the value, the back color, the column, etc and you need to assign the list box number to the specifice characteristic. Try this: cboContactInfoType.value = ListBoxOfficeContactInfo.column(3) to get the box to display that record, enter...

Yeah, I am surprised, I really do not understand the concept of precision. To get this to work I have changed my data types for large numbers to double and that seems to work. Decimal also worked, but I went with double. Thanks for the feedback.

When I enter a number equal to or over ten million, the last two values get rounded and I don't want them to be. My field is setup as a single, standard, two decimals. When I tested it I typed in 123456789, what I got was 123,456,800.00 enter 9999999 get 9,999,999.00 enter 10000199 get...

Try changing the varwhereclause to the entire criteria, bracket the stuff and separate the strings so you can see if they evaluate to what you expect. Do you know that you can stop the execution by clicking in the left margin so you can see the string? varwhereclause = "([T_all].[Email]="" &...

Each day of the week is numbered, Sunday is one, Monday is two, etc. I would create a table with the employee ID and the five numbers that represent the days the guy works. So if a guy works Monday (2), Wednesday (4), and Friday (6) you have three records for him, his ID number and 2, ID, 4 and...

The process of opening a browser in google maps at the selected address worked fine until I got to an address where someone had included an ampersand in the middle of the street address. Example: SE Corner Hwy 79 & Butterfield Ranch Road Path: http://maps.google.com/maps?q= Address: SE Corner...

At the risk of sounding crass, have you tried doing this in Outlook? Why in a database?

Dave, I lost track of you. You should post these new questions as a new thread, don't continue the old one, they get buried and lost. Anyway, here is the code you are looking for. It is a bit advanced but I have confidence it you. Let me know which version of Access you are using, my code is for...

Hey Murph, I would make one other recommendation. When dealing with dates, use dates. Your check box only allows for two years, this year and all years. What if I want 2009? I would get rid of the check box and use a combo with all the possible years. You can even add a line (All Years) to the...

Repent, You might be over cooking this with a sub query and all the criteria. Your observation that you need more queries would be my recommendation. Create a sum query on the tblProductionNumbers table and make sure you include the primary key field, tblProductionNumbers.ProductID. Then create...

Hey, thanks for the background. If you are moving this data from a locked database to a new, better normalized one, then I am guessing this is probably a one time activity. Creating a whole bunch of code will take more time than its worth. You might save some time by just using an append query...

Louisa, Access is an event driven database, so something has to happen as the database opens to cause a date check. There is an option to have a form open when the database opens, you could put the code there. Many people have a "Main Menu" that opens first so you can hide the code there, in the...

Orshims, Well, I still don't understand why it would be such a bad thing if the empty fields were displayed on the report, but it is your report, so here is your answer. In the report you need to set the shrink property of the fields in question to Yes. Then you need to set the shrink property...

Student, Just a guess here, but the DAO was for Access 2002 and earlier, ADO afterward, unless the references were specifically changed back to DAO. Try switching that and make sure the commands "execute" and "close" work in ADO. Change the ADO first, then delete the word "execute" and the...

Matthew, Your original post was " how to go about merging the data for each name into one record" and the suggestions I gave you should have worked. Telling me it didn't and going hmm, does not help. What exactly did not work? Did you get a list of all invoice numbers in one table? Would you be...

Mioshy, I have run into the same issue with crosstab queries and my solution was a bit extreme, but I could not think of another way. I created a temporary table where I put, (in your case) the DonerDetailsID and their names, with a current year donations field CYD, a prior year one PYD1 field...