Search results

Is there a way that I can make a field in a table (I don't mind using a query if you can show me how) which is a calculated field and gets its value by performing a look up (from a another table list) based on another numeric field for that person? e.g. In school grades, the student might get...

I am making a database for student reports where I need field size to be more than 255. Googling has led me to an answer that text fields are limited to this amount, but a solution is to use type "memo" instead as the base datatype of the field in the table. The problem is, that while this does...

Please look at my simple Access 2000 business database: http://www.bestsharing.com/files/6YcsupN277234/chem.mdb.html On the form named "Chemical In"... ...this is where someone enters the amount of product they are purchasing along with the purchase date. At the moment, the form also expects...

I've added a new report to a simple business type database. My report (useage by crop report) asks a user for start and finish dates for a time they want to see outgoing costs... try inputting the dates 1 Jan 2005 and 1 Feb 2005 to get the idea. The form works but... ...how do I get it to put...

If I make a database where client informations includes address details like street number & name, town, city, country etc... ...and then I go to print envelopes using a report onto envelope sized paper... ...some addresses may be missing fields (like not all have town or suburb). Is there a...

I'm making a database to help with my invoicing of miscellaneous jobs but it's proving to be a real pain in the very last stage of development. Basically, everything is up and working except that when I print a summary sheet of invoices, any invoice which was made for a client where there were...

I want to create a summary report showing ongoing payments / invoicing etc, with a grand total at the end. This is easy enough, except that I want to have the grand total appear on the bottom of the page while preserving a border decoration all the way down, even past null / empty report space...

How do I maually add a new section / heading area / footer (etc) to a report already created? Example: I have a report with these headings... <REPORT HEADER> <PAGE HEADER> <DETAIL> <PAGE FOOTER> <REPORT FOOTER> The <DETAIL> section lists billing information for clients like so... [client...

i've asked a question like this recently, although I think it's been abandoned (perhaps I did not ask clearly enough?) I'm sure it's not something difficult to do. How can I make a form which has inputs (text boxes etc) and an "Add Record" button which adds a new record from the input data to...

Question: How do I make a form with an "Add Record" button which creates a new record on a subform? Example: Let's say I want to make a "Christmas Shopping Wishlist" for several clients... First I have a table of clients... Table: Client [clientID] (AutoNumber) This will be associated to...

I have a form that contains data which needs to be requeried when someone hits the navigation arrows. I think I'm looking for a navigationbutton_click() event or something similar, but I don't even know the name of the navigation button object.

How do I make a set of comboboxes whose contents can change (lookup by query?) according to what has been chosen in the others? Example: If I create three combo boxes... [country] [city] [town] When someone hits "country", they should see a list of half a dozen countries. Easily achieved by...