I'm creating a new database from an existing database and copying/pasting fields from one to the other. The old datbase has a table with approximately 15,000...

I have inherited a project management Access database. In this database, there are forms or modules that come up as forms. My manager wants me to add Minimize...

Hi all I am hoping you can help with this... I have two tables in Microsoft Access 1.. Staff Information, and 2.. Training

Hi all, I'm not new to Access but I am new to this news group and I am struggling with the software. You'd think Microsoft could afford something good like...

I ran one report and it should be sorted by monthly. The problem I have is as following. My month was entered like 1, 2, 3, 4,...(for Jan, Feb, March...). When...

I have a "simple" two-table database... one that tracks individuals... the other that tracks payments specific to that individual. I have linked the forms so...

I have little experience with Access but I have played around with it a little. I am trying to build a DB that stores claims I file with vendors. I set up my...

We are looking to expand accross the country!!! $2000-$3000 / Month Part Time Income No Experience Needed - Full Training Provided No License Required - Earn...

Hi, I have a problem with err.raise I write a class module, and I want to use this mechanism to indicate errors when user set wrong values to properties But...

I am fairly new to using access. I have a query that gives the total calories burned for my exercise program. I want to create a field that gives the total...

Using Access 2000, I have an .xls (which is listing of 7600 Items) I've imported, which I'm *trying* to normalize. But it seems I've been chasing myself in...

Hi guys, I have a SQL string here that is intended to add the contents of a textbox into an unrelated table at the click of a button(the table is the...

Hi, I'm wondering if anyone knows of a free tutorial on learning Access. I think I have Access 2000 but a later version would probably be OK. Thanks. Jean

Hi Guys, I am now battling to pass the result of a SQL string to a variable. I can access the result that I need through the Dlookup function, but I would...

In the following code: EndDate = rsCompleteEpisodes! rsCompleteEpisodes.MovePrevious rsCompleteEpisodes! = EndDate If the the date in...

I have no knowledge of Microsoft Office, having just installed it. In Microsoft Word my screen shows a horizontal ruler, but I'd also like a vertical ruler. ...

Hi folks, I have a report that contains multiple columns of numbers. I want to provide a running total (not a page total) at the bottom of each page. I have...

I have a cbo which allows the user to select an enquiry type on a form. The cbo is based on a query with Date of Enquiry from tblEnquirer and Enquiry type...

hello all, I have a form that asks how many children a person has (text box). I would like the number of rows in a subform (linking to the children table)...

I'm running a query that totals MTD sales for a particular time frame and by a sales district. The query lists sales by district and then ranks the districts....