Recent content by Ramshan

Thanks for the reply David. I have one more question, is that possible for me to do the append queries and macros, if my sub tables are located in different database file?

Hi everyone, I need to transfer data from many sub tables to one big table by writing a macro( or let me know if there is any other option). I have no knowledge in macros, please help. Example: Main table - Table 1(Contains columns named a,b,c,d,e) Sub-tables table 2(contains columns a,c,d)...

Hi all, In my DB, I am doing some query which will bring me a report. The user will see the report and if he thinks he needs to make some changes, he should do it by clicking on a button called "Edit" in the report page, which will open a editable form. The editable form should hold the values...

Hi Alansidman, Even after removing Nz function it is not working. I think the Null values in the query form and table is not matching. I dont know how to resolve it. I have attached the sample access file here. Can anyone resolve it? The datatable Table 1 contains all values filled for first...

Hi everyone, I am running a problem with my search query. The query I have used is, SELECT Table1.PropertyName, Table1.City, Table1.Address,Table1.County,Table1.Material FROM Table1 WHERE (Table1.PropertyName Like Nz(Forms!QueryForm1!PropertyName,"") & "*" And Table1.City Like...

VbaInet - NO THAT IS NOT THE PROBLEM. I have resolved it myself.right now am getting all 64 fields in one page :). Let me rephrase the above question. If I query for example say City=NYC and it I get 2 results for it, that is 64 fields for 1st result and 64 for the 2nd, I am getting it in a...

Hi everyone, I am creating a report based on a query and if the query has (for example) 5 results, I am getting 5 continuous report one below the other. So here I have no option other than to print all of the reports. Is there any way to keep only one page for one query result, so that I can...

I think some of the horses here have drank a lot :P

Hi, I am trying to create a dynamic page in MS Access. But I not sure whether this is possible in Access. I need to have a button next to each of the query results. For example during first query if there are 5 results, i need to have five buttons next to the query. If the query brings up 10...

But I got to do this task in a single table. I am not supposed to split up this table into many by applying data normalization to it. So, is there anyway to perform this task? Thank you!

Hi, I have attached the table with this message. Can u just create a report that will fit all the 60 odd fields when we query it. Thank you! Appreciated

Yes, all from one table.

Hi everyone, I am having some problem in displaying the report. I have several columns(64 fields) for each record and I am finding it difficult to make it fit in a report after querying for the data. Can someone help me on this. Thanks in advance!

I am getting this result, when I try to create a report. Can anyone know how to resolve it, "Some fields may have been skipped because there was an error getting information about them or because they didn't fit on the report" I guess it might be due to the numerous field in my query result. I...

I am getting this result, when I try to create a report. Can anyone know how to resolve it, "Some fields may have been skipped because there was an error getting information about them or because they didn't fit on the report" I guess it might be due to the numerous field in my query result. I...