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 Rhinorhino 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: *

  • Users: blackduck
  • Content: Threads
  • Order by date
  1. blackduck

    Excel Transform data for database import

    Sorry I'm unable to explain, so therefore it is hard to search. Here is an example of what I have and what I want it to look like. This will be over hundreds of records. What the data is: Code Bore (mm) Bush (mm) Diameter (mm) Diameter (in) Kerf (mm) Rake RPM Teeth Tooth Grind TP2102540 25 16...
  2. blackduck

    Pro-rata monthly budget by week

    I need to pro-rata a monthly budget so that a greater proportion is allocated to beginning of month. They want it to be: working days 1-5 = 40% of total budget 6-10 = 30% 10-15 = 20% 15+ = 10% There is a table currently in the system called x_workdates...
  3. blackduck

    Payroll rates change

    I am after a bit of help with how to develop a database with expected change in $ Rate mid way through. Basically the budget and course/staff/duty, goes over a semester - approx six month period. These are the tables and attributes I have done so far: COURSE (tbl) STAFF (tbl) DUTY (tbl)...
  4. blackduck

    Form button and parameter to run update qry. Error 3061

    I have a button on a form that I want to run two Update queries from but am getting "Error: 3061 Too few parameters. Expected 1." Its driving me nuts, any help would be greatly appreciated. My code is: Private Sub cmdComplete_Click() If MsgBox("Are you sure?", vbYesNo) = vbYes Then 'Run...
  5. blackduck

    Access qry with subquery exp(sum(log(..)) to SQL qry

    I have a qry that gets the correct output result in Access, but it is way too big for it to process. As suggested I have been able to get it put on MS SQL Server 2008, but it wasn't successful. In summary, the subqry matches heaps of records, works out the product in groups, then the qry sums...
  6. blackduck

    Memory error, rows=millions, can Access do it?

    I have a query that will take about 10mins to run the first 100 TimeIDs but get a memory error if I try to run first 1000 (I actually need to run all 27,000 TimeIds). The subquery multiplies 12 probabilities together to get a product (there are 500,000 of these products for each TimeId). Then...
  7. blackduck

    Multiply rows

    Is there a way I can multiply each set of 12 data together eg. Prob for Match1 x Prob for Match2 x Prob Match3. PosID TimeID MatchID WinID Prob 1 1 1 1 0.521739130434782 1 1 2 1 0.419754953864771 1 1 ..etc 1 0.427902390929258 1 1 12 1...
  8. blackduck

    VBA code to export data with formatting and layout

    Access07 has wizard to export to excel, and you can check the box for "export data with formatting and layout" and this exports perfectly. But I need to be able to code it. Currently I can export using the following code: Private Sub cmdExcel_Click() 'Export query to excel...
  9. blackduck

    Option Group and Paramater on Form

    Have main form with subform. Main form has combo to filter by department. I want to also add an option group with three optins: (relating to the subform filter) * all records (ie no further filter) * field b checkbox ticked as being finished * field c checkbox ticked as being finished Have query...
  10. blackduck

    Show/Hide menus using code?

    Is there a way, using code, to show the menus. I have my own login security setup and have used the Tools>Startup> uncheck allow menus to hide the database window and other menus. (ps. I know shift bypass kills all of this - damn!). I have two buttons with the code below to show/hide the...
  11. blackduck

    Variable? to customise all reports with user's business name

    I want the user to be able to enter their own business name once when they get the database. Their name will then automatically appear on all of the reports without the user having to change each report. I feel this is probably an obvious one but just cant get it. Any ideas will be greatly...
  12. blackduck

    Macro or VB code - what is best practice

    I have just come across a sample database in office.microsoft called Issues Database. It contains a lot of macros. I havent used macros before, I usually use buttons from the control toolbox and then go into view code, with help from the wizard also. What is the 'best practice', or the 'for and...
  13. blackduck

    Composite key table to history table

    tbl DeptItem pk DeptId pk ItemId fk ScoreId tbl ScoreHistory pk ScoreId ?? DeptId ?? ItemId TimeStamp fk UserId I need to keep a history of all scores that a deptItem has. My problem is I cant seem to build a form to show what the lastest score is but add a new score. Is the structure...
  14. blackduck

    Sheet appears as Workbook - cant delete worksheet

    When in VBE, I have a worksheet that shows up like "ThisWorkbook" (as well as having the usual 'ThisWorkbook'). Does anyone know how I would have got this there, and how I can delete it? thanks hopefully
  15. blackduck

    Refer to named cell - excel thinks its a string of text

    How can I get excel to recognise that I want to refer to a defined name and not just the actual words? Example: A1 B1 C1 Chill =A1&C1 Out A200 is a cell named ChillOut and its contents are blabla. I want cell B1 to display blabla not the word chillout. I know...
  16. blackduck

    Excel Command buttons as placholder red X

    I have two workbooks that I have used ActiveX command buttons in. The worksheets work fine on the laptop but when its pluged into a projector all of the command buttons appear as the dreaded Red X placeholder or do not appear at all. If you click on the button placeholder the button does what it...
  17. blackduck

    Sort data in dynamic range by header double-click?

    Sort a data range by double-clicking header cell" FAQ707-4886. This code by VBAJedi is fantastic and has worked well in all of my other tables. I want to ignore blank rows when I sort by the No. field as there are no corresponding records in those rows yet. My worksheet is: D...
  18. blackduck

    copy worksheet values & picture to new workbook

    Can copy values and formats but get 'script out of range' error when I try to copy the picture (logo) across to the new workbook. Please help, its driving me nuts. This is my code: Private Sub cmdEmailVersion_Click() Dim Today, fname Application.ScreenUpdating = False 'copy to new...
  19. blackduck

    Revert to xlCalculationAutomatic before workbook closes

    Is there a way to set the calculation back to automatic when the user closes this workbook but so that the workbook doesn't recalculate again before it closes? I have the following code under ThisWorkbook: Private Sub Workbook_Open() Application.Calculation = xlCalculationManual...
  20. blackduck

    Copy command buttons or fixed worksheet header

    Is there a way to copy a set of command buttons inclucing their names, properties, and onclick code to other existing worksheets? There are 4 command buttons, 2 dropdown lists - on about 20 worksheets. Actually, they are just navigation buttons horizontally placed and the whole top quarter of...

Part and Inventory Search

Back
Top