Search results

Hi, Usually you send attachments in one of two ways: 1. Via Outlook 2. Via SMTP For more examples you may want to search the forums with these keywords "Attachment", "CDO", "SMTP", "Outlook". About the embedded Excel Object... I don't think you can do that with the most recent Office version. A...

G'd evening, It is not a good idea to have a form and sub form based on the same table. What you may want to do is add a new table to store the album name and any other information. the Second table will store the images. Then you can easily link your tables. With the tables linked you can set...

G'd evening, First off, you need to normalize your tables, respect (any) naming convention for your objects. Once you finish fixing these issues you can start working on your GUI. As far as your db is, even if you get to solve the problem at hand, it will give you more work than it deserves. I...

G'd evening, Is not just a pain but also way too limited. If you want to try something different you may want to try mine. see under the free section. EDIT: Link fixed :) Shame on me :o Thanks a lot Galaxiom

Have you tried Application.CurrentProject.Path

G'd evening, I really can't help you with macros, but i guess would be easier to use the Windows backup tool or use vba for total flexibility. something like this: Private Sub ExporTables() Dim tbl As TableDef For Each tbl In CurrentDb.TableDefs If (tbl.Connect) <> "" Then If (tbl.Name) <>...

G'd evening, Is not clear to me what are you're after. I don't see the need to loop through all form's controls when afterupdate/dirty/change and several others may work for you. In a normal context you will need an event for each one of the controls that belong to the UnitGroup. What you...

G'd evening, Do you get any rows by running your SELECT query from the query editor with the same parameters you have in your form? SELECT tblPacsfreeform.ID, tblPacsfreeform.[Request ID]...

G'd evening, You also may want to add spaces to your concatenated string like this SQLobsoleteperc = "SELECT tblDateObs.DateObs, tblStatisticRef.RefPercObsolete " & _ "FROM tblDateObs LEFT JOIN tblStatisticRef ON tblDateObs.DateID = tblStatisticRef.DateID " & _ "GROUP BY...

G'd morning! In addition to what Michael suggested, i guess you may want to take a look at my "MS Access Automation" document. G'd luck

G'd Morning, You can get all contacts from Outlook in several ways: 1. Manually export all your contacts from Outlook 2. Link your Address Book to Access 3. Automate from VBA. Manually export: This is ok if you don't want to keep your Address book in Sync with Access Link Outlook Address book...

remove the reference to Microsoft XML, 6.0 and add a reference to Microsoft XML, 4.0, that should solve the problem. Regardless of the windows version, if the referenced libraries exist they should work. I'd just tested the code and it's working. If you still have problems, debug your code line...

G'd morning, Answering your questions in the same order: 1. No 2. Yes 3. Yes In a little more detail: 1. You don't need another database. Even if you already have one with all the information related to their experience, you can link that table to your db. The difference is that you will need...

I just made a few changes on your tables and added a couple of forms. I guess that if you build an easy GUI your user will appreciate it. Like i said before one form for all is not a good idea. Back to your tables. I've found a couple of columns in several tables related to "last contact". That...

I tried your file and the vba code and worked for me. the only significant difference is that i replace the acImportDelim with acImportFixed. so i ended up with this: Dim strFile As String strFile = "c:ToAccess.txt" DoCmd.TransferText acImportFixed, "NotepadCustomSpecs", "tblText"...

Martyh, The documents you zipped are pictures. No body will create a table and fill it by hand to test it. If you can provide the notepad file with few lines enough to test will be easier to assist you.

G'd morning, Can you post a copy with just a few lines of the file your working on? Looks to me that the separator "|" makes empty columns in the automatic process. When you do it by hand you skip those columns. am i right?

Helllo and Welcome! If you really novice, i wouldn't use outlook (yet!) to send emails. I would do it with access own tools. here, Paul Eugin and Nigel Shaw posted a neat solution to send emails to a group from a table via Access. G'd luck

G'd morning Sam, I don't understand what your app is doing, but if all what you want is to requery your cmbSubjective then do so. If (Me.Combo42 = 1) Then Forms![frmCommitments]![cmbSubjective].requery Me.IncomeSubjective = DLookup("[Subjective]", "tblIncomeSubjective", "[ExpSubjective]='" &...

G'd evening Steve, At one point or another we all had faced the same situation. In some cases you can solve it and some others don't. As you know when you add any foreign control to access you do it by picking one from the ActiveX controls' list or by manually adding a reference. In both cases a...