Recent content by hycho

Hi, Does anyone know how to lock a table so that only certain users can edit a table in a particular database? As in, I can edit and change the records in the table, but everyone else has read-only access. I am using Access 2010, and don't know which drop down menu to start. Thanks. Hycho

Hi All, I am trying to create the below iif statement: Iif([Termed_Ind] is like *true*, 1, 0) However, when I try running the query I get error message below: "The expression you enters contain invalid syntax." The field "termed_ind" has some of the following values below: 1...

Thanks for the suggestion. I thought of that scenario, and it would be cumbersome to keep typing the word "like", "and" for 100 names. See below for more details. Like in ("John*","Ray*","Joe*", "*100 other names*") Thanks again.

Hi, I have a question regarding the like and in operators in MS Access. For example, on the criteria section of a query, I know the statement below works: In ("John","Ray","Joe") But I would like to know all names that are similar to John, Ray, Joe (and more). So I tried using the statement...

Hi, I am trying to using an iff statement to pick up null values, but I don't know what to type in the function. I tried using "is null", but got an invalid message. Does anyone know what value I should type in to get null value in the function below? IIf([popi_r2a] is null","",[popi_r2a])...

Hi All, I have to submit a file to a government agency that requires more than 200 columns. Is there a number of column limit an Access table can have? Thanks.

All, I have to convert a large number of phone numbers to string with no symbols. Such as, from (123) 456-789 to 123456789. I tried using the replace function, and was wondering if there is a way I can enter multiple symbols to replace. Such as the function below (which didn't work)...

All, I would like to convert the phone number: (123) 456-7890 to 1234567890 I tried using the replace function... But I was wondering if there is a way replace the symbols and spaces using just one function... or if there is a better a way of doing this? I have a couple of thousands of phone...

Thanks jdraw. Very good and thorough advice. I just looked at the first link regarding normalization, and I am like... this is useful since I have only taken one programming/C++ course in my life. Lots to learn. Thanks again.

This is good advice. Where do learn these advice from? Just from experience or is there a good textbook? Thanks again.

Thanks for the syntax/style tips. Typed in the brackets as a force of habits (accustom to calling a function and using brackets for variables in queries). Is there a reason why you have the two arguments pDay and pColor as strings? I tried running the code as below and it worked...

Hi, I am trying to pass two arguments in a function, but don't know how to exactly do this in VBA coding. For example, I would like to define the function happy() for color and day. Let me know if there is anything wrong with the coding below: Function happy([color], [day]) as string If color...

I kind of solved the problem. When I open the CSV file, and save it as new, the date format correct itself when I am linking. I also notice that the CSV file size gets like 5% smaller when I save as the new file, even though I didn't do anything. I can't post attach the original file to this...

This works well. Thanks. After using the CVDate() and CDate(), I have come across an unusual problem using the query filter "between [Begin Date] and [End Date]." Let's say when I 8/1/2012 and end date as 9/1/2012, I get the following results in the bottom. When I actually use "Between...

Thanks for the link. It's pretty bizarre for me as well, and it gives me a hard time to find records by a date range filter.