Hi, I've a little problem. I have two tables : - one with records with an id, a name and a field interest rate. Two records can have same id. - one table...

How to report a date in fiscal qtr's, our fiscal year begins Nov 1 of the year. How to covert a date to format like 2005-Q1, 2005-Q2 when using crosstabs and...

How do I make a poster collage from photographs?

I have screens that pop-up at certain times. I have a start time and an end time. The whole thing works great except....whenever I go to midnite for the end...

I have access 2000 and 2003 installed, but I am using access 2003 and want to use the calendar control. However, my calendarcontrol says 9.0. Shouldn't it be...

I got the message during an update that says "You are about to update 4 rows". But once I click yes I get a message saying I can't update because of a...

I'm trying to add text to a drawing but cannot get rid of the outline of the text box. Can you help please? Cheers

Could someone tell me what is wrong with this: program = DMax("", "", " " & Date & " AND ", "", " " & Date It returns a value where the startDate is less...

There is plenty of VBA code around that allows you send email messages. Does anyone know where I can see a sample of VBA code or a technique that only opens...

Any kind of advice is much appreciated to help me overcome this problem. I have a Customer and Orders table In an access application with a one to many...

I am unable to use the Page View features from the Objects box. I click on Page View which is right under Reports and the buttons "Design" "New" "Open" etc....

Ok, so I think I made really dumb mistake...as I was creating my switchboard, still in the devlopment stage...I selected some buttons that got rid of my tool...

for hp xp home edition: how can i manually delete a virus? i know the name. Instructions I have must not be the right ones.

Hi, I tried creating a form in excel using vba, but i can't add the components from the control box to the form because it comes up with an error message...

I am creating a database where I would like a user to enter a full or incomplete date, depending on what information they have available. For example,...

Hi all, I know this is not a pure Access question but many of you are so good with SQL and Recordsets I'm going impose. I use this SQL in the Access query...

How do you display the results in a textbox from a query in an exit event of a previous textbox?

Hi Group! I have an ID Field with Number data type and I want to convert it to an auto-numerical field.... How do I do this right now containing data in...

I know this is probably considered a bad idea but I want to go into a database and search & replace every instance of a particular text string. I have been...

I'm at a loss. I have an invoice report that has varying numbers of detail records for each customer. I need a page break and line to show up at the bottom...