Search results

Hello to you both and thanks for your replies. The users pc's don't have a mapped network drive to the server where the database is stored. I have a pc without a mapped drive working fine (!). The pcs all run either XP or 2000. I've copied the mde but no success. Freakazeud - is a default...

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)...

Indeed it is - some of the comments could run onto more than one page, so it felt easier to have them as subreports for each question - I can then run each subreport individually if I need to find all the comments for an individual question. Thanks for persevering with me...!

I knew that I hadn't explained this well! The report is basically from a customer questionnaire. The main report includes the company id that the customer responded about and then all the subreports are customer comments about certain questions. Each one of these reports has the customer id...

Hi I did exactly what you were trying to do with a purchase order database, but ended up regretting moving stuff from one table to another (mainly due to user error). What I ended up doing was creating a field in my current table called date completed and then a command button on my form that...

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 Thanks for your reply - I must be missing the point again though - I have put the code behind my combo box, but now get an error message of User-defined type not defined for Dim db As DAO.Database Dim oTD As DAO.TableDef Dim counter As Integer Any more ideas??? Thanks Georgina

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...

Use the conditional formatting option - if you click on your field in the form design view and then format / conditional formatting you are able to change the background colour and font of the field. Took me ages to work this out, so very pleased to be able to pass this on! Thanks Georgina

Hi Dan Do you have a date field or autonumber on your subform datasource - you could use the max / min function in queries in order to find the latest status for the record? Georgina

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 If you put the code that Pat has suggested in the after update propoerty of the field that could change that will work. In my case, the 2 fields that a user may change were Quantity and Unit Price George

You wouldn't beleive how long I had been looking for that answer! - Thanks very much for your help

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 had the same problem and found this in the forum: http://www.mvps.org/access/forms/frm0024.htm It has helped me, hope it helps you too!

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...