Search results

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

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...

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...

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 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...

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...

Could someone explain this? (problems in code - this is a sample from the debugger) ?int(39.564/13.188) 2 ?int((13.188*3)/13.188) 3 ?int(35.256/11.752) 2 I am beating my head against the wall. (sorry - adding - this is access 97) Thanks sam

I have a friend that has a database problem. When she tries to run the report wizard on a table - the tables show up in the "tables/queries" drop down list - but none of the fields show up in the "available fields" list. She said it started happening out of the blue on all of the machines...

I am trying to change a field lenght of a large database (access 97) It is at 50 right now and want to change it to 25. When I try to change it and save the table I get a error when the bar is about 3/4 the way accross the bottom. then This is error 3183. In the help it says that the TEMP...

I am having a problem that had been run into before. I have a couple of calculated fields in a subform. One sums a field in the subform and one counts the records. I have a function that I wrote that takes all the data from the main and subform and does a calculation. If I do a refresh and...

I have a from that estimates a price depending on hundreds of variables. I have a button right now called calculate that runs a function I wrote that does all the calculations. What I would like to do is if anything changes on the form the function will run. I would rather not put the...

I have about 20 querys that run every 5 minutes that pulls/updates info out of our navision accounting software. We just converted to navision the begining of the year so this is relitivly new to me. We used to use SBT(vfoxpro) which allowed us to use an odbc link on every computer to get the...

I have an odd problem. I have a form that is pretty intense. It is a costing form that allows users to pick operations needed to do a job as well as material and such. It calculates it on the fly and gives a price per part each time someting is changed. Now here is the problem. In the print...

Well I just found out that access 97 has a limit of 64000 records or so in the combo box control. I have a table of customers that I needed to have a combo box that workers could start typing in the name of the company and it would show up in the box. The table has over 600000 records. Time...