Search results

Thanks Pat, Based on your reply I played with a simplified report and learned a great deal. The results were not good for the typical sales orders, invoices, POs, etc. These are examples of when bill-to and ship-to fields are side-by-side. This pretty much negates the can-grow/can-shrink...

Hi, It's time for me to understand how these two properties really work. First off, I have never seen "Can Shrink" work, but I have seen "Can Grow" work. What I usually do to get around this is to set both of these properties to true and then make the text box as short as possible. The...

I'm using Dim db as DAO.Database

Thanks Mile-O-Phile, DAO 3.6 is checked and is above ADO in the references list. I had checked this before and it was set up. But it still didn't work. Any other ideas? Thanks again, Mike

Hi, I just ran a complex app through the upsizing wizard. I discovered that the DAO code that used to work in Access as an mdb doesn't work in Access as an ADP. I hope I don't have to go around and modify this code to use ADO. If this is needed, why didn't the wizard do it? Any ideas? Mike

I must have been spaced out. I was just not typing in the code correctly. I was typing "Me.ControlTipText" instead of "Me.Control.ControlTipText". I didn't realize it until after I created this topic. Sorry! Mike

Hi, Anyone know how to set a control's tool tip property using VB code? I'm finding Access help to be not very helpful on this topic. Thanks, Mike

Hi, Thanks for the suggestions. I looked into directormac's suggestion and used the following code, which worked: DoCmd.GoToRecord , , acLast I have to say that this is not very intuitive. It's the same kind of situation when you want to close a form. These should be methods of the form...

Hi, How do I open a form using code so that it comes up on the last record of its record source? Thanks, Mike

Use the form wizard to make a tabular form for the table.

You put it the Control Source to be found in the data tab of the textbox properties.

Hi, Has anyone developed a way to manually search and replace carriage return/linefeed combinations from a field in a table? Sometimes, when importing data from another database where users pressed the enter key a lot, a square appears. Access does not seem to respond to it except by showing...

Are you using an "=" sign as below? =Me.[Subform Control Name].[Subform Field] Remember you must use the name of the subform control, which the container for the subform, and not the subform itself.

Try adding a footer to the subform. Add a textbox to it and make it equal to the sum of the fields you want. On the main form add another textbox and make it equal to the subform's suming text box as suggested by RobinL.

Hi Sharad, Just do a SetWarnings = False before the append query. Run the query. Then do a SetWarnings = True. However, don't do this initially so that you can see if you may have problem with the records you are appending. When SetWarnings = False and the record to be appended violates...

Pono1 and IMO, Thanks for all your help. I opened an empty database for test purposes and found that the code I was using worked with the same paths. This result suggested that there may be some corruption where I had the code. Because moving the file was a small part of a large function...

Would you please provide a little more detail so I can give you a focussed answer.

Hi Pono1, Yes, I do have full permissions on the source folder. In fact I am able to manually cut and past from the source folder to the destination folder. Thanks, Mike

Normalize your database. Each table should define one thing and only one thing.

Hi, We have just migrated our Access 2002 accounting application to Windows 2000 Terminal Services. We have about 12 clients connected and using the program. It seems to be working OK except for a few nasty little glitches - unexpected errors. Everyone is using the same front end. We have...