Search results

Hi I have some code that checks if a file exists, its file size, creation date and date modified. The code works fine..however.. I need to import the file it is checking and that file can sometimes take up to 30 minutes to complete its posting. In fact I used the code to check it the other day...

Hi I have been importing files for a good while using the import spec feature and the docmd.transfertext command in Access97. However, in all of these, the files I've been importing have all had fields in the first row. This new text file I'm importing doesn't and I don't know if that has...

I have some code that copies results of a query to excel then does some formatting. The formatting code works with the exception of one piece of the code. The piece that doesn't work (bolded below) is supposed to highlight from cells F1 to G1 and then select down to the last populated cell...

When I click on the tables tab and then right click in the white space and select IMPORT, I get the IMPORT dialog box as expected. Then if I select a file to import (I've tried using Excel and Text files of type) and then click the IMPORT button on the dialog box, the dialog box closes and at...

I have 2 functions, one figures out adding 6 months to a given date. The 6 months added is stored in the variable dt - which is a public variable in a module..however, this function returns a value of "Y" or "N". This function works fine.. I would, however, like to see this date in my query...

The following formula returns -1 for all valid date values that are appended together from a string where the string field has 6 characters in it. However, it will not return 0 for all values that do not meet this criteria. It shows nothing in the field..(when I put my cursor in one of these...

Wanting to take a string month name and turn it into a valid month date format.. for example: fcn("January") = 1 Also, how do I change the value of the month, e.g. 1, back to January? for example, fcn(1) = "January" I know I could do a select case to do this the long way, but thought...

Was wanting some help on how to write code that will allow me to tell if a particular form is open so that if it is then I can do code as: if form is open then etc.. Thanks..

Would like to handle run time error 94 (Invalid Use of Null) in my code so that I can put my own msg in there so my users don't get the standard one mentioned. Any help as to how I refer to this error in error handling would be appreciated.. Note: Would like to place this in the 'On Error'...

Hello Trying to get rid of the Form View toolbar but only for a particular form. However, when I do so (by right clicking on the grey area next to my new custom menu bar and deselecting Form View), it applies to all my databases. I don't really have need of a replacement, custom toolbar...

USING: ACCESS 97 After messing with applying custom menu bar to a database and then it not working and (attempting?) changing it back to accepting the default menu, a number of my sub menu options that once appeared from the File Menu appear to have vanished. I know I can drag and drop them...

I'm using Access 97 and was trying to put a filter clause in a reports Filter property. I tried typing: ="PROD_TYPE = 'SEL'" and setting the Filter On property to Y. This didn't work. Help shows how to do this in visual basic, but doesn't show anything about how to use the Report's...

I have a report where I have employee name and address fields in the detail section grouped by the company they work for so that for each new company, there is a new set of names/addresses in the detail section with each new company forcing a new page. The company has a header with the Force New...

I have a report that is bound to a table with an ssn field in it (the ssn is captured as a string value). The report has the ssn field bound to a text box. I would like the text box back colour to turn red if the first 3 numbers of the ssn value is "999". The code I wrote is on the On...

I have a request to take a 5 page Word document and put this into an Access report that mirrors the Word document. However upon trying to add some controls that have verbiage (I have to split up the verbiage into paragraphs as they have it which requires multiple text boxes since there is...

Hi Looking for some help on some code that will kick out users after they have been in it for more than 30 minutes. Never dabbled in this stuff before, so not sure where to start. Any help is appreciated.. Thanks..

I'm using Access 97 and cannot find a PROPER function like in Excel. There appears to be only UCASE and LCASE functions. Does anyone have any suggestions on what I can use for a Proper Function? Thanks..

The error handle part of the code runs even though there is no error (I rem'd out the error handling to make sure there was no error)..Everything under: error_esc: runs. And, of course, since there's no error, the msgbox's that are supposed to show an error description are blank.. Is my syntax...

Hi I have some code that iterates through a query equal to the number of times that your data count is divided into intNbrRecs I was doing this so that I could automate the export of Access table data (with a count of more than excel can handle) into an excel spreadsheet over multiple...

The below code dumps data from one table into another using the query: qry_rpt_data_for_ct_prep_tbl as the intermediary to do so. It works, except that I wanted to restrict the data based on user selection for the time period. So, I put criteria in the query itself. But with this addition, it...