Search results

Hey everyone! I have some tables that I am updating from DB2 that I have linked in Access. I run macros to get those to update and all that and the tables are then used for various things. My question is, is it possible to schedule a macro to run say, Saturday's at midnight? I would like the...

Somewhere on here...I don't recall the thread.

Hey everyone! Here's the thing....I have some code below that works GREAT for emailing a canned message to someone over Lotus Notes....but there are a couple of problems... 1. It doesn't email to multiple people. I've tried unsuccessfully. 2. I need to attach a report that I have generated...

Sorry I didn't post this yesterday but I figured out how to get it done. I used the "DISTINCT" feature after all and since there were multiple groupings, it worked out great.

The situation does not allow a redesign of the database.

Okay, this one has been a pill for me. I just plainly am sick of trying to work with it because every theory I have is a dead end road. I have a table with employees on it. They are identified by an employee code. BUT, there is also what is called a dependent code on it. Each employee can...

I new that was a resolution but I wanted to try and get away from doing another table....oh well....

The company that I work for has a badge database... If I can get release on it, I'll help you out.

Okay, here's the thing. I have a customer table...in it, the customer can exist multiple times but with ONLY ONE item type that they're purchasing. That being said, a customer can have multiple item types but cannot have more than one item type of "11". See what I mean? I want to be able to...

Thanks very much...I got it to work perfectly using: [forms]![PullFromText]![txt_pulltest] I put this in the criteria for the query and put that SQL into the record source of the form.

Hey everyone, thanks for taking a look at this! I really do appreciate it. Here's the situation... I have one form that contains customer information. They have a customer id and a contract effective date. I have another form with payment information that has customer id and contract...

Not a big deal. I'm sure it's somewhere...I'll research.

Genious...pure genious... I love this forum

This code works great but what is the property called where I can edit the "from" line? I want to be able to set it so it comes from say, "ClientServices@yourcompany.com" instead of being from the person that's running it.

HA HA! Nevermind, forgot the comma....didn't even dawn on me.

See below for what I have. Am I missing a reference of some kind? Private Sub btn_insert_Click() On Error GoTo Err_btn_insert_Click Dim SQL as String Conn as connection Set conn = CurrentProject.Connection SQL = "INSERT INTO Emplids (Empl) values ('" & Me.txtSearchBox & "') " conn.Execute...

By the way, here's my form.

I'm trying to do a query where I enter a value (say, a primary key) into a text box and then click a button and the results come up...but...I can't find the data grid tool. Is there one? Also, how do I tell the button to pull from that text box and query based on what's in there? I'm so used...

I want to insert a record into a table that's value is in a text box on my form. When I click the "Insert" button, I want that value to go to said field in the table... Private Sub btn_insert_Click() On Error GoTo Err_btn_insert_Click DoCmd.GoToRecord , , acNewRec Exit_btn_insert_Click...

Yes, I realized that a second ago....so, I queried based on max date and then again to get that other column. Worked like a gem.