Search results

The following code copies the current database and zips it up. However this does not work if the directory name has spaces in it, e.g. ...Documents and Settings\Desktop... Dim fs Dim strSource 'As String Dim strTarget 'As String Dim strLocation As String ‘MAKE COPY OF DATABASE Set fs =...

I am trying to create a rather unusual custom counter. Any ideas will be greatly appreciated. I have already tried ideas based on the Microsoft Article 210194 (Formerly (Q210194) and I can't get it to work. The process is this: 1. Someone creates a record that is essentially details of a...

I have found an interesting occurrence where Access doesn't seem to be able to read a null value in a combo box. The operation is: one makes a selection in a combo box and then clicks a button to open a form and find a record based on the value in the combo box. However if someone opens the...

Disable Mouse wheel (and other apps.) Yet more questions about disabling the retched mouse wheel. 1) This is a question about Microsoft Knowledge Base Article 278379, the one about turning off the mouse wheel in Access 2000. If anyone knows how this affects other applications, i.e...

:confused: I have a database called 'Central.mdb'. This database contains a table called 'tblEmployees' and every employees name is stored in it. 'tblEmployees' is linked into other databases using the linked table manager. In the other databases combo boxes use the tblEmployees as their...

:eek: I have a database that is used to log working hours. There are 4 fields: Project, Task and the start and end time fields. The task and project fields are combo boxes. I have made it so when someone selects a project only the relevent tasks for that project are available in the task...

I have an orders database. The main form gives the order numb., supplier, etc. The subform gives the order lines: quantity required, part number, cost, etc. The subform is linked to the main form on the order numb. field, and it is a continuous subform. I want add an unbound text box that gives...

I have a form that has several buttons, 3 of which use the DoCmd.SendObject action to send an eamil, (each email is diffent from the other). There may arise an instance when in operation a user needs to send 2 or 3 emails consecutively to different people. There is never a problem sending a...

I know the following would work if the 'End' field was in the form I am trying to open but its not. The 'End' field is in a subform of the form I am trying to open. The subform uses a different data source to the main form. DoCmd.OpenForm "LinkFm", , , "[End]>= Forms![menu]![Text10]" If...

I have a database that loggs the jobs each employer does each day. One can enter job details, a start time and an end time. I would like to prevent someone from entering a start time that is before the end time of the previous job. I have been trying to do this as a validation rule in the...

Help!!! I would like to make a form open based on two values. One value is in the form and the other value is in one of the subforms. Any ideas will be gratefully received.

My database contains the following code that saves the record and sends a report by email as an attached file using the SendObject command. My problem is that the database runs this code onceperfectly, and then it wont run it again. i have to close and reopen the database in order to get it to...

I have seen many examples of how to change the text colour of a field in a form on condition of say the value is >50 or the value = "Yes". But I cannot do this in a report. Any help will be gratefully received. Many thanks.

Please help! I am trying to run an OpenReport action in a macro based on a control that is in a subform. Normally, if the control was in a form I would use I would use [controlName]=[Forms]![FormName]![ControlName] as the where condation. I cannot work out how to point the where condition to the...