Search results

I have used stored procedures in combination with an app as it allowed us to bypass some limitations with regards to triggers on tables we used to fire messages off to a queue that could then perform actions based on the total data available across many different tables. The input came in from...

As an alternative, maybe a rowing machine would fare better? Those I have used have been quite robust and can provide quite the workout. I would recommend those using an air brake/fan to provide resistance as it is smoother and easy to control like a Concept2 although it is a rather expensive one.

Having no idea what your home is like, here is a few suggeestions: Knitting or crocheting, yes, everyone can do it. Example Embroidery. Another one for all to do. Example If you have the room, woodworking/carpentry. Example if you don't mind the smoke, there is woodburning decorations. Example

One explanation could be that when it imports the spreadsheeet, it takes a sample of the first 10 or so rows to determine the datatype. If on of the useridd iss not a number in one of the sheets, it willl do exactly that. It can be something as trivial as a trailing space that messses it up.

A thing that might be a bit of a workaround and may not work. If you can have a staging table on your BE server, you can put all you data from the FE there. With a stored procedure you could have the server do the entire append operation instead of using access for any heavy lifting. I found...

The infection rate lags about 2 weeks as well. Only if you test everyone, every day, and get the result in time to act upon it, will the infection rate be known. Many people do not have symptoms that they notice but are still able to spread it. All you know from the death rate is how many...

Any reason you don't want to move the old data into the new table? that would solve the issue a lot simpler

If you make a query to collect the e-mail adresses required, you can loop through the result and add them to an e-mail. Though this does require you to use VBA, it will give you more options to customize the e-mails. You could even customize it to individual e-mails with specific messages if...

Did you consider using BCC? you only need to create one e-mail and none of them can see the other receivers unless you put them in the normal To and CC fields.

Keep in mind that size is not the same across fonts. I have found that verdana is about 1 size larger than arial. No doubt the same can be found between other fonts. I would not be concerned with the font size immediately but rather figure out how to get the font back to what it was.

Regarding the first part of your question, this is quite possible. All you need to know is the service interval for the particular job. You can then calculate the next due date. With regards to the daily mail, this is also possible. You should be able to schedule task that will run at a...

You might want to consider this article before making everything complicated: https://www.gizmodo.com.au/2017/08/the-guy-who-invented-those-annoying-password-rules-now-regrets-wasting-your-time/

Be careful when dealing with ships and the way they navigate. Most of the time they will be using rhumb line instead of great circle since great circle is a major pain in the a.. to use. For short distances (<100 nm) there will be not appreciable difference between the two distances but a...

You could also use the import function you have in access to import the tables into a temporary holding table. In that table you can then have the additional columns mentioned above. Use an update query to inser the information specific to that month. Use an append query to move the data from...

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