Recent content by romanticode

I've solved the problem. I use "+" instead of "&". Thanks All.

i've tried the code, but not working on table or query. where's exactly i should place the code?

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?

just an example table: kode desc 00 tiger 01 mouse 02 cat i wan to filter my query to show just data with code 00. but not working because it always change to 0 (on filter). other code working well although using 0 at the front. is it clear?

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

thats what i'm doing now. is there any metode to auto convert the file?

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

not working, any other methode?

not working unhide menu not active even i've hide some queries.

it's just an examp. thanks, i'll try

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