Search results

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

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