Search results

I have excel linked table. How can i add one column that cointains combinaton data of 2 column. Examp: Cell A1 = guest Cell B1 = House I want place on C1 = GuestHouse On excel i can use "A1"&"B1" function. But i don't know how to do it on access?

i have field that contain code, the kode use 2 digits of number. i try to filter by using code 00 (double zero) but not working. it's not working also on corelation query, but other 0x (ex; 01, 02, ect) working well. how can i fix this?

i have report with 2 column on data. but when i preview/print the report, it just show 1 table header. can i make my form to show header on 1rst & 2nd column? thnks

how can i change data source on report? my report use "a" query as data, and i want to change it using "b" query as data. how can i do that? i've tried change the data source, but not working? thnks

i have 1 table that link to excel file. the excel file is generate by other software and it's on excel 2.1 format. I've tried to directly link to the file but not working. so i manually open the file and save the file on excel 2002 format, then i use that file to be linked on my mdb...

o have access file 2000 format, working well on my pc, but when i try to copy and run it on my office it said runtime error like on pic below? i use link data, u've make location the same as on my home pc. i've tried to open the data trough access & working well. how can i fix this? thnkas

i accidentally change a property of a query to hidden, i don't know how to make the query displayed again. what should do?

i have table : code name aa 1234 bb 5678 i use the table on a combo box in form, the display value on combo box is "name" but the combo box use "code" to generating result. How can i put both value on text box on report? i'll use it as title. so on report will be shown as "...

my combo box using first coloum of query as criteria field, and third coloumn as display on form? i have try many ways but nothing work. how can i do it?

how can i filter my query, so if no list box item selected. the query will show all data. thnks

i have a text box & a button to filter query, on my text box i have default value. so far i never get my filter work on my query, my filter is combination of dafault value & user input. for exam; text box dafault value is "AABB" then if user input "123456", then the query will be filtered by...

i have several query and want to open it by combo box & button. if user select "AA" on combo box an then pres a button, query "11" will be opened. if user select "AB" on combo box an then pres a button, query "12" will be opened. etc how can i make that form? thanks

i have several query and want to open it by combo box & button. if user select "AA" on combo box an then pres a button, query "11" will be opened. if user select "AB" on combo box an then pres a button, query "12" will be opened. etc how can i make that form? thanks

on my query there's a colunm which contain based on two other column. so is it posible using if function like on excel or i have to use module to do it? i've read iif function but still dont understand. what i need to do is; if column A contain 1 and column B contain 2A, column C will be filled...

on my query there's a colunm which contain based on two other column. so is it posible using if function like on excel or i have to use module to do it? i've read iif function but still dont understand. what i need to do is; if column A contain 1 and column B contain 2A, column C will be filled...

i have query tthat calculate perioe between date. the result is number. how can i modify so it will show something like 1 year, 2 moths 3 days? Thanks

i have 1 table that store data as black/white list. i want to use it to filter on showing data by query. what code should i add in my form/button?

i have a query from 2 table. let's say table a & b. i have one form to show the query. the query show data based on what enter on the form. when someone enter a value, on form, the query use it as filter for displaying data. my problem is one field of my query show data from the second table...

i have database, my old database use blank, the new one use "0" (zero) on empty field, let's call "num" field. when i do calculation, it doesn't return any value (both on zero/empy). I use "-" (mines) calculation. So far i save it on excel and use excel formula to do the calculation. How i can...

how can i short my record by date. my ata using format dd/mm/yyyy. i've been try using deferent metho but not working. 1. how to show just certain date? ex. just data date 10/08/2007 2. how to show just certain range date? ex. just data beetwen 30/10/2006 - 10/08/2007 thanks