Search results

Hi I have been struggling for quite a wee while thinking the design of a part of my Database, it is maybe not that complex but seems quite difficult to me... :o I have different ASSEMBLIES made of differents PARTS (Bodies, Straps, Hinge, Screws...) and most of them are built on the same...

Hello, I have a strange problem: one of my comboboxe is looking up a column in one of my table. Some of the record can be duplicated so I decided to change SELECT to SELECT DISTINCT in my SQL for the row source but it doesn't seem to change anything. Is anybody's got an idea why?

Hi, Here is a snapshot of my relationship; I am not entirely sure i am doing it right. Got three tables linked together as shown (Drawing, Line Configuration, Line). My main form where I would enter the data would be link to the Drawing Table. Each drawing can have 1 to 6 lines, all lines...

Cheers wayneRyan, I have tried to refer to the column as you advised but it doesn't seem to work. I have used the following expression to define the criteria in a Dlookup function, "CasingID=forms.FrmLineDetail.CboCasing.column(0)"

Hi I have 4 Comboxes all Cascading from one an other and it's all working fine. My question is about My fourth combo boxe, It as two fields that the user can see when he selects the fourth comboboxe; pretty straightforward... I want the user to see the two fields on the form after using the...

Hello,I was wondering if anybody knew if it was posslble to show an aproximated value of a field with decimal records. I would like to see only integer values on my form.

Thanks Neileg, It is kind of obvious now,

Cheers Neileg, I am sorry if It sound stupid but how can i make it work by using a record for each line? Do I create a table With only the field line in it? I feel a bit confused.

Hi, I have a bit of a problem in the way i am thinking a part of the design of my database. I have some assembly used for offshore equipment, depending on the assembly, 1 to 5 lines can be run at the same time. I have attached a picture to make my question more understandable; i have got a...

Cheers guys for your advice, I have done what you have said but I am getting the following error now: Run time error '2448' You can't assign a value to this object

Hello, I have a text box bound to a Dlookup function which works pretty well. If the Dlookup return no value or 'null value' no values are displayed in the text box. I was trying to get the text box to show 0 if the dlookup function returned no value but I don't know if i am using the right...

Thanks RG, This is superb... Exactly what i was looking for. Cheers, Fred,

Well, the form i am trying to insert as a subform is a lookup form based on a query shown on the attached picture as 'The item in Stock query sheet'. Now, each time I am opening the 'allocation Status' form instead of being able to enter the parameter on the 'subform' I am being prompt to enter...

Hi, How don't know how stupid my question is but i was wondering if it was possible to insert a form inside an other form without linking them??? The reason for this is that the 'inserted' form would work as a 'search' form and could display usefull information for the main form to be filled...

I am sure I could but my system is quite complex and it is quite important that the summed values are return automaticly depending on two parameter visible on the open form. I mean even if aggregate functions are a bit slower, it seems that there easier to use and work fine for that purpose...

Thanks Scott, That was exactly what i was looking for. I was stuck for a little while because the query i was looking up was returning a sum and the look up function didn't seem to work that way. I, then, included the sum function in the lookup parameter and it 's working fine. Sorry for the...

I have been searching the web for quite a while now and I can't find any solution to my problem or my question if you prefer. I have got a query that runs with several parameters and return a single value. I wanted to know if it was possible to link that query to a single text box in a form...

Thanks Doc Man, I am going to have a look at it. Your reply is gonna be quite helpfull. Just for the information: I just added some event to a label to make it look like a command so it is sill a label...

Hi, I have got a small problem and maybe someone could advise me. I am creating a customised command button from a label button. The new button works fine but I can't apply the 'requery' function to it, if i do an error occures and i am being prompt to save the data first???? :confused: ...

I am not entirely sure that i am in the right place in the forum but my question is concerning updating data via a form so i hope it will be ok. I have a 'product' table linked to a 'batch received table' with a 1 to many relationship. I wanted the employee to fill the 'batch...