Search results

This issue is difficult to describe, so please bear with me. I have attached a sample database below to have a look at. There is a table tblData this contains numbers. I have reduced it for this post to a few records the original has several millions. A second table tblVariable contains...

I thought as I haven't updated my Access skills for some time and am probably rusty around the edges I should buy a more up to date book and work through it. At worst I will cover what I already use daily but maybe as I am not a complete begineer I may pick up more this time around... The book...

Hi All Its been a while...however I dont often get stuck and usually can solve things myself. However this is a mystery to me. The machine shop has decided they want an Access database and have given me a base form etc they want to use. On one of the forms to achieve input checking etc I...

Was reading the temperature may be a bit on the warmer side for our American friends next few days. Thought this is not that unusual for some of us elsewhere in the world. Perhaps we should make suggestions on keeping cool in these conditions. One I find works well in limited amount. Soak...

Thanks to everyone for looking into this. It really has me baffled. I have two online SQL databases I am linking to in Access in order to produce multiple reports, queries and so on. Both databases contain dates and typical for SQL the date on the linked table is formatted dd-mm-yyyy...

I don't understand why straight forward things in this specific database are being so problematic. The only explanation I can think of is I haven't worked in 2016 much, with most of the work I have done in earlier versions of Access. I have a form with three unbound fields. One combo box for...

I have a fairly complex situation where I need to get monthly historic data for comparison in a report. The complexity is the month is not fixed. Our month rolls from Tuesday closest to the 17th of the month to the following months Tuesday closest to the 17th except where there is 5 or more...

Every month I send a report to my customer showing chemical consumption. This has been a manual input in excel which is a bit of double entry as the data is actually in Access. I haven't been looking at this till now as it was on the old server and too hard etc in 2003 to do as much as I can...

I haven't been using Access for quite a while and I am needing to do some modifications to another database and I thought it would be 'easier' in access. It would be ... if it would behave. I know I am missing something its been too long strSQL = "SELECT * " & _ "FROM...

Access 2016 development with 2013 Runtime. Been looking at Inno SetUp, but I am new to this aspect and struggling with the scripting. Anyone want to help me out by showing me the ropes?:banghead:

Hi All I have a table which contains a scope of works for some job we are doing. The data is entered in the format similar to: 1: Open the door 2: Walk through the door 3: Close the door I am processing this through VBA and adding other variables in such as quoted amount, and variations...

Hi All Its been a while since I have played with Access, but I need to do an upgrade to a program I wrote to help me work. The upgrade is to instigate a standard order. So for example one of the products we make is a control board. This consists of 30 odd items that we order from three...

I have a need in an application I have been working on to grab an attachment from Outlook and file it using access to identify the file name adn location. Has anyone played with this idea before? The issue is that suppliers send me large amounts of pdf data on their products, I am trying to...

I am reworking my error handler to better help me identify the error location. According to a couple of books I own you can add line numebrs to your procedures and modify your error handler to return the line number. They then go on to say that this is well documented on the web and that you...

I have a form with a combo box to look up suburbs. To speed up form loading we limit the suburb by state intially to limit the length of list. The problem is that when the user wants to enter a different suburb from another state, how do we requery the combo box and move on with the new data...

The following is a query string I want to build in code (I think) to return specific records at runtime. I have knocked up a sample to get it to work first in the query window, however, every time I try and run it the query is telling me I need the keyword Exists. I have looked at my books and...

SQl and ADO and Order and ??????? I have been making a wizard for setting parameters order of appearance in my application. The table structure is as follows: tblPool PoolID Type Construction Sanitiser pH Control trelPool RelPoolID PoolID TestID tblTreatOrder RelPoolID Parameter TestTreat...

I did this once before and got it working, but lost the example I had in a harddrive incident. I am setting up a fairly complex wizard using form, subform model. The forms and subforms are unbound, and I intended to dump the data into a class to process on completion of the wizard. I am...

Access should have a built in shortened documenter for table structures. Anyway that is beside the point. I am working on a design for a new application. It is for testing water for swimming pools. The following are the documented requirements: -Any pool requires a test -Any test can consist...

According to Microsoft the functions dps_OkNew should allow my code to update the underlying table even though the user has no direct permissions on this table. However, everytime I tun this code it prompts me with a warning that I do not have update permissions blah blah. Function...