I have an existing database that was created before I came to work where I am by someone who knew what she was doing, but I have some access experience also...

how can i create See thru colour panels in Access 2003

Hello everyone, Your assistance on this will be appreciated I created a simple form in access to scan barcode item information. For example, there is a label...

Hey guys, I have a key number that I need to create a sequential number based on that number. For example: C-202743 and when you enter new record I wanted to...

Hi, I created an Access 2005 database and the back end currently uses an MDB on a network server. As what usually happens it's grown beyond what it was...

I'm not an Access power-user but was thrust into the role of creating a database and forms. I have the DB mostly complete but am having trouble figuring out...

New to Access. Set up lookup list for an item file but there are thousands of item numbers listed. Is there a find function for use while in the lookup...

Hi All. Anybody have experience to link mdb to MySQL database situated on remote server (Remote as in 1500km away). VPN maybe?? -- Kepior Senso Fumor

In A2007, I import data daily. the date field is not part of the import, nd I want to auto fill that with yesterdays date. So something like Today(-1) How...

I am planning the creation of a database in Access 2007. I will, in the future, us SQL Server (probably 2008) for the backend. Can you direct me to some...

I am using a template to track Adult Education at a church. The template has two tables (students & instructors). However, in my situation, a person is...

This may prove to be an open-ended question, but here goes. I'm anticipating having three tables with one-to-one relationships back to another table. All...

I have two subforms and in . Both subforms are Continuous Forms depending on different queries. In I want to apply a filter like: =!!!. However, although...

Hi I am new to designing databases and would like to know how to create a macro that I can attach to a button that would open a pre-populated message. I.e....

I've received a directive from my boss's boss. He'd like to see a database to record "key" process events. He'd like something with "key words we could use...

I'm having second thoughts on normalizing my Insurance information. I thought I had a good theory this morning, but am having problems fleshing it out. ...

I currently use A2003 w/sp3 on a lan. All databases are designed FE/ BE. A piece of the code of a module I've written inserts the hyperlink to a file stored...

Hello, I have an instruction document (with pictures) in Word on how to input data in the database. What is the best way to link this document to a button...

I am trying to figure out the best way to set up a relationship. I have a table that has job information (ID, address, dates, etc.). I also have a table...

i have created an access database to track the amount of work that comes in, is processed and completed in one week, for my staff. I am now attempting to...