Recent content by MrBen101

Hello there! Is this for a telemarketing database? If so I've got loads that I used to make for Coca Cola (before I ran away) that I can upload for you. PM me if you want me to post them here. Ben

I'VE DONE IT!! For completeness here's what I came up with. Any improvements please let me know! Private Sub Command3_Click() Dim DB As Database Dim rst As Recordset Dim X As Integer Dim SID As Integer Dim WeekY As Integer Dim NoToRemove As Integer Dim NoToAdd As Integer Dim NewValue...

Hi there. I'm close, just struggling turning this: 'sqlNewValue = "SELECT [Patients Waiting] " _ ' & "FROM tbl1stAttempt " _ ' & "WHERE [Weeks Waited] = 52 " _ ' & "AND [WeeksSinceApr06] =...

Hi Pat. Thanks for replying. Unfortunately I'm not able to join the tables as the patients to add and the patients to remove are both added/removed to the same field in my main table, but one at Week 52 and 0. I did it that way as it was the only way I knew how to get the desired results...

Afternoon All! Quick question, but it's got me stumped so I'm hoping there's a Genius out there who can help me out. What I have is a table "tbl1stAttempt" with my initial data. I've put this into an array "varArray" I have an SQL statement sqlNewValue3 = "SELECT [Patients Waiting] "...

Ok, I've got my array now, fully populated et al. Set DB = CurrentDb Set rst = DB.OpenRecordset("tbl1stAttempt") intArrayCount = 0 intCounter = 3 intArrayCount2 = rst.RecordCount varArray = rst.GetRows(intArrayCount2) rst.MoveFirst How do I perform...

Unfortunately I need to loop through the records one at a time to perform the calculations. Would it be better to get the records into the array first then calculate on them?

Hello there, that was a speedy reply, thanks! I've got that in there already With rst .MoveLast .GetRows .MoveFirst Doesn't appear to work, just gives me the first record from the table :confused: I need to get the info into the array, then perform various...

Afternoon All! I really need your help with this one, been going round in circles for ages now! I've got a DB which simulates future waiting lists. This works absolutely fine, it's just extremely slow, 15 minutes to complete process. What I need to do is change from the SQL statements I use...

Hello there! I'm probably being stupid here, but I'm really struggling with two nested For ... Next loops. The DB I have is a waiting list simulator. It has an amount of people waiting in 53 weekly brackets (0 to 52), for each Specialty (19 of them). It takes the starting point from another DB...