Search results

Thanks! For this specific database I have more than 4000 registers in a lot of tables. All database was constructed using table levels lookups. To correct everything without messing everything would be a master chess game job! But I'll follow your good advice for the next databases. I'll be...

Thanks Pat! Isladogs recommend that I read the article http://www.mendipdatasystems.co.uk/table-lookup-fields/4594445135 and I'll do it! The problem is solved. Just the ID number in the Default Value field did the job.

Thanks very much!

Thanks a lot isladogs, the number works! I'll read the articles. Do you recommend some books to improve on Access?

On VBA works for me too, but not when I use the expression in the Default Value for the State field. I want to define a default value for it. Maybe I have to use something else there.

Hear the database file, to tests.

Thanks, but the same error message. I don't understand why, since everything seems to be right.

A very simple example! A CUSTOMERS table, where data to CITY and STATE fields comes from the related tables CITIES and STATES. I want to define a default value to STATE field, and tried this expression: =DLookUp("[StateName]","[States]","[StateID]=1") But I got an error message: What I'm...

Great, brother! Also I will be answering in the near future. And also in the future, I hope we will have a better world with people helping each other. ;)

Thanks! I will keep the configuration just until I have a better understanding of Access and VBA. I have already many books and courses, and all of them have expressions with a comma. I have experience in other areas, like HTML and CSS, but I am starting with Access and VBA now, and I see an...

Thanks very much! :) Now I understand what happened! I just changed the language settings in my computer, and now the Expression Builder uses a comma, instead of a semicolon, in the expressions! I will keep the language configuration, since almost all software I use is in english.

Thanks! I don't understand well what you mean. I live in Brazil, but my Access 2013 uses the english language. The tutorial I am studing is ACCESS 2013 ESSENTIAL TRAINING, from lynda.com. The tutorial's author Access is in english. In different countries, are the vba expressions different?

Hi guys! Why the EXPRESSION BUILDER in ACCESS 2013 is showing this (wrong?) sintax for the LEFT function? Left(«string»; «length») I'm studing some books, and in all of them the LEFT function have a COMMA, instead of a semicolon: Left(«string», «length») This causes some problems! In a...