Search results

Keep in mind this code is based off my notes and memory because I don't have access to the computer that this code is at right now. (there may be errors) If there's a better way, please let me know!! So the code works right now to do what I want it to do, with one last thing to figure out...

I have a table of data where an instance of a job is recorded each day (a kind of snapshot, if you will). Each record has a serial number recorded, as well as a few other fields. In most cases all the fields are identical. What I'm trying to create is a query that displays records where they...

Hello! I'm running into an issue where I'm trying to tie several queries together into a list one running total. I have six queries that pull data from the same table, but that meet specific criteria. What I was trying to accomplish was to have a 7th query count the records in each of the six...

Hello all, I'm struggling to understand how to accomplish this. At first I tried taking what I learned from two different forum posts and make it work, but I wasn't really sure what I was doing, and couldn't get anywhere. So I tried another aproach, and still wasn't able to get this working...

It's been a while since I've been here. I'm back at it again. I'm trying to teach myself by creating an Access database for my own personal use at home. Let's jump right into it. My project is a Chores/Rewards database for my wife and me to use for our three kids. The current goal I have...

I'm trying to come up with a function that can track how long a user of the DB has been inactive for, and once it reaches a determined limit, it would save and close the DB. At the moment I'm just playing around with a test database. I have a form with a button on it (Command0 - I didn't...

I wasn't sure if I should have added this here, or in the Excel section. I'm trying to do this in Excel, so here goes. In my spreadsheet I'm using VBA to modify the contents of a pivot table. It works really well, actually. However, I'm also trying to include three radio/option buttons that...

Update - I figured it out! Original message: Hey, I copied some vba code from elsewhere and I've been trying to modify it to fit my needs, but it's doesn't work as expected. When I step into the process I can see that it recognizes LastRow as being row 63, but then nothing else happens...

In your opinion what would be the easiest way to do this? I have two tables that in essence are identical. The big difference is that one is meant to be a finalized version of the other. For simplicity sake let’s call them “CurrentData” and “FinalData”, and the idea is to import data from an...

I have a ranking issue. I put together the below expression but I get "0" for every value - One of them should read "1". I have a text file linked to this database, and I'm trying to create a Query that will pull all of the data out of this text file, and add a rank if two of the values match...

Hey everyone, thanks for all your help in the past, I really appreciate it. It's helped me to grow and get better at understanding how DB's operate. Unfortunately, I recently (temporarily)took over a position that uses an Access database that does not work properly, and I'm stumpped on how to...

I'm trying to build a query that uses the information pulled from controls on a form called "CharacterCreation" - 2 of the controls are "Race" and "Class", and the form stores this data in a "Characters" table. The query needs to refer to the Characters table, and another table called...

Hello, I have a form that allows me to change the information for a list of personnel. On this form I have a list box that displays all the personnel in the list. There should never be more than 12-15 people in this list so it's an effective way of selecting records, however I can't figure out...

I’m working on a home project right now, and I have a desire to add some shapes (that would be recolored based on the user’s preference) to a form. I’ve searched this forum, and google, and found that drawing in Access is very limited. Each time it was mentioned people asked “What do you want...

I have run into trouble with an Access database. I didn't build this database I am merely trying to get it running for our office because we really think it could benefit us. I created a shorter version of the VBA code that is giving me trouble so I can troubleshoot it. What it is trying to...

Help! I need to refer to a query called "UserID Query" to create a record set!!! I thought this would work but it seems to be locking out my database... SQL = "[UserID Query]" Set rst = DBEngine(0)(0).OpenRecordset(SQL) It's possible that this is good and the error is elsewhere but at...

Hey all, I tend to explain to much so I’m going to just throw it out there. I need to produce a Data Integrity report that lists the users of a separate database and the count of errors that they make, separated by error type. Currently my query displays all the users who made errors, and...

I have two subroutines, each one references the type of form that the call is embedded in. However, one works and one doesn't. This works: Public Sub doLockout(ByRef theForm As Form, ByVal isLocked As Boolean) ' In separate shared module Dim ctl As Control For Each ctl In theForm.Controls...

Hello all, There are so many threads on here for emailing a PDF version of a report. I've put together a nearly complete bit of VBA that will do what I want - except for one thing. Basically I have a personnel table with an email field. I Also have a field that details if a person is...

Is this possible? I had this idea just now. I built a report that provides all of the open support tickets. My idea is to have a button (Which I called "WorkIssue_Button") that displays beside each record that is populated on the report... I need this button to be able to pull the ID number...