Search results

There is a preference for DAO or ADO - which I don't really mind. Forms tight on screen boundaries might blow-out a little. When importing to 2007/2010 make sure in all the all tables, the Property Subdatasheet Name value is set to None rather than Auto. Personally, there are familiarity...

Ok. Running a procedure or Function over and over again is inefficient. what you need to establish (on most ocassions) Once if the image exists. Rarely does the image disappear. So it is better to run the ImageExist on a singular Record. I display records on a continuous form and a double...

whilst this might not be a solution - if you have a combibox on the parent and using this to slect records the screen is going to have re-render after selection. I work on the basis of the stillness principle. I have images lots - 25,000 but they are all the same size or on the web in a...

On Current on the Stock Entry Screen I have this to handle Images Function Originals_CurrentEntry() With CodeContextObject If IsNull(.[Orig Artist Ref]) Then Call SetPictureClear Else Call OriginalsFeatures Call GetPicture...

There is a real performance with persistancy. Another trick at the current project there are three main values Qty, Weight and Value, Index these and the system is much quicker as heavy analysis is done on them. Simon

I have the same problem and update the totals on transactional change. Simon

Store a flag InvoiceExists you only have to do it once. Simon

Write a separate query forcing Item Number into the Query with a Left Join and setting the ClosingInventory using NZ or is null = 0. Simon

Don't be afraid to store total values - SQL Server call these Cubes - but it is quicker to store total values from subsystems. I have thousands of records in sub-systems to do queries is inefficient - so total values are stored within the entry forms for these sub systems. I have a file with...

Also try persistancy - A file opened from the Front End eg A Menu Form hooked into a back-end table. Simon

With a Sring value with two characters 1=10, 2=20 etc - if you add a space before a single character and the value is treated as 1,2 etc Simon

I would always go for a Client / Server without reservation. Try to keep the database in a smallish volume and as high up the Directory structure as you can. If you want multi-user a Client Server is a good solution if you want remote Access then using a Terminal Server can use the same...

Can I make a suggestion. Create your Query as a Query and then qualify it using VBA. Then test your data and then put the Query statement into VBA. There is something that Access does that appears to optimise the Queries. You can also declare the Sql Statement as a string and create a...

I was was trying to point out that there are size limitation with Int

Are you the RecordSet to poplulate the Form or are the records derived directly from a Query or Table. Simon

You should use CLng as it is a larger and I don't think Lng was ever implemented. Int goes up to 32767 so if you are multiplying by 100 you are limited in the value you are applying Int to. Simon

I always in use this: SearchDate= format(WhateeverDate),"mm/dd/yyyy") Function GetDateConvert(SearchDate As Variant) As String GetDateConvert = Format(SearchDate, "mm/dd/yyyy") End Function OR Function GetPeriodVariant(SearchDate As Variant) As String On Error GoTo...

Try this: In VBA Dim SearchCriteria as String It basically relies on the Len(SearchCriteria) if the SearchCriteria > 0 then you need to concatenate the SearchCrtieria. If the SearchField is populated add to SearchCrtieria else if ignore. In the example then are logical combinations as then...

The advantage of eacvh order having a separate record is thast you can record the time on individual orders. If that is not necessary you could store the total number of orders for each project. If anyone mentions storing totals in records then look at SQL Server Cubes temp tables storing...

The other way is to use CLng basically to convert number to an integer (* 100) and then restore the two decimal places. Beats Round which I hace seen just take the precision in the round statement leaving the remaining numbers beyond that precision. CSng( CLng((Expression) * 100) / 100)) Simon