Search results

We have not...

Not sneering. Just not something we want to do anymore. It did serve us very well. We were able to do some amazing things. We just can't keep it up anymore. Plus integrating it into our erp wasn't a perfect solution. The 10 year plan is to put the stuff that we developed in house - into...

sure - we would probably not use access again. So - code is just for reference. (although I am using access 2021 to interface between our erp and our internal applications..) sam

We found a way to install office 97 on windows 7.. (there were some hoops to jump though - found online instructions..) Then 7 -> 10 -> 11 upgrades. I tried fresh installing office 97 on windows 10 but failed. sam

99% of the backends are now postgresql.. we have been slowly migrating things to our ERP and some java.. Access keeps plugging away though..

This just happened today.. (I was totally surprised it worked..) Hell - I was surprised it has been working in windows 10..

Well - I don't know what is different but the queries are running more consistent. It looks like if I want the most performance I need to create on pass through query to connect all the tables together... I guess that makes sense.. SELECT BIN_NUMBER_COUNTS.AVAILABLE_COUNT...

We have started using netsuite - it comes with what they call 'suite analytics' which gives you access to the underlying data. This is based on oracle. The ODBC driver when you link tables requires you to select the index(s) for the given table (I honestly have not see this since foxpro and...

I have a report that has Bill to and Ship to addresses. They are positioned across from one another (ship to on the right and bill to on the left of the page). The issue is that the 'can shrink' doesn't work when there is data in the same field on the other address.. Hope that made sense...

Doing more searches - seems the limit is around 30 variables that you can pass to a function in a query... We are getting by concatinating/delimiting some of the text fields that get sent.

I have a function that is getting called from a query. It has grown over the years as I am passing more and more variables to it. Is there a limit to the number of variables that can be passed to a fuction in a query? I have added 1 more varaible and now I get "the expression you entered is...

Ok - so it looks like I have to do it the old fashened way ;) 2 queries... First make a query that gets the max date for each part - then match that date up to to the original table to get the rest of the data for that date. sam

Stupid qestion... I have some data that I would like to get the last price charged. I thought I could do it by first sorting by date in a query - then the next query - group by part and get the 'last' price. It seems though the sort is lost and the grouping query goes by the original table...

I winged it from some other microsoft references... Seems to be working correctly. sam Dim varArray() As Variant, i As Long Public Function QrySeq(ByVal fldvalue, ByVal fldName As String, ByVal qryname As String) As Long '-------------------------------------------------------------------...

I am having a problem with serializing a query. I am using this function below from http://msaccesstips.com/2010/01/auto-numbering-in-query-column/ The query runs great (numbers correctly) until I try to add a criteria to the query - Then I get 3061: Too few parameters. expected 1. The...

Thanks again - we are running with the new odbc now for a few weeks. Everything is working great (I am using the NZ solution) With the new database and new server - it still runs a bit faster than the old system. (we run 50+ queries every 5 minutes or so adding, deleting and updating a good...

Thanks again! The more I think about it - the more I probably want to convert the data initally. There are a lot of programs down stream that would have to be modified. (I want to try to make this as painless as possible ;)) it is funny what you say about the date field. The old navision...

BTW - is there a better/faster way to compare 2 tables for changes (and update only the records that have changes) thanks sam

Cool. Thanks So - are you saying that when I insert the record (add query) - I should at that time convert all nulls to zero length strings using NZ.. Then during the update query - also use the NZ fuction in the criteria? (and it would have to be used in the 'update to' line also so the...

I have a access97 database that pulls data out of Navision accounting software through odbc. We are upgrading to a newer version and a newer odbc. The old odbc driver - 'blank' fields were zero length. ("") The new odbc driver - 'blank' fields are Null. The way the system is setup - is it...