Search results

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...

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...

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...

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, 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 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...

Hi, I am new to the forum and a Access user, I hoping to learn new things from others and provide some assistance where I can. GC1