Search results

What do you mean?

Here is a bit of my Code, I was trying to change the property of a form from opening it from an other form but it doesn't work. What would be the apropriate method to do it? 'Open Drawing Detail form stLinkCriteria = "[ItemID]=" & Me![TxtParentItemID] DoCmd.OpenForm stDocName, , ...

Hi, I have a problem with one of my query, the query has 2 tables, the secondary field from Table2 is linked to the primary field of table1. The primary field Doesn't allow null Value The Secondary Field does allow null value which means that the Data in table 1 only concern Some of Table2's...

Hey Sammy, This is great. Thank you

How would it be possible to get all the element contained in a form invisible on the open event of the same Form without Setting each single object property to invisible...

Cheers Rural Guy, I see what you mean, This is a good idea.

Hi, I am not entirely sure where to look in the forum to answer this question, maybe someone can help me. I am just trying to create a simple code that would open a form if a user enter in a field a value that never has been entered before and open a other different form if the user enter a...

Thanks Pat.

In the TblPart, some items are related to a Tubing Diameter but not all of them. I will, therefore, have a TubingSize field in the TblPart which contains values only for the parts concerned, all the other records for that field are going to be null.

Ok...I think I may still include the query inside the relationship window to ease the understanding of the connection between some of the fields unless it is a major programmer mistake. I apologize for being a pain :o but I still got a problem with what I mentioned in the second last post...

Sounds pretty right to me unless I missed something. I am still on the learning curve myself but I have done a transaction Sample Database that you can find in the sample section of the forum if you haven't found it yet (The sample is far from being amazing but it could probably give you a good...

Concerning the Previous Post... Is it acceptable to include a Query inside the relationship window? I was thinking of linking the table PipeSize to a query of the TblItem.

Thanks OldSoftBoss, I forgot indeed to add the message box for the error handling. Now that I have added that part of the code I can finally see what's wrong with my form: You cannot add or change this record, a related record is required in "TblDrawing" When I fill the form FrmDrawing; a new...

Yep....The form name is correct, I don't know if it can be any help to solve this problem but here is a snapshop of the table concerned but I doubt it has something to do with it.

Cheers... Richary, you suggestion is working, your help is well apreciated. Thank you very much.

I am trying to write a code to allow the user to change the inputMask of a text box. The thing is I am not what syntax to use; My Vba is still pretty weak and i couldn't find any example, I can't see where is my mistake; help... Private Sub FrmOption_AfterUpdate() Select Case Me.FrmOption...

This is the code i am trying to use to add a record in one of my table. This is not working properly, the data are not added in the table and if I add a value directly in the table I can notice that the autonumber is incremented by the number of time I have pressed the button. It is like all...

tblLimit ------- payWeek workType (twentysix work types some common to all sites, some apply only to one or two sites) LimitSiteA (three sites) LimitSiteB LimitSiteC LimitAllSites So, several "faults" are immediately apparent: LimitAllSites is ALWAYS the sum of LimitSiteA+LimitSiteB+LimitSiteC...

Getting there (BOM) I have been searching the forum for BOM thread but could'nt find any similarities with the situation I am in just now. I took a snapshot of the table concerned for ease of understanding. I need to link Some Data to the 'Parent' Assembly only, therefore I am going to get...

Thank you so much Uncle Gizmo and Pat your help is beyond helpfull. I am going to apply this layout to my system. Pat as you advise I am going to merge TableAssembly and Tablepart as it is the proper way to design a BOM. Therefore, if I understood well, my relationship should be similar to...