Search results

Thanks, seems to have worked!

I have an update on my problem. It seems that if the first asterisk in an individual column occurs on or after the 10th row in my excel sheet then the import error is generated, and all subsequent asterisks in that column will also fail to convert. If, however, the first asterisk occurs before...

If "Machine1" is the name of a sheet in you excel file then you need to put an exclamation point at the end of the sheet name to import the entire sheet. (ex. "Machine1!") Hope this helps.

I am sure that you are correct about storing different types of data in the same field. However, I do not believe that I am doing such a thing. All of my data is the same, except for when there is missing data and an asteric appears. The reason that there are two different indicators is because...

I have numerous excel sheets that contain number data that I am trying to import into an access database. The excel files were originally in text form but I was able to convert them to excel worksheets through a number of procedures. I have excel files for each month. Each excel file has hourly...

I have a program that will search for files. I only want the 'FileSearch' command to return files that occur after a specified date that the user inputs. I use the 'PropertyTest.Add' method of the 'FileSearch' command and it works, but it takes way too long. In fact, it takes so long that I went...

I have a form that has a text box that contains a date. When I push the 'UpdateDate' button I would like to change the default value of the text box to the current date. This I can do, but the default value is not saved the next time I open the form. Rather, it resorts to the original default...

I believe the problem lies in where VB is looking for your macro. Most likely, the program is looking for the macro in what ever database the code is written in, rather than the one that is being opened. You may want to try and include a path in the macro name (not sure this is possible), or...

Here is my problem: I am using VB to import text files into an Access Database. This is done, but currently it will only do one file at a time. I am now trying to get my program to search for the files I am interested in and import them. This is simple enough and I have the code written to do...

For anyone that might have a similar problem: I was able to get around changing the close event for the datasheet view of the query by automatically creating a datasheet form, and then using the onclose event. My code follows. DoCmd.OpenQuery "QueryName" DoCmd.RunCommand...

I need to wait for the user to close the window:D

Close button The problem is that it is not a form that I want to close, but the datasheet view of a query.

:confused: Here is what I want to do: Be able to change the action of a particular button. I know that I can do this with the 'OnAction' method. In fact, I have changed what happens when the user selects 'Close' from the 'File' menu. However, since very few people would ever close a window that...