Search results

If I have a bound field on a form is it acceptale to change the value of that field in the code or will access throw a wobly?

Hi I just added a currency field to a table 2 decimal places default value 0. I am displaying that value on a form as a bound field. I am calculating a value in a currency type field in my code and moving that value to the bound database field. I don't get an error but I know that system does...

Hi I am new to access and was hoping someone would save me a night of searching these forums. I am curently printing a report to a default printer but want to print it to a pdf printer if you know what I mean. I have installed cutepdf and it seems to work but what code would I need to change...

I'm doing some data validation in the forms beforeupdate event but the validation and course of action depend on what is going on so. I need to know if the beforeupdate event was triggered because the form was closed or because someone uses the default database navigation control to move to a...

Hi I have a form with half entered data in it. I want to be able to close it down and abandon the changes but when I click on the form close box I get a message saying "you can't save this record at this time invoice system may have encountered an error while trying to save a record. If you...

Hi I'm new to access programming so would appreciate a little help. My problem is that I want to validate a record in the beforeupdate event of the form. I have done this by setting cancel = true if the validation fails. The problem i have is that I then can not move to a different record...

Have not coded for about 5 years and need a little refresher. Can't remember what I need to do. Thanks Dim SelectedCompany As String Dim rs As ADODB.Recordset Dim Cn As ADODB.Connection Dim sSql As String Set rs = New ADODB.Recordset Set Cn = New ADODB.Connection...

When I create a new record using the default navigation bar it does not become real till something has been entered and it has been save to the table. How can I check the status of the current displayed data to see if it actually exists in the table (has been save)? My current problem is that...

How do I delete a record in form view using the default record navigation bar? I have set allow deletions=true Thanks

Hi I expect this is very simple when you know how I have some address fields displayed on a form, when the user adds a new record (via the default record selector) I want the screen to display a new blank record but have the address fields should default to the values from the previous record...