Search results

Hi to all. I think the subject besr describes what I want to do. I need something similar to what I can do in a report (create an unbound text box and then assign to it the value =1 and go to the running sum property) I think that it should be done easily or am I wrong? Kyriakos

I am not sure whether I posted in the right place but here's the deal: I have a form and a subform based on two tables and on the form I create a mathematical expression concerning a field which is based on another. The results are correct but of course the values in the table remain the same...

Hi to everyone. I have this form that my let's say clients should fill in. In one drop down list I need the client to be able to choose different currency i.e. euros or pounds or dollars. But I need the symbol to appear in the list and since the field is currency type I can't use the lookup...

Hi all. This is one has been troubling me for quite a while and once more I seek for solution to the right (hope so) place. I have imported from a Excel a table and based on that table I created a form. But when I try to add a combo box on the form header in order to search for a particular...

Ok here it is. I think it might be easy for most of you....I have one yes or no field on my form and I want some other fields who depend on that to be disabled all the time unless yes is pressed. When yes is pressed I want them to be enabled. How is thid possible? Thanks for looking at my post...

Hey everyone.This is the deal.I need to add to my form a command button that on the background runs an existing query gets the results and merges the names and addresses in that query with a word document that also already exists. I know how to do it manually, using tools in the database window...

Hey everyone...This is the situation. Is there a way to display records on a report that are sorted but not alphabetically (ascending or descendind) and not randomly but based on a sequence that i choose (and it is always the same...). Any clues??

Hey to everyone.Here's the problem: I need to display something that I think mathematically looks like this: STATUS_DATE < MOV_DATE < STATUS_OK_UNTIL Details : As it appears all 3 are date fields that belong to separate linked tables. I need to show all records that have a MOV_DATE between the...

Thanks MStef. That really helped me out....

Hi everyone. I have to run a query which takes data from two related tables...Here's the situation: the first table among others has a field named Code. The second one has (also among others) a field named tags. Many tags belong to a certain code. The problem is when I need to find how many tags...

Hi to all. I need to modify some existing error messages in my form so that I can create messages that will be more user friendly. I know that it is possible but searching for this issue was a bit confusing. How do I do this? Thanks in advance

Thanx Jon, that really worked. I thought, prior to testing that, that this would mean extra time to run the final query. In the end it is just a couple of seconds difference, so it's ok... Thanx once again.

Hi to everyone. I have this really complex query with numerous criteria on and I came upon this. The query (among other things) displays results from a test that was performed after a certain date (e.g. 31/12/2004). The query was displaying ok results until now but, I was told to not only get...

Ok here's the problrm. I've been searching the forum for this solution but I'm not quite sure if I got it right...I have this form that has two tables, which are linked by one field, but I need the common field to appear just once in the form for completion and on the same time the value I enter...

Hey all. I have this issue to solve. I made a report based on a very complex query and I now have to number each individual record within the report. I know it is something inside the properties, but I don't know what exactly. Help anyone?

I think the title describes best what I want to do. I need to send a letter to some lets say receivers, who fulfill certain criteria, and who appear in a data field in an access database. The letter is common for everyone with the difference of course of their address and name. I am sure this is...

Hey everyone, I've been busy creating a switchboard based on database, and I came across this issue. When I put a search through records command button, it seems that I can't use the wildcard characters, such as *,%,_ in order to find multiple records matching my criteria. Am I supposed to...

Oops sorry:D Figured that out!!!! Thanx anyway for that...Perhaps what I really need is much more complex.I have 2 connected tables, and I want the latest 2 (like I said) dates not of the entire table but for each event. I'm trying to combine SELECT TOP 2 and SELECT DISTINCT. Or so I...

Wayne, I have this field....let's say date field. And it has several dates concerning one event. It's something like: No Event Date 1 A 1/1/2002 2 A 1/1/2003 3 A...

Hey everyone. Does anyone know how can I make the latest 2 dates from a specific date field appear on the screen? What should I ask in the criteria?Is there a certain function or something else?