Search results

I have a continuous subform where I am facing an issue. The record source of the subform is included as Picture 1. The record source in datasheet view is Picture 2 The Subform in Form view is Picture 3. The problem I face is that the moment I start a new record in the sub form I get an error...

Yes. That was the reason. I got all users, including myself, to close the Front end files then deleted the record Thanks

How does one do that Arnel? I added me.requery in events tab of the main form under Gotfocus property - the only way I found out to requery the form. I still get the same error I guess deleting the affected row in the table is the key! How does one do that? Why can it it a simple deletion like...

I got this error in the main form/subform today In the table linked to the main form I see a record as below which seems to be the cause of the problem. The table linked to subform is as below I deleted the 2 entries in the sub form related table, ID 2470 and 2471 but am unable to...

I have not and dont know how to do it? Can you give some idea how to approach the problem. I want to do it myself if possible rather than have a solution straightaway

I have a form where the RecordSource is a query. In this query I have an expression as under and display this value of QryCode in the form using an unbound text field QryCode: IIF(Left([itemmastertbl].[internalcode],1) = "B" or Left([itemmastertbl].[internalcode],1) = "F"...

Thanks

The purpose of the query is to fetch the specifications from ItemMaster Table for each record in pending orders table. While doing this search, it should return the specifications of the first record of the item master table and not ADD an extra row as is happening now This is just a test...

I have compiled a simple DB to show the problem as enclosed. The qry results can be seen in the DB - see screenshot below. In SONo1 ItemCode 12345 appears only once but since it appears 2 times in item master, the query result has added an extra row and both rrecord OD's of ItemMaster can be...

I have a query wherein I need to fetch a field "Specifications" from a table "tblItemMaster" . The table is leftJoined to another table - tblPendingOrder and the key field is ItemCode in both tables. ItemCode is not a PK in either of the tables The issue is that ItemCode has duplicates in the...

Perfect! Looks so easy once you see it

Hi Vlad, This is perfect. For my learning, maybe I will need this in future, can we modify the message box such that the user can decide if he wants to amend the date or move to next field. Some thing like "EXW Date should be earlier! Would you like to correct it? Yes/No" If he types Y...

Hi Vlad The message box pops up in every condition 1. I kept C as 0 and entered dates of 12/Feb/21 as A and 12/Jan/21 as B. Diff is 30 days. With C being 0, msg box should not pop up and control should go to next record. The control goes to A and msg box pops up! I tested with positive C...

Hi Vlad This is some other file, not mine. Which of the forms should I look at. I tried to see the design of each , but could not see an event similar to mine

I dont know what mistake I am making I created a new TestDB when it was not working in my DB. The Test DB is enclosed. Cannot get it to work!

I added the code as below, does not work Private Sub EXWTargetDate_AfterUpdate() If DateDiff("d", [DelyReqd], [EXWTargetDate]) < ([TransitTime] + 10) Then Debug.Print "Recheck EXWTargetDate!" Me.EXWTargetDate.SetFocus End If End Sub

Hi Vlad, There is query in data source of the form to link tables 1 and 2. A and B come from Table 1 and C from Table 2. Therefore I have use me.C. I made a mistake. C is a number, not a date! "Put a break in the code and hover the mouse over each to see what you have." I am sorry I am not...

I have not used any message boxes in forms, only validations with inbuilt validation text. This time I want a customised message display without any validation! I have 2 bound date fields in a table - A and B. The form is bound to a query and a date C is available from another table When the...

I use a Mac and work on the server which is Windows and has Access (mac does not have Access). AltF11 throws up something else unfortunately:cautious:. Will try it later with a windows machine. Thanks for the input

Thanks. That was what I needed