Search results

I did do extensive research before posting here, I did try the free one click yes, and it works pretty great. I will be using it for my purposes, eventually Id like to learn to code this myself though! Thanks for your assitance.

Hi, I use an access form to send some 600 emails with a SNP format report as an attachment. Problem is I get the outlook prompt "a program is trying to automatically send on your behalf" Can someone help with creating a macro to simply click yes. Problem is I do not think clicking yes is...

ok thanks a lot its working now! "Why not create a lookup table with the smart codes and the english translation? You could then join on that table in your query." - I am not sure how to accomplish, I've never heard of a "lookup table"?

attaching a screenshot

the code is not really working for me? I am using this code(yes the spaces are part of the column name/data): Type of access: IIf("R X R X ","read only",IIf("RWXD RWXD ","read-write-execute-delete",IIf("all all ","all"))) but the results is "read...

Hello all, I have a table with a column called "DIR FILE". Now in this column the values are " RX RX", "RWXD", and "all all". anyways what RX RX means is "read-only', RWXD means "read-write-excute-delete, and "All all" means all. I want to run a query, and select this field, but I do not want...

I cant type in the password while holding the shift key though. the password has the first letter capitalized and rest in lower case.

I went into the tools>startup and changed the form to blank, but I still got the pw prompt. Afterwards, i tried renaming the autoexec macro but it would not let me as I did not have exclusive rights to the db.

I can look at forms in design mode yes, I just can't save any changes to it unfortunately. Last time I made design changes to forms/tables was like 1-2 months ago, I had no problems making changes once I had sole access to the DB. This time even with sole access, it will not allow me to make...

I held down the shift key until the password prompt window came up. It did not change the way the db opened, everything looked the same.

RuralGuy: didn't work :x

I am not sure what recordsets are, this database was originally designed by someone else. After I enter the pw to enter the DB, there is a small welcome form, which I have to click an open button, which in turn opens another form that houses 7-8 buttons, each button opens up a form for data...

"You Do not have exclusive access to the database at this time. If you proceed to make changes you may not be able to save them later" I have a Access 2003 database which I am trying to make some changes in. I am the only person with access to the database, but I still receive this message...

Hi I am importing an excel sheet as a table. I get an option called: Indexed what is the difference between choices: No, YES(duplicates ok), YES,(no dups) can someone clarify this for me please, thank you.

Your first code did not work, by the way I am not using 90 80 or 70, but words, dont think thats the issue though. Any tips? EDIT: nevermind I put " " around the 90, 80 and 70 and its working now, thanks for your help peeps

Hello I have a column named: Grades Then, I have only 3x different values in the fields under this column A, B, or C how do I run a if statement to create a new column trying to accomplish this: if A then I want it to return 90 if B then I want it to return 80 if C then I want it to...

What about UNDERSCORES in column names? Will they cause headaches in transferring a db from access to sql too?

ohhh great bit of info there. In the future here at my work-place we are planning on transfering this database over to ms sql. Since, I am in the process of editing this database currently, I will make sure all table-columns do not have special characters.

correct sir, the second table only contains the 'rows' of the employees that had missing emails on table 1. so: table 1: 800 rows (200 rows are employees that have missing email) table 2: 200 rows (the 200 rows of employees from table1 with missing email)

Tx for the tip: ill try to stear away from special characters in column names.