I am using Like & "*" in a query and it works fine. However when I use that same query with that criterior as a table for a DAP it doesnt reurn any...

Just purchased Office 2003 with Excel-Power Point-Word,etc. How do I separate these files separately, but in each individual bucket ie:all Power Point(.ppt)...

Sorry, but my other thread seemed dead, so I cannot save as/export access queries anymore, I used to , last week_ _I really need the save as/export...

I have imported data from excel into access. all leading zero's were removed. The field is a fixed length of 11. How do I tell access to add them...

I have an employee database that contains both employees and applicants. I would like to separate the applicants from the actual employees. Can you tell me...

I am working with Access 97 and have a form with a ComboBox (cboFirst), a TabControl and a ComboBox (cboSecond) on the first tab. I also have a "Sentinel...

Hi.everyone. I am new to access but with the aid of ms access internet informations , I have copied the total time calculation module and it is working...

Hallo All Using "DoCmd.TransferDatabase acImport" in VBA, I am importing tables from SQL to Access. How can I import the Primary Keys as well? Regards, Janine

I need STAT help! I am a newbie and I have a database I that will tract quality improvement criteria. I need several things (reports, etc...) from this...

I am a new user and have build a database full of resources (with hyperlinks) to files. I have two different fields with sort of like keywords listed. ...

How do i set up a database so that i can create an online forum/guestbook

I have an Order Entry Template Database -- I am using the invoice included with the database template; however, when I start to enter an order, I get the...

I have created a form and everything shows up fine when I print it BUT How do I get the text to continue straight after each field. Like one field is called...

Help... I am importing data with a date field which is set up as Aug 24 2004. I would like to change that format to mm/dd/yy. Can I do this using an update...

Hi, I'm new to Access and learning more and more everyday. Besides my stack of books, I use the provided Northwind Sample database included with Access to see...

I know that f7 spell checks in the forms, but how do I set the form so it will only spell check the current record, and not every record I have for that form?

Hello, I have some questions: I need to develop something in which many users can complete data entry and the information can be stored and queried. Most...

I have a fully licensed MS office 2000 and Office 97. My problen started when I installed Office 2000 (except Access 2000 program) and re-install only the...

Hi I have generated with 3 columns. I would like to add a column to the table generated by the column which simply gives an index for rows i.e. row one will...

I am trying to produce an invoice report which can be in=20 either $ 0r =A3. It does not have to have a conversion=20 factor. I can not find a way of being...