Search results for query: *

I have a form with 2 subforms MainFrm Subfrm1 used as a tool bar with several buttons subfrm2 datasheet In subfrm1 I have a Toggle button, when i click it, I want subfrm2 to display all records and with another Toggle button I want to display only records where datefield has no date . Hope...

I have a Main form(Table1) with a subform (Table2) Table1 has a field named Counter(number) The subform has a hyperlink field (Link) that store's the path to files on the server if i have 3 hyperlink record in the subform I want to have the total of 3 showing in the Mainform's Counter field Can...

On a form I have a button named NCR and a check box named "View" On opening the form if the checkbox "View" is equal to -1 then button "NCR" is visible if = 0 then not visible How do I write this code up what I have so far is not working Private Sub Form_Open(Cancel As Integer) If View = -1...

as soon as I add more that 42 records to a table and try to open the table it freezes I can view it with forms but not open the table Has anyone got any ideas on this

I have a control button with the following code It opens a browse window where you search for the file and then it places the path into the field called filepath ( Hyperlink type field) but when I click the path in the field it does not link Please help Private Sub Command7_Click() Dim...

I am very new to Crystal reports and I creted a rpt based on an MS SQL table and the date field "TDATE" 25/08/2011 appears as a number on the report e.g. 20,110,825.00 I have created a formula that converts it into a date I got this formula from this site and it returns the number as a date on...

Thanky you Gruuuu that worked a treat, now this leads to another issue when I do a Print preview of Worksheet 2, I was expecting 1 page with 4 rows of data but instead I had an additional 69 blank pages, obviously picking up on all the formula cells. I assume Set Print area wont work as the...

Worksheet 1 is populate from another source. with 4 columns, No of rows vary each time populated ID Date Job Number Hours 1 1/01/2011 1000 5 2 2/01/2011 1000 3 3 3/01/2011 2000 13 4 5/02/2011 3000 7 On worksheet 2 I have added formula to select only Date, Job Number and Hours, colums e.g...

Ooops "C;\ should be strPath = "Z:\QUOTES & JOBS\JOBS\" & [JnAlpha] If Dir(strPath, vbDirectory) = "" Then to match the rest of the script being that Z is a mapped drive on the server. but you can use whatever drive letter you wish as long as it is constant.

Sorry i just read your second question. This works for me, a bit more complicated as i create a Job number folder and severl sub folders with in that. Hope this helps Private Sub Command121_Click() Dim strPath As String strPath = "C:\QUOTES & JOBS\JOBS\" & [JnAlpha] If...

I have similar based on a Job number field name JnAlpha which can be a number or text. It will open the Folder with the name of the number in the Job number field Hope this Helps This is my Private Sub Command113_Click() On Error GoTo ErrCommonDialog1 GetFileInformation...

I have a Table "PivotChart" populated with data for Pivot Charts The Pivot chart will be based on the jobno field Catagory fields in Pivot cart will be jobno, ScopeDescription.PercentDescription Data Fields in Chart will be Budget,Hrs,PercentAsHrs, I wish to display a chart for the first Job...

Thank you all for your replies I found the problem was not in my query. Some of the records were corrupt the records were corrupt.

I am trying to do a simple update query based on records match between 2 tables but when i run the qry I get the error nessage "The search key was not found in any record" UPDATE [labour detail admin copy] INNER JOIN [Temp tbl] ON [labour detail admin copy].LD_ID = [Temp tbl].[ID Number]...

I need to write a query to filter records that were created in the previous week, can you please help me with this one, Thanks in advance Each record has an OpenDate field.

I have connected to a database tables using ODBC but dates are stored as a number eg 20081024 I need to ceiw this in forms or reports as 24/10/2008 Can anyone help me with a fis on this Thanks in advance

Thank you both for your time I just worked out if I run get data it brings in the text as is without removing the preceeding zero's Thanks

Sorry I do not know what Import specification means

Sorry I misunderstood the question Im just using the macro as explained. I am open to suggestion.

Yes iam within a macro : Transfer Text Transfer Type: Import delimitted Table name : ReconDetail File name: C:/Txt File/ReconDetail.txt Has field names : No