I have excel document using a number of VBA macros. This particular file will not work on Sony Vaio desktop running windows vista. The file will not save or save as simply stating "excel can...
I'm getting:
"microsoft access cannot open this file. This file is located outside your intranet or on an untrusted site."
Sure enought, the file is out on a shared drive, but How do I make...
Hi,
We have an Access 2000 Db residing on WinXP running as a server and part of a Win2000 Server domain. We are getting the above intermittant error in Access. It seems to occur for ...
I'm a real newbie at this: trying to execute a stored procedure from VBA: I'm getting a 3146 run time error. Any help?
'This is the actual connection string for the SQL tables in my Ac...
I have a table Orders with columsn OrderID OrderDate OrderAmount
It has information of 15 years of orders in it.
I want to create a query that allows me to when I run it input the month ...
Hi,
I developed an application with access and when I tried to deploy the application with the access runtime it gives me the following error:
"Execution of this application has stopped du...
Hi All,
I want to be able to read a csv file using VBA inside the Access mdb that is attached and insert new data into the Company table from the csv file. The VBA should also be smart enou...
I would like to take all the values of one field and combine them with all the values in another fields into a third field in a Microsoft Access table:
Field 1 Field 2 F...
Does anyone know how to disable the Mouse Wheel scroll within an access form? I do not want it to cycle thru the records. Right now, I have a search form that searches based on an ID, but th...
I would like to create a database to keep track of daily attendance at my school. I invision a form with the weekdays as columns and the students names on each rows. For each day/student c...
Hi, I basically have a form with a combo box which when a record is selected the results are displayed in another subform. I've had success when I alter an old existing form but when i tried t...
We have an Access 2003 database that was originally a multi user database. Now it allows multiple users to open it, but only the first user has full rights the rest have RO.
What happened ...
Hi,
App:Access 2003, SQL Server 2000
I cant seem to figure out what im doing wrong.
Calling a stored procedure on MS SQL 2000 from Access I know its working cus part of the stored pro...
Hi,
I have two tables in MS Access 2003:
> tbl_project; and
> tbl_requirement.
tbl_project has fields "project_id" and "project_name"
tbl_requirement has fields "req_id", "project_i...
Using Access 2007, I tried to set up an import task to import a csv file that I will be receiving on a regular basis.
I attempted to define a field as date/time that has the format "2008/04...
I was just able to successfully add an appointment from access to outlook using the general instructions here:
http://www.access-programmers.co.uk/forums/showthread.php?t=31517
However, ...
I select to hide the Navigation Pane in Access 2007 via the Office Button > Access Options > Current Database > Uncheck Display Navigation Pane. When I restart Access with that database, the N...
I need to open an Excel Pivot table from Access and refresh on open via VBA code.
Here is my current code:
Function OpenExcelPivot()
On Error GoTo OpenExcelPivot_Err
Dim objExcel As E...
Hi everyone,
I would like to create a comment box in my form that can be edited before I run the invoice. Here is what I have done so far. Created the following table.
Record # Date Emp...
Hi,
I'm sure the answer to this question is somewhere in this database already, but I am having trouble finding it. I am new to stored procedures.
I created a stored procedure in SQL an...
I am trying to discern what the formula is to convert a hex # to a DateTime.
In a file I am trying to parse, the Hex Value is 992947609 and I know that it is equivalent to 05/07/2007 07:01 ...
I have a main form with two subforms. The first subform has the child link to the main form identity key.
subform1 - Master Field: SK
Child Field: TrainingMasterSK
...
I need a small calculator on my Access form that will allow me to enter an acreage number and return the square footage equivalent. Any ideas?
HI there;
I'm trying to delete all records from a SQL table (using Microsoft Access). I'm using the following code:
DoCmd.RunSQL ("Delete from tbTempSubscription")
This works fine in ...
I have a linked MySql table in my access database. The access database stores russian strings but it appears ok. I think it uses unicode to store them. However, the mysql database stores the d...
