Search results

The reason you are getting the Syntax Error is because the line: Forms("frmMainForm")("MembersSub").Form.Filter = [MemNumber] = '" & Me.MemNumber & "'" is in fact in Error and this is my fault. I give you my deepest apologies :o You do have the line right, it's just that it's missing a Quote...

As I mentioned, the Sample I returned to you in my previous post was based from a sample you had posted even earlier yet. I made the changes to the Sample DB an returned it. To me...the sample I returned appears to work fine unless there is something I missed. If it is working fine then I...

If you use a File Compression program like WinZIP or WinRAR then you can compress the Database file and it should be small enough to send. Do a Compact and Repair first. Access likes to bloat so badly even after running once. Start the DB while holding down the SHIFT KEY. Keep the SHIFT KEY...

Hmmm. I don't seem to have the problem you are experiencing. When I enter the value for Customer IC 2 and attempt to move focus off that control (to say, select the Submit button) a check is done on the remaining product data (dollar amount and transaction date). if they are empty for that...

Phil, just use apostrophes instead of all those quote marks: Forms("frmMainForm")("MembersSub").Form.Filter = [MemNumber] = '" & Me.MemNumber & "'" .

You can use this Function if you like which will change the properties of Table Fields (including he Description property). Place all the code below into a Database Code Module: Public Function SetTableFieldProperty(DBName As String, TableName As String, TableFieldName As String, _...

- Place the Main Form into Design View; - Select the Members tab on the Tab Control - Select the container that normally displays the Members Sub Form - In the MS-Access Menu bar select View | Properties. The Properties Window will open. - Select the Other tab located t the top of the...

To begin with you need to make sure that the Main Form name is frmMainForm The SubForm Control name is Members subform. The Table Field that hold the member Number is named MemNumber. You need to make sure the proper names are in in code. In my previous post....I assumed a lot of the names...

In your Summery Tab, if your first SubForm with the Query war built using the SubForm Wizard, a Form was automatically created and it would most likely be named: QryActiveAdInDebt subform The second SubForm within the Summery Tab looks like it was generated based from a Table named: Frozen...

Uhhhhh...I see. You have a back ground image. This is what I missed. I knew it had to be something. :D Nope....With a the Background image as soon as focus is applied to the Text Box the back color for the Details Section will be visible. My apologies. .

This is a lot easier to demonstrate than it is to explain. You want cascading Combo Boxes (search the Forum for that) and then Filter the SubForm based upon what is selected within those Combo Boxes (again - search the Forum for Filter Search). Post a sample DB with some fictitious data and...

Unless I have completely misunderstood what you want, the following code will make a specific Text Box appear fully Transparent even when Focus is applied to the Control. Without Focus there is no Vertical Scroll Bar until focus is applied. The Control is also automatically Locked so that...

Microsoft Explain the problem and solution Here. Hope it solves your problem. .

Within the second Form's Code Module under the OnClick event for the IDnumber Combo Box, you can use code like this to filter in the Reocrd(s) you want for further data entry: Me.Filter = "[IDnumberFieldInTable] = " & Me.IDnumber.Value 'If the IDnumber is String (contains non-numerical...

Your welcome. I Hope it helps somewhat. You'll notice that the Search Form and the Queries Entry Form (as you call it) are actually one Form. It's all a matter of displaying what and when. .

You are missing a End If statement: Private Sub Save_Click() Dim db As ADODB.Connection Dim rs As ADODB.Recordset Dim cno As Integer Dim X As Integer Forms("Reservation")!Rents.Enabled = True If (Forms("Reservation")!FirstNameField = Null) Or _...

Sorry for the delay...I have been quite busy. Off hand...real quick...Here is how I would just start it (see attached) at least for your particular application: .

Like This.... Public Sub CGDTest() Dim LowPct As Double, LowDeduct As Double LowPct = 15.9 LowDeduct = CalcLowDeduct(LowPct) <-- LowDeduct is a LOCAL variable '..................... '..................... 'The rest of your code that will use the LowDeduct variable. 'If...

The color you see for a disabled control is a Windows System Color. You can change that system color to whatever you like using Windows API functions but the change you make will apply to any Windows application that is opened thereafter. Not a good idea. .

How true that is Singh400....how true that is. It falls hand in hand with Users using the Eject tray of their CD or DVD player in their desktop computer as a coffee cup holder. :) .