Hello Ajalwaysus and ChipR
Thank you both for your very helpful replies. I drew assistance from a combination of each of your suggestions in order to resolve my problem. I am not sure how to remove the question now that you have very kindly provided me with a solution. Many Many thanks
David Wright
Last Activity: Nov 2 '09, 11:30 PM
Joined: Jan 14 '09
Location:
-
MS Access - Make double click mandatory to enter data into field
Hello All
I am using Microsoft Access 2003. I have an input form (Single Form) into which the clerk records appliance details. Some appliance details will never change, for instance the 'Make and Model'. Some details will need to be updated later on, for instance the location of the appliance. When updates are required, the user opens the update form (Single Form). The user is able to cycle through all records of appliances using... -
Hello NeoPa
Thank you for your reply. I do not know SQL although I do use a few little bits of code like msgbox "----- "and Docmd.Maximize. I will research on the net about how to make a query pick up readings from a form (Unbound control would be a Text Box i expect). Thank you for the suggestion. I look forward to researching how to implement this. If I really cannot resolve it after a few weeks I will return to this forum....Leave a comment:
-
Macro Opens Multiple Parameter queries requiring same answer
Hello Folks
I have a Macro which consecutively opens seven ‘Make Table Query’s’. Each query requests two parameter inputs i.e. ‘Please Enter Department Code’ and ‘Please Enter Year’. It is arduous answering each parameter request for the seven queries’s as the answer to each department code will be the same department code and the answer to every year will be the same year. (I may choose to enter a different department... -
Hello Puppy Dog Buddy
I was not sure what you ment by 'comment out the form_current code'.
I deleted my:
Private Sub Form_Current()
DoCmd.RunComman d acCmdRecordsGoT oLast
End Sub
and inserted your code without any event. I hardly know anything about sql.
I still encountered problems.
I am content with auto number; it will suffice.
Thank...Leave a comment:
-
Auto Increment field in Sub Form
Hello Puppy Dog Pal
Thank you for responding to my enquiry. I had the following code in my ON CURRENT event property before I added your code:
Private Sub Form_Current()
DoCmd.RunComman d acCmdRecordsGoT oLast
End Sub
I added your code after this code. It may be that my code could have affected the results of your code. Your code did work but...Last edited by David Wright; Jan 22 '09, 08:15 PM. Reason: Changed Tabulation for spaces as clarity lost when published. This did not help. Never mind.Leave a comment:
-
Auto increment field in subform
Hello Everyone
I would be grateful if someone could help me with the automatic increment of a field on my subform called ‘Test_SrNo’. I am Using Microsoft Office 2000. The auto entry of the incremented number would help to reduce errors and make data entry simpler. The next record in the Test_SrNo field should not have any entry in it until the text insertion point enters the Test_SrNo field. Example: If the last test serial... -
Hello PuppyDogPal
I now have the answer thanks to your guidance. Please see below:
Private Sub Combo128_AfterU pdate()
Me.Combo128.Req uery
'selection from combobox used to update tblLogSheet
Forms!frmRECORD _NEW_APPLIANCE! Description = Me.[Combo128].Column(0)
Forms!frmRECORD _NEW_APPLIANCE! Insulation_Chec k = Me.[Combo128].Column(1)
End Sub
I could not have got there without...Leave a comment:
-
Dlookup Value based upon lookup Selection
Hello PuppyDog
Thank you for writing again. I tried what you suggested and this is the result.
Private Sub Combo128_AfterU pdate()
Me!Combo128.Req uery
'selection from combobox used to update tblLogSheet
tblLogSheet.Des cription = Me![Combo128].Column(0)
tblLogSheet.Ins ulation_Check = Me![Combo128].Column(1)
End Sub
...Leave a comment:
-
Thank you puppy dog buddy. I am affraid it did not work for me. I tried the following:
Attempt 1
Combo128 AfterUpdate
Private Sub Combo128_AfterU pdate()
Me!Combo128.Req uery
'selection from combobox used to update tblLogSheet
tblLogSheet.Des cription = Me!Combo128(0)
tblLogSheet.Ins ulation_Check = Me!Combo128(1)
End Sub
When I entered data into my form, the following...Leave a comment:
-
Dlookup value based upon lookup selection
Hello Folks
I am using Microsoft Access 2000
I would be grateful if someone could help me with “Dlookup”. I tried various methods of writing Dlookup and various events to trigger it, none of which were successful. I have been able to display the required value in a ‘text box’ which is a little helpful but not ideal.
I have a table called tblLogSheet. The ‘Description’ field of this table...
No activity results to display
Leave a comment: