Search results for query: *

Well with your help, I was able to find a way to enable and disable it upon saving. That fixed it. Thanks again! '------------------------------------ 'find Com ProgramID ' Dim lngRow As Long, objCOMAddin As COMAddIn 'lngRow = 1 'With objExcel.ActiveSheet 'For Each...

Thank you so much for your suggestion! Just so you know I'm on the up and up, my supervisor offhandedly gave me this challenge and said she was going to be interested to see how I crack it. Fun right? Ok so I've looked at the possibilty that it is a macro and found that it is actually an add on...

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

I apologize. Ok so here is why. I need to count the days between when amendments are submitted and when they are approved. My sample data above shows that there could be (multiple) rejections and submissions before an approval is given. Basically, I need to weed those out and only count the...

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

Sorry I don't mean to be confusing. So the table it's going into is a join table. A Log can have many grants and a grant can have many logs so this table I'm dumping this data into is a many to many table. So really it doesn't matter if the Log ID is in there because I'm just trying join...

Hi Andy, Ok so, the table that I'm putting this data in is relational to the LOG table that has LOGID as it's Primary Key. So the table I'm inserting this data into, LOGID is actually the foreign key for this table. Does that make sense? The LogID in THIS table could already be in there...

Thanks for the replies guys. Andy-I didn't notice I wasn't using strinactive, but I don't think it's the problem. Also, I'm not trying to overwrite any record. I'm trying to add to the table, but it is overwriting a record then adding the record in a new row. Duane-As always you are so...

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

I solved it. It had to do with the child and master links. I had to remove them in order for the subform to be refreshed to show the new records. See, something simple!

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

You are a genius! It helps so much to have it looked at by someone who hasn't analyzed it for what feels like a million hours. I'm going to give it a shot. I'll research my sql (kind of a newbie). Thank you again!

MajP, You are right there in my head! See I changed from that set up as I thought it was a waste of data. To be clear there is no need for an auto ID in that table right? For example: tblinvoiceLink InvoicelinkID ExpenditureID_fk ProjectID_fk 1 (Null)...

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 appreciate you pointing tht out, however, this is for work and since I work for the County they won't spring for that...WHICH is why me, a lowly paid employee gets to boggle my brain on it. I have tried suggesting them to use something such as a survey monkey program, but they want the people...

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

Thanks! I wasn't sure where to post it. I will move it there.

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