Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. holgi123

    Confine Activex button in Excel

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

    Confine Activex button in Excel

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

    Syntax Problem with Variable

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

    Syntax Problem with Variable

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

    Syntax Problem with Variable

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

    Syntax Problem with Variable

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

    Syntax Problem with Variable

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

    Syntax Problem with Variable

    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 =...
  9. holgi123

    Syntax Problem with Variable

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

    Syntax Problem with Variable

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

    delete space in field names

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

    Internal Audit hammering me! Help!

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

    Internal Audit hammering me! Help!

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

    Internal Audit hammering me! Help!

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

    Counting and Running Sum

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

    Counting and Running Sum

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

    Counting and Running Sum

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

    Sum sickdays based on form entries

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

    Sum sickdays based on form entries

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

    change table reference in qrydef

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

Part and Inventory Search

Back
Top