Search results for query: *

I found it! Choose WINDOW:CASCADE in the menu bar. Very strange!

I was working in my Access Database and the main window in the application disappeared! This is the windows in which you click Tables:Queries:Forms etc and it lists all of the objects in your database. I cannot figure out how to get it back. I am using Acess 2003 SP1. Any help appreciated...

Perfect!!! I did not try that as you can tell. Thank you very much. Sometimes it takes a set of fresh eyes to see the simplest things.

I have a crosstab query that I am exporting to a spreadsheet via the transferspreadsheet function. The information reported in the query starts with September of 2004 to present. My problem is that the results start with 1/2005 in the first column, and then 9/2004, 10/2004, 11/2004 and...

I am trying to do this same thing. I follow the instructions here and indeed the users can see my secondary calendar...but they can also see my main calendar. I do not want them to see my main calendar, only my secondary one. They clearly have permissions only to my secondary calendar (I also...

Yes, that did it. I knew it had to be farily easy. I did this: Expr1: Format([TrainDate],'mm/yyyy') It puts the columns in numerical order. The Date are "counted" and is the VALUE. Thanks very much.

Actually, I made a mistake in the results...it should produce this: BLD JAN FEB MAR APR MAY ETC..... 100 1 1 0 0 0 101 3 1 0 0 0

Hello, I have a database with building numbers and dates. I basically need to create a crosstab query with the building numbers being the rows and "JAN", "FEB", "MAR" etc being the column names. In each column I need the total of occurrences of a date falling in that month for that building...

I just figured this out by the way. Thought I'd post it here in case someone else has this problem. All I had to do was remove the brackets from around RowSource above. So each line would read: [Forms]![frmMain]![lstElements].RowSource = .....

I am trying to populate a listbox based on option boxes that are chosen in an optiongroup. The optiongroup is called frameTable. I have three tables (Table1 - Table3) that contain the values I want to list in the listbox. If you choose the first option button, then the stuff in Table1 will...

Holy mackeral it worked!!!! I have been trying to do this for over a week. I have spent a lot of time researching this! Thanks a bunch!!!

I saw the post from 123FakeStreet, but the query I am running is a crosstab and it needs to be viewed as a crosstab datasheet. So it isn't practical to dump it to a table first as he does in his example. He appears to dump it to a table then open the table. That won't work in my case.

I am trying to do something similar to this too. I want to create a query on the fly and then run it. It is a crosstab query. I understand what you are doing above, but what if the query doesn't already exist? I want to create the query based on what is selected from a listbox. The item...

I have both Access XP and Access 97 installed on a PC. Access XP was installed first. I have to have both versions due to an issue with an old database that won't work in XP. It needs to use the Text Import drivers but they are not there for Access 97. I tried running the SETUPCD to see if...

Yes, it is declared in the function declaration: Function SQLStatement() As String It is the line above "SQLStatement=" above.

When I do that I get: Compile Error "Duplicate declaration in current scope

OK, I have retooled everything so I can give you specifics. I have a table called Testtable which includes the following fields TESTTABLE BLDG - Two digit building number WND_DT - Weekending Date DOW_CD - Day of Week Code (1=Sunday) DATAELEMENT - A particular statistic I want to sum, consists...

I tried everything I can. I tried RunSQL and RunQuery to no avail. I can print the variable and the SQL is correct but I cannot run it or bring up results.

I know I must be appearing dense here but I really appreciate your taking the time to help me out. I have a function that creates a string consisting of the actual SQL of the query. But if I try to run it using the DoCmd.RunSQL I get a run time error. I am guessing I may need a querydef or...

I tried what you suggested and got the following error. "The Microsoft Jet Database engine does not recognize '[Forms]![frmForm]![lstElements].[Value]' as a valid field name or expression." Your post mentions to put the statement in the criteria field, but in the instance above I put it in the...