Search results

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

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

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

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

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

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

Hi Everyone, How I can write a query and pull values from 2 tables having different number of columns and having no primary key. I tried using SQL UNION ALL command, but his brings me only the common columns. My requirement is i need to pull all the columns from 2 tables for a particular query...

I am having two tables dbo_hpr and dbo_bridges. Only some of the columns in dbo_hpr are matching with dbo_bridges, SQL UNION ALL query only brings up the values that are common in both the tables. But I need to show all the values from both the table. So how shall I write the query to bring all...

I was trying to pull down values from two tables Dbo_Bridges1 and dbo_hpr using a query form named Prop_Bridges. Dbo_Bridges1 - gives information about the bridges in a particular area dbo_hpr - gives the property information in that particular area What I need to do is : If I select a...

I was trying to bring down values from two different tables that have County(Numeric field) as a common field. But i am getting this error, Run time error "3615", type mismatch in expression. I donno wat is the reason. Here is the snipet of my query, SELECT dbo_hpr.ADDRESS, dbo_hpr.PROPNAME...

I tried using the code below but I cannot figure it out why it isn't working. So here I have attached a sample file called Database6. So the requirement here is when I open the datasabe6, it should directly open the form with all the menu bar and tool bar hidden. Can you just re-attach the file...

Hello everyone, In MS Access is that possible to bring only just the forms opened when the corresponding DB file is opened? that is if a end user opens the db file, it should directly open the form on which they are going to work. All the menu and the tool bar should be hided when they open. Is...

Hi everyone. Is that possible in access for recoding the values in a table? That is I have a field called County in my table which is in number format. But each of these number refer to one county, example Adair = 112, alfalfa = 156 etc. So now I have to create a new column named CountyName...

Hi everyone, When I was working with my DB, I am forced into a situation to change my data type size, but when I tried to do so it gives the following message," Microsoft Access can't change the data type : There is'nt enough disk space". But I got lot of free disk space. I simply dont get it...

Here it is, In my query form i have a field called County, its a combo box and it contain the several values like Adair, alfalfa etc. so the user will be selecting one of this value to perform query operations. But here comes the problem, in the table where these values are stored they are...