Search results

Sending email using VBA code - RESOLVED I wish to send one email to txtFillOutBy via her txtEmail using Outlook. Can anyone let me know if this will work in 2007? Current errors are undefined datatypes and data member not found. They're in red. This is the third block of code I've found on...

I get an error on line :confused:. I have an array of variables in my table and access them using the for loop, see :rolleyes:. It does not seem to be working at the moment. The online example I used wasn't doing the same thing. Am I not accessing it correctly? Private Sub btnBuild_Click() Dim...

I'm unable to Google an answer to this question. I have a form with a subform. I wish to use this subform by multiple forms. I want a textbox to equal a textbox from the subform. On a button click event I wish to move the value. This is what I found so far. Private Sub...

I've been unable to find what I'm looking for using Google. I have a form with a dozen fields bound to a table. I can cycle thru the records no problem. I also have another dozen fields I want populated whenever the key changes. This code is in the form_load event and works fine but I don't...

I've found 3 ways to use a variable for a date in the where clause. None of them return records. I've set breakpoints and the date is correct. MyRec.EOF is always true. Set MyRec = MyDB.OpenRecordset("Select heure " & _ "from archives " & _...

Situation: My client gets as receipt Excel files with data in 2 columns, 1 headers and 1 detail. I wish to load the detail into 1 Access table. I created a macro to flip the data so that I have 2 rows. The user can easily run this macro and save it before importing the spreadsheet. Problem...

I have a table with daily entries for employees. I want to display a 12-month calendar and highlight each day that contains an entry in the table. I considered 365 textboxes which is just wrong. I considered 12 subforms. I'm not sure about child forms. I considered inserted an Excel object...