Search results for query: *

I have exported a report from Access to Excel. When I open the spreadsheet in Excel, the fields are switched and there is no formatting. I have tried to create a macro, but the data will not be in the same structure, ie: content, lines between rows, and there is a subreport on the report etc...

dhookom, I tried hiding, but since some of the data would be duplicates such as: status and date, I was missing data. So, I have used the subreport method. Thanks.

I have a report that has reports: incident, status, severity, description, and notes. The Notes reside in a seperate table and each incident can have multiple notes. I only want the Incident information to appear once, but have the additional notes listed below it. Right now I have a query...

I have a report in Access that I have tried to export to Excel. Well once in Excel I have to do a lot of formatting. This report will be generated on a daily basis, and distributed to a group that may do modificications to the spreadsheet. I do not want to take the time to format the...

Cghoga, your advise was the trick. That was alot quicker to implement than the hours of playing with the expression builder and searching the web for information on how to do this. two thumbs up!!!

In my report I list incidents based in status, which comes from an incident table. I also have a notes table that stores additional notes related to a particular incident. I need to create a query that will pull the right notes related to the incident. ie: Status IncidentId Severity...

I have a report in Access that I have tried to export to Excel. Well once in Excel I have to do a lot of formatting. This report will be generated on a daily basis, and distributed to a group that may do modificications to the spreadsheet. I do not want to take the time to format the...

I have reports that can be printed from Win98 correctly, but for users that are on Win2000, the report is missing data on the left side. It looks like it wants to print portrait, right justified, but landscaped. Any known issues with W2k printing.

Thanks for the suggestions. I tried Lotus Notes, but the group that needs it, wants it restricted to just their group- and Lotus Notes does notallow for that- atleast that's what the Lotus Notes Admin told me. Also, we are not in a position to purchase software. But once again, thank you.

David, Did you ever find any Conference room reservation code? I am in the midst of this kind of project. Could you direct me to any resources? Thank you

Does anyone know how or where I can get a grid that will display a weekday list of appointments by hours. ie: 8:00 John Doe- team meeting 8:30 9:00 9:30 10:00 10:30 And say 8:00 - 9:00 would be shaded grey. Any ideas, suggestions - would be greatly appreciated.

I am using Access 2000 as well, to write a text file.

Thank you very much, RJFost and DramerZ. I used Format(Date(),"yyyymmdd") and that worked great. Thanks for your speedy reply and assistance. soontobefour

I need to change the format of the date() function. When i try to use it know it yields mm/dd/yyyy, but I need it to produce yyyymmdd (without dashes). Does anyone know how to produec the date in this manner? You help would be greatly appreciated. soontobefour

hey Ben, I tried the code and it worked. I had to do some tweaking to better format my data, but I truely apprecaite your assistance. two Thumbs Up

I am looking for some assistance, writing a table to a .txt file. I have tried to use the transfertext method, but the data must be formatted with // between fields, so the transfertext does not work. Any assistance would be appreciated. Thanks

On my ASP page I have a parameterized Sql query that is to display the results in the DTC grid. But I don't know how to get the information in grid. On the properties page of the grid I specify the Recordset as objrs and Field/Expression to "=objrs("Room")" etc. But id...

Viv, The results I would like to display is the room and capacity for the rooms that are available. I want it displayed on another form. How do I do that?

I have a form that gets user information, when done they click on the "search" button which is to launch another form and on that form display the results of a query. this is the code on the new form launched: Me.RecordSource = "SELECT Reservation.Room, Rooms.Capacity FROM...

I have a form that gets user information, when done they click on the "search" button which is to launch another form and on that form display the results of a query. this is the code on the new form launched: Me.RecordSource = "SELECT Reservation.Room, Rooms.Capacity FROM...