Search results

You need someway to comunicate with Word from Access or someway to pass a parameter to Word. It looks like the string you are using to open and then print this Word document has a parameter in it called lpParameters. If that is the Command parameter that Word uses, then in VBA within Word you...

By the way, can you navigate through the entire list now, with showing the user the detail form for each item in the list box?

If you start at the first selected item, it's index number will be 0 (zero). Therefore, the next one will be 1, then 2, etc. Going backwards from where ever you are would be 3, then 2, etc. By keeping track of where you are within the list by using a Static variable in your navigation...

I just tried to explain it, but then I looked up ItemsSelected in Access help. I believe that will explain it to you quite well. There are two examples with the help text that I think you can find very useful too. If you have any more questions after working with the help examples, please ask...

Sorry I did not know the correct names of the properties and collection for the rows selected in a list or combo box. The collection for the rows selected is .ItemsSelected. Count is one of those properties. So you can go from ListBoxName.ItemsSelected(x) where x is from 0 to...

Make the "remarks" form a Popup form and Modal. Both of these properties will be in the Other tab for the form properties. The Modal will make the code stop running until after "remarks" is closed, or hidden.

If all you get are the selected records, then you should know where you have started. I'll assume at the first selected item in the list. That means you can go up or down the list by adding or subtracting 1 from where you are now. The bounderies would be 0 and .Selected.Count - 1. That way...

The condescension was not intended, sorry it sounded that way. I just wanted to explain that the DCount is the only way I know of to solve your request, except for the other ways that I believe would be a waste of time. And yes, it did sound to me that you were dismissing the DCount to find...

The only way I know of to change the size of a subform on a form is to resize the subform control using VBA. If you think there should be another way, keep looking. I have never seen another way, nor heard of any other way. In VB.net or VB 6.0, or if you want to find (I do not know of any) a...

In the total box put something like this: =Nz([Monday])+Nz([Tuesday])+Nz([Wednesday])... Change these days of the week to match the actual names of the fields you are using. Where the ... is, finish naming the fields you want added together. In case of Nulls in any of the fields, I would...

If you can't open a 2002 db, what version are you using? If you attached that zip file here, maybe someone could open that 2002 version and convert it to the version you are using. I have resized a subform control to fit the size of the main form as I have changed the size of the main form by...

Why can't you just use the SQL select statement the way it is as the RecordSource for the report? You don't have to make a recordset with ADO or DAO to see those same records. The SQL select statement should work fine as the actual RecordSource for the report.

Mark, here is an article that explains how to use an ADO, or DAO recordset with a form. I have not tried it, but I assume the same technique will work with a report. If you do try this, please post back and let us all know if it works or not. Thanks! http://support.microsoft.com/kb/281998

Is Memo the actual name of the field? With Memo being a field type, it is best to not use a reserved word for a field name. Can you rename the field to be more descriptive, which would also mean you were not using an Access reserved word for the field name?

Within Query2, add this field: DateAdded: Now() If you just want the date, then use Date() rather than Now If you want to write the date (or date and time) once at the top of where you will be adding the records from this query, then use this: .Range("A" & lngWhichLineToStart) = Now() Of course...

Have you looked at the table itself to see what is out there? I'm assuming that the old way has actually changed all your data to 2.00. If so, you will have to rekey it unless you have a backup somewhere.

May I suggest you run the function from the AfterUpdate property rather than the lost focus property. I would think you do not want any calculations done to the existing field unless you have entered some data.

I would suggest using a Label for each thing you want to allow the user to jump to. Then, in the OnClick event of that label, you would use code like this:MySelectedControlName.SetFocusThat's going to be a lot of coding if you have a lot of controls, which it sounds like you have. To make your...

When you are summing the values in your query (this would be easier if you and also included the SQL from one of your queries), use the Nz() function to return a zero if a null is found. Lookup Nz in Access help for more info. In the query Field row, use PrixTotalddpew: Nz([PrixTotalddpew] if...

Guus2005, I think one of my posts got lost out here somewhere too. So here it what I think I said, plus a little research results too. There is no need to use Call, but sometimes I do, sometimes I don't. If you use Call, you must put the parameters inside parens "()", if you don't use Call...