When I run a macro I get "Action Failed" Error 2950. The macro has one RunCode statement which runs a function. This public function runs fine if I execute it within the module. Also a similar...
What can cause a 3043 error (Disk or Network Error)?
I am getting the 3043 error in an Access application on same workstation where other Access applications keep running. If the network t...
Although I'm not done writing this code, I'm stuck on something I'm sure is an easy fix for some:
Does anyone understand how to incorporate the VB/VBA WithEvents declaration e.g. Private Wi...
I need some help in converting SQL code to MS Access please. The code came from an Expert who is helping with a project. He thought I was using SQL when I am using MS Access. Here is the code...
This has been driving me nuts. I know it is possible but apparentlly beyond my meager abilities.
I'm trying to construct a basic "LMS" database.
Basic table structure:
tblCourse (txtPartNum...
I'm pretty novice at the inner working of Access and sadly our in-house guru is away on a well deserved holiday so I was hoping someone may be able to help me,
I've been tasked with getting...
I have a table which does not contain a date field other than the year. It contains Dollars for each month in columns for each product number in rows (.xls table_example attached). I need a qu...
I have a Report, which I can base on a query or on a table, it does not matter which. If, in the report, I group on any field, the text in the text box that draws from a memo field truncates ...
I am consistently getting the above error when I try to open a recordset based on a query that has criteria that is supplied by fields on the form I use to run the code.
In the code below,...
Hello,
I have an MS access form where I am trying to put a validation rule on a text box and need some help with the syntax to get my expected results.
The form is bound to a table that ...
I have a bunch of individual Excel files. They are all contained in the same folder. Each one only has a few records. They all have the same format (data in the first 5 columns only). I'm look...
Hi,
I am a beginner in Microsoft Access 2007 and currently designing a relational database for my retail business. I have already made TOrders and TTransactions. I have 2 forms, which are ...
I have the following code:
Public Function Sendemails()
Dim strEmail As String
Dim strMsg As String
Dim oLook As Object
Dim oMail As Object
Dim rs As DAO.Recordset
Dim strSql As Strin...
Not sure why I can't get this to work and I thought I had accomplished this in the past, but I'm failing miserably at the moment. All I'm trying to do is Subtract one Date/Time field from ano...
Using an access 2007 database. There is a field 'contact' that has hundreds of names in it. There are many formats:
Mr. FirstName LastName
Mrs. FirstName LastName
FirstName LastName
Firs...
I need to change the code below from DOA to use a ADODB Recordset. I know how to open a ADODB recordset but the current code sets a Recordset filte and applies it.
How would I do this in A...
I'm trying to update data in my AS400 from odbc. I have a program that worked before and did updates in the AS400, and now i can't make it work. I also tried other updates via a test program, ...
I have two tables in MS Access 2003 SP2. The first table contains a large list of stocks and the price on a predetermined date (for example, June 1, 2000). The second table has stock, date, an...
I have a database that stores project information and does reporting. Because different groups need to maintain and enter their separate statuses for the same project, it is divided in a Proje...
How can I set the value for a field when user is adding a new record in MS Access?
The default value is the last value that the user entered not just simply a constant.
I tried the Control...
I have a database with a single table in it. This table contains historical ratings for military units, typically one record per unit per month. I need to produce a report that includes the ...
i am using the code listed below that i found on this website.It works fine except when i tried to set the range i keep getting a type mismatch.I am trying to do this from within ms access.
...
Hi there,
I been looking for a free utility that allows me to extract OLE Objects from my access database but i'm running into a problem. When the OLE Objects appear on my database as MSpHOT...
I have tested and had the code working on MS Word to find and replace text but now I am modifying it for Access side control of Word. I basically want to run it all from Access since there are...
Hello,
I have a form that users enter data into the text boxes then click the cmd button to run the query.
I am looking to have a user select: Yes / No on a drop down box. Once they do ...
