Search results

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

May helphttp://www.accessrepairnrecovery.com/blog/fixes-for-access-reserved-error

Not sure if this has been considered...but maybe an alternative thought process is required. After wrestling with code for various applications a few years ago I started down a different path, using tables and so on instead. In this case I am suggesting, in case it hasn't been considered...

Today for no reason at all it is working. I didn't change a thing. Left it and was working on other stuff now its working????????????

Its all online SQL Linked data. And yes its working fine, its only the date field and only the DtTo that isn't working which is baffling to say the least, formatted, not formatted...just not working.

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

Looks more efficient than my current approach. Will see what the client says this morning before I move ahead. I have proof of concept for the report, know what the report looks like, but am uncertain it adds to the clients efforts. The answer will dictate how much further I go. What I have...

Not quite. When I talk of closing the month we close the Monday night, harvest the data by Excel and upload to SQL on the Tuesday. Then on the Tuesday the field staff start the new job number and we remove the old job numbers online. Just used shortened description for what we are doing as...

Thanks, I ended up having to do multiple Ascii searches looking for 49. Once I found 49 I then trimmed to length 4,5 or 6 characters this returned the correct phrase. Hope this is consistent I will check using a few sample months and see. Nonetheless this is the correct direction at least...

I found an online example I think will work nicely. More or less I am planning to show columns of numbers: Pool Average This Month Last Month Consumption levels are what we are looking at. I considered charts but thought I would need a lot and after a while...

Its not bad place to live. I migrated here from Auckland in 1994. It was as though I stepped on the Tardis and flew back 10 years. The Perth I arrived in was almost quaint with service stations not open Sundays, shops only trading Monday to Friday and so on. I was stunned.

The data has been harvested using an online tool, transferred to excel, uploaded to SQL and now I am using Access to link to the tables. So how would anyone suggest I deal with it. The trailing characters seem to vary with the 'phrase' of the job.

Hope this helps

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

Thanks for the suggestions

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

That worked. Thanks. As I said been a long time, been playing around learning C# but got really busy at work and stuffed something in C# so thought Access would be easy way to fix, and it is now. Thanks

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:

This isn't code generated otherwise it would be easy. The user generates the task list in word or some other program. Copies and pastes it to a custom web application. The web application outputs the data when required for invoicing in CSV format. I bring into access and process to the...