Search results

I have a piece of code which uses For Each Control to loop through a piece of code for each control on my form. However, I want to be able to limit it to certain controls on the form now. Worst comes to worst I'll stick the code in a module and pass the control name to the function but I'd...

I'm currently looking for a NAS drive for use a sa media server, but since I have a few requirements I thought I'd make a post here to see if anyone knows of one which suits me rather than me flicking through pages and pages of technical specs and forums to check the compatibility of each one...

Don't think much explaination is needed here. I have a database which opens other databases via command line and uses the /x modifier to run a macro upon opening (which ends with the Quit command). This database loops through a recordset on a timer and every 10 mins it checks the modified...

As part of my work to automate a set of daily processes currently manually run across a few dozen databases I am working on removing any prompts form emailing reports / queries. The code I am using will be at the end of this post. It consists of 2 functions, SendEmail (which works fine) and...

Hi guys! I have a big selection of databases, each with macros which have to be run on a daily basis. What I am looking to do is to create a new database and use that to launch the macros within the other databases in turn. However, I also have the concern of poor hardware so I don't want...

I am using MS Access to automate a process which involves opening 2 files. The files in question are .ws files which windows knows the application to open it with (it's a file containing settings to be used with IBM's Personal Communications workstation software). I am trying to find a way...

I am working on an MI database to hold work receieved & completed across multiple teams. All work completed is recorded in a table against members of staff, the TeamID of the member of staff links them to another table (via a staff details table to make it a many-one-many relationship) where...

Right, This is my second attempt at writing this post as my first one just rambled on about the database I am building. Attached is a screen-print of the database I am working on. It tracks work received and processed on a daily basis across multiple teams. Some teams track figures at a...

So I'm working on a new database to replace about 50 interlinked spreadsheets which are currently used. I am designing a simple data input form, I won't go into the details of the relationships / structure I have setup as that's not the issue here but basically I am using a continuous form...

OK, I may need a fresh set of eyes here (or a fresh brain). I have a simple search form to search for a member of staff in my database. It has 3 controls, employee number, forename and surname. These 3 controls directly relate to 3 fields in the table (all text fields). Once you have...

I have a spreadsheet with 13 worksheet (12 months & the 13th worksheet for a user guide). Each of the 12 month worksheets follows the same template, B2:K2 contain field names. I need to export a years worth of data from 2 tables in a 1 to many relationship (1 - staff data, Many - Breach data...

Hello, I am having issues with a VBA recordset: Set r = db.OpenRecordset("SELECT tblHolidays.DateBooked, sum(tblHolidays.TotalHours) AS SumOfTotalHours " & _ "FROM (tblHolidays INNER JOIN tblStaff ON tblStaff.Name = tblHolidays.Name) " & _ "HAVING tblHolidays.DateBooked = #" &...