Topics Search

Change Field name in Table with VBA

Change Field name in Table with VBA
Views: 124
Is it possible to read the names of the fields in an Access table and rename the fields? *I have three tables, one with several fields, and I need to change the name of the fields.
Sponsored Links:

Similar posts...

 

Referencing Table Field Value to Change Back Color (with if/iif VBA/expression)

Referencing Table Field Value to Change Back Color (with if/iif VBA/expression) Icon
I have a report where some field values will be blank at times. I would like to write an if statement (in VBA or as an expression) to state that if the field is blank, to change the backcolor of the field value on the report.

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.
 

validation rule or vba

validation rule or vba Icon
I have a table purchases that contains a lookup field. The lookup field displays the field upc from the table red. id is the primary field in the table red.

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
 

Change a field to Primary key in linked table

Change a field to Primary key in linked table Icon
I need to change the properties of a field to be a primary auto number field. I know that we can't just change it so I am needing some code to copy the existing Contacts table structure. Change the ID field to Primary autonumber. Then we need to copy the contents of the original contacts table to the existing table, rename the old contacts to contactsOld and change the name of the temp table to contacts.

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.
 

Can't change Table Field Name to All Caps

Can't change Table Field Name to All Caps Icon
XP/2010

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
 

Change Record value to another field

Change Record value to another field Icon
I have a table with 2000 records.
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.
 

Set the field size

Set the field size Icon
You can adjust the amount of space that each record in a table uses by changing the field size property of number fields in the table. You can also change the field size of a field that stores text data, although this action has a smaller effect on the amount of space that is used.
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
 

Change to a new table

Change to a new table Icon
I am trying to get my Access Report to use a new table. In design view, I change the Record Source to the new table name. I also change the table name in the Order By field. But it won't let me save the change.
 

VBA Code for buttons, Access 2010

VBA Code for buttons, Access 2010 Icon
In using this new version of Access, I have found that when creating buttons, Access no longer uses vba codebehind to handle all the dirty work - rather, it seems Microsoft is forcing me to use the upgraded (and very nice I must say) Macro builder.

This is fine for all the simple tasks, but what I have myself into is a little more complex than the Macro builder is ready tohandle I think.

Before, when I created a button, not a Macro. I am trying to build the following button types:

Button 1 - Update a Field in a table, Save form, Close form
Button 2 - Update a field in a table, save form, new record
Button 3 - Update a field in a table, save form, print report, close form . and so on and so forth.

I used to put 3 or 4 buttons on the form, then copy and paste the generated vba in the correct order in a single button, and delete the dummy buttons. But now it seems as the basicfunctions are built using an embedded macro, and when that is combined with VBA, Access must choose between one or the other, rendering my button useless.

Is there a setting in 2010 that will change the way buttons are created in that VBA is used by default instead of macros?
 

Log record change in back-end?

Log record change in back-end? Icon
Is there a method, in the back-end file, to log that a value (any value) in a record was changed? - - adding a new field to the table just for this purpose is ok.

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?
 

Change group and sort options via VBA?

Change group and sort options via VBA? Icon
I have a report currently grouped by one field name and sorted by a few others. What's the best way to change the group and sort options via VBA so I can make group/sort buttons for each field on the form? - OR - What are other methods of accomplishing this