Search results

Hi vbaInet! Thank you for your quick reply. I do not have such field as Stand. How can I search for it? Unfortunatelly my boss want everything from excel. My efforts to explain him that excel is not a database and access is lot more suitable for this were in vain. :( So I have to build access...

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 Kiwiman and vbaInet! Thank you very very much for your replies! I tryed Kiwimans solution and it worked! Thank you for it! However I still have 2 questions, if you can please help me. 1. I do not understand one thing. When I click the export to excel after selecting the save path there is...

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

Please try to help if you can!!! :(

Hi vapid2323! I need it unbounded as I have other data which are query data and cannot bound them to the list selection. I would need it unbounded! Please try to help if you can! I really do not understand why I cannot set the format to currency... :mad: :confused:

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 spikepl! Finally I managed and got it working! Thank you so much for your help! Thank you!!!

Hi Spikepl! Thank you very much for your help! I already learned a lot! However (as I am a beginner) I still have problems. The question is: "And in the AfterUpdate event of the List0, you need to requery the subform, for your newest selection to show up"... what do you mean by I need to...

Hi Spikepl! I changed the IDs and normalized the tables as you advised. However, my problem still persists. On the control tab I see all the controls, and not only those which belong to the selected risk on the listbox. Please help me to proceed further. (Please find attached the new Example...

Hi Spikepl! I have textfiled for the IDs because I want to have IDs which look like R1, R2....R99 and so on. Those are the IDs.. Spoole.. your link is good however it is about using parameters. What I would like is a list and selecting by clicking.

This is my problem... How could I set the relationship between the list and the subform? This is my question as well. How could I get the subform to 'realize' which record is selected on the list, so it will show only those controls which are related to the selected risk. As I am quite new 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...

Please try to help me if you can, as I would like to show the database to my bosses and I can't before it's not complete. Thank you very much in advance!

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 Lagbolt! As I wrote in my post. The code is working properly. My problem is that I would like to simplify the code. Instead of manually typing in the name of the table, the code should automatically name the new table the SQL parameter. Please someone help me! Thank you!

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 Trevor! Thank you for very much for the reply! It helped a lot! Thank you!

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