Search results

Thanks for going to the trouble of putting this together, i really appreciate it. I like the way it works but would prefer not to blank out the combos. I had a similar issue a few years back when I am sure I had a function that checked combo boxes and coloured them Red, but just wish I could...

My combos have nothing to do with Counties or Towns I was just using it as an example for ease of explaining. The first combo selection can have the same options in the second combo box hence why I want to inform the user visually rather than having to reset the second and subsequent ones. Also...

I have several 'Cascading' combo boxes on a form. So basically when you select an option from the first one, the next one displays only those values that that are valid to the first selection. I use queries to reference the combo boxes on the form to control the lists and all this works...

Thanks everyone for your replies but i managed to achieve what I wanted in Excel in the end with no complicated vba functions. Attached is all I wanted to do, it really didnt need to become so complicated. I then used the attached to update the Operation number in my table. Simples :)

Thanks for this I will try later tomorrow as in meetings all day today now

Thanks for this I will try later tomorrow as in meetings all day today now

The ERP system doesnt really come into question whilst I am doing this update as I am not updating the table itself as I have a copy of the data in local Access table. Once I have updated the Operations number field with the correct number then I will be replacing the whole table and at first...

Hi I have a table which has over 50 fields and I need to update the Operation number field with a new number putting them in reverse order. There are over 2000 unique codes all of which have multiple records with various different information. (This is how is it set up in the ERP system so I...

Thank you so much you are a genius. All working perfectly now thank you.;)

I have created a new function but the first line goes red and then when I run the debug it points at the iDay on the first line saying Expected: Optional I have no idea what this means, can you help me again please?

It was just as an example but I would need to also ensure I could use a variable for the specific day of the month as that is stored in the database. So for example the field called 'InvDayOfMonth' would need to be reference to find the Specific day of the month for the given invoice date...

I have a sales table with one of the fields is an invoice date. I need to run a query that will find the 30th of every month in the invoice date field. I have a function that will find the first day of the month but cannot find anything that will find a specific day of every month. This is my...

Got this working perfectly, thank you so much. I just need to incorporate it into all my other routines after changing them to functions now. :D:D:D:D:D:D:D:D:D

How do I get my procedure to return a Boolean value? I have tried Googling it but the results have just confused me even more. Can you help me with the vba please? This is one of my procedures that is being called Public Sub CreatePDF() On Error GoTo ErrorHandling ''' 'Create PDF Dispatch...

Thanks for both of these suggestions. Hopefully I will find a solution from these.

I am new at error handling and am trying to incorporate a little into my code. The issue I have is that I need to stop code running if there is an error in either of the two subroutines after they are called. I am trapping errors in the two sub routines and all is working perfectly there but...

Thanks Minty. Think I must be having a blonde moment today. God knows what I expected it to do when I clicked on it. Of course its a toggle stupid me :banghead: All is working as it should. Still hungover from new year me thinks :D

The 'Show all Macro Actions' button wont expand even though it is enabled (it is not greyed out, see screenshot attached). It doesn't work for any of my existing databases nor any new ones created. I am using Access 2013 and is was working up until recently but I dont know when this started as...

I did get the Dlookup working but I actually found another way as it wasn't the solution i needed in the end but thanks for helping out.

I am trying to get the correct syntax for the below code. DLookUp([CatCode],"LookupCategoryFormat","[LockNetPrice%Disc]= '" & True & "' AND [CatCode]= " & [Category Number] & "") Category Number and CatCode are both Numeric fields and LockNetPrice%Disc is a Yes/No field. I need it to return...