Hi,
I have one table called catalouge and another for renting a book.
I want the rent page to be unable to rent a book unless the value of the book being available in the catalouge table is true.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
This is an issue that i was unable to find a resolution to..The Logic seems simple but am unable to translate it into Practicality..
Well the issue is as follows :
I have a table called "Or...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I'm creating a library system and i have one table for the catalouge with all the book information.
One table to rent a book and one table to return a book.
There is an Available field on th...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am working on migrating an excel spreadsheet to access. On of the sheers has the following information on it (numbers are CPU):
Code:
Server 2008-12 2009-01 2009-02
live ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have a huge table. One of the fields is a Yes/No field, and I want to change all "No" records to "Yes". To do this manually would take hours of brain murdering work....
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have created a form in access, based on a single table query. The form displays church information (ID no, sdate, mdate, tdate, group, district, attendance).
ID sdate mdate tdate group distric...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I want to show how many staff worked for us throughout each month of the year. I think I can only use their start dates to work this out but I don't see how I can calculate to say there were 100 s...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello All.
I am trying to create a report from the data in the tables and am struggling!.
I have attached a DB with sample data. I am trying to produce a report from this data that only returns c...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Im not sure if im going about my problem in the right way! I have a continuous form with a time capture box (Text 1)on it. A button is pressed and the time is captured, a second box equals this ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have made a query that works just fine except I can't sort the data.
This is the query:
SELECT TOP 100 PERCENT dbo.TblMoederrollen.Moederrolnummer, dbo.TblKwaliteitswaarde.Kwaliteit...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
If someone makes a comment about NEXT FRIDAY do they mean tomorrow or Friday next week?
I would have thought that because today is Thursday then next Friday would be tomorrow but most people r...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi
i am using MS Access 2003.
i have made application, while checking the database settings, i have changed many settings and now facing problem to reset them.
Details
i open the
Objects-> For...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a cbo query for the row source that selects once of each instance of ProjectID in the table tbRFIs:
SELECT DISTINCT tbRFIs.ProjectID FROM tbRFIs
I would like it to select once of each i...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I've been cobbling together a basic contact database for customers who require a catalogue CD from us.
As I've been on a level 1 Access course, my department decided I was our 'go-to' guy to b...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a clock running on a form that is part of a timing system. It updates every second. I would like to be able to stop the clock from running on the press of a button, is this possible?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have created a monthly report which totals transactions by group on a monthly basis, with a date range parameter for the last year (eg 01/12/2007 - 30/11/2008). However, when I run it for the ne...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
can anyone help me with this:
I need to print a report containing only current main record and the total subform records. When I do like this, it will print all main records with all subforms reco...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi guys, was wondering if u guys can help me on a hyperlink thing.
I got the code from one of the fellow forumer here and it worked like a charm, bringing me to the website i want.
but i've al...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I'm trying to create a search on a form. I want to be able to enter a string of text into a textbox and search every field of every record for the occurance of that string and show only the...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I could test some of this myself by uninstalling MSOffice but perhaps I can avoid that paid
In code I use to print Word docs that have had data inserted to bookmarks is
WordDoc.SaveAs ("...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
when i want to run a query it says "you tired to execute a query that does not include the specified expression 'Dur1' as part of an aggregate function"
what does this mean?
Dur1 is in...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
How to Measure magnification
How can I see how strong a magnifying glass is?
I bought this magnifying glass http://www.liangdianup.com/inventory/189901.htm [http://www.liangdianu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
=( what is wrong with this...
when i run the query it says "data type mismatch in criteria expression"...
Field
aprid: Sum(([prem]+[eprem_o]+[eprem_m])*1*IIf((Not ([code]=[rcode]) And No...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Can anyone explain (simply) the ColumnHistory functionality ?
I've seen it in a couple of MS Sample databases (Lending Library for example) but I can't replicate it in any of my databs...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
In older versions of Access, after I compacted a Db, I would check an option to 'Show System Tables' to see if any MsysCompactErrors tables were created during the compact. I can't find how to do ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
