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

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

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

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

Hello all, Everytime i try to write an event procedure in the NotInList property of a combo box when I test it I get this error msg: "The Expression On Not In List you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was...

I need help I'm trying to insert a row into a table using data from variables with values from an excel sheet. the problem I'm having is that the table I'm inserting them into has an Auto_increment field and I can't get the code right for it to work. Here is a sample of what I have: Code '...

I need help I'm trying to insert a row into a table using data from variables with values from an excel sheet. the problem I'm having is that the table I'm inserting them into has an Auto_increment field and I can't get the code right for it to work. Here is a sample of what I have: Code '...

Hello all, I am writing code that opens an Excel file from Access and places previously acquired data into certain fields of the Excel sheet. It works fine the first time it is run but if you run it again without first closing Access then reopening it Excel is visible but not the workbook. The...