Search:

In the form properties in design view go to the data tab and change the allow additions to no.

If you look at the properties and methods of the listbox object in the online help you should be able to figure this out. Specifically look at the ItmesSelected collection and the ItemData property....

You will need to build a criteria string or where clause for your report while looping through the items selected collection of your listbox. At the end you should have something that resembles...

What if you create a new db in 2000 and link to oracle tables and update them. Does it happen then?

I've updated 97 db's to xp but not with links to oracle but sql server. I would recommend getting the latest odbc drivers for oracle and try deleting and recreating the links to the oracle tables.

You might also try specifying the recordset type such as dbopendynaset. This has solved some of my error messages when I've upgraded from 97 to XP.

A lot depends on what you intend to do with the data once it is in the db. I used Access 2.0 with tables consisting of record counts in the 100,000's. But all I did was simple reporting and...

In a private message you wrote:

"I have one question how do i get a running tally of my Inventory. I have the number for example one item 3, 9, -3. How do I get the totals for that item to come...

Instead of 3 tables I would use 1 or 2 and use some columns to specify the types of transactions. This way you could set rules that a to stocj transaction uses positive number for a to stock...

In your query, change the join between the tables from an equi-join to right join - all records from accounts table and only those that match from transactions. You should then get records returned....

Yes, performance was improved with SQL server. I'm still monitoring it though and am currently researching replication.

I'm not sure about your first question. I'll see if I can find out though.

In which row of the query grid are you referencing the combobox? It should go in the criteria row under the department code column.

Here's a couple of links that hopefully will help.

KB

Experts

You can try and use the attached code if you know what length the result string should be. Usage is as follows:

varString = PadZero("StringToBePadded",10)

where 10 is the length of the result...

Are the front ends located on workstations or servers? Make sure your tables have good indexes. Also, when returning recordsets, try and limit the number of records being returned with criteria. This...

I'm assuming you are referring to the handlebuttonclick function in the switchboard forms module. This is a custom function that carries out instructions based upon the button on the form that was...

If mailto: is always at the beginning of the field you can use the mid function in an expression in a calculated field in a query to isolate the name. Then just concatenate a comma. Something like
...

If you want this function to be used in more than one situation you will need to pass values to the function when calling it. This means you will need to have one or more arguments in the function...

Just to add my 2 cents to the 6 cents that has already been offered, most likely the data type mismatch error occurred in the code behind the button in the where condition argument of the OpenReport...

Go to tools/options/keyboard tab. You can set the enter field behavior to go to end of field. This is a global setting so I'm not sure if this suits your needs. The only other thing I can think of is...

I believe you need to employ the orderby and orderbyon properties of the report to affect the sort order of a report.

Thanks Allan!

I've got something similar to the first example. The problem I'm having now is setting who the emails come from. We've created a specific mailbox for this operation and I'm now...

I don't know if that would help. What makes you think it is the listboxes that are slowing down the opening of the form? Do you have a lot of code in the form's module? I've read that heavy forms can...

No, I get no error message. The memo is created with the addressee, subject line and the report in HTML format nicely pasted into the body of the memo. But then it just sits there and isn't sent...

I'm trying to send reports in a batch process through Lotus Notes using the SendObject command. Everything works fine except that it doesn't send the email even though I have the EditMessage argument...