Change Field name in Table with VBA
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I can't seem to get it to work in either VBA or as an expression. In VBA I get a debugging error as to how I reference the table field value. In an expression (I am not sure how to refer to the back color of a field) I first tested with true returning "Good" and false returning "Bad".
Even though the table field value is blank, it returns "Bad". I even tried to include IsNull(""), but this still returns "Bad".
Even if I put a value in the table field and refer to that in the expression, it still returns "Bad" instead of "Good".
At the moment I don't have a date selection form before the report, but I have a record in the table that shows when switching the report to View mode.
The reason for these gymnastics is that I am selling some software that will integrate with ShipRite and I need this to happen programitically so I don't have to physically go to each client to do the install.
The lookfield upc should only be able to except the values greater then 10 but less than 100. Do I come up with a validation rule for this field in this table? If so what is it? Or is a form with vba the way to goand if so what is the vba
I need to put the last hour of the day and employee for the field EndTime.
It is possible for vba cod?
Look at the picture in attached, please.
I have a table with a field name "distcode." I need to change it simply to all caps; DISTCODE. In Design Mode I type DISTCODE, save, and when I view the table the field name is all caps. But when I close the database and reopen the table the field name is back to all small letters. What is forcing this default change?
The Data Type is Text, and this table is not linked to another table
In this article
* What happens when I change the field size?
* Change the field size of a number field
* Change the field size of a text field
I can easily see a method if one can put vba in the front-end form that the user uses. I can use vba to insert a change code into that record's log field.
But I can not see any method that would exist only in the back-end file. Is there any technique out there?
The only way I can fix it atm is by using the Compress and repair database,which restores the links between VBA and the forms etc.
What causes this to happen? Is it a known bug in Access 2010?