Search results for query: *

Thank you all for your help!! I just love this site. I ended up using a table and linking to it like Kevin suggested. Works great, now I just need to modify the table rather than all the queries! Thanks again, Andrea

I do update the table every month just to contain the date range I'm looking for. Unfortunately the In statement of my queries does not automatically update because I'm not using the standard year but starting in the middle of one year and going into the middle of the next, it just leaves the...

Thanks Kevin, I don't think it's the format I'm having trouble with. Here's the SQL for the query ... TRANSFORM Sum(CurrentDataQuery.QTY) AS SumOfQTY SELECT CurrentDataQuery.[REFDR NAME], Sum(CurrentDataQuery.QTY) AS [Total Of QTY] FROM CurrentDataQuery WHERE (((CurrentDataQuery.SiteID)=1))...

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...

sirkenj, Did you ever solve your problem and restore the min/max/close buttons? I was having the same problem just recently and found this thread with a keyword search. I fixed my problem by going to Tools: Options and under the view tab,check system objects, the buttons were then restored...

I'm not going to waste your time on this ... there are many other options that I can use! I'll save it for something more important. Thanks anyway!! Andrea

It's really strange, all of the properties for the form are set to datasheet only. If I just open the form I have no problem and when I create a macro with OpenForm command and set that to datasheet view it still works. It's just when I open it from the switchboard manager form that I'm having...

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...

Thanks, I'll give it a go.

The list box I have does that already, for instance, if after selecting the list box I type C, it puts me at the beginning of the all of the C's. What I would like it to do is allow me to type in CAT and it will put me at the beginning of the CAT's. Since there are so many names, my users are...

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...

Thanks Joe! I just sent you an e-mail. Andrea

Raskew, Were you ever able to find the issue that covered this problem in "Inside Microsoft Access?" Thanks, Andrea

Skip, Thanks for you help, this makes more sense to me!! Andrea

Skip, If I'm searching for the next blank cell in row 6, would I just replace A1 with A6 and replace Row(s) with Column(s)? I don't understand how it knows that a blank has been encountered. Sorry, don't mean to sound ignorant but I'm fairly new at this VBA stuff ... Thanks, Andrea

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.", _...

Thanks for the suggestion, I'll get to work!!

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...

Chuck, Yes, I do retrieve the e-mail. Andrea