Search results

Have you gone into the Import Specification to configure date info?

if you make the form the way it would normally be created you'll have the Refrigerant info in the master form and the cylinder info in the subform. If this is the way you have it set up, then the Refrigerant ID field should be filled in automatically to match the Refrigerant displaying on the...

open the csv file in wordpad/notepad (don't open in Excel). scroll down to the bottom and see if there are any empty rows. They'll look something like, "","","","" (the empty rows actually could be anywhere in the file, but probably at the end) If so remove the whole row and save the file, then...

I think you'd get more responses you you gave more info on what you're trying to accomplish. Maybe jdraw understands, but I don't. If you're getting a syntax error, it looks like you have quotes within quotes. Maybe they need changed to apostrophes? Don't know since I don't understand the big...

you're jumping out if there are no attachments. SaveAttachment varPaths ' remove here If Not IsArray(varPaths) Then Exit Sub Set olkApp = New Outlook.Application Set olkNamespace = olkApp.GetNamespace("MAPI") Set olkFolder = olkNamespace.GetDefaultFolder(olFolderInbox) Set olkMailItem =...

A junction table is to make a many to many relationship. Can each area have more than one bin, or one only? Can each bin have more than one location, or one only?

does one form open the other? Or are they just open at the same time. You can reference another form by forms("formname")!ControlName.property or Forms![formname]!ControlName.property, but if you are opening the other form you can send info to it using the OpenArgs parameter. In the onOpen event...

ComboBoxes can be set so they don't limit you to the table data. So if you can enter an item and it'll go into the table.

I answered this on the other forum.

find is for ADO recordsets. Is that what you're using? if you don't know specify your recordset with Dim r3 as adodb.recordset I can't remember which function requires it, but one of the find/seek functions requires the field to be indexed. DAO is the other method for recordsets and uses...

http://www.techonthenet.com/access/functions/date/format.php

Josh McDowell wrote a great book called "Evidence that demands a Verdict." It delves into archaeology, textual studies, etc. It is not light reading and is very scholarly. There are several other books which are written for a more casual reader. It's easy to criticize the Bible, but after doing...

There's an opening dialog box which contains a video and a getting started button. Have you tried these?

Camtasia. Latest version

I'm attaching files using Outlook, so don't know if there is a different way. Below is my code you may be able to figure out. I'm also sending HTML, but don't think you need to do that. Dim objMsg As Object Set objOutlook = CreateObject("Outlook.Application")...

Let it create the pdf and save it, then attach it to your email.

>>I want to use information from these two tables to create a third table that has a unique name (Site-Name) for a name and address combination For what purpose? Usually a calculated field is not to be stored in a table. If you can calculate it there is no need to store it. This can be easily...

see if this youtube helps you with the combobox lookup wizard https://www.youtube.com/watch?v=EdH1aIWaD-0

You have this line in two places, did you change them both?

>>it will not requery the form. you're telling it not to filter Me.FilterOn = False You are clearing the fields, but if you want it to requery after clearing the fields Me.FilterOn = True