Search results

Renaming Columns I'm not having much luck either. Thanks for the help. If I come up with anything I will post the answer.

Column Headings in a table I have two column's within a table. I need to add information to the column name's, such as a date range that will change. I then export that table into excel.

Is it possible to add information from a field in one table to the heading in another table? There is a variable that is required in the column heading.

In the Print window when printing an Access Report there is the option to print to file. This saves the file in a .prn file. How can I then open up the .prn file I saved and print it?

Is it possible in Access to create an .ini file to hold different paths needed in a database, then call the .ini file instead of coding each path? The company is moving and combining servers. All paths will change. Would be easier to change at this time to .ini files, so that if it happens...

Double, Format = Fixed, Decimal = 3 I am trying to accomplish this in VBA. I can send code if that would Help?

Is it possible to stop Access from rounding in a select statement or query when grouping by one field and getting a sum in another? I have to compare the summed field in the table #1 with a like field in table #2, compare for any variance, and then prorate back by adding or subtracting any...

I have a report with 4 sub reports imbedded. Each report has a separate table it reports on with 3 fields and 2 of the fields have sum formulas. Here's my dilema. When there are values in one of the fields with formulas I see all of the fields with 0's if no sums. If a report does not have...

Thank you the solution worked.

I have a table that has varying numbers of rows with unique data, i.e., Col A = xxxx and Col B = B or S, Col C = D or U. I can have XXXX B,D or XXXX B,U or XXXX S, D or XXXX S, U. These are group by XXXX. Finaly the question. How do I assign a unique number for XXXX B,D Etc. If I have 10...

When the database calls this function it returns the runt-time error 3027 Can't update database or object is read only. I am opening the recordset with the Set rstOrders = dbs.OpenRecordset("qryRoundConfirmedORDERS")but when it moves to the rstOrders.Edit it errors? Where should I look next to...