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 f...
I need to launch Excel from an Access form control and open a spreadsheet that has an Auto_Open macro attached to it without running the macro. I know I can do this by using the /safe command...
Not sure how to word this question but here it goes... I have a Master Inventory form with a Serial Number combobox (The serial number is also the primary key in the table). When I select th...
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 ...
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...
I have a MSAccess VBA application that is querying multiple Oracle tables. I need to allow the user the ability
to update records which are displayed in a continuous subform. I am able to...
Access 2003, this is an easy one for you guys but I haven't done this in years. I have a small Access database and I need all of the records locked unless an Edit CMD button is clicked. Can so...
I have a form with a various items on (comboboxes, textboxes etc).
I have set the tab order up so that the tab order goes from top to bottom of the form. On the form I have a combobox for ...
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 200...
Trying setup this filter on a form. I got this code from someone that was using an option group in a form to filter the data using a regular field. I am trying to setup the same type of filter...
I have an Access 2003 database form. In this form I have a subform. What I want to be able to do is when you click on a button in the subform it brings up a popup form to input information int...
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...
Hello,
I have a form (TestApptDis) which the OnOpen event triggers the RecordSource property
to find the table that equals Date() (the tables for this form are titled with dates).
The form ...
Hi -
I'm not so good with Access/VBA and need some help. I have a form that has a combo-box and a multi-select list box. I'd like the selected items on that combo box and list box to eac...
Hi guys.
Right i have a form with a tick box labelled [IN STOCK]
i also have a a field called [date packed]
using expression builder i would like to write an expression that when [in s...
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...
Hi i have a table called InvoicedCommDue and also have a form called InvoicedCommDue that displays certain fields from the table. Most of the table is populated from an append query but there...
I've been using this function for the longest time without any problems, only now has it been causing hiccups.
it works almost all of the time... the only time it doesn't work properly I've...
Hi Experts,
I have a calendar control I want to become visible when the date combo box is clicked. Below is what I have, nothing happens when I click the combo box. Thanks for your help. T...
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...
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 a form in MS Access 2003. On the form I have a combobox dropdown.
When the form moves to a new record, the query for the combobox list is automatically refreshed using a query 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...
1. I have a query that has parameters on two fields - one is on a company field and another on a date field. The parameter on the date field is as follows:
Between [Forms]
