Search results for query: *

So, I'm not even sure how to approach this issue, but on a hunch I decided to try sendkeys hoping it would help. So far...no. So here's my issue. I created a database that sends auto-emails and at the same time saves an Excel workbook based on filtered information. The problem is, when I go...

Hi All, I'm trying to figure out if this is possible and I've gone round and round with the possible scenarios in and out of the access query. What I need to do is find the number of days between a submittal and an approval of a amendment. Now seems easy, but there's a catch, there could be...

Hi all, I'm sure this is something simple, but I just can't pinpoint it. I've searched the boards, googled to death and I don't see anything that stands out causing my rst.addnew to overwrite a random record while putting in the new record. Let me explain. I have a multiselect listbox that...

Hi all, I'm sure there is a simple solution to this (isn't there always?), but I have yet to find it. I have a main form that has a listbox containing records linking to main form. In the main form I have a subform that builds on the listbox actually LINKING the record to the mainform's...

Hi all, I've been going back and forth on the relationships I have for a particular database and am now desparate enough to bother anyone who will read/assist. I've got a database that needs to track financial transactions. Normally this would be cut and dry for me, but I think I've been...

I've been searching the boards for the best way to build my form and I came across a couple of suggestions from MajP about using an unbound combobox as a main form and then linking a couple more subforms linked to that. They were only snippits and such so I'm hoping for a little more...

Good Morning, I created a database about a year ago that generates ID numbers that are unique and have the string "PD-" in front. Here is my coding: Private Sub CreateNewIssue_Click() Dim JobIDprefix As String JobIDprefix = "PD-" DoCmd.ShowAllRecords 'in case it's filtered DoCmd.RunCommand...

Good Morning, I created a database about a year ago that generates ID numbers that are unique and have the string "PD-" in front. Here is my coding: Private Sub CreateNewIssue_Click() Dim JobIDprefix As String JobIDprefix = "PD-" DoCmd.ShowAllRecords 'in case it's filtered DoCmd.RunCommand...

Hi all, I'm hoping that you can help ease my very confused mind. While I am good at Access, I'm not very good with relationships and understanding them (no this is not a dating question :) I am building a database that tracks jobs given out. We have five types of jobs that can be assigned...

Hi all, I know we have addressed this issue in different forms, but I need some clarification. I currently have a database that has 8 users. It tracks jobs and assigns. The database is not open unless you need to add a job or update a job. The issue I am having is when the users are in it...

Good Morning, I have searched the forums for my question, I'm sure there is something I have missed. I have two pesky comboboxes that refuse to show the table contents. I have checked my options in both the form and the tables and cannot see where I have gone wrong. What I have is one table...

Hi all, I'm SUPER new to posting to a forum, but I have been using your site for sometime now and appreciate all your great advice. With that said. I am working on a workflow management db for my group. There are 3 admins and 4 users. I have it set up currently through the Access Security...