Top Solutions

I need a way to display the images that are stored in an ImageList on my form. The ImageList absolutely must be populated at run-time.

One of the ways I have tried to do this is to create an Image and ImageList control on the form and then in...

Hi All,

This should be an easy one, but I'm running out of time and need this asap.  I need to download the Microsoft Access ODBC Driver so that I can set up a User DSN that my Java programs can connect too.  I was shocked when I went into...

We have this old Access app that REQUIRES the 2003 runtime and doesn't run correctly under 2007.  The app can't be updated, either.  So, we need to find a download of the 2003 runtime.  Does anyone know where I can download an installer?  Is it...

In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I have entered the coding where username and password is entered into the login form that is then compared against those logins...

Hello.

I am using MS Access 2000 and after repairing an old database and  importing tables from another database (that users copied... and were inserting information), I wrote a few queries to insert any missing records from table B to table...

I am using access 97, I would like to be able to make use of a hash-function in my vba code. Does anyone have any examples?

Many thanks

Matt

Hi,

Can EE give me some examples?  Thanks

Using google maps with microsoft access. Anyone ever use this or understand this:

http://www.issociate.de/board/post/268098/Using_Google_Maps_In_MS_Access.html

I was good up until this point:

Save and close the new module naming it...

Hi

I need to find the value of an item selected in a list box. I can find the index of the item using the following code:

Private Sub Command335_Click()
    Dim frm As Form
    Dim ctl As ListBox
    Dim varItm As Variant
    Set frm =...

I've got the follow code working just fine as long as I'm just filling in one control on the webpage. My question is how would I revise the code below to fill in multiple web input controls plus how would I programmatically fire an on_click event...

Access neophyte here...in need of assistance.

I have two issues I think..

First off, I moved three access 2000 databases from one folder to another, then created shortcuts to the .MDB files on the users desktop.

When user opens...

I need to record Purchase Order line item quantities to 2 decimal places. In the past I've always used a double data type and forced rounding to 2 decimal places in my forms. I've been toying with the idea of changing the table column from a...

Recently I was looking for a way to eliminate the dependancy on the ocx file that provides the CommonDialog Control control in our Access Application.

I found on this site a possible solution in the FileDialog object.
Yes it required a...

The following VBA code creates a new field that is a counter for the number of times an ID appears in a table:

Modifications on the following "While" loop in VBA are appreciated:

Do While Not rs.EOF
    If Billing_ID = 0 Then rs.MoveFirst...

I'm missing something in my code... It is not looping further into subfolders (as the msgbox states).
Can you please advise what's missing?  Thanks!

Private Sub cmdEmailFolders2_Click()
'12/1/07 outlook folders button
Dim y As Integer
Dim...

I created SSIS packag from sql server 2008 64bit and source was access dataabse.  I successfully created ssis package and tested the connection on source and destination databases.  I imported the SSIS package onto Integration Serivice and i also...

Hello,

We have an SBS 2008 network where only Windows 7 and Vista clients get an error like the one in the attached image.

This has been happening ever since we migrated to SBS 2008 from 2003.

The following EE articles have been tried:...

I have some Canon PowerShot A470's in operation.  They cannot be set to act like a disk drive, and expose a drive letter in Windows Explorer.  Consequently, the filesystemobject cannot manipulate them in the least.  I have code that points to...

I  have an Access database (XP) from which I created several Crystal Reports (8.5) because Access would not handle all the fields required for the reports.

I tried using the Wizard only to find that it asked for a password.  My database has...

Hi,

I know that this has been asked before but I want some code to create an inputbox in MS Access that has a password character *  in it rather than displaying the text.

I know this is possible in MS Excel by creating a customer Inputbox...

Hi all!

I need to develop a payroll database using MSAccess but without VBA.

The database should let me enter employee details and time sheet info, and then calculate the amount due for each employee for a range of working days.  The...

