Search results

Yes it is safe to continue using Access for your front-end. The main difference developing in the VB environment is that it is more robust than the Access environment. VBA and VB are interchangeable. VB is an environment and VBA is the language used when programming VB, MS Office or other...

The .Attachments you are referring to is a read only value. For example you can use the .Attachments.Count to see how many attachments there are in your mail message. You can use the following to add attachements to your mail message. Dim objAttachment As Outlook.Attachment ' do all your...

You can create a global (module level) variable. In the On Open Event of the form, set the variable to True (there is data) and in the No_Data even set the variable to false. Then open the report if the time is 12:24:00. After the report is opened it will return either True or False. Then in...

The simpilest answer is to set the Record Selectors property of the subform to Yes. Then in Form View, click on the record you want to delete then right click on the record selector (it will be the square on the left of the record) and press the Delete button on your keyboard. You will be...

That is the correct syntax, so your problem is that the subform you created on teh main form is not called department. Check the properties of the subform (the one on that you created on the main form) and change the name of it to department.

If the data for the subform is in a separate table, you will also need to delete the data that has a relationship with the information on your main form. You can do two ways. The simpilest method is in the relationships window, set the referential integrity between the parent and child table...

Its looping because you have your OnTimer event to check the time and if its not "12:24:00" then it does the else statement which is send an email saying there is no report. It will keep looping because that is the only other choice you gave it to do. In an nested IF Statement, check to to...

If it is not the primary key (even though the Yes (No Duplicates) is set you can still enter duplicates if it is not the primary key) I really don't know for sure what it could be. I have had problems in the past with strange occurances of this type. Try copying the table (with data) or...

In your first query, select the Account Number field and the Date. Turn on the 'Totals' row from the View Menu. Ensure that the Totals for each of the fields says Group By. In the Date column, select Descending for the Sort. Create another query which will use the previous query you just...

make sure the the Primary Key is still the primary key. Sometimes when errors occur within the database, the primary key will be removed - I've had this happen a few times. Take a look at your table in design view to ensure the key next to the SSN field is still there.

I may have had the same problem. Using the SendObject method, everything would work fine the first time I sent the email, but it would not work after that unless I shut down the database. This is documented on Microsoft's Premier Support as being a bug with the SendObject method. To get...