Search results

I am compacting a database everytime it is opened with the following code: DBEngine.CompactDatabase str2Print_TDI_Path & "NewTDI_be.mdb", strTempPath Kill str2Print_TDI_Path & "NewTDI_be.mdb" Name str2Print_TDI_Path & "NewTDI_be1.mdb" As str2Print_TDI_Path & "NewTDI_be.mdb" The problem I ran...

Is there a way to put a functioning button on a report. Have a rpt that is at times more than one page and I want to duplex print at that time. They also want to preview the report prior to printing and do not want to minimize the report to click the duplex button. Any ideas?

I have purchased an new laptop with Office Professional XP. I cannot get the font color to change in access. Palette comes up, I can click on a color but it does not change? I have went into setup and added all of the options to access not loaded originally. I can change the font color in...

I have two pop-up forms that I want to minimize when a report is previewed. Now the two forms stay in front of the report that is being previewed. Anybody have any ideas?

Is it possible to edit a power point slide within Access? They want the ability to change the name of a company on a power point slide using criteria from a query, then print the slide. They want to do this from a button on and Access form. Who thinks up this stuff?

I have an unbound entry form not populated by any query or table, that users enter date, function, number, time and user initials. The function is a combo box with a list of 97 different functions to choose from. The time function can have a user entered time value or I have created code that...

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

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

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