Now that I'm upgraded to 64-bit, I need to update some of my Declare statements.
However, I am also going to make sure this is backward compatible so those still on the 32-bit systems can run it.  I think I can handle that part with the #IF...

This should be easy.  I'm trying to declare several global variables that will be available to every form in my database.   After searching the internet, and through trial and error, I am pretty sure that I need to declare the variables as Public...

Hello,
In VBA, if I want to base an If statement on two values equaling or not equaling each other, do I do it like this:

If([FORMS]![FORM1]![TEXT1] <> [FORMS]![FORM2]![TEXT2] ) Then
     'Do Something1
Else
     'Do Something2
End If
...

Hi

I have a simple Access form with a button that creates a new record.
There is however no btton to save the entries made to the table.
What VBA code would I use to commit the data to the table
and what measures would I need to stop the...

Hi. I have a button on a Access form which opens a folder in explorer using the following code:

Private Sub Command12_Click()
Dim ProjPath
ProjPath = "Z:\" & Me.PolicyNo.Value
Shell "C:\WINDOWS\explorer.exe """ & ProjPath & "",...

I've been trying to compose a VBA Select Statement in Code in Access 2007 without Success. I have been trying very simple queries and from all of online examples, It's always either complaining of a variable I have set incorrectly or something I...

Sorry in advance - this question is a bit vague and doesn't relate to a specific piece of code.

I often get confused with the use (in Access VBA) of Cancel and Undo. It seems in some situations when I set Cancel = True in a BeforeUpdate event...

I'm working with calendar data exported from Outlook.  For some reason, Outlook exports the data as text, not a date/time variable, so I need to convert the data to date/time before I can work with it.

I tried the following:

Private Sub...

This is a "Just For Fun" type of a database.  If it works, then I am sure it will be something that is very useful to my fellow co-workers.

At the Chemical Depot we work the Dupont Shift Work schedule with 4 crews (A, B, C, D)

             ...

Hello all,

I have a database in Access .mdb and would like to convert it to a .exe

1 possible way would be to use Office Developer but it seems like Microsoft has discontinued the product? I can't find it anywhere and even if i do, i'm not...

Hi all,

Normally I would consider putting this directly under the MS SQL category, but I'm pretty certain the problem I'm having lies with VBA/Access.

I am attempting to pass values from from as parameters to a stored procedure using the...

I have always in other versions of Microsoft Access 2007 used the Command Buttons to open other forms from the "main form."  While my buttons that are already on the main form open the new forms fine, I am having problems while creating a NEW...

I am creating a PDF from access 2007 using DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, strPath, , , , acExportQualityPrint

I am using microsofts office 2007 pdf generator and works fine.

However I have a report set up to print an...

Could this error mean that the user has never opened access before and therefore has not started a system.mdw file?  Please let me know.

Hi
I am trying to connect to a secured access 2010 database from C++ code using ADODB
Windows 7, C++ compiled using VS2010

Using the following connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data...

Hi Experts-- have a function that works great to create Outlook tasks from an Access app.  New requirement is to set the start date & reminder time for 2 weeks prior to the 'due date'.  Accomplished setting the start date very easily (see below)...

I have several excell document that have multiple users accessing them, some users can open an make changes while other are connected, and some only get read only. How can i fix it so that all user with can modilfy when multiple users are...

Help!  I’m new to Access 2010 and trying to create Ribbon Bars…
I can’t seem to “hide” the File portion of the Ribbon bar.  When I create the ribbon bar and put it on a form I still see the File tab and Save, Save Object As, Save Db As, Open,...

In Oracle, i can retrieve the row number of selected records by using rownum.

Example:
Select rownum, id, name from MyTable;

But how can i retrieve the row number of a record in Ms-Access (Equivalent to rownum in Oracle)??

Thanks

No success in getting Windows 7 to add Foxpro ODBC Driver v6.01 under Data Sources (ODBC)

Anyone have any ideas?

