Search results

Is the cmdCompactTables function called as a button on your "main menu?" or is it automatically executed when the Front End is opened by a user?

I just manually split my Access 2003 database into a backend and frontend per: http://support.microsoft.com/?kbid=304932 Both the Front End and Back End files are on the network server. I go into the network and open the Front end directly from the server. It's taking a good 15 seconds to open...

I looked into setting up automatic reminders for doing things from Access. I came across this method of assigning tasks from Outlook. I should be able to assign tasks to myself and recipients from this code. However, it activates the Microsoft security warning again. Is there another method to...

This topic gave great info on going from Access -> Word!!! But how do we create tables, borders, tabbing, etc, and other types of formatting in the Word Document from Access VB? As of right now it's still a very limiting feature as it can just import straight text only. Is there a way to have...

Is there a way to program this for Access 2003???

You're absolutely right, it's extremely inefficient since I have to go through the entire table. Luckily my table is only around 1200 entries so the search and matching is instantaneous. I actually am very unfamiliar with Visual Basic and Access so i don't know how to open a recordset on an SQL...

The count just lets me know that the loop is actually "working" going through checking all the entries. What i'm after is being able to grab all the data from a specific line item entry in the subform table for that specific main form order entry. And i found out that the line items ID of the...

Thanks for pointing that out. However, now that I finally get it to be able to grab values from the table in the sub form, i'm trying to match the Form number to the Subform Table ID number... and the FindFirst function is giving me this error: "Operation is not supported for this type of...

Each page on the main form stores information on an order in the sub-form table. So that the main form is tied to the table Item_Line by a Relationship. However, when I try to pull values from VB code, it doesn't give me all the information from this relationship. What's going on? I created...

I was also wondering the same thing. How would you pull or call out every single line or values in a subform from the mainform because when he does strLine2 = rst!product & rst!price Won't this just grab the first line of the value Product & Price? Shouldn't there be some way to go...

Nothing happens when i use port 587. My smtp server doesn't recognize these ports maybe?

Now a new problem I started running into was trying to used the CDO to non-company emails such as yahoo, gmail, etc. When I type in a gmail address for auto email i get Run-time Error.... The server rejected one or more recipient addresses. The server response was: 550 5.7.1. Unable to relay...

Thanks JR! That worked like a charm!

Late binding seems awesome, I have implemented it and it works, but i don't quite understand from the code how passing parameters into the CDO function would not need the CDO 1.21 library. Can anyone clarify how this modification bypasses needing to actually reference the library? Also, how am...

I have a shipping form where the user fills out To, From, Address, Tracking #'s, etc. and in it is a sub form that contains a table of all the items ordered and shipped I'm trying to do a message box that pops up if not all items are shipped. ie. items shipped < items ordered Item_Line_sub is...

I'd really like to know how you did this as I want to do the same thing.

No one knows?

How do you do that?

I'm not too familiar with using Reports in Access, so I tried playing around with it but it seems Reports pull up all Form entries in a list or some arbitrarily chosen format in design wizard or whatever format one composes. I don't have any issues going from Forms -> Reports -> PDF (Lebans)...

It seems like this Security Evader software is referring to the Outlook security prompt when you try to use it to send out emails. There seems to be a general method on these forums of using the CDO 1.21 library to send out emails using the SMTP server and thus avoiding the Outlook security prompt.