Search results for query: *

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

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

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

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

I tried searching for solutions to my problem but I really don't know what to search for. Here is what I need to do. I have a listbox that contains friendly names of data elements. These elements refer to larger tables of data. For example, the listbox may say "Total Hours" but when you...

I am trying to set up a table link to a series of files that do not have "txt", "asc" type extentions. The filenames are names of newsgroups actually. How can I link directly to them? When I try to link to them, Access tells me "You cannot import a text file unless it...

I browsed the forums and couldn't find this exact situation discussed so here goes. I am trying to calculate the difference between two times that are formatted like this "830", "1110", "1430" etc. I really don't have to worry about crossing the 24 hour mark or...

I have a HUGE MDB file of various queries that I use to produce various reports. My queries are getting all jumbled together and stuff. I am in the process of needing another rather complicated query written that will utilize several queries and tables etc. I would like to write it in its...

I frequently use Access to populate raw data in Excel spreadsheets then use Excel to report them. How do I open Excel with a particular spreadsheet running upon open? I don't always know where the Excel executable is, I would think there is a variable or something. Any advice appreciated.

I work for a delivery company and need to combine the results of two queries into one dataset. They are: Delivery Query 1 - Center Number 2 - Vehicle Number 3 - Employee Name 4 - Data Date 5 - Sum of Delivery Packages 6 - Count of Delivery Stops Pickup Query 1 - Center Number 2 - Vehicle...

When I click HELP:MICROSOFT ACCESS HELP in Access XP I just get the little help wizard. Isn't there a detailed help in a manual type format? The help wizard doesn't seem to cover much and there is no table of contents or anything like that. Am I missing something?