Search results

Hi I have an access 2000 database with split back end / front end. Each user has an mde file, which sits locally on their pc, my pc has Access 2003. I currently have aroung 25 users I have 5 pcs (at last count..!) - two with Access 2003 and three with Access 2000 - these 5 pcs cannot view any...

Hi I have an adp with SQL 2000 backend. I am trying to execute a stored procedure via Visual Basic using: Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim stDocName As String DoCmd.SetWarnings (False) DoCmd.OpenStoredProcedure "Append" DoCmd.SetWarnings (True)...

Hi I have read a most of the posts that I have found and was looking for an answer on how best to manage the problem that I have! I have a report with 16 subreports which are linked by a company id number. Everything works OK when all the subreports have data, but when they don't a blank page...

Hi I have a problem that I can't seem to get around!. We have an external supplier that has decided to stop allowing .snp files through their firewall and won't change their policy. I have a report which is automatically attached to an email as .snp format which is stopped. I have tried with...

Hi I have a search form with 1 combo box and a button which when the user inputs an invoice number and clicks the button, a main form is opened for that particular record. The problem I have is to display an error message before the main form opens if the user has either left the combo box...

Hi I have a form and a linked subform which are linked by Purchase Order Number. When items have been delivered on the purchase order, the user should update the continuous subform with the number of items that have been delivered. This works fine. The problem I have is using an exit button...

Hi I have a continuous sub form linked to a main form. The fields on the subform are: Quantity Part Number Description Code Price I also have a total price field for each record the control source for this is =[Quantity]*[Unit Price]. I then have a text field to calculate the order total...

I have a field entitled call log time (a date and time field) and another one entitled action time (also a date and time field). I need to either e-mail or pop up a message box when the action time field is blank and the call has been open for 2 hours. I would then like reminder messages to be...

I have a main table/Form that stores personnel information. Each director requires access into the personnel files that relate to his area. I have created a switchboard with command buttons for each directors name and now want to apply passwords to these buttons so that when they are clicked...