Search results

Hi All, Been scratching my head and trawling through google for the last hour with no luck. I have a SQL query written for VBA but due to the length it covers more than one line: Sub refreshform() Dim xteam As Integer Dim sSQL As String xteam = InputBox(Prompt:="Team Number Please.")...

Hi All, Hope you can help me out here... Currently I have a VBS which when ran runs a macro in an Access database. My current VBS is : Option Explicit dim oaccess set oaccess = createobject("access.application") oaccess.opencurrentdatabase "C:\temp\qm data storage\Audit - TCF Master...

Hi All, Just looking for some assistance.... I have an access database which has an autorun which sets off before my team gets in in the morning using autoexec and schedualed task. The database goes through to almost 60 small databases (under 3mb each) and appends to a master table in the...

Hi all, Just looking for some wisdom and help. I currently have a report which has a field that has this formula: if((({GF_CALLDETAIL.CALL_TYPE})=3 or{GF_CALLDETAIL.CALL_TYPE}= 4) and (isnull({GF_CALLDETAIL.DIAL_DIGIT}) or length({GF_CALLDETAIL.DIAL_DIGIT})<3)) then 1 else 0 This works...

My company produces an update of sales each day for a month to date overview using SAS to generate a html intranet page which we can all view. Up until now I have been copying and pasting these SAS driven tables off the intranet, into excel and then linking the cells from the pasted table into...

Ok, the title doesnt do justice to the question but its tricky to capture the problem in a line. Attached is a simple DB that has been created for the purpose of managing holiday entitlment and booking for a small group of people. It also allows you to book appointments for each team leader...

Ok, so I have a workbook with 4 sheets, on one sheet I want to have a button that will sort data on a differing sheet. I wrote some VBA code and it didn't work, so I went back to basics and used the macro record and the code were virtually like for like, I took the code from the recorded macro...

Ok Guys, I have searched this forum and used google with not much luck... I have a database shared on a network which works fine. I am looking to add the feature to be able to track when network users go into the db. I;m not to concerend about finding out the changes, more importantly who...

OK, I won't profess to be an expert at access, I'm not in any way whatsoever. So I could really do with some help and direction! I have been given a access db which contains 2 tables, both tables have inforamtion/data in which I need to use, the only 1 thing common in both is that the ref...