Search results

The coding works great. But I have just noticed that if I close the database, and then open it again, the control is not locked. It is only locked if I change it again? Do i need some more coding in another place?

John BB, Thanks very much, pal. It is much appreciated. The coding works a treat. It is like i am now a fully fledged computer programmer (LOL). I also experimented by removing the Me. and the coding still worked. Is it necessary to have the Me. there. I ownder??

I am trying to lock one Control based on the value of another. But my coding does not seem to work. Any ideas on what I am doing wrong? I put this coding in the After Update event but get "Syntax error" =IIf([AmountReceived]<10000,[Commission Percent].[Locked]=True,[Commission...

TextBox name is DateReceived_Label Control name is DateReceived Me.DateReceived.BackColor = vbYellow still gives the same error message

Therefore, what coding would i use (and which Event do I put it) if i want to change the background colour of 2 Controls to light yellow when the first control has the focus? I have tried many different ways but now I am too frustrated!!! Does the coding go in one or both of the Controls...

Thanks JBJ, Does the below code look OK? It does not seem to work. DateReceived.backcolor = vbYellow The objecvt doesn;t contain the automation object vbYellow

Currently my Forms are set at 6" width. The left margin of the Form starts on the far left of the screen. The right margin is approx half way across my wide screen (with high resolution). Is there any suggested standard width for Forms which make it look OK on most screens at most resolutions?

Hi, What code do i need to change the backcolour of a control to light yellow when it has the focus? I know how to do this using the Conditional Formatting Manager, but what code goes in the On Go tFocus event? Would I also need to put code in the On Lost Focus event as well...

plog. thanks for all your advice and suggestions in this post. i know my database is much more efficient thanks to your time and effort. it is very much appreciated. cheers reddevil

Plog – thanks again for your direction. I think my database is going to be awesomely efficient J I have updated the database. However, my logical mind is NOT able to understand why it is considered 'easier' to combine two Fields together (eg. AmountIn and AmountOut)? With my limited Access...

plog, I can see your message much clearer now (about how the 'base' table should be trimmed as much as possible). thanks. I think that Phase 1 of the revised database (attached) might be completed now? I wondered if it is time to move onto Phase 2? Are there any thoughts on that? Have I...

JBB, Cheers for your input. The problem was solved by just a simple case of deleting and creating a new Combo by using the wizard. Thanks again.

plog, i really do appreciate your time reviewing and commenting on my database. I have updated tblFinance to include:- 1. TransactionTypeID (not sure if this field is required?) 2. TransactionType1 (this seems to work fine, especially with the ComboBox on frmIncome) 3. IncomeOrExpenditure...

Hi, I have been trying to add a ComboBox (on my Income Form) with data from tblTransactionType. My problem is that the ComboBox seems to be duplicating most of the records. Please could someone let me know where I am going wrong? Thanks if you can?

Yes. I think tblFinance contains all my Income and Expenditure data. I cannot think of any other Fields that are required, that are not already linked/included in other Tables. My only question is whether the WorkOrderID needs to be included on tblFinance? My intention was to create a separate...

Plog, thanks very much for your comments and suggestions. They have been very useful indeed to set me on the correct path. It seems to be easier now that it is possible to have all the Transactions in one Table. I guess that makes it easier to create Queries and Forms if the data is...

Hi, I have just found out about Anchoring. Now I have managed to stretch my Logo and Page Titles across the screen (whatever the screen size). But I have two columns of controls (text boxes and combo boxes) in the Detail Section which I want them to keep the same width and height and do not...

Sorry guys, hopefully I have answered you better this time. I thought it was best to upload my database with some sample data. My Income Table is actually called tblRentalIncome My Expenditure Table is actually called tblPropertyManagementExpenditure Thanks in advance for your suggestions.

Thanks Mr.B. I learned something about "OpenArgs" today. Actually, the problem is the othewr way round. Eg. I have the Rental Income Form open and just need to click "New" to get a new data record. On that form is a field to input the Contract ID. When the Contract ID is chosen, I want the...

Sorry for the misunderstanding. The fields in my Income Table are exactly the same as my fields on my Income Form. Same goes for the Expenditure Table and Expenditure Form. I have given examples of what kind of data will go in these. Are you looking for upload of some sample database also?