Search results

Yes it did.Thanks I am still learning. Cheers

Sorry about that. It is set earlier

I have 2 Tables Sections_New and Sections. Both have the same fields and data type. I am trying to copy the data from the Judge field from Sections into Sections_New using the following code the error is cannot find input table Sections_New. the table Sections is a linked table and Sections_New...

Hi I think i may have got it by trial and error Is this correct DoCmd.SetWarnings False db.TableDefs("Patronage").Fields("PatronageId").Required = True DoCmd.SetWarnings True

I am using VBA to change [myTableName]![myFieldName]!Required.Value = -1 I am getting error Error 2465 Can't find field '|1' referred to in your expression

Hi I tried it. It stopped MZ tools working. I used it to change 1 field and had trouble, so i uninstall it and it uninstalled MS Office. Lucky i did a backup of the system before i installed it :(

Back the start of the year or late last year I asked if anyone had a search and replace. I think it was you that said you had one in a function/ Module

Cheers for that. did you get the search and replace working. I have a few selling mistakes i would like to fix. Like Descripition to Description

I have now changed this so the yesno field displays as check box Call fnNewProperty(fld, "Required", dbInteger, 0) Call fnNewProperty(fld, "Format", dbText, "Yes/No") Call fnNewProperty(fld, "DisplayControl", dbInteger, acCheckBox)

The new code . It works. Thanks all '-------------------------------------------------- Private Sub cmdTest_Click() '1 = Text '2 = Memo '3 = Number '4 = Date/Time '5 = Currency '6 = AutoNumber '7 = Yes/No '8 = Text with Mask On Error GoTo cmdTest_Click_Error...

What about a Yes/No field. this isn't working Set fld = tbl.CreateField(strNewFieldName, dbBoolean, 2) fld.Properties.Append fld.CreateProperty("Format", "True/False")

Thanks That worked

I have several clients, that i have to add field's in the back end. I am going to add code in the front end so i don't have to upload and change them, just supply a new front end. Each one has the same DB but different data in them. The new front end has some forms changed that need the new fields.

Hi I found this code and using it. My problem is i am addind a field called PhoneNum. it adds it ok but i want to change the InPut Mask to varMask = "!\(999" & Chr(34) & ")" & Chr(34) & "900\ 0000;;_" Public Sub fSetOrdinal(db As Database, strTbl As String, intOrdinal As Integer...

I did try with a list box but got a few errors and problems. I will try again Thanks every one

I set it to none, but didn't work

How would i do that

I have a main form on which is 3 sub forms. These are selected by the labels at the top Exhibitors, Birds an memberships. Pics attached. Users click in the split form to get the exhibitor then fill in the data as required when the + is clicked the pic "subform" is what happens. in a table it...

Is it possible to hide the record selectors on a datasheet in a split form. They have a + and when you click on them it shows the sub form which i don't want them to use through the datasheet as it has code on some of the fields. Thanks

I didn't have it to start with. I changed how i used the form and added the code to close the form first, then open it in design view. once i removed the code to close the form all came right.