Search results

Sorry. I used the wrong word It is split database and not split form

I am using a split form and the FE file is enclosed. I am not at liberty to share the BE file. I hope this will help in analysing the problem The form in question is "frmCustomerMaster"

When you say in another form in Design mode, what do you mean? Right now views are as under In the same form I added this code and got an error and on debugging get the error as below

did not work ! I turned both form and layout view to No and datasheet to yes. Still does not work

Manually from navigation window

Some forms do not open in the specified Default view like the one below. It always opens in the single form view. What could be the reason?

Thanks Arnel Where are these Dlookup commands added? I have never used this Update query before Will this be in the rowsource of these 2 new fields

The customer table 'tblCustMaster' has 2 fields - 'InlandCity' and 'DestPort' which are text fields. In the form I used cbo to select these names from the tblCityMaster. These were my initial foray in Access and did not realise future problems in this approach. Since the text fields are...

Unfortunately not. I tried. Got errors

I have a database of over a 1000 customers. It has the usual address information, I now also need to add shipping information - Sea Port used for shipping The City and country information unfortunately is text. Now to add the shipping information I created a table with all cities and ports...

Tks See enclosed. I think this is what you advised. With this logic, I still could not understand the below. I am sorry to bother you but I also want to learn at the same time The cbo "TopFoldType" captures "lengthID" from the mastertbl and this is joined to "Topfoldtype" in tblUserInput" so...

See enclosed- failed again. I have done these cbo multiple times. This query of course is far more complicated.

The other thing I could not understand is how is the data of cbo being saved in tbluserinput? The data source of the Form is the qry not to the tblUserinput cbo TopFoldType is linked to tblCutLength and captures the lengthID So how is the data of lengthID stored in the tbluseriput? Similarly in...

I feel very embarrassed:cry: in coming back to you This is posing new challenges at every edit stage After I edited the query, I added the fields in the form - Liner Type Liner GSM and weight. The cbo box does not capture the data. I double/triple checked the cbo boxes of Sewing code etc - it...

June7 Thanks. I created a new query,copied the old SQL, renamed it and changed all joins to include all records of tblUserinput and matching records of the rmasterdata. Looks good now. Tks

Just when I thought I had understood everything, comes a surprise! I wanted another element of a bag - Liner. I added 2 fields in the tblUserInput - LinerDesign which is a Numeric field to be linked to the data table LinerAddOn PK. The moment I added this table in the qry and linked the...

Perfect. All issues resolved Thank you much for bearing with me (y)🙏

1. Conditional Formatting - Done 2. Width range issue - Done 3. Current event VBA on the Form shows an error Private Sub Form_Current() If Not Me.NewRecord Then Me.WidthBag_AfterUpdate End Sub I tried Me.WidthBag_AfterUpdate() - still shows an error 4. I tried to follow your advise on the...

Good Morning 1. I have removed the Requery from VBA 2. I could not understand the conditional formatting correction. I applied the rule - see screenshot enclosed. Would appreciate some guidance. I checked online too. and saw videos too The values of sewing top and bottom are not visible for old...

DB enclosed