Recent content by dbalargin

Great! Thanks smiler44!! I'll try this and let you know.

I need to link or import an Excel file that is on a SharePoint site. When I use the "Import Excel Spreadsheet" wizard in Access and populate the path to the SharePoint file I get an error stating "Only XML files can be imported from an Internet address (http://, ftp://). Enter a path that points...

Are you receiving an error message?

I use datediff or datepart. I enter 3:30 pm 12:00 AM. With datediff I get -15. When I use datepart I get 15. What is going on?!?!?! :mad:

correction: IIf([monday_start]<[monday_end],Format(DatePart("h",[monday_end]-[monday_start])+DatePart("n",[monday_end]-[monday_start])/60,"#.00",0)

I am calculating the difference between 3:30 PM - 12:00 AM. This is a work shift and I need to know hours worked. Here is my statement: IIf([monday_start]<[monday_end],Format(DatePart("h",[monday_start]-[monday_end])+DatePart("n",[monday_start]-[monday_end])/60,"#.00",0) End result is 0...

I want to allow the user to make changes in one row of boxes and not in any other rows. How do I unlock one row of boxes without unlocking the other rows of boxes

I have a continuos form with 7 seven text boxes. The more records in the bound table, the more text boxes. How do I unlock only the 7 text boxes that is the "current record". I do not want the other boxes unlocked.

Brilliant Suggestion! Thanks!

I want to open a db holding the shift key. Here's the catch... I have the db automated to open by itself. I have other users, so when they open it, the autoexec macro runs. When I open it, I want to have access to the db window bypassing the autoexec macro.

Shift key problem: do a search for "shift key". you'll get a lot of examples

Mile-O-Phile...works like a charm. Thanks!

i am getting the same error as before. only the warning box is maximized

did you import the tables? the tables is where your largeness comes from sometimes.

I get an error that reads: The command line you used to start MS Access contains an option that MS Access doesn't recognize. Exit and restart MS Access using valid command-line options. I am using Access 97 if that makes a difference.