Search results

They do not have common field...

Thank you Bob! I will try it! Could you please help me with this or five me a hint... Table1 COUNTRY...... CITY usa............ new york uk............... london and Table2: NAME.......AGE michael.... 32 linda........ 25 I would like to create a new table...

Hi Bob! Thank you for your comment. Actually I need this extra column in the pivot table, and as I am totally new in Access, I really do not know how to put this data in the pivot table without creating the column! :(

Ok! I was able to solve my problem. If someone is interested here is the solution: I created a new empty column in the table. Then I set copied the Code column to this column: (Update query, select the empty column, modify to: ='tablename'!'columnname'). Then I trimmed the code ( I needed the...

Hi Bob! Thank you for your reply. "1. Rename your field that is named "NAME" as that is one Access Reserved Word that will just play havoc with you later. You do not want to name fields or objects the same as Access Reserved Words, but NAME is probably the worst one to do." Actually it is in...

Hi there Everyone! This is driving me real mad! :( It should be very easy but (as I am very new to access) I just cannot cope with it. My problem is the following: I have a very simple table which has the following fields/ columns: Table1.Code, Table1.Name, Table1.Address. What I would like to...

Hi Gemma, sorry for my poor explanation. :( So here is my problem. I have two tables with the following columns: Table1.Name, Table1.Address and Table2.Phone_number, Table2.ID_number From these two tables I would like to create a joined table which would look like this: Table3.Name...

Hi there Everyone. First of all I am very new to Access, so please try to explain detailed if you can. :) My problem is that I need to merge/join two databases/tables, but horizontaly (not verticaly). This means that the tables should be united by adding the data to columns and not rows. I hope...

Hi Jal! If it won't work I will post it to the reports section of this forum maybe someone there can help me! Thank you so much for your help! Just wanted to ask you in LBconnections table how could align the amount to the middle (3rd column)? And is there a way to give a number format to the...

Hi Everyone! I have converted a txt file to access. The problem is that in some of the columns there are spaces in front of numbers or characters. Someone please could show me how to make a query which removes these unwanted spaces before or/and after. As I am very new to access please explain...

Thank you so much! This is what I wanted! And what command will delete those rows where the given field is blank?

Hi Jal! Sorry for replying just now. I have been very busy lately. I will try to make the report during the weekend. Then I will presumably post about my findings! Thank you!

Hi there Everyone! I am very new to access so please explain me detailed the solution if you can help. I have the following problem: There is one field which contains many types of data (blank, numeric, string). I would like to make very simple query which deletes all the rows which are...

Hi All! Thank you for the ideas and oppinions. You know convinced me that 65 mb is not too much... Thank you!

Hi Everybody! Thank you for your comments. I have found the problem, but it really makes me very sad. When I started to create this database the first and most important issue was to be very user friendly because it will be used by REALLY computer illiterate people. So I have added a graphical...

Hi! Rural Guy! Yes, I did. But maybe I did not split properly the file. Here are the steps what I did: 1. Create the back-end: Tools » Database Utilities » Database Splitter 2. Prepare the original mdb file for mde: - Compact and repair - Decompile - Debug the code - Compact and...

Hi there Everyone! I am very new to Access, and I already got a lot of help on this forum while creating a database. So I have now my very nice database and I would like to split it to front-end and back-end database. The front-end would be an mde extension file. Actually I have already split...

Hi Jal! Thank you for your help! I will try to do that today. I will get you back with the result! Thank you so much!

Hi Jal! Thanks to your advice I was able to make a report for the Form2. The problem is that I would desperately need one for the mainform as well. In the mainform report I would like to display everything: the searched codenumber, the name of the company and beneath the listbox. Is that too...

Hi Jal! Thank you so much for the advice! It is working very good. The problem was that it was left one Important_0 parameter in the query, and the method you told me showed it where it was. It seems that the application (your application) as almost fully functional. There is one more thing I...