Search results

Another option would be to have a function generate the random number and then have the form check if the random number field has been filled. If not, call the function to generate a random number and insert it in the proper place. If the field has already been filled, leave it alone. This...

Hehe, I had quite forgotten about this one. The code I used was meant to fire some data off to a website and then parse the xml reply into a staging table. The recordset is there because i looped through a number of datapoints for which a reply would be given. This was provided by a query...

Good afternoon I have been struggling with some word automation I set up for a word 2007 document. It worked ok when it upgraded to 2010 however the upgrade to 2013 completely destroyed the functionality I was using. The task I an looking to acommplish is relatively simple. Open the...

Merry Christmas and a happy New Year. I assume you connect to the server through some kind of program. If you are able to connect directly to the server with SQL server management studio you will be quite able to run any kind of sql you fancy on the server without pulling the data to your own...

I would assume so however it may be that whatever you are using to access it does not allow you send any SQL to the server.

Whether you stor them or calculate them every time really depends on what you are using them for. I know you can calculate them but overall it may be simpler to look it up rather than calculate it every time. Recently I have taken an interest in the BI side of databases and there you never...

I think it really depends on how it is calculated. If one of the inputs that are used is liable to change it might be better to do the pre-calculated field in a different manner. Otherwise you might end up with a cascade of calculations running in circles. If the result is not going to change...

If you do as pbaldy suggested and have a version table in both the back- and front end, you can check if the two match when the front end is started. If they match, just continue as it means you are running the latest version. If they do not match, stop and go to some kind of update routine. The...

It is not possible unless something has gone very wrong. Those pumps and buckets normally have a filter to prevent branches and trees from getting in and clogging everything up. A diver is ever so slightly larger than what can go through.

Maybe the place you host your website at already has a simple store template you can apply? It would not be unheard of that they offer such a service. Maybe they offer you to install something like wordpress. this may have a plugin that gives you what you are looking for.

In Denmark there was once a large scale project to collect bio-degradeable waste from households and use it to generate biogas. It would be mixed with pig manure in the reactor at a rate of 5-10% household waste. The plant suffered from continuous problems caused by plastic bags. they would...

Or just change the sign to a pictogram showing a bottle and can.

I recently experienced a puzzling problem with DoCmd.TransferSpreadsheet. After having the some code run successfully for several months on a daily basis, the data from a spreadsheet was suddenly not imported anymore. There were no error messages or any hint of why the import failed. After...

I have used this site to create small quizzes before. They run in a browser so pretty much everyone can use them. http://www.internetraining.com/Templates/CKQuiz/index.html

Before you start appending the data to the new tables you should convert all the future foreign keys to their new values. This will ensure you can catch any problems before they crop up in your new data tables. This means that instead of a country name in your import table, you would change it...

The question really is, do you want to be able to use the pivot table functions such as slicers on your data or is it a fixed result you need? For a working pivot table you could: Import the data into access Use queries to make the calculations Store the result in a temporary table Export the...

I don't know how your policy is but a relatively painless import/export can be made using something like dropbox although it requires you to have an internet connection at least some of the time. You can make a function for your users backend data to be dropped into an excel file that is placed...

You are aware of the option to both format and calculate fields in the pivottable in excel? Using excel 2010 I find the calculated field menu under PivotTable tools - Options- Fields, items & sets (in the calculations group). You can get it to make pretty sophisticated calculations for you.

I was really hoping you had a single structure of the backend and that it was only the data that was different. The biggest worry I see is the integrity of your data. When you get updates from the various users they really need to be kept in a way that can make sure you do not overwrite data...

If the backends are unique to a user, you could store it in your master backend in this structure: -------------------------------------------------------------- | Masterdhid | UserID | Userdhid | Field1 to FieldX| -------------------------------------------------------------- This will allow...