Search results

I have 6 fields. Allotment Number Date 1 Date 2 Date 3 Date 4 Date 5 I want to write a query which when run will give all the dates and their corresponding Allotment Number which are 1 week after today but not later than 2 weeks from today i.e. Suppose today is 11.03.2010. I would like the...

Where shall I write this code IIF([Field] = 1, TRUE, FALSE)

I just used "abc" for example :-)

For data type of fields of a table, i can go to table design and change the field type to boolean, but in case of an expression in a query there is no way to change an expression field to booleAN.

How do you change an expression field to boolean. The expression field is Expression:IIF("Table1.Field2 = "abc",1,0) How do I set this expression field type to boolean TRUE OR FALSE will also do, because I just want the checkbox field to be checked/ unchecked based on a certain field value.

Checkbox check uncheck based on field value I have a checkbox, which I use in a report. The controlsource of the checkbox is an expresssion field in a query. This expression field has value 1 or 0. I want the checkbox to be checked when this field's value is 1 and to be unchecked when it is...

Thanks a lot

I want my combobox dropdownlist to show records from two fields, one below the other. An example will make it clear. I have two fields each in a different table. Field 1:Desktop Records: HP 112,Dell 325,Hitachi 652 Field 2:Laptops Records: Dell Inspiron, HP Notebook, Lenova Pad I want the...

Thanks. That was what I needed.

Thanks for you guidance. But I think I was not clear in getting my question right. I use the table to perpare a report, which has to be signed by an examiner. There is a "Date of examiner's signature" field in my table, which I want to populate so that it gives today's date, so that I dont have...

I want to update my records to today's date. Whenever I open a the access db the table which contains the date field should update automatically to today's date. In excel this is done by today() I tried using date() but the stored value is static, (it stores the date when that record was...

can somebody help please. I need to do this urgently.

Hello, I have data of 15 of my department collegues in an access table. It includes their name, date of birth & Email Address. I need to accomplish the following. Say if tomorrow is Mr.X birthday. I want to send a reminder mail to all of the other fellow about the birthday except Mr.X...

I have created a website as given here. http://www.utteraccess.com/forums/showflat.php?&Number=1024572 Now i would like the user accessing the site to upload images which will be saved in the back end. How to do this. Also I wud like to create a page for updation and deletion of records...

I have access 2007.Will that work..?????

I want the web page to be accessible over the local intranet. i have my website in wwwroot directory.

I have an access database with a table and a form. I would like a webpage which will contain a textbox for searching the primary key of the table. When the user at the frontend hits the command button("Print") after entering the search query, I would like to print the form as it would have...

I have tried that. But I am not able to acheive what I want

I have a database of my friends. The database contains a table containing the primary key(autonumber), Name, Telephone no,mobile no, home add, office add, photograph, Date of Birth and other details of my friends. i want to do the following: 1. i want a userform to insert other friends details...

Hello, I am new to access. I know more than average about excel and I am new to VBA programming. I need help in the folllowing 1.I have a welder qualification database as an excel file. The database includes the following columns. A- Sr no: Serial number from 1,2,3 ... it is unbounded B- Welder...