Recent content by Tony1258

I am trying to get the following code eto look for a account number and if it is found update the value. I can get that to work but if the account is not found I want to force an account number and I cannot seem to get it to work. Any help would be appreciated. Tony intValue =...

I have two tables that I import that have both a date field and a time field formated as text. date field looks like yyyymmdd and time looks like hhmmss. I am using two append queries that combine the data into one table and I need the date and time fields to be date and time format...

Thanks for the reply I will give it a shot

I have a table that can contain from 1 to 60 date values. I need to write code that will sequentially step thru each date value in the table and use it as a input to multiple queries set up in a macro. Not sure how to write the code to step through each value and run the queries. Any help is...

I have a query that captures date values from a table based on a between function that works fine. What I would like to do is associate a sequence number fro each date value returned and either perform a make table or leave it as a select query. If I create a table I know that I aam able to...

For some reason I am getting the following error creating a mde file, This error is usually associated with compiling a large database into an MDE file.* Due to the method used to compile the database, a considerable number of TableID references are created for each table.* The Microsoft Jet...

I am trying to create a multiple IIF statement with IIF(ISNULL([xxx]) and an or and it does not work any help would be appreciated. See below IIf(IsNull([AI Rate]) or IIf([AI Rate]>0),0,1)

Have you tried using the sendobject within a macro to send the object. You could put a command button on the forma and have it execute the macro.

I currently have a form that has a pivot table on it and I would like to automatically export to a spreadsheet in a specific directory when the form opens. On the form is a comand to export the pivort table to excel. Has someone written any code that this can be incorporated into the on focus...

shades Thanks I found what you were identifying by adding a object on the spreadsheet . I was using the command button from the control tool box and it does not have that option available. Thanks for the help on this. Tony

I am putting the button on the spreadsheet. When I drag it to the spread sheet and right clicthere is no option for assign macro.

How do you refer to the macro in the command button code?

I have a macro that I created and I have copied the code from it to the code area for a command button and when I execute the command button it does not work but if I execute the macro it does. see the code for both below, I receive the error Selected method of range class failed Macro...

What we have done is use a macro scheduler program in which I open the specific database and run the macro to update reports. Within the macro there are various output steps that send reports to excel, word , snapshot type files on my lan and we use another datanbase set up as a front end to...

I need to out put a query to excel into a specific sheet. Can someone tell me what the format of the output would look like. c:\DIRECTORY\SUB-DIRECTORY\FILE.xls How is the sheet specified? Thanks for the help in advance