Search results

send the data base for further assistance

Try Private Sub Form_Open() Me.OrderBy="employee_name ASC" Me.OrderByOn = True End Sub

Refer this: http://www.access-programmers.co.uk/forums/showthread.php?t=218423&highlight=ribbon+menu+in+VBa+for+print

I that case i would be making fresh combo box after deleting this one

First Say Q is the query you want to make from Table T the code for the query as you mentioned for Q will BE SELECT * FROM T ORDER BY [column_animName] asc While report of a query, Use query Wizard which you will find on create Ribbon and give reference of query Q, which will populate the...

Just Hover Mouse over the Code using Breakpoint and see if the format of date is correct or not. It will be a clear picture to you.

Probably help you out if u b explain more what is in the list box and what does it need to do in same form.

Probably answer lies in the mdb it self, however you need to set up parent child link for what u want to display.

As per assumption u r asking the result displayed in screen to limit, then probably go to properties and limit to your required number.

It seems u need column to eaxtract in alphabetical order, query and add order by column name asc, If you provide the header and footer to your report it will b came through out the page when navigated.

It Will Be in Table Format and i am assuming you dont need A you Need Acc that is B: SELECT Acc, Sum(Int) AS CumInt FROM T1 GROUP BY Acc;

Do it in this order: SendObject - Report, RPTDailyReports RunCommand - Print Close - Report, RPTDailyReport

Steffen, Here is the Solution, you have joined on Parts for the query where u need unique colors, Which is not perfect as there are many to many relationship occurs, so suggest you to join on Parts and Color as well for the same. By this you 2 queries will be achieved: 1) Condition >=0 2)...

Could you send the tables by removieng confidential data and replacing with dummy details that will b a help?

Ur code must be calling on on close event also, here utill without seeing the code i cannot provide solution. It will b helpful if you provide the DB deleting all the informations data.

Why you want to use template for editing, append on email body macro instead for adding amount, it will be more easier than work it on it again..

You want to make table or query? quite dont understand what you need. Please explain thoroughly.

Here seems you want to send the mail individualy to customer as the msg is taking one customer name and sending one attachment to many email IDs. Quite confused here. Also setting up record set in SELECT query provide only email as it will be fast for query to run fetching one column only...

In that case i would be maintaining a audit table, which have records of PK of edited records and counter of number of times edited on PK. From there you can check if the PK counter is 2 then ask for password. But why you need to have password for 2nd time editing only?

Does it log in when you supply incorrect Password?