Search results

I'm helping our local Scouts with a Christmas tree order database and pre-delivery, we need to create labels for each tree. I'm using Access 2003 As the orders come in from customers in any order for location, delivery day and tree size, I need to sort the records with a query which sorts by...

I've got a table with items that are available with a [startdate] and an [enddate] for their availibility. I've also got a report I want to run that is date limited. Some items will start and end within the period, some will start before and end during, some start during and end after and some...

I'm trying to count the numbers of Rooms at any given Grouping level on a report, so there's so many rooms in a building, so many in a groups of buildings and so many groups of buildings in each region. To count the rooms in a building I've got a text box in the room header, RmCount. Set the...

Ok, found this: currentdb.TableDefs("tblOneOfMmyLinkedTablesName").Connect returns something like this => ;DATABASE=X:\FolderPath\XXX-data.mdb BUT: To get this looking neater.. How can I strip out all of the detail except the mdb name? OR How do I display any of the database properties of...

Quite often I'll make a "training" version of the backend database so that people can "play" (or should I say get training) on dummy data without them having to worry about ruining the live data. If my real data is in a file called RealData.mdb and my dummy data is in a file called...

I've got a report containing information on Building occupancy. Each building has rooms and each room has occupancies. I've designed a query to bring together all of the required information. Buildings have a URN of BuildingID Rooms have an URN of RoomID Occupancies have an URN of OccupancyID...

Just tried this - it'll be heavily used form now on as I'm not very consistent in my indentation at present! Simon

Nearly there... Jon, Many thanks for the demo, I can see where I'm trying to get to now! I've altered your demo to match my field names, so far so good, but the query seems to fall over if there is no date value set in the MoveOutDate (or OccupancyEndDate as you named it). As I'm not only...

I'm calling this code on my Form's BeforeUpdate Event which I understand should only run if the form is dirty. In this example, the code should check to see if 4 fields ("txtField1", "txtField2", txtField3", "txtField4") have data present, if not highlight them yellow. Function Msg() Dim ctl...

I've come across a couple of free/inexpensive Access utilities in my wandering over the web and wondered if others had found Access related utilities/addins/tools that they would recommend to other developers? I use/have used: Free NJH Tools zMsa Tools - Oscorp.com V-Tools Paid for Access...

Actually, it's Property (as in Houses) rather than Rooms but as "Property" has another meaning in the Access context.... Here's what I've got (simplified version): Properties Table PropertyID (PK) PropertyName People Table PersonID (PK) PersonName PersonCategory Occupancy Table OccupancyID...

Mile-o-phile Thanks, so it sounds like a pragmatic rather than a programmatic solution then! :rolleyes: Thanks, Simon

I'm creating an App in Access 2000 which will be deployed as an mde in a multi user network. Since the initial build, the Client has now upgrade some PCs to Office 2003. The problem is that some machines use differing versions of Access, either 2000 or 2003 (the 2003 machines can use the 2000...

billyr, Firstly, thanks for the swift replies, it's greatly appreciated! I follow all you have suggested apart from: Sorry, but exactly where does the unique character string go? ======== On the other tack (i.e. using database properties) I found some code in Access help to show properties...

billyR, Thanks, that worked. Thinking about it, now I know which table I'm linking to, what I really want to display is the folder name that the database I'm linked to is residing in. I've got two folders "Training Data" and "Live Data" each with identically named back ends in them. What I'm...

Mr Tibbs - I'm using 2000. billyr Great :) thanks, I'm assuming that this will go to the first table in my db. If I've got more than one linked database for my front end (and I have!), can I specify which linked table I want to report on? Cheers, Simon

Show Linked Back End Database - How? I'd like to show users which backend database they are linked to (e.g. "Training Data" or Live Data") by showing a message on a form. Can this be done? Thanks, Simon

Show User Group on Form - how? I've got User Level Security and want to show the logged on User which Group they are logged in as on a Form at Start up. I'm already showing a message using CurrentUser() to show their name but I'd also like to show their User Group (the Groups are hierachical...

I've got a sub form which allows users to select a customer from a combo and add a visit date in another field. For space reasons I want to show the Customer's details on the parent form when one of the existing or new customers is selected. I want this to happen when any part of the row is...

Got a problem in a database, of my 45 fields, 31 are in number format that are fed by lookup tables. When I try to write a query with the "English" names showing instead of the numbers, Access just stops responding. When I reduce the fields displayed in the query, things start to move again so...