Search results for query: *

I have many crosstab queries with different criteria however they all have the same date column headings. I'm working on a rolling year so the mmm-yy format is what I'm using. The problem is every time I update the data I have to manually go into each crosstab and change the properties for the...

I'm having trouble with a form that when I open it directly it opens in datasheet view which is what I want. When I try to open the same form with a command button or from the switchboard manager it opens in form view. Does anyone know how can I get it to consistently open in datasheet view...

Hi, I have a list box on a form for the user to select a name. The list box is generated from an underlying table and there are thousands of names. If the user selects the list box and types a letter the first name beginning with that letter will be brought up. My question is this: Can you...

I've set DisplayAlerts to False before I close the current workbook because I don't want to be prompted to save. However I'm worried about the macro closing before it has a chance to reset the DisplayAlerts to True. Is this an issue I need to address or does Excel automatically set the...

I wrote the following code to get data from one sheet to another. On the destination sheet I want to choose the next available blank cell to put the data into. Sheets("Newdata").Select Range("A1").Select Cells.Find(What:="The Data.", _...

Wondering if anyone can help? I need to import data into an Access table(s) from an Excel spreadsheet and I'm having trouble determining fields. My spreadsheet has months as column headers, modalities as row headers and the data is # of procedures done. Another row header is the location...

I've just got a new computer with Windows XP OS and Outlook Express 6.0. I'm trying to connect to my mail account but get prompted for a POP3 logon. The username is already in but I have to type in the password. The Remember Password box is checked but greyed out. I went into the accounts...

I am relatively new to working with macros and I'm trying to accomplish what I thought would be a simple task, but running into road blocks. A co-worker has asked me to put a macro on his computer that will stop him from having to right click on a cell, choose paste special and then select the...

Can anyone help, I have a form where the primary key is an ID number. The ID number is the first field to be entered on the form. I would like the user to know if that particular ID is already entered before they go through and fill in the rest of the fields in the form. I've been trying to...

I created a database to track medical records for particular patients in our practice. A few of the fields involve phone numbers. The database was designed in Access 2000. I had to switch to Access 97 because most of our office uses 97. I went through the converting process and compiled /...