Search results

That is correct. The issue is that there is no validation for the checkboxes so the add_record runs straight to the code to add that field without any checks, hence creating a record with just that data. The form is definitely not bound and there are no sub forms.

Yes Add_Record is a command button and two of the checkboxes run code. Private Sub GSTApplicable_Click() If Me!GSTApplicable = 0 Then Me!GST = 0 Else Me!GST = [Price] * 10 / 100 End If End Sub And Private Sub MinStockSelect_Click() If Me.MinStockSelect = True Then Me.Label97.Visible = True...

Thank you so much for your response. As I said I am a bit of an amateur at this and I guess it shows. The users are not that bad but my code was designed to check if every field was completed. I have implemented IsMyFormValid and it works really well. Much tidier than what I did! Back to the...

Thank you for the responses. Why will this prevent issue? Sorry I do not understand.

Hi June7 Yes it is

Hi All I am fairly new to access and coding. I have an issue with a form as follows: The form is unbound as it update two different table when the "Add Record" button is clicked. Within the form are three check boxes, "Active", "GST Applicable" and "MinStockSelect" I have code to ensure that...

Thanks Appreciate the responses, and yes, I agree that I could just open a form. What I was trying to achieve here is: 1. An autoexec option that popped up a diary style reminder everytime they opened the application. I do not want the user to have to remember to check the reminders. I guess...

Hi I am new to coding. I am trying to loop through a query that will show a form that reminds the user to follow up an event from last year. My code is: Public Function EventReminder() Dim db As DAO.Database Dim rst As DAO.Recordset Dim qdf As DAO.QueryDef Set db = CurrentDb Set qdf =...

Hi The_Doc_Man Again, apologies for the slow response, I travel a lot and cannot get to this for quite a few days at a time. In relation to your comments... The "no" result comes from a Yes/No checkbox on a form and is formatted as a yes/no in the table. It places a Yes or No value in the...

Thanks The_Doc_man I tried what you suggested and unfortunately, I am still getting the wrong result. As this function is "month to date" I also tried changing enddate to simply "date" as that would give me the correct outcome. In all instances I have debug.printed the variables and they are...

I have checked the references and none are noted as "missing"

Thanks for the responses folks and apologies for not getting back to you as I have been away. This just gets more curious (and frustrating). I copied the application to a USB stick and opened it on another computer and it works perfectly. Just not on my new laptop. I really don't understand...

Correct Result is $5,198.00 Function is returning$61,982.10!

Hi Folks I had an unexpected shutdown of my laptop which has caused some major issues with my application, particularly my functions that use Dsum. Following is an example of my code that is producing a result but not the correct one! Public Function ThisMonthWeekdays() Dim StartDate As Date...

Thank you all for your help with this. It seems my old notebook had an unexplained shutdown and restart which corrupted a lot of my queries. Don't know why but the field names in some of my queries were renamed expr1, expr2 etc which caused a lot of issues. When the field names were renamed it...

The application is definitely the full version not run-time. The old PC ran windows 32 bit and the new one is 64 bit. Thanks

Sorry but no, I do not know what I am using it for. After I unchecked it and complied, I get 2 errors. Undefined function "Nz" in expression, and An error occurred while sending data to the OLE server.

Yes. Microsoft Office Web Components 11.0 is missing

Hi I hope this is the correct forum to post this to as I am new to Access Forums! I am not an experienced Access developer but have learnt a bit to date. I have purchased a new laptop running Windows 10 and have installed Office (Access) 2007. I have migrated my application (which worked...