When I add a textbox control to a form, it comes with its own linked label. If that label is deleted, I can create a new one but how do I link the new label...

Hello I am an amateur but enjoy a good go at access! I have a small, probably easy, query but I cant work the bloomin thing out! I need to create a report...

I am using the following expression in a query. It works except that I am getting a negative number. Can anyone explain why? Days in Hold:...

I have four tables: tblEmployees (employeenumber, firstname, middlename, lastname, address, city, state, homephone, cellphone, hiredate, salary,...

How do I compile an access database into a standalone program? Do I need special software to do this? Does it cost money or is it available as a free d/l on...

Using Access 2000 on a 4 computer network with a customized data base that attaches/detaches to tables housed on one computer. Worked great with Windows 98,...

MassInk Refillable Ink Cartridge for Epson Printer How to control the flow of ink without foam? Refillable Ink Cartridge. Big Savings on Inkjet Printing...

Hi there... I am using a list box to display values for the user to select and the selection is supposed to be a filter in a SQL query for another list box....

Hello all, In building a query, I use: Not Like *mystring* if mystring may be part of a larger string. Access then converts the criteria to: Not Like...

I have two databases (almost identical) that I'm copy data between two of the tables. Table1 has 350 records and Table2 has 380 records. I'm just trying to...

Hello, I make a form that bound by the parameter query. The query works well. But I do not know how to 1. When I input the parameter (one unbound text box)...

Hi all, I have a Chemical table that contain all chemical. I need to search for their name offten. If there is not this chemical in the table, I will input...

I have designed a database with three tables. The corresponding forms each have a search function. The search function works as follows: I click on the...

40 days in now, MS, after a 10 year layoff, ya'll been brilliant. Check this out, please sirs, (and/or ma'ams if there are): Runtime Error '2465' Project...

I would appreciate instructions on how to accomplish the following: I would like to add two fields to a table that I have copied from another table (created a...

I have a bank account where I can collect the data as a CSV file. For some peculiar reason the debits and credits are delivered in one column. The debits are...

Hi. I have a table being created in MS Access from a query. The table returns all the data I want in my query based on the criteria I set. Occasionaly one...

I have a worldwide membership database where I need to check that members do not have duplicate entries. I propose to check the combination of "LastName" and...

I am trying to come up with a way to print the dates on my report for and . My query calls out for this in the criteria of the production date. I have tried...

Hello My database has 2000 to 3000 records. My staff does not know how to use queries and expressions to filter it. How could I create one simple form with 2...