Search results

Dear All Looking for TSQL appropriate for SQL Azure. I have a need to create sub records on a table by calculating a split of a volume. I probably haven't explained that very well but if you see the example below it might be clearer. Essentially I have casks and I want to split them into...

Dear All - I thought I had posted this already but can't seem to find it. That's what happens when you are a bit rusty. Hope everyone is well. Looking to see if anyone can point me in the direction of a good skeletal design of a inventory management system for liquid aclohol management system...

Hey guys I had been holding out for ages but finally issues with the mdb format has meant I've had to move so rather than muck about with suspect copies of Access 2010 just went for Office 365 and... My 2003 personal CRM project pretty much worked out of the box - had to change some...

In Azure SQL I was wondering if anyone had tried to save the Create table/view generated SQL scripts in some way automatically to a linked ms access table from specified remotely linked SQL Azure database. I only need specified tables and views.. (I am talking about SSMS which has an option to...

Dear All I have a single table of a list of persons that is referenced to itself for the father and mother field. So lets say its called t001 and has a primary key of PKID structure is similar to the following where pkidt001mother and pkidt002father is referenced to itself. pkid firstname...

Hi all I am trying to create a computed column as per Computed columns But I would like to use a conditional statement to create the value IF datefieldvalue is null or >= Today computedfieldvalue = Future Else computedfieldvalue = Past END IF Has anyone any pointers ?

Hello everyone Another questions about a race timing system 4 finishers In a report or a form what do you believe is the optimal way to rank finishers such that people with the same time are marked equally eg 1 - John 2 - Bill 2 - Colin 4 - Thomas With the ranking running automatically off...

Dear All I'm thinking of putting together a simple database that can print out race numbers for athletic races. I'm using MS Access 2003 and from limited testing it seems I am limited to a font size of 127. The numbers on the bibs probably need to be quadruple that size. I am thinking of...

Dear All Just thought I'd try and garner some support! I've requested that Microsoft think about increasing the default maximum file size for MS Access files on the Microsoft Access Users Voice from 2GB upwards. This is an idea that has been floated twice before and Microsoft has responded...

Access front end with link to SQL Server - Where are the Queries RUN? I probably should know this but If you have a series of ETL queries , written and stored in an MS Access front end linked to SQL Server. If you run a script of those queries - what engine performs the heavy lifting - are...

Here's something that I haven't tried to do before. If there are a small number of field values that error out eg in expression calculations within a query. Is there a simple way such as Not #Error? Running a loop of a query and there are a small number of values that have calculated out as...

Ok the question is in the title. Have been struck a number of times by the really great design of Access as an integrated design environment. I have heard that some went on to help with the design of SQL Server - no idea whether this is true or not. I've looked up Wikipedia and there doesn't...

MS Access at Microsoft Ignite - MS Technology Conference Microsoft hosted a conference from the 25th to the 29th of September titled IGNITE. It was broadly centred around the usage and roll out of Microsoft technologies. Included within this was a session on Microsoft Access and how it fits in...

Have tried to set up a link from MS Access 2003 to SQL Azure as per FMS Luke Chung directions http://www.fmsinc.com/microsoftaccess/cloud/link-to-azure-sql-database.html When I run the link everything seems to work ok - I see the database I see the tables and I can link to the tables- I even...

Early days of an idea. I was wondering if anyone has ideas or experience of creating a function that would take a table or a query that partitions the recordset loaded from the query or table into multiple recordsets. The recordsets to be defined by a variable number of total records. For...

I am trying to develop some code to create SQL that updates a field in a table using nested IIFs I am most of the way there. I create three recordsets and loop through each refering to a table which will hold the old and new values to be in each of the IIF statements the code below all but works...

OK this isn't quite as simple as the title states - I've tried CINT and Val functions don't quite get it right. I'm currently doing a transform of data between systems and I have a table of of Tables... which relate to mapping. I would like a number to uniquely identify each table which at...

On the 4th November 2016 MS announced that MS Access is now included in Office 365 Business and Business Premium Some MS Access LOVE Additionally Microsoft has 2 developments marked as being acted and they are decent. BigInt data type support (which is a good improvement to integration with...

I would be interested in the statistics on number of sample databases submitted by an individual And Number of times sample databases have been downloaded. Just an idea I realise its gamification but its a subjective measure that is hard to manipulate so in that respect appears a good measure...

The following code and example database takes two tables T001ParentRecords and T002ChildRecords and creates separate word documents for each parent record. A new word doc is created for each parent record and then three fields for each child that relate to the parent are placed in the document...