Microsoft Access

Microsoft Access 1997 emailing

"I have a business that currently is set up on Access 1997. We have an option that allows staff to email directly off this data base to our customers. However this is only in an HTML format. I would like to change this to a PDF format. So essentially I am looking to change the way I am emailing my...

Trying to learn - How to filter dates...

I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only get current dates needed. I need to know a way...

Microsoft Access Report "Specific Printer"

Cannot get MS Access reports to let go of default printer. Selection of "Specific Printer" in page setup does not get saved. Also set .UseDefaultPrinter=False in code but it goes back to true no matter what. Have also tried every conceivable means of setting properties of both application.printer...

Access 2003 using VBA

I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have...

Resizing fields to see content in Microsoft Access 2003

In Access, to expand a field to view the field's contents what can you press?

CSV to Access

I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?

Creating Ref numbers from two fields

I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.

Simple SQL server question?

I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help. This is what I want to do, in order: 1) Select the top # records of a table, "#" is a field in another table....

Update Access Databse

How do I set up web application, using classic Asp to update access 2002 database?

Barcode scanner that dumps into text file

Hi, I'm going to try to implement a barcode system to keep track of inventory. I was wondering if anyone can suggest the best handheld scanner to get that will let us scan several barcodes and then dump the scans into a text file? Or if anyone know of another better way to accomblish this. I'm...

printed out in Access to populate the box

I want to have a field where the date the form was printed out populte that box in Access 2007. How do I set this up?

Data Entry in Microsoft Access using ASP

Data from the form not able to add into the database although using Internet sample source code.

How can we migrate Oracle database to Microsoft Access?

oracle to ms access

Using Microsoft Access to create reports from MACOLA

Where can I get instructions on using Microsoft Access to create reports from Macola?

Paste from Microsoft Excel cells to Microsoft Access table successfully but...

When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

VB6 retrieving MSAccess all records in VB6 ComboBox

Im beginner to VB6 and I have project to buildup company Database, I will be so grateful if anybody could help me in that: "How can I get all records of any field of MSAccess database in ComboBox or ListBox of VB6

How to use lookup query to return only entries matching the related field of active record

I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

subform

I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the command button to open the subform the...

Delete duplicate values in Microsoft Access

there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

Database Access 2007

Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can't any hint? When I go into my design mode those new fields do not apper?