Search results for query: *

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...

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...

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...

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...

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!

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...

I am trying to import a column of data from an Excel file into an Access database table. The data I am trying to import is the last 4 digits of each employee's SSN. I have a column in an Excel spreadsheet that contains that information. Because the last 4 digits of some people's SSN start...

Hi, I "inherited" a database that our company has been using for several years to track all of our work flow, production, etc. The database includes contact information for all of the company's employees, past and present. However, most of the contact information is outdated, and I need to...