Top Solutions

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 & "",...

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

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,
Having done many searches over the net, i believe my subject matter is pretty uncommon. However....

I am attempting to carry out RUMBA screen entry from the data within Access (screen scraping). Common actions that i would be performing...

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.

When I open a form and use this code it works fine when there are no values asigned to the field on the form and I can then add the values to the form. However when I open the form and Me.txtRiskRating has a value assigned I get the error above....

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

Hi,
 I have an access 2007 form containg drop downlist & inserting data for table.
how do I convert this form to web page

Thx

I am trying to create a Form using the Datasheet view were it will format each row depending on the value in on of the columns. I could use the Conditional Formatting feature within Access if I only had three types of formatting, unfortuantly I...

I have a Microsoft Access 2000 form that has an option group with radio buttons.  I just want a 'yes' or a 'no' answer and I want it to be mandatory.  So a checkbox won't work.  I have the option group set up and I have the default value set to...

I know what is going on here, I just wanted an explanation why?  I know the way it works is if a tab is clicked, the user has to actually click on the actual page, not just the tab, for the event to be fired.  Why has Microsoft done this?  This...

Hi guys

Problem:  Access 2007 does not appear to allow me to size forms in Form Design, so when I open a form modally it is those exact dimensions.

I have recently discovered Access 2007, and am trying to play with it / figure out if...

I haven't touched Access in a long time and need some direction for help. I am using Access 2007. Here is what I have.

TableA: Main Information
TabelB: Multiple entries that links to TableA

Example:

TableA: Key, Last, First.....etc...

I need to print a single page layout of an Access Form page for a client. He has An Access Database that includes the form for all his data items. He wishes to get the form formatted to print one form layout on a single page. Is this possible in...

Getting the following message when I open the database:

"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is deleted. ...... "

It only gives the option...

I'm using a split form in Access 2007 to display the results of a query. When I view the "Other" tab on the Property Sheet for a textbox on the form, there is a Datasheet Caption property... when I change it there, it works fine, but I want to be...

Hi all,

I'm using Access 2007 and I'm attempting to address an issue with a continuous form seemingly taking whatever height it feels like when I open it (and changes on different PCs).  I've found a tentative solution in VBA that works great...

I've tinkered around a while try to make Adobe PDF Reader work with Access. I added the reference from the following path:

C:\Program Files\Common Files\Adobe\Acrobat\ActiveX\AcroPDF.dll

Doing this allows me to drop an adobe control on the...

When I try to add the Microsoft ActiveX control - Common Dialog (Comdlg32.ocx) the message appears:
"You don't have the license required to use this ActiveX control"

I have registered the control and the message still appears.  
I have MS...

Hi there,

I'm very new to using MS Access, and am creating a report for a batch of employees - basically a form letter with employee-specific data.  In particular, I'd like to make a nice shaded 3D pie chart for some of the stats per employee....

I'm running Microsoft Access 2003 and I'm trying open up a form based on the selection in a subform which is based off of a query.  Ideally, when that record is selected(double clicked) I want it to open another form which uses the query output...

Capricorn1 helped me with this previously: I was trying to create a filtered table using multiple combo boxes and then exporting as a tab delimited file.

I thought this was working, and it does to an extent, but am now having a new problem....

*************
* Background *
*************

I need to store and update data in a load of global variables:
- When I load up forms I pre-populate the fields with this data.
- When controls are changed the global fields I update the globals
...

Hello

When I display a form and the fields are displayed as a datasheet if I click in the left most column it selects the entire row, I beleive this is called the record selector. I want to call the record selector function if the user clicks...

Please see link to view screencast.

Looking for better technigue to search contact records using a list box or a subform.  I need to click a record in list and have the form go to that record to show data for that contact.  I also need to...

Hi

How do you refer to a form if you have a string variable containing its name

    Dim fld As Field
Dim strForm as string
strForm = "Customer"
    For Each fld In Forms.strForm 'This line causes an error
       Debug.Print fld.Name
  ...

I have an Access database with a single table containing 13 fields. I need to design a form which will update its contents when the user changes on of the input fields.

The form will have seven items, ItemNumber, Name, MaufacturerName,...

Hi,
I would like to use the Smart tag in Access 2010. When I go to the ''properties'' I have the option to do that. But when I click on the ... to see the ''default Smart tag'' (like the default smart tag in Word 2007) my list is empty. Do you...

