I have to do monthly report form, due to the weakness of Report within Access
and the complexity of the monthly report form, the best way of achieving it
I’ve ever thought is:
1. To do some queries (for example one query for calculating one column in

I have a database for apartments.  One table lists all the amenities for the
units.  There are two fields from this table that I require for a report and
several rows for each property.
I know how to append two data fields( Amnt:=data1 &" "& data 2) but I'm

I am using the Access 2007 Developer Package Deployment feature to deploy a
package using runtime.  It seems to work, but two things are wrong.
1.  I am uing the package Deployment feature to add a registry key. I wand
to add "HKEY_CURRENT_USER\Software\Microsoft\Office\12 ...

Hello all!  Thanks for all that you do ahead of time.  Without getting too
far into detail I would need some direction as to how to keep some data.  
Please let me know if I need to get into details.  
I currently have a database with salesman information and from time to time

In my worksheet, there are "A" and "B" located at different cells.
After running my macro, these two data will be changed to other cells
randomly.
I would like to write another macro that find the location of cells of these

I currently have a table in SQL.  One of my fields is a MONEY data type
field.  Is there anyway to drop off anything after the decimal point and make
the values in there whole numbers?

I use an excel sheet to send data to an MS Access table. Basically, I fill
the form out and it sends the data from specific cells to an access database
when I click "submit". It has been working fine for almost a year. Now i get
an error that the database can not be located, and ...

I want to calculate length of service.  Excel sort of guesses and doesn't do
it.
I DON'T WANT THE DIFFERENCE IN DAYS.
eg: start 01/may/1980 leave 31/may/2008 = 28 years and 31 days.

  On my continous form I've many fields: timer,SR number,Agent name....ecc.
I want users to select a field then to press on a button to sort the form by
this field,then another one to sort the form descending...
How can i do this...

Hello, I have a question. When I put a button on my form there used to be a
wizard that would come up that would ask me what I wanted to do with the
button ect. but now it doesnt? It worked and now it doesnt and I dont recall
changing anything that would of affected that. Please ...

I have a report which has data in 26 columns across the page. There are
7 tables with 3-4 fields in each table that have to be pulled together
to make up the report. In the query, they are all left joined from a
table that contains labels for each row. Thus it is possible for the ...

I have created a mail merge from an Access database and need the results
displayed in a table. At the moment instead of getting 1 table with lots of
rows I'm getting lots of tables containing 1 row and each table is seperated
by a page break.

When button_1 clicked
it must sets price of specific item in a sub form specific row using
following code
Forms(formA)(formB)!Price.SetFocus

I have tried a sql that looks like this:
DELETE [Bokföringen mxg].TRADE_DATE, *
FROM [Bokföringen mxg]
WHERE ((([Bokföringen mxg].TRADE_DATE)=#5/16/2008#));

I have a combo box [cbStatus] which has a row source Yes;No
and a text box [tbInvocing] if [cbStatus] is "No" can [tbInvocing] show "No"