Search results

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

One thing you could consider is making a master ID field for each of the tables in the central backend. When you copy the data from the user backends to the central backend you keep their auto-generated number but also store the user name or id. This allows you to check if a particular user has...

You should be able to set a default value of the parameter in your stored procedure. Something like this: @Parameter as Int = 0 You should be able to use a date as a parameter although dates are handled differently in Access and SQL. I find that I need to convert it into something that I can...

I am not sure what you refer to Galaxiom. I found another way that was supposed to work with inputting parameters however I could not get it to work and the thread where I found it ended without a working solution. If you could post a simple example I would appreciate it. It is always good to...

Thank you Minty. With a slight change to the way the stored procedure worked, mainly related to converting the string values coming from Access to date and such, the whole thing works brilliantly. I ended up with this result: Set Cn = New ADODB.Connection Cn.Open = "Performance leadership"...

Good morning Following concerns about someone accidentally deleting the access database we have been using to crunch performance numbers, I have successfully moved the data on to an SQL server :D While the database works as it is, several of the queries are running extremely slow. I therefore...

you can always use dmax+1 to get the next higher number for the invoice in your invoice table.

If you are absolutely sure they all start from row 8, you can delete the first 7 rows through vba and then import the entire sheet. For deleting the rows you don't need, you can find some inspiration here. For the import bit you can use the DoCmd.TransferSpreadsheet Method