Search results

This works in the above code. You can concatenate the string with the number and access the field name it creates - may be strange but works fine. Rabbie, thanks for your suggestion. I have tried breakpoints but where should I put the breakpoint to see what happens when I press the nav bar (to...

It is in a routine called CalcFields. The CalcFields sub routine get's called by the forms current event and it gets called by the lost focus event of 46 fields on the form. Is that a problem? I also zero the value in the form before insert event Thanks Pete

Thanks for the help but it didn't work. Any more ideas, this is driving me crazy. I wish access would let you know what's going on.

Thanks. That's what I thought but Access doesn't work when I do it. If I enter a value in a bound textbox field on the form I can use the navigation bar to move around the table, the values I enter are saved and everything is fine. If I set a value in the code like this me!boundfield.text =...

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...

sorted now. thanks

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 Bob Yes I know the database is awful. This was a specific requirement from the user. I tried to change his mind and had a lengthy discussion about having a separate invoice lines table but he wanted the data to be stored in the same way as his existing excel system. I have removed all the...

It's still 640K can I e-mail it to you?

Hi Bob What's a subform LOL I used to program in VB 3,4,5,6 & 7 up till about 5 years ago. I have done nothing since then till someone asked me to do an access system for them and this is it. You want me to post the whole access database here? The code is well dodgy and the database...

Thanks. The code looks a lot better now but I'm still getting the message saying "you can't save this record at this time." I get it regardless of how I respond to the "do you want to abandon the record" msgbox. Any ideas?

Thanks. I think I am doing that in the code below. In debug this routine sets cancel = true and does me.undo but I get the ""you can't save this record at this time invoice system may have encountered an error while trying to save a record. If you close this object now,the data changes you made...

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...

Thanks. All sorted now.

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...

I had messed up the field names and wasn't even looking at them as I though the problem was elsewhere. Thanks. All sorted now

Is this right? I don't have any other code or dim statements or anything relating to ado in the project. I'm getting the same error with this. Dim SelectedCompany As String Dim rs As ADODB.Recordset Dim sSql As String Set rs = New ADODB.Recordset SelectedCompany =...

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...