Search results

Thank you both, Cronk and Fran for your advice and code. Is a bit silly that I did not thought of putting in dummy data. I will try it as sun as I'm back from my vacation :).

Maybe it is a bit unusual . Let me explain . I have a data table (eg Table 1) and the form for adding and editing records in this table. Certain fields in this table must be filled in, so for this fields the Required property is set to "Yes". This ensures that all required fields are filled...

Hello! First let me say that I am using Access 2010 and I do not have much experience using it. I need advice on how to change the property of a field in a table programmatically. I have a table in which one field has Required property set to "Yes". I would like to set this property by using...

I got the add-in on the Helen Feddema's Home Page (code20.zip). This add-in allows you back up front end Access databases and the most common types of back end databases. I must admit that I do not have much experience with Access, but I'm looking for possibility that users can more easily...

Hi! I'd like to know whether it is possible to run the add-in using VBA code and if it is how can I do it? :banghead:

It works. Thanks.

Hi! I ask for your assistance in the following matter: I have a form with a textbox for the warning about the possible duplication. In the control source I have a formula "=IIf(DCount("*";"[Pacient]";"[ID]<>" & Nz([ID];0) & " And [LastName] = '" & Replace(Nz([LastName]);"'";"''") &...

NickHa and JANR! Thank you both for your answers. I'll try both solutions and I'll inform you if both of them are working.

Hi! I have a table that contains certain characters, which should be replaced with others (such as "è"" with "c" or "§" with "z"). I do not know much about Access, but I know that a single character in single field can be replaced by using a query. I would like to know whether it is...

Hi! I have a problem using the following function (found it here on forum) in Access 2010, which works very well in Access 2000. Option Compare Database Option Explicit Public Function Conc(Fieldx, Identity, Value, Source) As Variant Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset...