Recent content by AlexDoran

In theory i have now finished converting from 2000 to 2007. Im sure maybe a few more aspects of the system will need tweaking or fixing, references adding as some of the dormant parts of it get used occasionally. This is a live production system - its roughly 20 years old. The backend is ~900mb...

Well i wanted to try and ditch the accdb Backend and import the data into sqlexpress or similar instead. I have done some reading on it today especially, but also in the past and i can never really tell if a whole redesign of the code on the front end would be required. Thanks Alex

Isladogs, Thank you very much for your help. It is greatly appreciated - i will certainly look to remove those lines of code and follow your advice. All of this corruption is pointing me towards trying to migrate to SQL. Will this a considerably painful task?

Well, i feel really stupid right now - but i dont understand how this has happened, possibly when i re-imported all of the tables and data into a new fresh database to try and resolve any corruption. However the Table name on the Front End was actually "tblMaterialIssueReqestLineItems"...

Hi there, Thanks for taking the time to reply! If i copy that string into SQL View of a query and run it, i get the same error. thanks Alex

Hi there, I am in desperate need of some assistance in trying to regain functionality of a large amount of Functions from my Database. Today i converted my databses Which consist of a Front & Back end to accdb / 2007 from mdb / 2000 in an attempt to try and reduce the frequency of database...

Hi Johnnie, I am by no means an expert in Access but i am sure it would be fairly easy to implement what you want without using any (or very very little) VBA at all. As you say a crosstab query can easily handle the Summary section of your desired form, you just need to create the relevant...

Do you mean that you want to open Child Records based on what is displayed in the Crosstab?? Im not sure how you would go about that, i opted to use datagrid view where we could easily apply some conditional formatting, from here they can double click into certain fields (Eg Job Number) to be...

Thanks for this advice, i tried this and what happened was the week numbers shifted one to the left, this forced me to check the names of the textbox and label controls. What i had actually done was removed a redundant field from the Paper Report when creating the form, and i never updated the...

Hello everyone, first of all allow me to state i am by no means an advanced Access / VB user but consider myself competent to a certain extent :D :banghead: One of my roles at work is to main and develop an access database that was written by a few of my predecessors. It is used to create...

Hi there, my name is alex and im from the UK, i frequent the forum in the background as a lurker but finally decided to say hello :D

Im soon to be climbing that mountain and am keen to learn about SQL, is there any good recommended material / tutorials?

Re: User can't run query's, strange problem with references? Option Explicit is present, i understand your point with certain queries becoming corrupt, however these queries were created a long time ago, and are rarely edited, and have never been modified in their query type. Im going to...

Sorry about the double thread, I thought my first attempt failed to post so tried again in another section. All users have been upgraded to Office 2010 32Bit September last year. The database is also developed in 2010 32Bit, the file is distributed as .mdb (the database is 15+ Years old). The...

Re: User can't run query's, strange problem with references? Hi there and thanks for the reply. I was under the impression from internet research that no particular reference is missing or broken. The exact error message that is received is: "Funtion is not available in expressions in query...