Search results for query: *

I created a database for a coworker that has the following code within it: Public Function FindImport() As String Set ObjFSO = CreateObject("UserAccounts.CommonDialog") ObjFSO.Filter = "VBScripts|*.vbs|Text Documents|*.txt|All Files|*.*" ObjFSO.FilterIndex = 3...

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.

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

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

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

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

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

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.

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

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

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.

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

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

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

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

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.

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

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

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.

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