Search results

  1. C

    Is access the way to go?

    Good Morning folks! I've got a project here - quite a simple one actually. It's just a system for aggregating comments about the running of business (like "need better control of welding materials" or "purchasing need to get their bottoms in gear") from various users and allows administration...
  2. C

    Swapping data between two rows

    Good morning, I thought I had an easy project - but I've hit a bit of a wall in terms of how to best do this. I'm developing a scheduler application, and ultimately need to be able to swap two rows in the schedule - literally just shifting them up or down - simple stuff... except I've suddenly...
  3. C

    Live tables - how to only update on demand

    Good Morning folks! I'm using Access as the front end for an SQL server (I'm unsure of the underlying configuration/architecture of that server - I just know it's address and how to pull data off of it) In this front end I have a monstrous abomination of a query - 18 tables, 30 joins involving...
  4. C

    Concatenate Rows based on grouped query

    I have recently had an issue grouping with a memo field and removing something other extraneous data - but today the specificaiton has changed! (Again(after spending most of last week working on that problem)) - and now I need to add the contract number that corresponds to each rejection...
  5. C

    VBA for preventing duplication during import

    Good morning folks! I am currently developing a database that will be used to keep track of procedures and specifications for an engineering plant. One of the features requested is the ability to import excel tables for a particular job, containing a list of the required procedures and...
  6. C

    Merging Tables

    I have a table that has somehow dropped some of it's data in a particular Column (I can only assume it's been a botched SQL statement somewhere along the line - though why it's only dropped some of the data and not the others is beyond me) Anyway - I have a backup of the table, and want to...
  7. C

    Parametric Search Implementation

    Hello again folks! To make a long story short, I want to create a parametric search for tools on the shop floor based on multiple fields [using VBA] I've had a good search and turned up lots of useful things; but each example insofar has been fairly specific as opposed to a guide on how to...
  8. C

    Problems with Images and Duplicate Entries

    Hello again folks! I run a database of all the standard tooling at my work for the CNC machines, each machine has 20-100 tools assigned to it that never come out the machine: "standard tooling" (and there are about 40 machines - so, a LOT of standard tools!) Anyway, to make a long story...
  9. C

    Version number on form

    TL;DR - need a value on a form that gets carried across to other forms (in the form of a label preferably) ---- Hello folks, I'm a relative newbie with Access so my apologies if I'm doing something daft and not realised it! I'm in the process of setting up a series of databases for my...
Back
Top Bottom