Hi, I'm having troubles getiing a form/sub form to requery. Shift F9 works fine, however... Me. Reqery Me.Forms!!.Requery Forms!!.Requery and don't seem to...

Twice a day I run a series of queries that re-make tables full of financial transaction records for various segments of our enterprise. For various reasons...

I have a form with a subform. The subform is based upon the table order detail and the subform is name Order Detail subform. In the footer I have a field...

G'day all I have been asked to set up the following from our Database and am not sure how to proceed. We have a database with the fields , TenderID, Employee,...

Is it possible to copy a query, form, or report in Access 2007 and rename it and use it as the basis for a new query, form, or report? Or, is it necessary...

If I use several list boxes on a form to filter the data displayed on a subform using the subform's "record source" SQL statement, how can I have the query...

Hi guys. I created an Access 2002 database program (badge.mdb) on my computer. The remote side computer had Access 2000 running on windows Vista. When I put...

This is a test message.

When I use a list box as criteria in the sql statement to filter data I would like to return all data if the box is left blank, any Ideas?

How do I go about locking Records more than 3 Months old, I do have a text box on my form, I am trying to lock if is more than 3 Months Old ! -- Thanks...

Is there a way to 'count' the difference between 2 letters? Such as being able to determine that if I begin with "M" then "K" and "O" are differences of...

I have created a table in Access, and I have serval Numeric Fields but when I type in "39.40" it displays as "39.00." I need the numbers after the decimal to...

Sept 11. Still remember what I was doing and who I was talking to when I heard the news.

I have two command buttons for clocking In and Out. Everything works great when i pressed the clock in button it recorded the employee id, dept id and time...

I am having an issue with MS Access. Here is the situation: We keep all of our backend and front end mdb files on a network share that only myself and a few...

i want to link the columns within my table, well im not sure if link is the correct statement, basically i want it so that if the information in column A is...

Hi Folks, I have a database which uses a bunch of lookup tables. Many of these lookup tables have auto-generated indicies, and can have records added to them...

How do I get MSN Access 2000 to allow me to import a *.prn file which is an excel file turned inside out ---- without getting an error msg ---- "Database is...

I have two questions regarding Access/Excel linking: 1. I know that if an Access table is linked to an Excel spreadsheet it cannot be edited for whatever...

My team has a workbook that has quite a bit of manual work involved. I am attempting to streamline these documents. I have successfully created the...