Recent content by pgp

Fixed! Got that fixed, thanks though

Hi, I have 2 tables quoteheader and quotetable. I have few fields whose data needs to be copied/imported from quotetable to quote header. I have quotenumber, quotedate,territory, product & csr field data to be copied to quoteheader table(which has the same fields too) When I try copy and...

Access 2002 might help? Hi ! Thanks for your response. So from what you suggest, will the speed show a considerable change if I go with access 2002 instead of 2000? I am currently working on access 2000. Im facing the same problem that you had mentioned. Its wierd that the form takes so long...

Still slow Hi, I did try almost all of your steps, but still access seems to be slow. I have windows 2000 on my PC. When I open the db - it opens the switchboard faster, but when I click on the buttons on the switchboard , it takes around 30-45 secs to open. But once the main form is opened...

Hi Ian, I think its the .Visible property - not the value that we assign. When I do Me.Cert1. ( It shud pull up all the valid properties that goes along with this) , in my case, it pulls up just "value"alone. Am I doing something wrong here?

Method/datamember not found Hi Ian, Thanks for your response. But unfortunately, it does not take .visible property . Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Description = "CRATE" Then Me.ItemNumber.Visible = False Me.Cert1.Visible = False Me.Cert2.Visible =...

Hi all, I have a a quote system DB in access developed which is about 10.5 MB in size. I have a main switchboard with 6 different buttons - taking to different forms. EVerytime I click on a button on the switchboard it takes a very long time before it opens the form. Is this because of the...

Hi all, Can I alter the different fields that I want to be displayed on the report depending on a particular field? Like- Say I have 2 records(1 & 2) and 4 fields - A,B,C & D (columns) Record 1 has field A as green and record 2 has field a as red if field A is green, I want to display only...

Hi all, I have a report that has a header , footer and a detail section The detail section has a subreport. The header and footer of the report pulls the data from a quote header table with quote number, cust info etc. For every quotenumber, there might be mroe than one line items. The...

Hi I want to have a commmand button on a form , which when I click , should open an excel spreadsheet that I already have. Once I do some calculations on the spreadsheet, can I grab those values to textboxes in the form and use it for calculations? Im not sure how to go about with this I...

Hi ! Thanks Wayne for your help!! It worked!! About the horizontal text box formatting - do I have to adjust the width property everytime the length of the string changes or? Thanks again

Hi , I have a report with a lot of text boxes displaying data from table. Problem 1: I have this one line Certs: COM MIL CMS9090 OV% 25 on the report where "Certs:" and "OV%" are both labels and others text boxes. Even though I have the Can shrink of all the text boxes to Yes - its not...

Hi, On my main form, I have a button which opens a report in print preview mode with values. Problem: 1. Is there a way I can go and edit my report? Like remove spaces etc. 2. Is theer a way to print the report of multiple pages as one single page report? Thanks in advance for any input

Hi, In relation to my previous posts, Right now, when I double click a record in my subform, it opens a new form without any values being populated. I tried creating a query to see if that can select the record Im trying to populate in my new form DoCmd.OpenForm "ChangeNomexQuote", , , "...

This is my doubleclick event code, My new form is ChangeNomexQuote, and in my subform - I have text18 as my lineitem number field. Private Sub Form_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "ChangeNomexQuote" stLinkCriteria = "[LineItem]="...