Search results

Hi, I need to loop through a directory and import all the files with the response sheet of the excel file into a table in access. my sheet has a questionnaire and a response. When i try to simpley import the file, it imports the questionnaire sheet and gives me errors when I try to specify the...

Thanks. Turns out, that it was a text that was being forced to return a string, and i didn't have anything that had the value i was trying to type. Anne

Hello again, I am getting a type mismatch error. On my form, a combo box text box(enter new date) text box(enter description)---this is where the type mismatch error is occuring. here is the code. Private Sub Next_Week_Exit(Cancel As Integer) If IsNull([Next_Week]) Then Else n =...

Hi, I am trying to update a record set using a form to enter the new work week. The code is below. Please take a look and provide somefeed back as to what is wrong with this. <code> Private Sub Update_Click() Dim nd As Date Dim rd As String If Forms![Update].Form![Prev_Week] = "" Then...

Hi, I am trying to use a recordset vairable and find a record using the date parametr passed in from the from. It doesn't seem to like the & before the Forms command or after the enter sequence. Please help. Anne Here is the statement I am using. mytable.FindFirst "EMP = '" & mydata("EMP")...

Hi, I want to average all my employees reimbursibility ratios in my report. I am grouping by empployee. Is There any way that I can have a final average for all my employees in the report footer? I need to get this fininshed. Thanks. Anne

Hello, I have an average in an Employee Footer, and I want to use that value to calculate the overall average for the report, in the report footer. Is there any I can do this? Please help. Anne Johnson

It is a crosstab query.

I have a cross tab query that I want to export into a .Cvs file. I want to know how to do this with a macro. How can I tell access 97, to export this query to this file. Please help. Anne

I have a report that is based on a table, based on the results of the crosstab query. I have the column names that I need. I want to know how to sum the Values as they are grouped by the columns. Please Help. Anne

Hello, I am trying to convert an access2 database to an access97 database. The problem is we have a module that contains a lot of old vb code and I can't find a resource that will tell me what some of the ssytem coomand have been changed to. here are two for an example. Msg = "Processing ...

Bob, I think you also have to tell the SQL Select (field) From (table name). That might help some of you errors. Anne

I am wanting to import an append table qurey into VBAso that I can set the parameter without having to pass the parameter in the form. Is there a way to break up the query into smaller pieces to see it and be able to read it. Thanks. Anne

I am tsting a section on a form tosee if any of the fileds have ben changed using the dirty property. I want to know, is it possible to change a single predefiend field's data when anotehr field has been changed? Thanks. Anne