Dat/Time Field, Mandatory Field text/VBA CODING!!!

Spot on! Perfect!

Many many thanks for your help guys!

Much appreciated!

im sure ill be back on here with some more questions as the development of the db continues...

thanks again

Jon
 
Jon

Glad to help, just remember
1. Do not use RESERVED words Like Date, Time etc. for field names
2. Field names to be one word or two words joined by an underscore. Do not use N/O etc.
3. Correct data type e.g. Number for storing numbers not Text.
 
Where in the VB coding of the form you supplied can i change the percentage values?

for example - if % of Major needs to be 1% rather than 4% and Minor 5% and Unacceptabel 5%?

Regards

Jon
 
Jon

I have attached a document with the code and highlighted the relevant sections of the code that are used for defects percentages.
 

Attachments

Many Thanks once again. It wias confusing me because i was looking for the 10% and couldnt see it - didnt realise it was entered as a 0.01%!!

All works fine now - Thank You!

As you can probably grasp by now im not an Access Expert but trying my best! lol

Heres another one for you...

Is there a way of making that command button "yes/no" also "Save the record" once clicked?

Im sure i had it in a previous DB? But im not sure on the coding for it?

Regards

Jon
 
Thank you for your comments, I am not an expert just a person who dabbles with access.

You want to save the record when the user clicks on the Pallet Conformity button when the caption is YES and take no action for a caption of No.

Using the Click event of the pallet_conformity button add this code. The docmd line will save the changes

Private Sub pallet_conformity_Click()
If Me!pallet_conformity.Caption = "Yes" Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
MsgBox ("Record saved")
Else
MsgBox ("Record not saved")
End If
End Sub
 
Once again many thanks! Yu must dabble more than me Allan!

And for the next part.......dont worry Allan, i will keep you busy for a few weeks!!

The Command button that says yes/no

Is there a way of displaying the result (yes or no) into the DB table? So when reports are done etc the Pallet Conformity or Yes or No pulls through...?

Or maybe...could it link to a hidden field that displays the text YES or No depending on the result and then i could link that field to a column in the DB Table?

Once again many thanks...

Jon
 
Yes there is, please send a copy of your database with the relevant for mand table. Maybe it would be a good idea to take this of forum and send the database to my email address below.
 

Users who are viewing this thread

Back
Top Bottom