Search results for query: *

Skip/Andy, Thanks for your help. Andy, you were spot on. I found a line farther down in my code that executed the autofit and thus overwrote my static column widths. Feelin' pretty sheepish right now! Skip, even though I ended up not needing it this time, that FAQ is extremely useful, so...

Hi Skip, Thanks for your reply. I did as you suggested, but it still does nothing. Here is what I have written: With ExcelWkb.Sheets("Sheet1").Range("A:A") .EntireColumn.ColumnWidth = 35 End With What I don't understand, is why all of the other formatting seems to work. In...

Hello, I have an Access VBA module that outputs the results of a query to an Excel 2007 spreadsheet. I have written the code to format the cells as needed, and everything seems to work except for one thing: for some reason, it just ignores the code I have written for setting column width...

Ok, I found the answer. Basically, what it came down to was that Windows 7 stores the msador15.dll file in the 32-bit system folder. Here is the default path: C:\Program Files (x86)\Common Files\System\ado\msador15.dll Note that it is located in "Program Files (x86)", rather than in the...

Hi everyone, I have an Access 2007 database that has been working perfectly - until now. I was provided with a new computer at work, and now whenever I try to open the database, I get the following error: "Your Microsoft Office Access database or project contains a missing or broken reference...

Worked perfectly. Thanks!

Hi everyone, I have an Email field in my table that I converted from a Hyperlink field into a text field, and now all of the email addresses are concatenated with "#mailto:[the person's email address]". I need to delete everything from "#mailto" to the end of the string. I could go through...

Well, sure enough, the problem lies with the Approve-It add-in. We disabled it on my co-worker's computer, and the procedure now works perfectly. Go figure. We both had the same add-in installed, but for some reason it was only an issue on his machine. Oh well. Thanks, gkoliver, for your...

bubba100, I have not tried that. I don't think the file name is the issue, because it actually opens the file (he sees it on his screen), but then gives the error before any of the cells are populated with the export information.

Skip, The user clicks a "Browse" button and then selects a file in the file dialog that appears. txt_Select_File is the text box that receives the pathname of the selected file, so it should be accurate every time.

gkoliver, Thanks for your response. We actually went through and compared which add-ins he had on his system with the ones I had on mine,and they match up. We both have the ApproveIt add-in, but it doesn't seem to be causing any issues on my computer. Maybe I will have him disable it...

Hi everyone, I have a procedure in my database that exports some information from Access 2007 into an Excel spreadsheet. The procedure works perfectly whenever I run it on my computer, but when one of my co-workers tries to run the same procedure on his computer, he gets a "Method 'Open' of...

Also, just so you know, it exported the results as the number, and not as the formula.

jges, that worked like a charm. Thank you! And thanks to all of you for your help!

Thanks for your responses. I am fine with storing the durations as seconds in the database. My question is, what is the best way to convert the duration from the date/time h:mm:ss format that the spreadsheet uses into the whole number format that I need in order to store the data as seconds in...

The Excel data is stored in cells that are formatted with a custom number format code of [h]:mm:ss. If I change the format to Number, it simply changes to 0. However, if I change the format to Time, it displays it as a time of the day. For instance, if it shows the duration as 0:04:37, when I...

I know it has a date/time data type. But is there a way to import the data in the h:mm:ss format? Every time I have tried, Access has converted it to a time of the day.

Hi, I need to import duration data (i.e. duration of a media file) from an excel spreadsheet into an Access database. The duration values in the spreadsheet are stored in the h:mm:ss format. Since Access does not have a duration data type, what is the best way to do this? Thanks!

Your assumption was correct. I just checked the recordsource for the main form, and it had a SELECT query that joined the two tables. I changed it so that the recordsource for the main form is just the T_People table, and now it works perfectly. Thank you for your quick response!

I know this is probably a really dumb question with a really easy answer, but I can't figure it out. I have a form that displays information about people in the database. The form has a subform that displays a person's test scores, date they took the test, etc. The main form references the...