Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: marle35
  • Content: Threads
  • Order by date
  1. marle35

    What are some good questions to ask the interviewERs

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

    Move chart in Excel from Access

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

    Access opening in read-only mode or program not responding

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

    Conditional formatting is making text blink

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

    Why is database so slow when more than one user is on?

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

    Determine database path in Data Access Page?

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

    Determine the default folder of database

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

    Display stored images in a data access page?

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

    combo boxes have problem dropping down when clicking arrow

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

    Data Access Pages EXTREMELY slow to load

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

    How do I make a data access page disconnect from the DB?

    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?
  12. marle35

    Adding info. about individual records, with mult. records showing?

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

    DAPs don't load even though Office Web Components installed

    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?
  14. marle35

    Hide details in a Pivot table in Access 2000?

    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?
  15. marle35

    How do prevent unenabled objects from having grayed out text?

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

    Can't add totals to Pivottable

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

    Improving performance of Data Access Pages

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

    Using the chart object

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

    Accessing listbox selection in listbox AfterUpdate event

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

    Textbox grow vertically to fit text on a Data Access Page?

    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?

Part and Inventory Search

Back
Top