I need to know how to find and install Microsoft DAO 3.6 Object Library as it is required for a module I am working with.
Can someone please direct me. I am working in Access 2000.

Description of the issue
We have an issue in which end users cannot filter or sort Microsoft Access tables that are links to Oracle tables for which the schema+tablename exceeds 30 characters. When the end users attempt to sort tables with long...

Hello!

I need someone to help me with the code on how to open a file browser dialog box that can be used to select more than one ".xls" file. Similar to the one used in Outlook when selecting attachments that are more than one. I want to be...

This question has been asked here before , solution of which tells that if you go in "office button" and select "access options" then you can setup "startup form". I still dont know how. I am a biginner, please explain.

hey guys

basically i'm near completion of my project. its due in on thursday and i want to add a fgew "killer applications" (as i like to call them!) to the project - your know a few bells and stuff just to make the project look really fancy...

We have a database designed in Access 2003 and we are testing it in 2007.  None of the reports will open and we believe it's because of trusted locations.  So I tried to add the folder where the frontend is located and got the error below.

the...

I'm inserting a record in a MS-access database.   I'm doing it in the c# section of an asp.net site

I use this code:

cmd.Parameters.Add("@Myndatexti",OleDbType.Char, 50).Value = ((TextBox)(FormView1.FindControl("txtMyndaTexti"))).Text;
...

I feel silly even asking the question, but how do you hide and unhide forms from the user interface in Access 2007?  

In Access 2003 and earlier, when I had an open form I could go to Window --> Hide.  Or to unhide a form, Window --> Unhide......

Good Day,

I'm abit confused as to why i'm having this problem.

I recently installed Oracle_11g_R2_64bit_version_11.2.0.1.0 on a Windows 7 Ultimate OS. Now tried to connect MS Access 07 to the Oracle Database by doing the following:
a1)In...

Hey Experts!!

I'm not sure if it's even possible, but can I connect to a Microsoft Access 2003 DB through an iOS app? Or should I convert everything to MySQL?  The problem with converting is that they are so heavily invested into the MS Access...

One of my clients has his secretary work with an Access 2007 database to create billing reports.  The billing report is based on a query that searches for records based on a user-entered invoice number that is currently being entered by the...

To make a long story short, I had to reinstall an instance of SQL on our server. It is a Windows 2003 box running Microsoft SQL 2008. It has two instances on it. We have a mix of XP and Windows 7 machines.

I have an access program that uses...

When Compacting and Repairing Databases the error: "Selected collating sequence not supported with the specified file format" occurs. I have compacted and repaired the two databases previously with no problem. This phenomenon has just begun to...

I have set up RemoteApp (MS Access2007) to run via RDWeb via RD Gateway. Clients have connected with XP SP3.  
However, the connection from the remoteApp via RD Gateway takes 2 - 3 minutes even on a cable connection. I need to  make this...

