Search results

Hi all, I've used a Union query in Access for the first time recently and I'm encountering some strange behaviour. The query is set up correctly, same number of columns, same data types etc and runs fine when I click it in the navigation panel. However, this query is the record source for a...

Hi, Hoping this is a simple one, my Google-Fu is letting me down today. I'm trying to debug an issue with a form that's misbehaving. One of my VBA functions isn't working quite right, so I'm adding breakpoints to figure out what's going wrong. The problem I'm having is that each time I enter...

Hi, I'm designing a form which will display a lot of employee information in a tabular layout. Users need the option to update a lot of these controls, but I want them to do that on a separate form. I'm wondering if VBA can determine the position of a clicked button within the tabular layout...

Hi, I've been asked to get some information from my database and I'm a bit stuck. I have a list of refunds in tbl_main and each one includes a dateReceived. I make a record in either tlk_located, tlk_unableToLocate or tlk_bulk depending on the outcome when we're trying to send the money back...

Hi, I have a database that contains details of payments returned to a bank account without sufficient information to identify who the money belongs to. The DB is used by a team of people to retrieve details of an individual entry and when they have figured out who the money should be sent...

Hi, I have a database that is used by managers to log activity of staff. We wanted to allow staff to write to the DB, but not allow them full access. We decided to accomplish this by adding a VBA function to an Excel sheet that they already use every day. It allows them to select a...

Hi, I'm using a datasheet in a database and have recently been asked to add some conditional formatting to certain entries. I've managed to do that, but I cannot for the life of tme figure out how to remove the white space between fields. See attached image for an example So far I have tried...

Hi, I've created some code to make a backup of my database backend. I've tested it and it seems to work fine, I just have some questions about it's use. Here's the code: Public Sub backupBackend() Dim TestFile As String Dim strReplFile As String Dim copyFromLocation As String Dim...

Hi, Just a general question that I can't find an answer to on Google... If I need to display various unrelated (in database terms) details from multiple tables on a single unbound form is it more efficient to make queries or to use recordsets? I'm making a form that includes a summary of...

Hi, I'm trying to make a sub form that displays the hours of an employee selected in a listbox. I've got most of it working but having a bit of an issue. The info for thre query is in 3 tables: tblStaff (name etc) tblShifts (start and end times for days that this employee works) tblDays (a...

Hi, I'm working on a database to store details of current employees and I'm a little stumped for the best way to approach part of it. For each person who works for our company, we would like to store details of which tasks they are trained to do. The list of tasks is quite long, possibly...

Hi, I'm having some trouble getting a query to work as desired and hope somebody can help out. I am setting up a database to hold staff details, and would like a query to show each member of staff's total hours and FTE. Staff name etc is in tblStaff Staff shift details are in tblShifts...

Hi, Tried searching/googling for this but can't find anything relevant... I have a couple of questions about datasheets. 1. I'd like to use a datasheet for some data entry. The bulk of my data entry will be through 'proper' forms but there are a couple of places in my app where using a...

Hi all, Having a wee issue that I hope is simple for somebody more experienced with this Access monster... I have a database that is used in our office. It is split with the backend stored on a network share. I need to make some updates, and to do maintenance I usually make a copy of the...

Hi, My manager wants to be able to implement a kind of punch card system for managing staff time. I'm thinking we could make a database that links to a folder in Outlook. Staff will be able to send an email to the inbox saying that they are, for example, going on a break at 10:50, and then...

Hi, I'm looking for a little advice on how to set up part of a database. I've been asked to make one to keep details of around 300 employees, including their shifts. Their shifts is the main thing that we will be pulling from the database as this is to be used for resource planning. The...

Hi, I have code that calls an append query and then a delete query as part of an import process. The queries were set up in the query design interface and are called by name in VBA. This works fine, but I wonder what options we have for error checking. I have turned off error message for this...

Hi, I recently made a database that we will use to allocate appointments between a team of up to 30 in 2 different sites. I have tested it with 10 people in the same site using it and have had no issues so far. One of our managers wants to know whether it is likely to cause issues with...

Hi, I have a database that is used to allocate appointments to our staff. It has 2 tables, one that lists the clients we need to call in that day, and another that stores details of each contact attempt. I'd like to design a query that find all clients who we have not dealt with so we can...

Hi, I've made a few posts here and got some help to get me this far, I'm looking for a couple of pointers. A quick rundown of what I'm doing: I have a table with a list of clients to contact in a 2 hour window. Some clients are marked as a priority and should be called first but could appear...