Hi I need a little help with a command for my query. At present I'm using this to find an *exact* match in the whole field I'm searching Like This one...

Example: 1. I select 'Homeowner' as one of my options in a list or combo box that I have created for a field named 'Category' (which will contain about 10...

Hello, I am new at Access and I have a problem that hopefully you can help me with. I have created a simple database with 3 tables: accounts, categories and...

We have a database with 1285 records which need to be amended, never deleted I want to create a button on the form that will delete all fields but one This is...

Hi I have two combo boxes on a form, cbo1 and cbo2. Cbo1 searches by name and displays total orders in list box (list1). Cbo2 searches by date and displays...

Is it possible to create a form that will get and update the data from two tables? do some of the fields will be from one table, and other from a different...

When a table or query is emailed in txt format, it produces a format that I cannot duplicate using the export wizard or macros. Is there a way to use code...

At work I copied the front end & back end to my thumbdrive & took them home where I copied the front end & back end onto my home tower. I have been doing...

I’ve just started learning Access 2003 and would like to make a form with new Customers and all their information, dealing with the window tinting business...

I know how to do the following: strSQLAPPEND = "INSERT INTO (FIELD1, FIELD2, FIELD3) " & _ "SELECT '" & rst.Fields(0) & "', '" & rst.Fields(1) & "', '" &...

I need to query by day, week and month. Is there a way to do this? For example I need to know all services that was done on 12/12/06, then all services for...

Another question. I have 50 records (or more) that need to be ranked. I can put a rank in manually but is there a better way to do this? Plus I don't want...

I just created a form that opens and functions perfectly from the database window. When I try to open it from the switchboard,"error 3021, no current record...

I have a search form using an Option Group for Name(Option 1) and Date(Option 2). In the Click event (Frame) either Name or Date fields/combos/lists are...

I want to add pictures to a database but no actually have them embed in the base it's self. I want to be able to see the picture in the base as well. I have...

I want a simple way to access a record in a database using an index key and then be able to change a fields content. I am a new user to access and cannot find...

Good evening, I have just finished creating an Access Database. While working on it, I entered a lot of "TEST" data. Is it possible to export or copy only...

I need help with Viewing/Deleting Object Dependency. Please provide info for a "beginner". Thanks. -- Bluebayou Desires to be a power user of the MS Office...

I am using Access 2003. I would like to know "how can I enter a Validation Rule that would specify users to only enter the numbers 1, 2, 3, 4, or 5"? In...

I've created an Orders Form similar to that in Northwind, and have been trying to learn by duplication. My Problem Is: I finally managed to get my subform...