Search results

Hey all. My case is that I have two combo boxes on a form and through the two and a command button I filter my values and get results on a new form (cascading combos). Up until now I am familiar with it. Now I want to be able when I am selecting values to leave one of the two combo boxes blank...

Hi, i was trying to do this but I don't exactly know how. On a form I would like to place a field which will automatically insert a text value and on the same time a numeric value on another field, every first day of a month, starting from this month and on. Something like this: Text field...

Hi, this is the situation. I have one table with some fields in it and based on this I want to design a form. On this form I want 2 combo boxes to do this:one to set a starting point for a field and another one to set the finishing point. Something like From this value to the other value, and...

Hey everybody. I have this form and on this form I've placed a list box which is set to multi select (if needed) several data. The problem appeared when I tried to add a command button which would duplicate all the fields of the record (with the exception of an autonumber field). All fields do...

Hi to everyone. I have this form which is used to insert specimen data. The form consists of certain combo boxes, fields etc. and works fine for individual insertions. The problem is that when I have to insert tons of data on which their only difference is their serial number (which is in this...

Hi to everyone. I work for a vet firm and I have this problem to resolve. On a form (based directly on a table) I have a field named species which is linked with an one to many relationship with anothet field from another table from where it gets its data. Now based on the selection I make from...

Hey to everyone. I have a main form and based on the selection I make from a combo box a subform opens. On the subform I have another combo box and I want the new selection to be displayed on the main form as well. And I don't know how...Does this has anything to do with the relationships? Can...

Hey ppl. I run a query based on a table and 2 other queries, and based on these I get Fcode field from the table and two number fields from the queries (one from each query). If the number is null in either of the fields (it can be null because the number comes from a count statement) I cannot...

Hey everyone. I have this situation: I work for a veterinary company and I have a project which includes 4 tables.The first one has a list of all of our clients.The other 3 are : a table for the year 2004, one for 2005 and one for 2006. Not every client visits us every year and I need a query...

Hey to all. I have this form in which I need according to a user selection to assign a picture and display it on the same form. Is this possible? How do I do this? Or can I display the picture to another form or a report based on the first form? Thanks in advance.

Hi to everyone. I was assigned to collect all data regarding the electronic equipment of the firm that I work for and I just need a push to start with :D My thought is to create 3 tables (one containing the users, another one containing info about the equipment and a third one to be something...

A bit big title I guess... Anyway I think you got the picture of what I am looking. I have this form and I link on that, through stLinkCriteria, two fields to open a form with a subform on it. Using this code: stLinkCriteria = "[Offer_No]= '" & Me![Offer_No] & "' AND [Species]= '" &...

I used the command button wizard to create a button to open a new form. The wizard only allows you to link just one field to another but I need to link two in order to filter out records...Searching through the site helped me discover the stLinkCriteria command and its usage;and now I have an...

Hey all. This is what I have to deal with. I have this form with subform. Based on a certain selection on the form the subform opens. And on the subform when I select a value a new subform must pop up. So far so good. Problem appears on the nested subform I get all matching results regardless of...

Hey all. Here's the prob: I am dealing with some offers. An offer composites of many different species and each species composites of many different proposals. (Form with subform and subform within the subform). An offer has a unique name but species can have the same name in different offers...

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