Search results for query: *

Hi All I have table showing previous years sales based, against month, format as below: PartnerID Type Jan Feb Mar 01113 YT-1 23 55 34 01113 YTD 33 45 33 01123 YT-1 44 55 43 01123 YTD 42 51 48 partner id is customer identification type YT-1 = last...

Hi All does anyone know how to output only the date (not time) on the afterupdate of a microsoft date control? THanks Ali

Hi all I am trying to use the following code in the onclick of a command button located on the master form to filter a subform to show records between the dates Me!frmVisitReport.Form.Filter = "AppointmentDate BETWEEN #'" & Text48 & "'# AND #'" & Text50 & "'#" Me!frmVisitReport.Form.FilterOn...

Hi All have a continuous form listing all customers, against each customer is a check box "Report", i m looking to use a command button to set every customers "Report" check box to false, can anyone help with the code to do every line not just one at a time... Thanks Ali

Hi All I have a table with below field names ID Type Jan Feb Mar Apr ..... Dec 001 YTD 12 15 13 20 001 Y-1 15 18 25 17 002 YTD 11 18 13 14 002 Y-1 15 65 11 17 003 YTD 17 18 33 11 003 Y-1 20 44 43 11...

Hi All I have a master form which i would like to total up all items entered in a continuous subform, could anyone help how i could total all values in the filtered continuous form and show it the master form?? THanks Ali

Hi All I have a main form "frmContactReport" with a text box called "Attendees". On click another form opens and it displays all contacts relevent to the current customer (master form with a continuous subform). what i would like to do is check next to the relevent customer contacts which in...

Hi all I have a customer report which at present i have a detail section showing multiple quotes against each customer, how can i add a similar detail section to the same report to show multiple contacts, at present i can only show the first contact, but each customer has several contacts...

Hi All I have a problem with importing an excel sheet into an access table. Problem i have is, it wont import because key violation errors, it notes "Null value in an auto-number field" So whether i enter number in this field in the excel sheet or not it still shows the error... Is there any...

Hi All Quite a simple one i think, i have query which shows the number of quotes closed against a particular reason for closure as below Code Qty PTH 10 OTH 5 I would like to add an additional column to show this qty as a percentage of the total quotes Code Qty % PTH 10 66 OTH...

Hi All Having some trouble trying to apply a filter to a subform using a combo box selection. I have the following code on the after update of the combo box, but which ever i select it just leaves the subform showing no records Dim rs As Object Me.frmInternalQuotesSubAll.Form.Filter=...

Hi All I have a query using the below sql SELECT DISTINCTROW InternalQuotes.CustomerID, Format$(InternalQuotes.InternalQuoteDate,'mmmm yyyy') AS [InternalQuoteDate By Month], InternalQuotes.InternalQuoteCurrency, Sum(InternalQuotes.InternalQuoteItemsQty) AS [Sum Of InternalQuoteItemsQty]...

Hi all I am lookin to generate a unique reference which uses the first 2 letters and last letter of the customer name, for example: customer name - British Gas, the code would extract BRS, and insert into a reference number. Can anyone offer any assistance, the rest of the code i have is...

Hi All I have a master form "followup" with continuos subform which is filtered by the master form to combo selection. Is it possible for the records of continuous subform to expand to accomodate the full text in the memo text box, at present they are at set sizes even when i check the can...

Hi All I have a query which contains notes from each stage of a quote, i would like to combine all the notes in one column is this possible? in simple terms at the moment the SQL i have is SELECT RFQTracker.RFQID, RFQTracker.RFQDetailInputNotes, RFQTracker.QuoteSummaryInputNotes...

Hi All I have a database which manages all the quotes we issue to our customers. Scenario - customer requests a requote Requirement - Use code to transfer data from an old revision to the new revision Setup - would like to to select a check box, with command button action to transfer all...

Hi All I recently asked how to implement a autonumber using code, which worked like a dream when creating a new record. now I tried using the below, same technique as with the abov, in an existing set of records but it does not work, i applied this in the default value property...

Hi All I have a database form which uses a tracking number RFQ, which is in the format xxxxx-x, these numbers are sequentual, at present we have to track manually and enter manually. I wanted to know if it is possible to step automatically based on the highest value previously entered...

Hi All I am slightly perplexed, i m using the below code to do a quick check that data is entered as it should, but it seems to bypass all the if and elseif statements and carries out the else statement regardless... can anyone offer any thoughts... Private Sub Command138_Click() On Error...

Hi All I have a query which i wnat to output all results even if count is null SELECT Sum((RFQTracker.PriceToHigh)*(-1)) AS SumOfPriceToHigh, Sum((RFQTracker.NoBid)*(-1)) AS SumOfNoBid, Sum((RFQTracker.ProjectCancelled)*(-1)) AS SumOfProjectCancelled, Sum((RFQTracker.OnHold)*(-1)) AS...