Search results

Because it has just been a friday I cannot resist. http://imgur.com/yv3ZW?r

Using it as a refueling station though, that might be possible with a robot. Water is a quite useful resource for oxygen and fuel. The amount of fuel you can save by refueling out there is staggering.

It really depends. How many new species of fish and other marine life is discovered on earth every year? How long will it take to be sure there are not other lifeforms there already? We are pretty good at surviving here but on Europa we would die due to the radiation. It might not be the best...

I would use the two tables you mention from ebay and paypal as the place where I import data. For my own use I would strip out those fields I need from both tables and have them in a single table. As pbaldy said, this would contain an indication of whether it is an ebay or paypal transaction. A...

How about using this method? I had it in function for exporting the various things I needed to a data sheet in an excel file. I could then run the few calculations needed in excel from that. The majority of the calculations were done outside excel. Dim rst As DAO.Recordset Dim ApXL As...

I have used something like this to import from excel files: Option Compare Database Public strPathOriginal As String 'The original path to teh file location Public strPathWorking As String 'The path to temporary working location of the file being worked upon Public...

Having run into similar trouble as CJ_London is describing, I have taken to always displaying dates in a manner that will never be mistaken. In your case, I would display Aug 2016 or Aug 16. That way it is very easy to see if you have entered something wrong or it is behaving in an odd manner...

You can set all three fields in the same query if they are in the same table. When you are in the query editor, simply add the fields to your query and set their new value.

Google has a free website service you can use. I am sure there are other places that have a similar service you can use. If you have your own webiste, there is a chance that your hosting company will have a webiste template you can use. Some of them have a one-click setup. Otherwise you can use...

Have a look at stored procedures and views? That way the calculation, filtering etc. is done on the server and you only get the result back. Generally the server is better equipped to do the calculations and filtering anyway so it should save you a lot of time.

Depending on how you build your word template it can be done somewhat easily but it might be easier to use the reports in Access with their limitations.

Doing that will ensure you have a unique number. The number may or may not be sequential and can be both positive and negative. I would certainly use the autonumber but only as a reference internally in the database. To have something that can be referenced by a human I would create my own...

one way to get around a field not existing in the tbale is to use the normal import function in access to import the csv file once. Let it create a new table for you. this ensures it names the fields in the correct manner. Delete the contents of the table and you have a template for the import...

This https://msdn.microsoft.com/en-us/library/aa537149(v=office.11).aspx seems to explain it pretty well.

To me it looks like you are doing some text insertion. If so, consider concatenating it in access instead of inserting each line seperately. That way you may get away with just doing a single insert. The actual inserting can be done by using either a text form field, table or bookmark. I have...

Have a look at a star diagram type database. You would purposely de-normalise the database in an effort to make speed the priority. This is a pretty specialised database design so it is completely unsuitable for the normal transactions. The basic idea is that all data is pre-digested and...

I believe it is posisble to do this but you need to set up something to run a few things. Adding a new document is fairly easy. When you do this, include a timestamp for when it was done or it is ready for approval. Have a field for when it was sent for approval and one for when it was...

You can always multiply the result with -1.

You can also try to start the file with the /decompile flag. Example: "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "Path to your file" /decompile Save the above in a .bat file and see it if helps. It works when there is something wrong with compiled vba and forces it to compile it...

Why not combine your current method with another button that will carry over all of the variable data from the form to a new record? That way there will be a way to make a record for each occasion without typing in everything if there is only a small change as well as a way to get a new record...