i dont know if its possible to do this with Access......because im new to using Access. but i have to create a report in a tabular form. Total No of Jobs 1...

I can click a command button on Form1 to take me to Form2. I add new data on Form 2 and click a command button to go back to Form1. How do I get a specific...

Hi, I have two forms that I would like to minimize at the same time. One is called “Area IPPM�, and the other one is called “Area CSPC Tag Summary� I...

Is it possible to use the text value in a field on a form to be the in() part of a query. For example, if the field had C28, C47 could the query say...

I receive a db that has a single table with 52 Fields. Each Field has a Caption defined in the table. For example, Fieldname has a Caption of "Bank Nbr". ...

I have a bound text box and I want to display a date, but formated like this "dd/mm/yyyy". I tryed to input a mask like 99/99/0000;0;_, but when I insert in...

Below is a sample of my data set and "Material" will be the primary key. Now, for every "Material" you will have "101" in the "Txn" field and multiple...

Can anyone help me to figure out how to do a Create View Query? Thank you, Salomon

Currently, I am using the following code to execute a stored procedure. How can I support the use of RETURN values from a stored procedure to use as a basis...

I have a summary query that works great. It sums the various costs of a sale and gives me a total as deisred. I want to know the profit, so I try to calculate...

I need help with this asap, I am running on a deadline that is almost up. Question. I have a field name Category Code and I have the critera set . I have...

I have a form that shows different subsets of data depending on some hard coded filters. One of the fields is a yes/no named select1 which I allow the user to...

Hello. I have a continuous form with about 10 fields. Of those there are three fields in particular that I need help on... "Date Created" "Field1DueDate"...

Hi I have a table with Requests in it and want to run a report based on a query that will show rejected request by date. I have set up the query to search by...

What would cause VB outputting to Excel, not work the first time, but work everytime after that (while the database is still open) i.e. I output a query to...

I have been receiving an Excel list file from another group, at least once a week, with many duplicate records in it and I need to remove the duplicates. ...

I Guys have a function that allows me to find the part of a feild and create a new field from this value, However, can anyone tell me how I get it to just...

I have an access application that tracks clothing in and out of a laundering process for a cleaner. The Main table I have contains SeqNo (auto id Pk)...

Hi, I have bit new to access. suppose I want to choose Five random nos from 1 to 31, but I want to put restriction selecting numbers the following nos ...

I use Access2003 for a small database to record my movie collection. When I use combos to look up records, I want to suppress the word "the" when searching...