Recent content by GC1

Thanks everyone for your input, I now have a working solution.

Thank you arnelgp, much appreciated. This works perfectly.

Hi All, I am seeking some guidance on creating some VBA code to handle a process, I recently started to edit VBA and have had some fun creating a CRUD db. The next project is slightly different and if I have some assistance on the principles I can build what I need from there. I have trawled a...

Thanks @CJ_London I managed to pull something together from the similar posts in the end.

Good Day, I have followed a video and successfully created the code to import a spreadsheet into my DB. Being new to VBA I don’t really know what is going on and therefore unclear which elements of the code I need to change to meet my requirements. I hope someone could explain what is happening...

Thank you theDBguy, your code has worked, much appreciated :)

Good Day, I have a form which has a calculation however I only want the calculation to calculate when another text box has a value. At present when the form is loaded the calculation completes without there being a value. The calculated field (RemainingLife) is based on this...

Thanks Eugene-LS, this solved the problem :)

Hi, I am seeking some assistance to edit my VBA code to update boolean field I have in my table(201Assets). I have a working Delete button and I have copied the code and attempted to make some changes to instead of deleting the record, I would like a boolean field (AssetFlag) to be made True...

Hi, please could you advise where do I insert this?

Thanks, I don't intend on storing the data, this is to be exported into excel and used as part of a query in sql db through the user interface.

Thanks for this, Display Field Data Horizontally seems like the one I am after. I am guessing I need the loop to stop at 90 and start again on a new row? I wouldn't know where to start, let me make a start on a DB this week and go from there. Again, thanks for your input.

Hi, I have repeat job each month that could do with some automation. There are c1500 records (in excel) each having a unique value in column A and change each month and there is no sequence, I need to concatenate these into a field separated by "," every 90 records. I thought this could be...

Hi isladogs, HierarchyID - Indexed to No and Required also set to no I tried added the hiearchyID field to Sheet1 populated the value and still no joy. I used this as a trial, the pop screen referenced updating the 58 records but nothing is showing. UPDATE 1103_System INNER JOIN Sheet1 AS...

Hi All, I have a new small DB and there is table know as "1103_System", I have another import table know as Sheet1. Sheet1 is used to cleanse data then my plan is to append this data onto 1103_System. Most of the data appends without fail with the exception of a foreign key "HierarchyID" on...