Can I do unique multiple replacements? For example, I have over 50,000 records and I need to replace several different text with other text. Can I do this...

How can I make Microsoft Access give me a sign that the date that I put in a given field of a record, is equal to date of the computer ( in the future not in...

I have an Access database that I would like users to be able to see reports from or enter data into forms remotely. We have a VPN but even with a T1 the...

Hello, I'm trying to import an excel file using a macro and a field on a form. I would like for the macro to reference a field in a form to capture the path...

Hi, I have a table of Propert Addresses, and a Table of Tenants within the properties, and I am trying to build a table for maintenance issues. The first...

I've moved my database to a new computer. Now a couple of things are working right. I checked the References in the Module, but nothing shows up as missing,...

Hi, Friends. I'm hoping someone will help me think through this problem. I want to automate the 'Publish to the Web' wizard in Access 97. When you select...

I have two tables, each with individual information about the same "Job". The information is linked through the "JobNo" fields. What's the easiest way to...

Hi I am having some problems using Date Range on Crosstab to create a Reports. I specify the 'StartDate' & 'EndDate' for the Date Range in the...

I have created a database that monitors the QA vendor risk process. In the main form of the database the user performs a lookup for a specific vendor and...

I need to create a simple database with 2 tables for several people to use. They key will be the project number (colum #1) on both tables. I have never coded...

I put in the incorrect outgoing information in for my mail server and I don't know how to change it again. Can someone please tell me?

Is it possible to format text in a memo field to be a bulleted series of steps? For example: * Step 1 * Step 2 * Step 3 All 3 lines of text would be in one...

I have a form that contains two fields and . is a drop down field. If I select "Complete" or CompleteDeem", I want to auto populate with todays date. ...

Hi all, Had two questions about indexes and queries 1) suppose I'm doing a simple group query and counting the groups, ie "select category, count(*) from...

Hello, I just had a quick question. I have set up an invoice db but in my calculations, when the result is negative, the result has a negative sign in front...

I am wanting to build an mot/insurance checklist database and new to building databases, any ideas where I can find a template?

Well, as the world is changing we also need to change, our behaviour, thoughts and action should change, so to style of earning money !! Working from day to...

Hello - I have recently begun a job where we need to transfer files to Excel, make a few data manipulations, and then import the data into access. The problem...

How can I set a chart's axis to show only whole numbers and not decimals? thanks -- deb