Search results

Wrong idea for all the wrong reasons ;) If you intend to head for disaster, you most definitely should not offer tables to illiterate users ;) Create a form. RV

Export your data into a text file. Open the text file using whatever applic you want to. Search the forum, similar questions have been asked quite often. RV

Why? There is no reason to use separate tables... RV

You're suffering from data corruption. Have a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=113209 RV

Date() + Me.Interval, whereas Interval is the name of the control on your form where the user enters the interval. RV

The If statement should start on a new line: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim intResponse As Integer Dim strMsg As String strMsg = "Do you wish to save changes?" intResponse = MsgBox(strMsg, vbYesNo + vbExclamation, "Save Changes") If intResponse = vbNo Then Me.Undo Else...

Put this code in the Before Update event of your form: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim intResponse As Integer Dim strMsg As String strMsg = "Do you wish to save changes?" intResponse = MsgBox(strMsg, vbYesNo + vbExclamation, "Save Changes") If intResponse...

Guess you didn't understand my reply.... You'll simply have to provide the full path to export your xls file to, you haven't got much of a choice ;) However, you can create a treeview that enables you to select the folder you want to store your file to. RV

Add your button to the form in design view. A wizard will be started, just select the appropiate categories and actions. Rv

You can achieve this in multiple ways, using combinations of the Left, Mid, Right, Len and Format functions. FYI, similar questions have been asked quite often on the forum. Rv

Logically, you do need to specify the full path. As for bypassing error messages, that's definitely not a good reason to use macro's instead of VBA ;) RV

You need to use two separate conditions, one to compare on months and one to compare against the current year. RV

If you're referring to Dutch players, Agger is actually Danish ;) RV

Create a query including all dates. Save your query. Create a report based on the query. Now, create a form with either a list box including all months or with an unbound text box to enter a specific month. Put a button on the form to open the report (follow the wizard). Now, amend the On...

Yes. Simply add a condition to your query. Create a form where users can input a due date and a status. Set both text fields to unbound (as in they are not based on a column in an underlying table/query). Put both fields in the header of your form. Next, create a query. Add conditions...

Your code is incorrect. You're referring to a non-existing column partno whereas your column is named Part No Change your code into Me.description = DLookup("[description]", "table2", "[Part No] = '" & Me.PartNo & "'") RV

As for your second question, use a list box rather than a combo box. RV

MoveLast moves to the last record in your recordset hence you cannot move to a next record, as there isn't any, hence the error. Anyway, you're on the wrong track. MoveLast moves to the last record in a recordset, which is not necessarily the last entry in your table. To retrieve the last...

Your query is incorrect. Open your query in SQL view and replace your SQL by SELECT [Projects Data].*, [Project Due Date].* FROM [Projects Data] INNER JOIN [Project Due Date] ON [Projects Data].ProjectID = [Project Due Date].ProjectID WHERE [Project Due Date].[Project Due Date] = [Project Due...

What puzzles me a bit, to be frankly honest, is that normally you basically can accomplish what you're after by using a (as in one) query. That is, there is a dependency between the different statuses, for instance, status2 can not start if status1 has not been completed. Are you storing your...