Search results

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.

this is normal. The "temp" tables have not been opened in the new database yet. Once you open the new database, you will see the change in size.

How do I open a second database from a procedure in a first?

I have a report with a text box for each day of the week in the detail section. I only want one box to be displayed at a time depending on the day of the week. When the report is opened, a parameter pops up for each day that is blank (6 days). I do not want the parameter requests to pop up. What...

How do I delete records in a table that is in another database? This database is located on a different drive. It is accessed across a company network.

I import from info from table Clerical Queue. Once the info in table Clerical Queue is processed, I send this info to another table Archive. The next time I import info into table Clerical Queue, I do not want the info that was previously imported and processed, that is now in table Archive to...