I am wanting to build a warehouse inventory system and would like to use
Access since we already own it. I would like to know if someone can tell me
if Access is capable of doing a couple of things before I start.
1. Can Access create / output barcode labels to a thermal printer ...

hello there...i have one relationship with 2 tables and a query coming out
from these tables and one form with a few fields from that query...one field
is in combo box form and i want when i choose one value all the others filled
automaticaly with their values....if anybody knows ...

Can  anyone help a newbie .... I have to produce a list of films
currently available for loan. Members can borrow films, only one at a
time though. When a film has been borrow, a tick is put against that
member's field. Also, the details are stored in table 2. I need to be

I have a FrontDesk Access 2003 Program that I have split for multiple
users (2).  I have the Front End on their C drive and the Back End on
their G drive which is a shared network drive.  Whenever they access
the program at the same time  the program is either freezing or they

How can I delete data that has relationships.  For example I have a talble  
for clients and another table for individual  members.  So they are related.  
When I try to delete a particular person, ACCESS tells me I can't do it
because the table is related to another table ...

Access 97
This sounds like a fairly standard sort of thing to do, but I am stuck.
I want a text box in a form (to update a field in a table) to be enabled or
disabled for editing depending on the value of another field within the same

I have here a small problem...
I need the get the day-number of a date, for example from the date
21-11-2005, I need the value 21 in a variable...
Is there a function to do this or some kind of trick to do it simple?

I'm wondering if there is a way to copy the menu line a made in one accesss
file to another.
When it comes to queries, forms, reports etc I can use the Import function,
but I have not found any simular way to import the menu line.

I need to sort this out today if possible as I don't have much time to work
on it after that.
I have set up a DB at work and each month we will receive data in delimited
txt format.  I need to be able to update the DB (5 tables) with this data.  

I have a report based on a query that displays 3 fields. 1 is a number of
items produced (A), the next is number of items destroyed (B). The last field
(C) is calculated based on the 2 previous fields: it s the % of compliance 1-
(B/A) (# of destroyed/ # of produced).

I was trying to have some of my input in upper case letters. When I use the
input code > nothing happens. What am I doing wrong?

Hi All, I posted on the wrong thread, I am newbie to Access, any help will be
appreciated.
I have 4 tables:
PROTO                        PROTOITEMS              WEEK                    

Am looking for help in scheduling two teams of five (5) persons....7am to
3pm, and 3pm to 11pm...Mon-Sat. (Sundays off).  Furthermore...of the teams of
five, the team covering 3pm to 11pm would give up one to cover 11pm to 3am...
Major holidays off. (covered by On Call ...

Thanks for organizing this great web forum, hope this will settle my problem.
I've created a form with search command button with code;
Me.Filter = "[YourFieldName]='" & YourFilterValue & "'"
Me.FilterOn = True

Lately when I open a access data base I ge a window that says "Windows
Installer and Prepairing to install" the message flashes on the screen for a
few seconds and then goes away. If I open a new data base without closing
access I don't have the message, only get it if I shut ...