Message box from Visual Basic code includes the control box "X" so that uses can close the box without selecting "OK".
How do I remove or disable the "X"?
I have other pop-up boxes using "O...
I'm currently using Access 2003, and the problem that I'm running into is that when I attempt to use the autoupdate command in the code snippet below, my subform says its 'Filtered', but nothi...
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...
Hey All,
I am going to be running a simple DB in runtime mode so the user won't have access to the toolbar, therefore I need to create a button so they can sort by certain fields...
I wa...
Hi:
I have a form that I've converted over to HTML, but now some of the commands don't work bcs its obviously in a differnt language (originally done in VBA through Access).
The code that ...
I have a continuous form where there is a combobox in the header that contains only SS#'s. The continuous form has the data record for all SS#'s.
Whe I select a SS# in the combobox, I want...
I have created a Pivot Table in MS Access 2007, it looks wonderful apart from the Totals in the Column and Row fields (I cant get rid of the word TOTALS). I can get rid of the data by clicking...
Would somebody be able to point me in the right direction?
I am in need of gabbing a vbcode to do the following:
I need to filter a listbox that will be contained in a form, over a ton o...
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 ...
Have the following VBA, built from the wizards. Can I easily add a message box to indicate when input is not found. Thank you
Private Sub Combo32_AfterUpdate()
' Find the record that...
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...
I am trying to develop an interface for Access where Engineers can enter test data. They are currently using an Excel version that is very cumbersome and non-standardized. This makes it impo...
Hi,
I have a table, "Websites", that has two text fields: "DisplayName" and "URL". I want to use this table as the source for a combo box (i.e. Select DisplayName, URL from Websites) that w...
Using MS Access 2007 as a front end to tables in SQL Server Express
In a previous question I asked how I could allow users to work on a list of records without the underlying tables being u...
I would like to assure that the user enters a date more than 30 days in the past and is a valid date format.
<=Date()-30 works to prevent dates more recent than the past 30 days.
What is...
I am trying to multiply the two fields:
Private Sub gw2_AfterUpdate()
Me.gk2 = gw2 * 0.454 & "kgs."
Me.gw2 = gw2 & " " & "lbs."
End Sub
Shouldn't this work?
I have an access database that is used as a front end for a SQL database. Part of its function is to store CVs in the database and I have a function that allows the user to view the stored Wor...
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 contain...
I am currently trying to alter my database to represent data better...
What I have currently got is a technical database with various tabs with client information. One of these is a broadb...
I am attempting to create a switchboard in Access 2003.
This is what I have done so far:
I have manually created a table [ObjectList] in my Access database which includes a column for Obje...
OK so I'm obviously making a very basic error here - but all I want to do is programmatically add some controls (such as a cmd button) is response to a user click.
So searching around, the ...
If I bind the results of a query to a form. (Data Sheet View). How do I then allow the user to change field contents?
Hi everyone,
I have a number of combo boxes on a form. When select there is a textbox for each one that grabs the column(2) value.
How do I sum these textboxes?
Thanks
Jetera!
I have a form with a subform in data view (Access 2002). The user can apply filters on the subform to get a subset of the data. Now I would like to allow the user to export this subset to Exce...
Simple question: On a form in Access, I update the value of field 2 from an AfterUpdate event on field 1. How do I get the contents of field 2 to automatically display on the screen. At the mo...
