Search results for query: *

HI Roy-Vidar, Thanks for you response. Your method partially works. It has stopped the records from returning to the first record after the requery. However the requery does not work all the time. Some times the requery fails and the record stays on the form. If the user clicks the command...

Thanks Stephen for your reply. I don't think this would work because the record is being removed from the form in to another table. Then te requery is run to remove the ghost record from the form.

Hi All, I have a common problem which I can not seem to stop. after the requery the forms records return to the begining. This is annoying for the users when there are 1500+ records. I need the requery but I can not use bookmark with a requery. The following code is under the command button...

Hi hneal98, I'm using Access 2000. Cashe

Hi Scottian, Thanks for your perseverance. You are absolutely correct. I've used your DCount expression and it works great. These are the DCounts I'm now using: =DCount('[ContractorID]','[qryContracts]',"[End_Date]is null And [Con_Status]='Needs Contract'")...

Hi Scottian, The [ContractorID] field is a primary key field and therefore contains no nulls. I've looked in to the problem further and you should not use DCount for nulls as an objects control. Glalsop's post works great and gives me the correct total. Thanks for your help Cashe

Thanks Scottian and Gary for the fast response. I've tried both of your methods. I'm still getting the same results as before with Scottian's method. Gary's method works great and qives me the correct value. I will remember not to use DCount for counting Nulls. Cheers for your help Cashe :)

Hi All, I'm haveing real problems using DCount in a text box on a form to count nulls in tblAssigned. I need to count the nulls in the End_Date field. A null means that a contract is rolling and therefore no end date. The expression I'm using is...

Hi Nicsin, Thanks for your reply. I'm using the query grid and there are 3 more queries which are dependent on this one. The query is not in the vba program so I can't use the if block. Is this true? Thanks again Cahse

Hi abbazabba, I think this should work. Remove ascending from the Sort field on your query so that the query is not sorted on any field. Then go to the query properties and enter the name of the date field in the Order By property. The date field should be in ascending order when you open it...

Hi All, I'm trying to pass either Greater than 0 or Less than 0 to a query from a combobox on a form. It does not work because the query is looking for <0 as a value when it should be pulling up all negative numbers. The same is happening with >0. My combobox has two values the user can...

Hi Ken, The pay and procurement is one system and we want to integrate it with a payroll package so that it can take the available balances, expense information etc of each employee on a monthly basis run it through the payroll package (sage for example)which will calculate all the corect tax...

Hi All, This is just a general question. I'm looking to integrate my pay and procurement system (which I have built in Access 2K) with a standard pay roll package like Sage. I know there are other packages like Pegasus etc. Has any one done this before and who knows a good pay roll package...

Thanks Hans, That worked great. Time to sign myself up on the next VB course HAHA And Thankyou Foolio12 for getting me on to the right track :)

Hi Smitan, Thanks very much for the help. Well worth a star. I'm getting an error message: Run-time error 3011 The MS Jet database engine could not find the object 'C:\Documents and Settings\Mark\My Documents\Aaron Bott.xls. Make sure the object exists and that you spell its name and the...

Thanks Smitan, Is there an example I can look at. I'm not a programmer and am feeling out of depth here but I need to get this done to day. I'm having fun trying but starting to go blind now :) Thanks

Hi foolio12, I'm getting there. I can now import one workbook to an existing table &quot;tblTest&quot;. How do I get the program to loop through all the *.xls and create a new table for each of the 671 files. The table name should be the name of the workbook. I can then delete blanks and...

HI Foolio12, I could be way of the mark here. I'm in new water now. Thanks for the code but I can't seem to get it working (lack of experience) This is what I have: Private Sub ImportFiles_Click(directory As String) Dim currentFile As String 'Make sure we are in the right directory to...

Thanks for the reply foolio12, One problem the files are in the same format with the field names on row 2, however they do not all have the same range and have no unique identifier. I would need to import each into a separate table before manipulating them. The things a mess. Also this part is...

HI I have created a payment an invoice database to take over from excel spreadsheets. The problem is each contractor has a &quot;curent balance&quot; excel workbook. There are 671 work books to import into a temporary table. I only need Sheet1 of each workbook. All the workbooks are named...