Search results

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

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

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.

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

I have about 50 variables to insert into a table. My code looks like: docmd.runsql "INSERT INTO ..." Problem - I need to continue the line at a variable. What do I do?

How do I trim the first two letters off of a string in a query? ex. Iif(isnumeric(fdrid),fdrid,I need the trimed word here)

I have a text file that I am tring to import. I have used the spec, fixed width, delimited width, and everything I can find. The Information that imports to the table is out of range. ie, two fields are populated, three are blank, one is populated.... etc. What do I do?

I want to display a label or text box on the report header. This label or text box will have a different caption pending on which button the users clicks on a form. What can I do to make this happen? ex. if cmdBucket is clicked ... then report label reads "Bucket 2" if cmdTotal is clicked ...

I want to import a query using an autoexec macro from another datasbase. When I try to use the results of the query, I get an error saying cannot find "ID Table Tulsa". Is this cause the query needs to be ran first? I need to retrieve the results and use in a form. HELP!

I have a query with the fields: First_Name and Last_Name. I want to create a field that is made up of both fields and call it Name. Thus, Name = First_Name + Last_Name

I access application1 from application2 using this code. Dim Settlement As Object Set Settlement = GetObject("C:\Settlement3.mdb") Settlement.DoCmd.RunCommand acCmdAppMinimize DoCmd.Quit Application2 closes and application1 is now open. Problem...when I want to close application1, it...

I have a Form that opens on start up. The form imports from a text file and transfers info. I have a command button on the form when it is pressed... the form load procedure fires again and imports the info again. I do not want this to happen. Hwo can I prevent the form load from running when I...

I am attempting to kill a file. I first need to know if this file exists. If it doesn't, I get an error that says file not found. What can I do to see if the file exists before I try to kill it?