Search results

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

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

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

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

Hello everyone, I have 2x tables: 1) TBL_EMPLOYEES this table has 800 records (employees), 200 of these records have null value under the "e-mail" column 2) TBL_EMPLOYEES_MISSING_EMAILS This table has, 200 records, these 200 records are the ones from table 1 that with missing emails. *...

Suppose I have a table, that has 2x columns: FIRST_NAME and LAST_NAME some of the data in these fields are all in UPPER case while in others are all in Lower Case. Because, these are first and last names, I would like to change them to have the first letter to Upper case and the rest of the...

Hello all, I have a MS Access 2003 and MS Outlook 2003. I have an Access database, where I have a form which I use to automate a process to send emails through outlook and I attach a 'report' with that email. The thing is this report is sent as SNP format, I am wondering if it is at all...

Through the help and suggestion of this board users, I have a CASE driven code for my report I am working on. I am hiding/showing (visible=true/false) some textboxes/labels. Now, I am wondering if I can also move textboxes/labels through vba coding? For example, What would be the syntax to...

Hello all, I am making a report, that containts a subreport. I am hiding and showing (visible =false/true) on some textboxes/labels to achieve the display I want. I have somewhat accomplished this but not exactly. Let me post my code first: Option Compare Database Private Sub...

Hello I am attaching a screenshot of my code and the design view of the sub_report. I am not sure why it is not working? I am trying to accomplish this: the textbox named Application has a control source of Application. if the result is LAN, then I want it to hide a textbox and a label while...

Hello everybody, I am attaching my db in zip format. I have a man_email filter on, enter angelina.alba@man.com or jose.iglesias@man.com for testing, they are the best testing options. I have 3 subreports in my report. I am trying to make sure they display their information separately...

Hello I have a table I am trying to run a query from. One of my columns name is "Sports" the data in this column has over 15 sports, showing multiple times, because this table is for athletes and what sports do they play. In my query I want to do an if statement to display A for Soccer, B...

Hello, I have a few subreports in 1 report, all located in the detail section of the report. My question is, is there some kind of properties that will make the reports display their data separate from each other? Allow me to clarify, I wish for the first subreport to display its...

Hi all, I am trying to design a report with various subreports, but having issues. Can someone please look at the database I am attaching and help me fix my mistakes. Ideally, the first subreport (SOCCER) should display once, and together. The 2nd subreport (FOOTBALL) should display once and...

Hello, I cant figure this one out: I have a textbox with control source [APPLICATION], when I run/execute the report, depending on the persons name and etc etc, the application will display either: house, hospital, or car. At the same time I have 2 labels: Label1 and Label2. Nothing is...