Search results for query: *

Hi, I have a MySQL database which looks like this: ID | NAME | DESCRIPTION | DRESSINGS ---------------------------------------------------------------------------------------------------------------- ham_and_cheese | Ham and Cheese | A sandwich with...

Hi, Access 2010, split database, multi user (no more than 10) at a time, they access through the front end, the database is saved as accde format I have a user form which is used to log absence records at my place of work, the form can be accessed by clicking a button from the main form, or...

Hi, I have a database that is used to log absences, I use the users network login to identify them and display data that is held about them within a specific table (tblusers), the database has started to fail when it opens for a random select group. the main form is a bound form using this...

Hi, I have a form that is used to enter absence records, fairly basic but does the job for that. When the form loads it loads to a new record, when an employee is chosen it checks the database to find all open records, these are then displayed in a sub form, this works fine. If a record is...

Hi, I am trying to import data into excel and I am using a DAO copy function to get the data, but I am having a problem with dates, this is what i have tried with the sql string 'strSQL = "SELECT * FROM tblBPData WHERE ((Date)=date()-4);" ' this works 'strSQL = "SELECT * FROM " & TableName & "...

HI, I am struggling with getting automation of ie with vba, I have done it many times with url's and clicking links on a page, this is a different problem Everytime I go to a certain URL, it pops up straightaway with a Login and password box, all coding I have tried just halts at this point...

Hi, I have a continuous form which displays a count of all records for all LineManagers in my database, I have six different columns depending on the AbsenceType's (sick, awol, late, etc) If I double click on the total column the desired form opens up with all the records for the LineManager...

Hi, I have this formula which works nearly. =SUMPRODUCT((Source!$B$2:$B$5000=A13)*(ISNUMBER(SEARCH(B13,Source!$D$2:$D$5000))*(Source!$F$2:$F$5000))) this sums all values in F range if D and B range values are matched. However I have some instances of double counting, see below the 2 cells in...

HI, I am using the formula below to get some data for me. {=SUMPRODUCT((Source!$B$2:$B$5000=A14)*(ISNUMBER(SEARCH(B14,Source!$D$2:$D$5000)))*(Source!$F$2:$F$5000))} I have noticed a limitation in the formula and I can't figure out how to get the data. I am searching for this string within...

Hi, I am using the following code successfully to send an email without any assistance every 2 hours to the distribution list strHTML = "Hi," & vbCrLf _ & "The Data has been updated, please remember that there may be changes as this has been automatically generated." & vbCrLf & vbCrLf _...

HI, I am using a textbox to enter a value and a list box is then filtered on the data entered in the textbox, it works fine the first time when I run through the userform, then I always get a permission denied error in this code Private Sub FilterList(iCtrl As Long, sText As String) Dim iRow...

Hi, I am using the formula below to calculate number of people in on any given hour...

Hi, I am using this formula successfully to calcualte all data in column BB for each day, H1-AL1 have my sheets names in. =SUMPRODUCT(SUMIF(INDIRECT("'"&$H$1:$AL$1&"'!a2:a500"),$B2,INDIRECT("'"&$H$1:$AL$1&"'!bb2:bb500"))) I need to adjust it to sum all data in bb it AZ has a "T", but i...

Hi, I am using the code below With objie .Visible = True Do While .Busy Or .ReadyState <> 4: DoEvents: Loop With .document.forms("aspnetForm") .ctl00_MainContent_txtSiteHistoryStartDate.Value = sdate .ctl00_MainContent_txtSiteHistoryEndDate.Value = edate...

Hi, I am trying to copy a range of cells in an excel sheet, the range contains data and charts. Windows(wrname).Activate Sheets("sheet1").Activate Range("a1:w46").Select Range("a1:w46").CopyPicture XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlPicture AppActivate ppt.Name...

Hi, I have to work out when an email would be out of SLA. I need to be able to display a date and time 12 WORKING hours before the current date and time. my working hours are Monday 08:00 21:00 Tuesday 08:00 21:00 Wednesday 08:00 21:00 Thursday 08:00 21:00 Friday...

hi, the below coding is part of an IE automation script. If objie Is Nothing Then 'page isn't open yet 'create new IE instance Set objie = GetNewIE 'make IE window visible With objie Do While .Busy Or .ReadyState <> 4: DoEvents: Loop .Visible = True With...

Hi, I am looking for a betterway than vlookup's to find matches or differences in names from 2 sets of columns. Column A has the name from one system Column B has the name from another system is it possible to compare the lists and show all possible matches for each name from one of the...

Hi, I have the following lines within a module to create a record on a website i use. Application.Wait Now() + TimeValue("00:00:01") .Document.forms("savereq").elements("df_49").selectedindex = 26 ' account code i have a problem whereby the powers that be change the "selectedindex"...

Hi, I am using this formula =SUMPRODUCT((OFFSET(Data!$D$2,0,0,COUNTA(Data!$D$2:$D$4000))=$A5)*(OFFSET(Data!$E$2,0,0,COUNTA(Data!$E$2:$E$4000))=$B$2)*(OFFSET(Data!$G$2,0,0,COUNTA(Data!$G$2:$G$4000))=C$4)) to get the data based on a selection within a data validation cell (b2) how can i get...