Search results

Hi Everyone! I am quite new to Access/SQL and I hope you can help me. I have two tables: tbl_client_data tbl_calls The clientID is the foreign key in the tbl_calls. I make a search on the clients and their respective calls. Of course one client can have many calls (not the other way around)...

Hi there Everyone. I hope you can help me with this problem. I have three tables. Risk, Names and RiskAndNamesJunction table. I have the junction table because I have many to many relation (meaning many people can be connected to one risk and many risks can be connected to one people)...

Hi there Everyone! I have a very big problem, and I do not know how to solve it. I have a risk table containing risks and risk owners (many owners for one risk), meaning that I have two risk owners columns. What I would like to do is to connect both risk owner columns (containing the name IDs)...

Hi Everyone! I am pretty sure that my problem is very basic, and probably it is about connecting tables the right way, however the end result I would like to see it in a query. So here is my problem which is driving me mad. I have two tables: one contains the risks and the riskowners, the other...

Hi there Everyone! I have a problem and I just can't figure out the solution for it. Please try to help if you can. Actually the problem has two major parts: 1. I have a table (please see the attached file) with three columns. An autofield, a "Code" column and the "Description" column. The...

Hi there Everyone. I have attached a test file to show you what is my problem. So I have two tables. Risk table and Controls table. The controls are connected to the risks, so one risk can have many controls. The controls can be efficient or not efficient. I would like to make a query which will...

Hi there Everyone! I have a formula in the expression builder. The formula looks like this: DLookUp("[Vezeteknev]";"Names";"[NamesID] = " & [tbl_ICS_MainTable_Risk]![RiskOwner1]) However I would like to dllookup to join some fields I need (not only one). Something like: DLookUp("[Vezeteknev]"...

Hi there Everyone! I have a problem with the export of an access query to excel. I have a column in a table which has a row source from another table. I set the bound column to be a number but the display column is set to display a text. When I run the query I get the text to be displayed...

Hi there Everyone! Please try to help me as I am very desperate with my problem. I have an access database with a few tables and one query. In the query I have one calculated field (the last one). When I run the query everything runs smoothly, I get the desired results in the query. My problem...

Hi Everyone! I have a very basic problem but (as I am a beginner can't really solve it). I have a form with a textbox on it. The textbox is called txtAmount and it should display the number in currency format (the table column is set to currency format and the textbox itself is also set to...

Hi there Everyone! Althought I still did not get any answer to my previous question (post: http://www.access-programmers.co.uk/forums/showthread.php?t=212420) I am already having another problem. I have a list from which I can select the records. With the help of the VBA the fields fields on...

Hi there Everyone. Please help me as this problem is driving me mad. Here is the situation: I have a form. On the form I have an unbound list. By the help of a VBA code when I choose a record on the list (in my case risks) I get the likelihood and impact numbers of that particular risk. So far...

Hi Everyone! I have a make-table query with a parameter. I have a function which does the following: 1) ask for a new table name 2) start running the SQL query 3) the SQL query asks for a parameter 4) the new table is created with the new query data. Here is the code: Function CreateTable()...

Hi there Everyone. Please try to help me as I am having an annoying problem, and can't find the solution no matter how hard I try. My problem is the following: 1. I have a subform inside a form. The problem is that this subform has a grey border and I can't hide it. Please see the attached...

Hi there Everyone! As I am very new to access please try to help me if you can. I have a field (field A) which contains numbers. In the field B I would like to get the result of the subtraction of the last two numbers of field A. Example: field A.......field B 3...............-...

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

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