Search results for query: *

Hi there, I have a button on an Excel spreadsheet with some VBA code. On click it changes the location as well as the caption. I have tried many ways to limit the movement of the button after the click event to a certain range, i.e. "D5:G10" but so far not successful. Could someone may be...

Hi there, I have the following problem which I do not get to work: I need to calculate commission and I dim a variable which I want to set to a table column, however this does not work. BUT the entire calculation works, if I declare the variable but do not reference a table column but rather a...

Hi Everyone, is there a way to a) programatically delete [blank] within field names for tables, i.e. convert tbl1.[Field Name 1] to tbl1.[FieldName1]. I might have to do this for several tables and heap of fields. Secondly is there a way to programatically change my forms and queries. I tried...

Hi there, not yet desperate but in huge help. We made an aquisition and got a bad legacy system :-) I got out of a legacy system a file which I got into Access and it looks like this: Col1 Col2 Col3 Col4 Col5 Col6 1 05.05.04 $20 2 03.07.05 $30 3 PCN007...

Hi Everyone, I would like to get some help on the following question. I have a report which is structured as follows: =============== 2003 2004 2005 State A Rep1 $ 100 $ 35 Rep2 $ 15 $ 25...

Hi there, any help on this would be very much appreciated. I have a report for performance where I need to calculate networkingdays. I was able to get grossworkingsdays and holidays per user (grouping). The report is generated after I enter a timeframe on a form, i.e. 01/01/2006 until...

Hi there, I'm working on a problem that I do not get solved and would appreciate some help. I posted in a previous thread but maybe I did not outline correctly enough. I create a query which calculates commission rates for sales reps. Some are under a new plan and some are under an old plan...

Hi everyone, in a previous thread I posted a question about changing a table reference within a CreateQueryDef code. I managed to do so by defining various string variables and than include an Iif-Clause within the CreateQueryDef which defines which str variable to pull. Now I get an error...

Hi there, I would like to get some help on the following problem: I have some code that allows an administrator to calculate commission. She selects the month and the system does the rest. So far so good. Now they changed the commission plan and I have 2 tables with 2 rate structures -...

Hi Everyone, I keep track of campaigns(C1, C2, C3) in a a dbase and I want to retrieve the last contact date for telemarketing agents. My structure (only partially dispayed) is like this: C1FirstContactDate, C1SecondContactDate, C1ThirdContactDate 10/11/2005 12/11/2005...

Hi everyone, I would like to get some help on the following problem: I have a report based on a query, which basically works fine. At the end I want to show number of sales packages by type, like this: # of Package A: 10 # of Package B: 34 .... .... .... So far I do this by creating...

Hi everyone, I have Telemarketing team working from a Fe and BE database. Besides following up existing records they come across the situation where our call centre gives them new inbound leads. If they make a sales, they enter the record. So far they used a fake ID "99999" they constantly...

Hi everyone, I'm really desperate as I do not get something working. I have a multi-user environment, where employees perform Telemarketing and try and close orders over the phone. I want to create a PDF file, store it on the server, than pick it up as an attachment into Lotus Notes. The file...

Hi everyone, I would like to ask for help on the following issue: I have a multiuser environment and use a form to perform Telemarketing Calls. When the agents want to submit a quote I want a PDF created, than copy it into an archive and generate a lotus email, with the order/quote form...

Hi there, I would appreciate it if someone could help me out here, I'm almost desperate :-) I have a multi select listbox with three columns: PCN Description Price 111 Ink 50 222 Label 60 333 Case 120 I...