Search results
-
A
Split database, SLOW performance
Hi, I run a FE/BE split database and have the speed issues. The Fe file is copied at each users computer and all the tables are linked to the be file using the UNC path to the be file. As the DB has grown, the speed is a major issue, specially when editing reports and queries in the fe, not so... -
A
Adding multiple records using form with incremental field values
You are right. Tools need skill too. Manipulation will not be easy. I need to understand the code first. Will try -
A
Adding multiple records using form with incremental field values
Yes, that would be better -
A
Adding multiple records using form with incremental field values
Super Arnel as always. You guessed my need so easily. This is exactly what I needed. I gave up trying to understand the vba code logic but it works perfectly in the test. The format of the form is split form which I have not used before. I wanted to add the Description of tblPricingGroup in... -
A
Adding multiple records using form with incremental field values
If this multi record feature is not available, user needs to add the cust code for each record, add the ID 1, for first record and then add the Correction MF ad applicable for this ID. For the next record, add the same custCode, ID 2 and the CorrectionMF for ID 2. he needs to do this for all the... -
A
Adding multiple records using form with incremental field values
Yes. For a new code, values have to be added in CorrectionMF field for all 16 ID's. So the 16 records will have same EndCustCode, Pricing GroupID from 1 to 16 and all cells of Correction MF blank. The user now has to enter all 16 values in the CorrectionMF field -
A
Adding multiple records using form with incremental field values
The problem is that the user needs to add these 16 records every time and it is not only time consuming but also is prone to errors! -
A
Adding multiple records using form with incremental field values
I have a continuous form based on a table "tblCustRFQCorrection" as below In the form when a enters a new EndCustCode, I would line the form to add 16 records with the same EndCustCode and PricingGroupID from 1 to 16 with blank CorrectionMF fields which the user will fill up If the End... -
A
Solved Using a Query and Table in form makes it uneditable
Hi June7, I wanted to change the selection of the drown down of bottom stitching and modified the SQL as below. I don't get any syntax errors but the drop down rows of cbo are unchanged. What is wrong with this code SELECT tblBagMasterWt.SewingCode, tblBagMasterWt.SewingType FROM... -
A
Solved Using a Query and Table in form makes it uneditable
Thanks June7. I dont know SQL but reading and understanding it in this case was not so difficult. Syntax maybe an issue in future. Will use this as base and develop. Thanks once again -
A
Solved Using a Query and Table in form makes it uneditable
Hi June7, This form is working perfectly. I was too happy that i got the whole routine working and did not try to understand many details. This, when I want to now develop something else on similar lines, I tried to understand the logic and have got stuck at a point See the query screen shot... -
A
On Focus event of Form
The UncoatedGDMID is stored in the table as it is used in many other queries and if it is a field in the query, I would need to recall this query i/o table making it slow. Hence the need to have the events to be able to store the results of the Dlookup's It seems having the 2 lines of code in a... -
A
On Focus event of Form
In other words I cannot add the 2 events anywhere such that when the form opens, these 2 events occur for all records I did try me.refresh and ,me.recordset.requery on load, on current events of the form, doesn't help -
A
On Focus event of Form
I tried . The unbound control has a dlookup as below and I could not include this in the query (record source of the form). I am unable to writeSQL for queries and can only do the Queries in Design view and hence the limitation and this workaround , if one can call it this... -
A
On Focus event of Form
I have 2 fields in a form which are supposed to store values when user enters data. The 2 events in after update event of the 2 fields (UncoatedGSMID and ) in the CoatingGSMID1 form are as below Me.UncoatedGSMID = Me.UnGSMID Me.CoatingGSMID1 = Me.CGSMID1 The events work fine. The problem is... -
A
Solved SubForm not refreshing after running Update Query using command button
This worked. Thanks Gasman. It requeries now I need to get rid of the error messages reg updation! How?