Search results for query: *

Thank You for your suggestion. However I could only find the Properties Tab on a Form Control and not an an ActiveX Control. Any other idea how to solve this? Thank You again for your help.

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...

TheAceMan1 & PHV, Thank You soooooooo much to both of you for helping me in getting this done. It finally works and calculates everything correctly. It will also help me in getting my code much shorter and less confusing. Again, thank you very much. Regards

Hi again, I do not know why but now it runs without an error, after I removed the [ braket, which is good. The problem is that it somehow does not update the table column. I run the function in the immediate window and it calculates correctly. I changed the table set-up so that it only deals...

Sorry TheAceMan1, false alarm. I still used the old backup database when I looked at the results and did not initially realised I did not test the code. When I run your code I get an eror message saying "Compile Error: External name not defined" and the code highlights the word...

TheAceMan1, OmG! Thank You so much for helping me on this. Yes it does work (...and I even deployed it already in another area, where I had a similar challange). Again, much appreciated your support on this. Cheers

Hi TheAceMan1, all fields are Data Type: Number Field size: Double Many thanks for youe further help on this, much appreciated. Cheers

Thank You so much for your help TheAceMan1! Luckily I started to redo the entire commission database last week only, so haven't yet used the table column a lot. Here are the new names: ================= strsratebelow60 = "tblServiceRates.Below60Rate" strsrate60to80 =...

Hi AceMan1, thank you for picking this thread up. Here is the SQL: ================== Set db = CurrentDb strsql = " SELECT tblmarketingfinal.*, " & strservice & " as ServicePay " into tblcommissionresult FROM tblmarketingfinal " With db Set qryNew = db.CreateQueryDef("QueryMaster", strsql) End...

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 Everyone, after having first an interim solution working and than got rjoubert approach working I now have several other files with the same problem. However, there is one big file, where the sequence in Col2 is different. This time the partnumber is the 1st row and than followed by the...

Hi Everyone, thank you to all who helped and got me some ideas. I could not solve the problem in Access but with the suggestions of using Excel to better prepare the data I finally got things in a workable shape and can now further use them. Thanks again for everybody's help. Much appreciated...

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...

Dhookon, you are correct, the closing parens was a typing mistake, as I did not paste the code. Apart from that the code seems to be correct. May be I explained things wrong. The report looks like: 2003 State A Rep1 Prod i $ 50 Prod ii $120...

Guys, THWatson and dhookom, thank you for your help. I got things working. I probably forgot to mention that each sales rep has also subgroups being the products he/she sold. The solution that finally worked was, that I put the following code into the unbound textbox's controlsource...

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 Lynchg, thank you for your suggestion. I got so far in another way. However, the problem is, that I need the results of these queries on a report, which is structured by Name. So I have a report which shows performance by Sales Rep and I need to display orders by net working days, something...

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 PHV, thank you for your suggestion, but unfortunately this did not solve my problem. The code runs without errors but it still does not pick the different tables names. May be it has to do with the fact that my SELECT statements in the CreateQueryDef - which are coded in the strnam, strnew...