Search results

Hi, My apologies .....I should be more careful with my explanations... Anyway your code works or rather performs the action that I want. By pressing Ok, the user has decided that he/she has read the message(message will be become more explicit, thanks for the advice) and is happy to...

Hi all, (I am using A03) I've looked into this issue using the search facility but I havent managed to find suitable assistance. I am checking the options in an option group. I am hoping that the user is made aware that the options have not been toggled. Given the option using vbOKCancel...

My apologies... :( I did try that but to no avail. I was wondering whether I would have to include a field name within the brackets. Anyhow thanks for replying. Much appreciated. :)

Hi, I am trying to apply an adapted function/module (from this site) to a textbox that I have created in a report, but with no luck. Can someone assist me? Thanks :confused:

Hi, Sorry for the delay.... Got around the problem in another way. Rather than have the user enter all the data before the On Update was triggered, I set up a little routine (make table query) that would check the ID and the status of the ID being inputted. I based the input form on a...

Ok...will do so tomorrow....thanks for the offer.

Hi, I have also tried this code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim lngCount As Long Dim strCriteria As String strCriteria = [Status] = "Active" strCriteria = strCriteria And [ID] = Me.[ID] Debug.Print strCriteria lngCount = DCount("*", "XXXX", strCriteria)...

Hi, I have amended my conditions. It is still two fields that I want to check. They are the ID and I also want it to check the text in a particular field (rather than the Y/N toggle). Private Sub Form_BeforeUpdate(Cancel As Integer) Dim lngCount As Long Dim strCriteria As String...

Hi, Tried this code and still it did not work!

Hi, I am having problems with the code. Are you still available to help me out?:confused:

Hi, the code worked, however it disabled my undo button which would have reset all the fields in the form. Also because I cant reset I have to close the form, and when I look at the table the entries have been saved. This code is only advising me that a duplicate exists but does not prevent...

Hi, I've checked many other posts regarding this same issue but I'm still having probs. I would prefer a Before Update event procedure. The code I'm using is : If DCount("*", "tbl_XXX", "[ID]="" & "[NOM]= Y") > 0 Then where tbl_XXX is the table being updated [ID] is one of the fields...

Hi, Grateful for advice I have a table with different fields, lets say field A and Field B Field A can have duplicates Field B is a y/n toggle I would like a constraint which prevents two records having identical data in those two fields. Thanks

Hi, John, the filtering works a treat but its what I want to do with the filtered records later that I'm having problems with. What I eventually want done is that I can tag the filtered records and assign it to a covering reference number. 1. I filter my database using this filtered method...

Thanks....I'll read it now and see whether I can adapt it..

Hi all, This is perhaps a deviation from my previous post and which i thought was getting me nowhere. Anyhow my current problem right now is : I have a main form and a subform. The subform is based on a query (whuch is based on a number of related tables. The purpose of the subform is to...

Hi, I am attaching sample database. Grateful for advice: ____________________ frm_LPO The main form is where enter data related to the covering reference i.e. A No.etc. In the subform within I enter the items bought. ________________________________________________ frm_DeptPV...

Hi, already have ... but I dont think its what I want! but we'll research it again.. Thanks

Hi Gemma, I am trying to assign a number of invoices to a cover reference which I will enter in the main Form... I am preparing a sample of what I'm doin so I can post it... i'll be preparing it in A03.. Thanks

Hi VilaRestal, Thanks, yes that would be great. so far the idea is to 1. select an invoice. 2. Those records which do not match the supplier for that record would either be hidden. 3. I could then select from those invoices that i would want to select. 4. a reset button to reselect those...