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

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

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.

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

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

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

I am new to VBA and are trying to insert data entered by the user on a form to a table. This is the code I have so far, but the Dimming and setting of CurrentDB does not work. What could be the problem?Dim tbl As TableDef Dim db As Database Dim rst As Recordset Set...