Search results

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...

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...

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...

Hi, I am trying to convert a text string into a date string, and was recommended to use a cdate() function. I tried looking at the web and the help function in Access, but could not figure out how to use it. I tried putting the Cdate function in a query, and I get an error message saying...

Hi, In CSV, I have the date as 7/23/2012. But in an Access table, the date is 2012-07-23 and stored as a text. I would like to have the Access table to have the format 7/23/2012, so that I can run queries using the filter: between 7/1/2012 and 8/1/2012. FYI, I am linking the CSV file from MS...

Hi, Does anyone know how I can read in a blank (or empty) cell and spit out an empty value? See my code below, as I have everything set up except for the null string. Option Compare Database Function cnty(x) As String Select Case x Case "Bronx", 5: cnty = "Bronx" Case "New...

Hi All, I need to transpose some columns into rows, so that I can unique records in my database. Here's an example of data I have: ID Language 1 English 1 Spanish 2 English 2 French Here's the output I want (notice I now have two language columns instead of one): ID...

I've found Jon K's database/VBA codes to be very useful. However, since I switched to a new computer, I am no longer able to run his codes. To find out more about his database, please look at the thread below: http://www.access-programmers.co.uk/forums/showthread.php?p=1172983#post1172983...

Hi, I am trying to convert "HELLO123!" into "Hello123!". In MS Excel, I can use this function: Proper(HELLO123!)=Hello123! Is there a function in MS Acess 2003 to turn words into proper cases? Or is there a way I can get the desired results using a combination of functions? Also, what's the...

Hi All, I am trying to write a simple code using a string function, or perhaps using another function I am not aware of. This is what I want to do, but don't know how to write this code using correct VBA syntax. Function code (x) If x equals to one of the values in the following list...

Hi, Let's say I have a column full of zip codes, and I want to see 5 digits. There are some entries where it only has 3 digits because the first 2 digits are zero's. So, instead of seeing "00123," I just see "123." Is there a way I can force the column to show 5 digits, so that I can see...

Hi all, I have an Excel workbook, where a language column has 1 to 5 languages. For example: Language Record 1: English Chinese Spanish The 3 languages are separated by hitting the enter key, and not the space bar key. I have about 400...

Hi all, I have a question about changing the formats of phone numbers. In my current database, I have these type of numbers: 222-222-2222 (222)-222-2222 (222-222-2222 222-222-2222 etc. I would like to run a query to change the format of the above phone numbers to just having ten digits with...