Hello,
Is there a way of changing VB code so that ONLYif a statement is true then the command runs.
This is what I currently have:
If Me.chkDoorChoice = True And Me.cboFrontDoorType = "N/A" Or Me.cboFrontDoorColour = "N/A" Or Me.cboRearDoorType = "N/A" Or Me.cboRearDoorColour = "N/A" Or...
I have a main form with customer information on it. Id, Name, Address etc and 4 buttons to take me to other forms such as Works Needed, Therapist Info etc.
What I want is the four extra forms information to link to the ID on the main form so when I change record on the main form all the other...
My form has just started to add new records when I use the mouse scroller. Before when I used the scroller it would stop at my last inputted record. Any ideas what I've done to it or how it can be stopped?
Morning folks,
Todays problem is as follows!...
Is there away to set the values in a combo box depending on what option button you have selected.
What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another...
Hi people of the Access world. Wondered if you could help me once again.
I have set up a form to calculate a number of combo boxes where the option is selected to "Y".
There is a bit of code where it is not working properly. I will post the code where I think the problem lies but if you need...
Think I've seen this posted on here recently but cant find it.
Is there a way to hide the database window so that only a form is visible?
Then if you need to view the database window you can press F11 to make it appear?
Hi there guys,
I have set up a form that is going to be used as a survey.
I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each.
Is there away to calculate a total score?
for example if all questions were answered...
Is it possible to do something along the line of:-
if [combo box(1)] = "Y"
and if [combo box(2)] = "Y"
and if [combo box(3)] = "Y"
then
[Total] = "100"
Not sure if you can do it this way but im sure you guys will know a way round it!
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End...
Hi peeps,
I am encountering a few problems when I'm using the options button on a form.
Is there a way for the options button to display a different value instead of a -1 when the data is transfered to a linked table? i.e Good or Poor or Fair?
Also can a number of option buttons have the same...
Hi people i once again need your help!
What I would like is for a combo box to disable if a certain vaule is entered into another combo box.
I have a combo box [FrontDoorType] and when the vaule is N/A or blank then the [FrontDoorColour] combo box is disabled.
Have tried using the conditional...
Is there a way where you can send the data on a form to a detination table without closing the form?????
It's probably the easiest solution but it's 4pm and nearly home time so a memory blank is upon me!
Hi Guys,
Does anybody know the formula for validating a date in a DOB field.
I want it to only allow dates where the age is at least 18years old.
Something like '<Date()-18' (But a formula that works!)
Thanks in advance!
Hi guys,
Still trying to get used to this Access lark.
A table contains a column with numbers i.e - 1,1,3,4,2,2,2,3,4,4
If i just want a query that shows one of each i.e - 1,2,3,4
what do i need in the criteria line?
Thanks in advance
Hi there,
I have 4 fields in a table(Call_Freq, Call_Week, Call_Day, Call_Sequence)
I have to make a query that finds records with Null values in these fields.
If they are all null that is fine so I only want to return records with either one, two or three of the columns with Null values...
Changing the text colour on reports
I have a report in Accessrun against a query.
In the report I want each line that starts with 'F' to be returned as coloured RED and I want all others return as GREY.
Is there a way of doing this through Access functions or do I have to use some VB code...
When I run a report I created, a VB error box appears stating: -
'Error Accessing File. Network connection maybe have been lost.'
Any idea what this means and how it can be fixed?
I need a query that will return values of a customer number that have been created within the last week.
There is a customer_code field and a date_created field.
Any help would be appreciated.