Search results

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

Hi every one, After I perform query operation, I am getting a result table that consist of some 120 variables which makes printing harder and it messes up. So is that possible for me to do some operation like excel transpose in access before printing? Thanks in advance

I was working on Access forms and VB code. After I am done with the code, I tried to check its funtion by clicking on one button and its throwing this error, Microsoft Access has stopped Working and in the problem details it shows the following, Problem Event Name: APPCRASH Application...

Do we have any function that can be incorporated in forms that will change all entries in to CAPITALS when I hit a button? Thanks in advance

Some info on the tables: Both the tables doesn't have any primary key, and they have different number of columns. So this restricts me from using UNION ALL query, else ehich would have been much more easier.

My objective is to pull down all the columns from two tables 1. dbo_hpr 2.Dbo_Bridges1, (where dbo_hpr.address = Dbo_Bridges1.address) OR (dbo_hpr.city = Dbo_Bridges1.city) Here is the query and I have tried using INNER JOIN in SQL, SELECT dbo_hpr.OBJECTID, dbo_hpr.PROPNAME, dbo_hpr.RESNAME...