Search results

I posted an earlier question about an Access query export to Excel putting leading apostophe (') before all data. To remove them I thought I would use Find/Replace but the Apostophe is not recognised! Is there a way (programmatically) to remove the first character of each data entry in each...

I am exporting a query from Access 2000 to Excel 97 - 2000. - There are 4 columns (3 text fields and a number field). After exporting, the text fields data all display a leading apostrophe (') i.e Golf becomes 'Golf, Coil Pack becomes 'Coil Pack, the exported number field is OK. Why is this...

DOH :rolleyes: I had been 'Viewing' the results expecting to see '01/01/01' in each of the cells in the [StartDate] field. But you dont see the results until you 'Run' the query. I was thrown by seeing empty cells when I viewed. Which is exactly what I should be seeing. :rolleyes: Thanks...

I have already tried that SJ. This is in Access 97 Field: [StartDate] Table: [tblSubOrder] Update To: #01/01/01# Criteria: Is Null It doesn't update :confused:

I have a field [StartDate] that when the database was designed was not a 'Required' field. It now needs to be. However, there are 3500 blank entries that i would like to put some nominal date into (say 01/01/01) so that I can enforce the 'required' property. I have tried #01/01/01# in the...

should have done a search on forum first :rolleyes: Found answer straight away Compound Condition

I have a query with 2 date fields. I want to display results that show records with the field [ChaseUpDate] that are blank (Is Null) but only the blank ones that have a date < or = to todays date in the field [PaymentDueDate](<=Now()). If I put both the criteria on the same line I get nothing...

Thanks Mile-O-Phile So easy when you know how!!!! ;) NEL

How do I change the Record Source of a Form from a Command Button on the same Form? i.e. Form = frmA Record Source = qryA Click a button to change the Record Source, to: Form = frmA Record Source = qryB Thanks in advance NEL

Thanks Colin I checked the properties of the field, they were Short Date. However, I also had code running behind a 'New' button that added todays date into the date field and used Now() instead of Date(). Problem sorted Thanks ;)

I have a query that uses the BETWEEN and AND criteria in a DATE field to filter the records. I have a record that is dated 08/10/03. If I type that as the Start and the End date the query returns no records. If I type Between 07/10/03 and 09/10/03 the query returns the record. ??????????? Can...

Sorted Thanks both of you I always call my date fields Record_Date, Order_Date, etc. I was rushing this time. Never too late to teach an old dog new tricks!!:D Nelmo

I have created a form with an 'Add New' button that adds a new record, gives focus to the date field and fills in today's date, i.e. Forms!frmConcrete![Date] = Date(). However the date displayed is always 30/12/99. Any thoughts as to why? :confused: Thanks in advance Neil

Thanks for the reply and suggestion DB. I have found the cause of the problem. The user's PC shares two printers through a switch. An A0 Plotter and an A3/A4 inkjet. He had it defaulted to the plotter, default to the A3 and everything works fine. Is there any way to check in code if a...

I have a client/server application running on two pc's on a network. It is a simple order system. On the order form there is a print button to print preview the order. The front end is exactly the same on both pc's. However, on one when the print button is clicked the order is print previewed...

I am not sure if this is a query or VB problem. I would like a field in a query to display the results of the calculations on the following fields in a [Percentage] field. [REG YEAR] 1996, 1997, 1998 etc. [MILES] a value list "<2500", "2500-18000", "18000+" There are six possible outcomes...

When I run the following procedure the report always outputs to the Windows desktop. Dim stDocName As String Dim StFileName As String stDocName = "rptSiteOrders" StFileName = Forms!frmViewOrders!cmbSites & "." & "RTF" DoCmd.OutputTo acOutputReport, stDocName, acFormatRTF, StFileName...