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

Thanx...First time I 've heard of this function. Used it already...

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

Pat thanks for answering. Perhaps I wasn't clear enough (or my knowledge is limited enough :D ) . On my main form I would have to fill some fields.These values should on the same time be passed to a linked form and on a subform on that form....If I use the OpenArgs property then (if I got it...

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've changed the order and this is the code I used... stLinkCriteria = "[Offer_No]= " & "'" & Me.[Number_Offer] & "'" & " AND [Species]= '" & Me.[Species] & "'" Now I have noticed that the word AND does not turn into blue so there's certainly a syntax error. The matter is what exactly?

Pat thanx for replying. I've tried it like you said and it does not prompt me for error but I still can't get the wanted results. It is like as if only one criteria is linking. After I enter the AND operand it is as if I don't enter anything at all. I still getting matching results for the first...

Thanx for answering. But perhaps I wasn't clear enough. If I omit the offer number and link only the species field, it is working properly. If I add the offer number the problem occurs...And yes I have the field in my form :D BTW Now it says type mismatch but I can't figure out the reason. All...

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