Hi,

I want to remove the appearance of the vertical gridlines in the Access 2007 listbox. It would appear from the property box that I should be able to do this by choosing either transparent on the gridline style property, or by making the...

I am not too familiar with design in Access 2007, but I would like to insert some shapes to use as a background in my form.  But all I can find in Access is a rectangle or a line.  I want a square that has rounded edges (see attached picture). ...

I need a column in Excel that shows every 2nd Monday of every month. Does anyone know of a quick way of doing this?

Hi Experts,

I have a situation where a cilent needs to print out a screen shot of the form.  She has reports, but there are times she wants to print the form.  I would like to do two things, (1) make the contents fit on one page (it is...

Hi Guys / Gals
I am designing some Access 2007 Forms and when the form creates it defaults to a graphic of a form at the top left, or report etc...
Where can I find some similar icon examples for forms like, Companies, Contacts, Appointments...

I use unbound forms to lookup records and it has worked well in Access 2003. I change the .recordsource on the subform  using a sql statement and then do a .form.requery.
This no longer works in Access 2007.
After trying many combinations of...

I am relatively new to using pivot charts.  I am creating a company performance presentation and I have found a lot of uses for the pivot charts.  One thing that I see as an option is to add a second vertical axis to the chart.  When I do this...

I am using Access 2007. I have an input form that collect SS#'s with an input mask and saves it in a text field. The contents of the text field is 123456789 for example.

The report field format property but does not have any syntax examples....

In the For VBA Statement below, you can count 1 to 10.
For I = 1 To 10
Next I

I wish to count from 10 to 9 using the for statement, is this possible.

I have been asked to create a project management database in Access.  My PC at home is running Access 2007, and one of the Microsoft Online Access  2007 Templates is called 'Tasks.accdb' and it is exactly what I need, since I don't have time to...

I made an ADP project in Access 2007 and I have a form that opens another form using the DoCmd.OpenForm command and it doesn't work in Access 2010.  It just hangs up the whole program and I have to kill it with task manager.  Can anyone help?...

I would like to FIND and OPEN a SPECIFIC PDF File within MS Access. My MSdatabase is over 17000 records with many fields (this is a law firm). We have PDF files related to each account contained within the database. Currently we have a large...

I use the above ocx frequently in my Access 2003/2007 applications to provide a file select box. Sometimes on certain clients' pc's I have to copy an ocx file to \windows\system32 and re-register it. This usually works fine.

I have just...

I have a seemingly simple question but I haven't been able to find any specific answers addressing it.  Having never taken any Access classes, I'm sure my code is not the prettiest.... but hey it works and it's been getting a good workout lately....

How can I (manually, in design view) associate a label control with a textbox control, so that (in design view) they both move together?

How do you remove null values from an access pivotchart?

the null values are currently showing up as zeros on the graph; I want the graph line to stop at the last true value

I do not want the 'null' values showing up on the chart as zeros
...

I am aware that MS has included a conditional formatting feature in morre recent versions of Access, including the version I am using, 2007.  

However, my client would like to simulate the highlighting of fields and rows they are currently ...

How Can I change the icon for a access application, but is not to change all access icon. is it possible to change or remove the Access Icon on the taskbar ?

Does anybody know how to install Access 2010 Runtime in silent mode with prompt for destination folder

I'm fairly new to coding in Access 2007 and have come across a problem regarding listboxes.  This new project that I'm working on is using an Access front-end to a SQL server back-end and all of the forms that reside within the Access DB are...

Hi,
When I entering new data to a new record in a text type field in Access 2007, what's the way of "auto-complete this field using previously entered values" ?
Thanks

I've been looking for this for some time and it must be my question language that's the problem.

How do I call a sub routine on a sub form from a master form?

I'd have thought that it'd be something like Me!SubForm.SubForm_Code.

Thanks.

Hi.  I thought this was easy to do, but I can’t seem to get it to work.

I have an access 2007 database tracking Maintenance History of various equipment.  It works fine, but data entry is a bit cumbersome.  Currently I have a button that just...

Hello,

I have a form and a subform. I would like to create a one-to-many relationship, however when I create a new record within the main form, my subform won't allow new data to be entered. I have attached my sample database (in access 2007)....

Hey All!

For some reason I cannot get CDO to resolve the Alias name in this VBA code. When I put the actual email adress in, it works wonderfully but I need to put the alias in and have it resolver. Any suggestions?

Thanks!

Hi,

I have an Access database, which has been running for a number of years.

The one form users run, which returns a number of rows of data suddenly started giving #deleted message as soon as a second user runs the same process.

So...

i would like to be able to change the ribbon using vba.

ie.

if user = frt then

me.ribbonname = "frtribbon"

elseif user = acc then

me.ribbonname = "accribbon"

else

me.ribbonname = "otherribbon"

end if

i'm hoping to use...

Hi Guys

I need to validate data entry in a form, let's said fieldNAme
I do not like Input Mask that much, >L????????, because it put those _ and if the user starts typing in the middle it will capture the blank spaces and the begining
Now i...

We have an access db that is growing. The issue we are having as we create more and more forms is a growing lag when switchin to design view on many forms. It also lags a lot when viewing the "Add Existing Fields" or sometimes after it updates...

Hi I am using the following code to add the table names of an Access database to a ComboBox
but for some reason the ComboBox remains empty
Private Sub Form_Load()
 
    Dim lTbl As Long
    Dim lFld As Long
    Dim dBase As Database
   ...

I have to prepare a form for inputiting a particular piece of information at various tables / fields. Previosely, I had used check boxes for multiple selection and thereafter retrieved the info through queries. Now I want to make a dynamic drop...

I need the code to create a login form that checks the user name and password against data stored in the database. Which gives it a set number and from the number it views data from a different set. I have about 20 different sets and they have 9 ...

When using MS Access 2007 - I have a form where users enter a date range

From: ______      to  ________  the textbox names are txtBeginning and txtEnding

In a query I use the criteria  below to return records between the dates in the...

I'm using ADP in access to sql server 2005, trying to get a button click event working. I think i'm missing a reference in the VB editor but i don't know which one. I'm getting this on any of my onclick button events: The Expression OnClick you...

hello,
opened ms Access (2000)
opened xl spreadsheet into Access ( as I wish the spreadsheet to become a database)
Cannot insert a new field in form view (no button or menu item to do this and
cannot insert a new column in list view (...

Hi All,
I am trying to run code that I have assigned to a button on an MSAccess form. The code creates an SQL statement which searches the database for an address. I want to run the code when the user clicks the button but also, when the user...

i have a form with a 2 date controle boxs, the user suppose to fill the first field with Gregorian Calendar date
and then i need to brows the Equivalent Hijri Calendar date beside it in the other date controle box.
how can i get the Equivalent...

I have an Access 2007 database and have a form with patient information. There is another table in the db that has the insured's information in it. What I want to do is if the information is the same as the patient is to hit a button to copy it...

I'm using MS Access VBA and would like to open a dialog open box, similar to MS Excel's "GetOpenFileName" function for the user to select a specific file.  I then would like to capture the complete path and store it in a local table.  My code is...

I am looking to add some help files to my access application in access 2007.

There seems the ability to refer to a help file in access - Help file on main form and a context help ID on objects on form.

Microsoft seem to recommend html help...

I have two fields which I want to combine the data into one (FirstName and Last Name) to create another combo box which lists all names called Full Name. Full Name will be bound to the Customer ID field which is a number. I have the query working...

I have a button on a form that will delete the current parent record via Me.RecordSet.Delete.  This parent form has 5 subforms.  Each subform is displaying a record associated with the parent record via referential integrity and "Cascade Delete...

Can someone please combine these 4 IF statement that i use currently in Access 2003 query window to one SINGLE  Iff statement please.

 IIf([16Feb_Jetbase_2_XCOLL]!EBK_MATURITY<#16/02/2009# And [16Feb_Jetbase_2_XCOLL]![Last Date...

Experts,

I am working on putting  a password on a form
      frmLCAmendHistory
I open this frmLCAmendHistory from another form called
      frmLetterOfCredit_Cont
frmLCAmendHistory has ONOPEN code to open
      frmPassword

I need the...

My MS Access 2003 application works fine using data tables linked on the string fields that are also displayed in Text, List, Combo boxes, etc.  I "normalized" the back end data files and now all the tables are linked using Integers Primary Keys...

So I am fairly new to Oracle Forms and am still having some issues. I am working on a form that someone did already, and the data block (let's call it A) has a execute_query in it's trigger when new form.  I need to add another data block to do...

I type the following line in access 2003
Dim fso As New FileSystemObject

it prompts me the error

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

User-defined type not defined...

I have an Access 2000 Report which displays data from MS SQL Tables based on a DATE Parameter entered into a form which appears when the end user runs the report from within Access.

What I need to do is to expand on this existing [or start...

I am trying to running the following code, to select the list box value where there is only one item in the list. However I keep getting the error "7777 You've used the ListIndex property incorrectly". I have observed the following points.

1....

Im having a problem with form filters in Access 2007.  Ill try to explain it clearly&

- I have a form called Contact General whose record source is the table Contacts.  

- On the form are two unbound controls, named FNameFilter and ...

Hi Boss,
I need to set Zoom View in a OLE Adobe PDF Reader object,
embedded in MSACCESS form.
How can I do it in VBA for MSAccess?
Or by registry?
Thanks,
Best Regards.

I have an Access frontend with a SQL Server 2008 backend.  The Server has a LiveSales database as well as TestSales database.
I would like to write code in Access that fills a label box on the main form with "TEST DATABASE" if the current...

HI Experts !

I don't know why, but I am trying to use a very simple method here called "select case" and for a reason I ignore, it simply doesnt want to return any value.
I am changing the value with a list box and based on the selection, I...

I am using Access 2003 and was using this code to cut mp3 files into smaller parts:



Private Sub cmdCut_Click()
Dim bytData() As Byte
bytData = ReadFile(App.Path & "\music.mp3", 1, 30000)
Call WriteFile(App.Path & "\1.mp3", bytData)...

Hopefully an easy one this, believe it or not I cannot find anything that gives the solution!

I have a VBA sub that will continually check something at set times, so needs to run forever, all I need is a line that will detect if the "q" key is...

I recently developed an Access database at my company with Access 2007. Developing the database and all of the forms, etc was problem free until I split my database. Since that point, problems. I keep the backend on a shared drive and everyone...

Hello,
I have database with 1 table-
When I am trying to import an excel sheet with new data -I recieve error 'can't overwrite table or query'.
can my problem be with database or the data I am trying to import in?
I follow this same process...

I'm using Access 2007, and the only VBA that I know is what I've picked up along the way..

Ok, on to the database. I have a fairly small database for entering/viewing employee training data, with a main form for actually entering the data (no...

Hi

I'm pulling my hair out on what I thought would be a simple problem:
- I have an Access DB with a form
- in the DB, I have a table with 2 fields: image name, image ( of type OLE object)
- I have manged, by using code found on the...

Experts,

I need to know if a form can be locked down to only allow one particular user modify the
 data?

Thank you  

I have a form with the RecordSet set to table with an autoincrement field, ID, as the primary index.  

I added an acCmdRecordsGoToNew command to the Form.open event.  The new record for this table doesn't seem to get created until I modify one...

VERY new to Access, so please use layman's terms and pretend I know nothing.

I have a table named ROLOG and a form named HISTORY. The form has three Text Boxes I would like to use as filters. The first being a Text Box for Date that I would...

I have got a list box with multiple select switched on, which is living on an access form and the code below works and can pick between the selected items and the not selected items,

but cannot figure out the syntax to display the item values...

Hi There
I'm a relative novice to VBA

I'm trying  to fill a list box, from a ODBC mysql db
I want to set the Rowsource to the query.
The Rowsourcetype is set to table/Query
I had it working just as intended , but then I added some extra...

Hi Experts,

I have a form frmA. In this form I prompt the user to enter a caseID that will match to myTable.caseID.
When I click on Enter botton on frmA, another form frmB will pop up with a textbox myTextbox
I want to set the default value...

I will like to create a table listing the ft and inches on one column, list the converted fraction in the next column and finally list the conversion in decimal places in the last column as shown below.

I need to have a list up to 30 feet in...

I am trying to transfer 3 access forms from one database to another; the transfer is to update the individual databases on 10 different laptops.  I am getting a '2135' error on the "count = 1" line and do not know why.  Any clues?
 

I have a form to allow users to easily find records.  When they find the record they need they click a command button which runs a macro and opens another forms and goes to a record to display all of the details.  What I would like to do is have...

EE Experts,

This seems like a stupid question but I have to ask it any way. How do I get my application in MS-Access 2007 to run in debug mode? When I am in the code editor and set a break point; I press F5 to execute in Debug or click on the...