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

    ActiveX component can't create object

    ...within it: Public Function FindImport() As String Set ObjFSO = CreateObject("UserAccounts.CommonDialog") ObjFSO.Filter = "VBScripts|*.vbs|Text Documents|*.txt|All Files|*.*" ObjFSO.FilterIndex = 3 ObjFSO.InitialDir = "C:\2010 USDA\Scanning Data\" InitFSO =...
  2. dbanker

    Retain value of variables after module closes

    Mr Hookom That did the trick thank you sooooo much. Iv'e been pulling my hair out for the last few days trying to get over this hump. Thanks again and thanks to everyone that gave suggestions.
  3. dbanker

    Retain value of variables after module closes

    I just took a much closer look at the code from the example fneily suggested and it looks like it will only total for one idName and value. If I'm wrong let me know. I have at the moment 12 different idNames I have to total hrs for and that will vary according to the number of employees we have...
  4. dbanker

    Retain value of variables after module closes

    I had previously researched fneily's suggestion earlier when dhookem suggested using a field in the source query to calculate the running sum. I thought it would be perfect for what I was trying to do but when I tried running the code I got a "Run time error 3061 Too few parameters. Expected 2"...
  5. dbanker

    Retain value of variables after module closes

    DHookem Could you give me an example of how to calulate the results in the record source query?
  6. dbanker

    Retain value of variables after module closes

    Putting the data in a table might work, not sure if it would be more work than just setting the variables to hold values after the sub ends. Tried using the running sum properties but the report is grouped on the DayWorked to show who worked each day and I need the hours they worked to date for...
  7. dbanker

    Retain value of variables after module closes

    I am making a report that displays employee's hours and want a field in the details that also displays each employee's hours to date. I think I solved it by writing code in a module. This module is called from the On Print event of the details section of the report. Here is some of the code in...
  8. dbanker

    Create a Running sum in detail of report

    It looks like DSum function is exactly what I'm looking for I just need to get the Syntax right on it. Thanks a lot.
  9. dbanker

    Create a Running sum in detail of report

    Okay, I have two tables. EmployeeInformation which contains fields EmployeeNum (Auto), LastName, FirstName, Active (True/False), and EmployeeHours which has TransactionNum,(auto), EmployeeID (tables are joined on EmployeeNum & EmployeeID) TransactionDate, and HoursWorked. The source for the...
  10. dbanker

    Create a Running sum in detail of report

    Okay, sorry I didn't tell you everything I've already tried and the results, so here it goes. As I mentioned before I tried the sum properties set Over Group, I also tried grouping by the employee's last name with a sum textbox located in the group footer. Here is the problem with that. The...
  11. dbanker

    Create a Running sum in detail of report

    Yes I tried that but it totals the hours of all employees together for each day. I need each individual's hours totaled as each day progresses.
  12. dbanker

    Create a Running sum in detail of report

    I am trying to create a report that displays employees hours grouped by the day they work and would like to have a field that shows their accumulated time beside their hours for each day. Anybody's help would be deeply appreciated. Thanks
  13. dbanker

    Open Database & Run Macro from Current Database

    I am trying to write code that will open a database and run a macro from the database I currently have open. Here is the code I have written: Dim db As DAO.Database DoCmd.RunMacro "AppliQueryAll" Set db = OpenDatabase("C:/2008 USDA/2008PSU/Arcview/ArcviewInfo.mdb")...
  14. dbanker

    Need to Calculate a field in a table using other fields in same table

    Thanks I'm sure I can get that code to work. I just couldn't remember the "edit" and proper syntax for navigating through the records. To answer you MajP, it is a long story but I'm using the data in that table in a Sequential Connect with ArcView GIS software and it needs to be saved in the...
  15. dbanker

    Need to Calculate a field in a table using other fields in same table

    I have a table that has three fields in it. Two have data and one is empty. I want to write a procedure to calculate a value and enter it in the empty field using values located within the same record in the other two fields, and would like to do this for every record in the table. Does anyone...
  16. dbanker

    Entering multiple lines of data in a text field

    I discovered the "Enter Key Behavior" property and found out it worked and was just coming back to let anyone else know it works but looks like RoyVidar and PHV beat me to it. Thanks though everyone.
  17. dbanker

    Entering multiple lines of data in a text field

    Thanks for the suggestions everyone. They do work both when transferring data in the variables and when I personally use Ctrl + enter while the field has focus. But I would also like to have my users not have to use Ctrl + enter but just press enter (only while that field has focus).
  18. dbanker

    Entering multiple lines of data in a text field

    I have a text field on a form that will be used to record special notes for a project. The field size is set to 250 characters. When someone enters the field I want them to be able to type in data and then start another line of data in the same field. Right now when you enter the field, after...
  19. dbanker

    How to write an Append Single Record SQL in VBA

    I'm familiar with Microsoft Access, so using it all you have to do is use query wizard to create a query connected to any table ( it will change when the SQL statement is run) and then save it as any name you desire. If you are using a different database engine that may be made differently.
  20. dbanker

    How to write an Append Single Record SQL in VBA

    try this First create a generic query and save it as any name you wish 'Define the varibles being used Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String Set db = CurrentDb Set qdf = db.QueryDefs("Name of generic query") StrSQL = "INSERT INTO Financial Data (Financial ID)...

Part and Inventory Search

Back
Top