I've been contracted to work on a large scale database for a local physicians pratice that meets at 4 locations. I'm looking for a sample healthcare employee Access Database, so that I can begin to look at the requirement relationships(their...

I have a split Access 2010 database that crashes any time I try to view or run the VBA code it contains. I've tried Compacting and Repairing both the front end and the back end, but that did not fix the problem. I can view the tables and open the...

When i try to import a spreadsheet in Microsoft Access, it gives me the Error "Error in Loading DLL". The title of the window is "Import Spreadsheet Wizard". I am able to import something from another access DB, just not from spreadsheets or the...

I want to drop a Foreign Key constraint in MS Access but if it doesn't exist I get an error (CHECK constraint 'FK_MemberFamily' does not exist.).  Fair enough.  Therefore I want to check if it exists before dropping it.  I can't work out the...

Sample Project ----some one who already has Forms,Switchboard,Reoirts,Query,tables
to have a idea

If you use SQL Server as DBMS it's easy to write queries like;
Select * from MyTable Where ID = @ID
from Visual Studio's query bulider when adding a query to a adapter of a table in a dataset.
But when using Access "@" symbol doesn't...

What is the best way to detect proxy settings using VBA?
1. direct (no proxy)
2. manual
3. auto proxy

I am using Microsoft SOAP Toolkit 3 (MSSOAP30.dll) to call a web service in Microsoft Access.  This works great when the user has direct...

Very long question, I apologize up front.
My company sells 3 types of a product.  Each type of product has several different specifications.  Each product is sold in various sizes, some types have only one, some types have as many as 5.  We have...

VBA seems to think in 'American' when dealing with dates. Is there any sort of a 'regional setting' to default to dd/mm/yyyy?
John

There are a few computers on this peer to peer network with Access db's on a NAS box.

All other clients (various OS, XP, Vista, x86, x64) access this file fine. Only the new Windows 7 Professional x64 system will not.  It will not access it...

I am creating a form that will allow users to view a summary of trading activity by month.  I created a query which takes the user input (year, sector, min trade size) and returns the sums grouped by months.  One problem that I encountered is...

I am trying to open an access database from a networked drive and I recieve the message, "Microsoft Access cannot open this file. This file is located outside your intranet or on an unrestricted site. Microsoft Access will not open the file due...

Hi,

Im not sure really where in my code this occurs but for some reason my access app has gone crazy!

A double click event that opens up a form comes back with the error

Runtime Error 3024 Could not find file 'C:\Documents and...

I am a rookie at databases.
I am trying to make a hit counter that totals hits by the hour. My tabe has a time column. Would it be better to add a total column that displays totals of hits per hour or just open the db and have code total by the...

hi,

  I need to convert .mdb file to .odb file .Using OpenOffice,Ms access tables are getting imported.But Forms couldn't able to import from msaccess to openoffice.

help plz

I've a issue where the columns stores the date, starttime and end time in PST time zone. I want to add another column (computed if possible) and convert the date/time to IST. Is this possible? How can I do it?

I am accessing an excel sheet through VBA I want to set the focus to a specific sheet in the excel workbook.  Everything works except for the fact that if the workbook opens to a different sheet than what I am looking for I get an error.  It...

We have a memo field that serves as a scratchboard-type of notes field.  Several command buttons allow users to enter common phrases to the memo field by just clicking on them.
Example:
Me.reqnotes_memo = Me.reqnotes_memo & "  " & vbCrLf & date...

I have a number pad on screen using VBA Access 2003 with  Sql Server
I click one of the buttons and a number appears in the text box.Hit a button again and the next number appends to the first and so on.  This works with no problem.

The...

I have a listbox that displays results of a query.
The first description field can be lengthy and I want to show at least two or more lines.
I searched for code to increase the width of the list box row and found the code below.
When I run it...

I know how to do a single-line comment in VBA:

'This is a comment

Usually when I do multiple lines I just begin each line with a single quote:

'This is comment line 1
'This is comment line 2
'...
'Comment N...


Is there a...

I am unable to view a .snp file created with Access 2010 using OutputTo method. The error "An error occurred while opening a Snapshot File' with Snapshot Viewer. We are converting to 2010 and have many DB's using .snp files and would like to...

hOW DO I TELL A FIELD IN THE QUERY TO EITHER
SELECT FIELDS THAT CONTAIN A VALUE "CALL ME"
OR BEGINS WITH A VALUE "CALL ME"
THERE WILL ME MULTIPLE VALUES IN THE FIELD TO SELECT SUCH AS
"CALL ME"
"MAIL ME"
"EMAIL ME"
I WANT TO SELECT ALL...

This should be a no-brainer ... but I've been looking online for quite a while.
Can't seem to find sample code or even reference docs for how to use the Crystal  activeX Report Viewer control  11.5 from VB within access.    From earlier versions...

This has been asked a few times and I've seen no generic solutions so here is a function to retrieve and display the row number in a query:

Function GetRowNum(strQueryName As String, strIDField As String, varID As Variant) As Long
Dim rst As...

I have a .dbf file that was exported from a third party program.  I cannot import it into access 2007.  It imports fine into access 2003.  I can open excel 2007 and do a file open and select dbase .dbf file type and it imports fine into excel.  I...

I am trying to convert a date (in milliseconds) to Date Time format from 1/1/1970

I am already able to convert the current date/time into milliseconds using this code (snippet):


But I can't do the opposite!  Can someone help with this?

Is there a way to use the "Best Fit" option to format font size in an Access Report? I know it can be used in Excel. I have some long text and some shorter, and when I put them all in a columnar layout, I have to shrink the font size down to 7 so...

    Dim ImportTbl
    Set ImportTbl= CreateObject("MSComDlg.CommonDialog")

on the "Set ImportTbl= CreateObject("MSComDlg.CommonDialog")"  line it gives an error stating:

Run-time error '429':

ActiveX component can't create object
...

Hello!

I'm trying to determine the feasiblitly of processing a SQL Server table through MS Access, and for each SQL Server record, converting a BLOB field in the record to an individual JPG file in Windows.  For example, if 10 SQL Server...

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, our setup is like this...We have a call-center where...

I am trying to translate the follwing SQL code to MS Access.  I've tried the switch statement and I've tried writing a module, but I can't seem to get anything to work.

    Sum(CASE
        WHEN TABLE1.VAR1<'30' AND TABLE2.VAR2>0 THEN...

I have a Access 2k F/E app that's been around for a while (2000 in fact).  To date the client has run it on several Windows/Office combinations by using the 2000 DB Format.

Office 2000/Windows XP
Office 2003/Windows XP
Office 2007/Vista ...

Hi
When I try to start MS Access 2007 on a XP computer I get the message
"Can't find language DLL MSAIN.DLL" and access fails to start.
I can open MS Access before my udpate to MS Access 2007 (I was using MS Access 2003).
Would anyone provide...

The file ACWZUSRT.MDT is located in the same folder as System.mdw, and I believe it is created automatically by Access. What is it's purpose and when does Access create/ revise/delete this file?

I use the TransferSpreadsheet method to export Access data to an Excel Template file (.xlt) worksheet called 'DataSheet': Cmd.TransferSpreadsheet acExport, , "qry1ForTandI_FormExportToExcel", strFile, True, "DataSheet"  The Excel Template already...

I have upgraded our Windows 2000 Terminal Server to Windows Server 2008 with Terminal Server role added.  In the 2000 environment, users logged into the server and on their 2000 desktop was an Access shortcut to a frontend file that was linked to...

Shouldn't this make the report close after it is printed?

    DoCmd.OpenReport stDocName
    DoCmd.PrintOut , , , , 1, True
    DoCmd.Close , stDocName, acSaveNo

It does not work, I have to manually close the report

HELP

Hello Sirs,

I get the following error message when I try to open an access database from a VB6.0 application running under windows 98

"Provider Cannot Be Found, It May Not Be Properly Installed"

The VB6.0 application uses ADO to access...

I need to remove leading zeroes from the following types of text strings.  I'm looking for the shortest, fastest way of converting this field.  I'll be using setvalue to post these to another text field.  The initial field's character count can...

I have an MS Access database that works fine on Windows XP using Office 2003 but on two Windows 7 Pro PC's (one 64-bit and one 32-bit) running Office 2010 (32-bit) it intermittently hangs during compact/repair. The same problem can also occur...

Hi everybody,

that might be a newbie question but I am simply not able to
find the solution ...

What I want to do is to create a piece of VBA code which
uses GetObject to start and instanciate an OLE Object. The
Object pointer I want then to...

Hi, I have a following scenario -- I need to open Excel from Access database, load particular add-in (Reuters add-in, called PowerPlus), open particular worksheet, wait until data on worksheet is updated (from Reuters) and some calculations is...