Search results for query: *

by the interviewee for an entry-level database maintenance job? All suggestions extremely welcome.

I have code that creates a chart in Excel and moves that chart to a certain sheet. This code works in my home Access 2003 (and Excel 2003), but not from Access 2000 (and Excel 2000), which I need it to work from. It just creates and leaves it in the existing "Sheet1." I want it to be in the...

There is one computer, that when opening an Access database from within Access, gets the message "this program is not responding". Then when Access is closed, and they try to open the file from the Windows browser, they get a message saying that the database is open in read-only mode. But this...

I have a subform of continuous forms with conditional formatting that works fine on one computer, but on another computer the conditional formatting makes the text constantly appear and disappear (blinking) making it hard to read. What could the reason be? It's only with continuous forms.

When 2 or 3 people or on, Access is at least twice as slow. Is this normal? And if it's not, how do I find out why it's so slow? FYI, in advanced options, the following options are set: Default open mode: shared Default record-locking: no locks Open databases using record-level locking: TRUE...

Is there a way to do that? Other than attempting to parse it out of the connection string, which has other information in it?

Is there a way to programmatically determine either the "default folder" or the folder path that the database file resides in?

Is there a way to store images in the database, but also have them show up in data access pages in addition to forms? I know I can store links to images, but they exist outside the database. I have tried the OLE object datatype, but Access won't let me put that in a data access page. Is there a...

I have a form with unbound combo boxes. These boxes will not drop down, unless the users clicks the very bottom tip of the arrow. This is unlike all of my other forms with combo boxes, where if you click on any part of the arrow, including the middle or top of it, the box will still drop down...

I have some data access pages on a shared network drive that access an Access database on that same drive. On some computers, the pages load lightning quick (less than a second). However, there are other computers that take many magnitudes longer. For instance, loading a page with just one combo...

I have some data access pages where no data is being entered into the database, just some combo boxes linked to queries. However, these pages create a lockfile and slow down the database. Is there a way to have the combo boxes fill with data and then disconnect?

I am working with an inventory system, and would like to have a form that shows all products and their current inventory levels, and next to each of them have a textbox for entering in new inventory levels. After the user enters in all their new inventory levels, there would need to be...

The Data Access Pages work on some computers, but not others. The DAPs were made with Access 2000. Internet Explorer is used in all cases. What are some possible reasons that no data loads?

The version I am working with does not understand the command Pivottable.ActiveData. HideDetails Is there any other way to hide the details without getting rid of them?

How do you keep the text black when the object, like a textbox, is not enabled?

I am building a pivottable programmatically, and I am able to add all the appropriate row, columns, and detail data, but I am unable to add totals. I have tried this with Access 2000 Pivottables 9.0 and Access 2003 Pivottables 10.0. Access 2000 gives an error stating something like "You cannot...

My DAPs sure spend a lot of time "databinding." Besides changing the underlying queries, what are ways of speeding up data access pages?

I have a problem in that I am unable, at times, to set the property of .ChartTitle.Text of the chart object. I found that this happens when the chart has no data. For instance, a product is chosen that happens to have no data associated with it. So nothing appears in the chart. Then, a different...

I am using Access 2000. I have a single-selection listbox in a form, and I am able to access the selected value, but only at a later point like when a button is pressed. In the the AfterUpdate event for the listbox, the event fires but when I try to access the selected value, I get "Run-time...

I am using Access 2000 and would like to know if there is a way, in a Data Access Page, to make a textbox expand vertically when there is a lot of text in it?