Search results

Hi, That's a good call, I've stripped out all unnecessary stuff from my backend and attached a sample of what's left. So tbl_main has the amount we received and the date we received it tlk_located has the dates that we performed various actions, the important one being the date we...

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 don't know how I would identify what has been newly appended. My append query just appends everything from tbl_outbound, and the delete query deletes everything from the same table. The queries are run by the timer event of one of my forms, and since 3-4 people have it open there's a...

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...

Thanks vbaInet, I'll colour the text rather than the background for now and perhaps look at a continuous form as an alterrnative later on. I've done some tinkering and realised that none of the display options I select for a datasheet register. For example in design view I select all gridlines...

I'm no expert, but hopefully I can set you on the right track. For problem 1 I would set up a query that pulls in whatever fields you want to be viewable in your notes view. You would need to set the criteria to check what has been selected on your form. For examples the notesID may have the...

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...

Thanks both for your responses. I'll look to implement Jack's suggestion within Spike's guidelines. Which event should I be working with to run code when the FE has closed the connection to the BE?

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...

I think you would need something more like this iif(nz([date reqd],"")="", date required, date reqd) Nz function returns the value after the comma if it finds a null value, null is not the same as ""

Providing an example for anybody who happens to find this from Google. Original code: Me.txt_totalEntries = DCount("trust2PK", "tbl_main", "Trust2PK >0") Me.txt_totalEntries2 = DSum("amountRefunded", "tbl_main", "Trust2PK >0") Me.txt_unworkedEntries = DCount("trust2PK", "tbl_main"...

Thanks vbaInet, very helpful as always. I'll take a look at those 2 methods. I started doing the summary page yesterday using DCount and it's working fine so far. Thanks to David as well, I won't need a record of these details, I just need a view of progress we've made on the work being done...

That's kind of how I was thinking of recordsets. Pretty much everything I've done in Access to date has been through unbound forms as I found it easier to get things done that way at first. So I've got pretty comfortable with using recordsets. The trouble is I think I'm missing out on some of...

I suspect I was using the DLOOKUP wrong... I was using it to pull a version number for the application from a field and display it at the bottom of the main form. It was the only detail in the table and was ony used for that, but took a good 3-4 seconds to populate. I switched to using a...

I've used DCount on a form before to display a single piece of data and I noticed that it was really slow. It took maybe 3 or 4 seconds to populate the box after the form loaded... Is that typical or did I maybe use it wrong? I'll take a look at the options available when I'm back in work...

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...

Tried that and it works perfectly. Thanks for your help

Thanks Gina, I'll give that a go today. Sorry for the slow reply, I made the thread just as I was leaving work and all but forgot about work issues until I got back in the office :)

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...

That sounds good, definitely bit cleaner to implement/maintain than the way I was thinking of. Thanks for your help on this one... Not that you'll remember :)