Hello, I would like to assign sequencial numbers to invoices (YYYY/sequecial number), where YYYY - year: 2008/1 2008/2 2008/... but when a new year is...

I have a report that contains 2 graphs that work off the same query but different fields. Also on the report I have test data information that is pulled from...

Hi I import data tables, that come in through another source (mainframes & Spreadsheets), every week. However the fields names of the tables are all coded...

Is there a way to get the AutoNumber feature in Access to begin incrementing at a number other than 1? For example, to begin the numbers assigned to a customer...

Good morning, I have created a form for our field reps which they will be completing to escalate an employee issue. One field I have in my bound table is...

Hi let's say i have 2 tables with identical structure, date and value for example. These 2 tables contains overlapping data for example, the first table ends...

Hello, I have 2 tables of our church membership, member table and addrfess table In member table there is a foreign key of address table. When we come to...

OK this may be easy but I am stumped. I have a table "Employees" it has two columns: Employee and GroupTitle I have a second table that tracks points per job...

How can I ascertain whom, on a network, is accessing the Access database? On one form, I have a text box which displays who printed the form using...

Need to create a routing slip for employee use

I have tab delimited text file with some 155 columns. When I try to import it into an existing table using the import wizard it gives me an 'Invalid Argument'...

Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

On a FE/BE Access 2007 database the IT team asked me not to use a mapped drive letter but the server name and path (UNC) when linking tables. I changed the...

I'm trying to establish a medical excel file for my mother. She has a complicated medical history and everytime I think I've created an effective excel chart...

I want to replicate my database and see from a posting in the Replication newsgroup that it is advisable to create a Front End and a Back End and only...

I need to be able to pull specific fields from a table based on inputs in a form. I have two Tables set up as follows - the first is called TYPE and the...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

Hi. I’m relatively new to working out how to structure tables, so hope someone can help me I need to set up a case tracking database which tracks leads and...

I am trying to create a database to allow our employees to locate artwork for 4 different product types, silkscreens, metalphoto, labels, and misc. The...

I created a new Access database using Access 2002 SP3 I made a table and a text field with field size 200 When I try to paste text into this field I get an...