Search results

I am fairing competent at using Visual Basic however this one thing has just come to me which I would like to utilise for a project and would like input if someone else has achieved this. Basically I would like to write my application and once it has been compiled etc and being used by a user...

I'm initially thinking it would be easier to do the loops using a 2 Dimensional array that way each permutation of the results would be help in the second portion: This way I can work with the loops a little easier. Essentially if I were to use a number range of 1 - 10; this would...

I'm looking to generate a series of numbers from a range of numbers to find out all the possible out comes for example number range 1-10 and if we wanted sequences of 3 numbers from the range they would be like 1,2,3 1,2,4 1,2,5 1,2,6 1,2,7 etc obviously I'm looping to do this via loops...

Well it could have technically been any but for this particular portion I just needed a way to code variable values into a record in a table; the previous methods I'd tried kept failing. TBH working with database's AND vba code isn't my forté, I'm more of a games programmer, i mainly use coded...

I've sorted it I was opening the inital connection in the wrong method the working code is: Set conn = CurrentProject.Connection Set rs = New ADODB.Recordset rs.Open "oCourses", conn, adOpenDynamic...

Set iCourses = CurrentDb.OpenRecordset("oCourses") With iCourses .AddNew !SessionDate = SessionNumber_WorkingDate !SessionTime = lstAt.ItemData(iTimeLoop - 1) .Update .Close End With Set iCourses = Nothing This is what I've currently got but doesn't seem to work within access, oCourses = table...

i'm working on a course booking system using access which is heavily coded using vb however I have stumbled onto something that a few eyes maybe able to put a bit of focus on. creating new course dates that follow a repetition: I have a form with a couple of combo boxes a list box and a...