Recent content by ccondran08

Thanks for your reply arnelgp, i will give this a go.

I have found the following code from a google search that will copy an attachment from a record to a file location. This serves the purpose of what i am trying to do, however I would like to make some modifications which i am struggling to solve. I would like to reference a query of the table...

I have the following DCount formula in a text box on the main menu form (frm_Main_Menu) which works fine. However, there is a field in the query called "Date_Planned" and I have two text boxes called txt_Start_Date and txt_End_Date which is also on the main menu. I would to add to the formula...

Hi, hoping someone can make my day here and assist. I have a subform table that has a column called "Project" and lists all the project numbers. I have set up a Hyperlink on the field so that when the project number is selected is will open up a new form and transfer the existing hyperlink...

Brillant, worked like a charm.

Hoping someone can help me with this. I have set a field in my form to a hyperlink, the field is called 'EventID' and data in the field looks something like 'Event 12345'. I have put in the following on click event for the field ; Private Sub EventID_Click() Dim Audit As String Audit = Right...

After some persistence, I have finally solved this in case anyone is interested. My first problem was the at the Categories.NextID field was set to Text instead of number so I had to change this to Number so that the number could increment. Then I played around with the first line of the Before...

These are the macros that I have used which is straight from the article. The 'Before Change' works fine, it is the 'After Insert/After Update' that is the problem by not incrementing the '+1' ; Before Change If Updated("Category") Then Look Up A Record In Categories Where Condition =...

Thanks for your patience JHB, If you open up the Assets table and add in new item, then choose an item from the combo box in the "Category" field then click to the next record you will see that the AssetID field will concatenate the second column of the "Category" field with the "NextID" field...

Sorry about that, I was in a bit of a rush. If you look at the Asset table the AssetID field is supposed to auto populate with the next available number from the Categories table, incrementing from the NextID field. I have followed everything step by step from the instructions (Before Change...

Hi, I have just tried to work through the example below but it appears that the 'After Update' action isn't working. I have attached the file also. Any suggestions ...

Hi, I've searched high and low for this but still cant find anything. I have a main form (frm_Main_Menu) which has a Tab Control with a series of tabs. Inside one of the tabs is a subform (frm_Red_Green) with another Tab Control and inside one of the two tabs is another subform...

For some reason, it still didn't work...however, I have found a work around which will do the same job, which is to give the user the option of which priority the query should run in. Appreciate your help JHB. http://www.access-programmers.co.uk/forums/showthread.php?t=287721

Brilliant, thanks Galaxiom, works perfect. Thanks for you help.

Thanks for taking the time to look at this Galaxiom, however it is still not working. I'm getting the same error message as before. I have attached a copy of the file.