Search results

  1. C

    Locked .accdb file

    Hey folks. I have a database with extension .accdb. When I open it, everything is locked. I can't access VB Editor, Navigation Pane, Ribbon, nothing. It just opens a form and the only thing that can be edited are the text boxes on the form. I can't use Shift when opening it, that does...
  2. C

    Query Critera to Show all Numbers

    Hey guys. I normally filter text fields in queries using combo boxes on forms to show all records. So I set the default combo box value to "*" and use query criteria Like FORMS!MyForm!MyCombo How can I achieve this for numeric fields in a query? I want to have an option in my combo box...
  3. C

    Append Query Extremely Slow

    Hey guys. If someone can find the time would they please have a look at the database I have attached here? What it does is calculate average cases shipped for each day of the week from 4 tables for each day which contain an average or 15,000 records each. There are queries that also has to...
  4. C

    Store Calculations in a table and run them in Code

    Hi guys. Does anyone know if it's possible (if so, how) to store a calculation in a table and run that calculation in VB? I have about 20 different calculations that I would like to store in a table rather than hard code them so they could be edited by a general user who knows no VB. For...
  5. C

    Out of Memory Error While Working With Clipboard

    I'm attempting to save a screen shot of a form as a bitmap. My code works correctly sometimes but somethimes it doesn't. Here's the code: Option Compare Database Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte...
  6. C

    Do Not select records if duplicatation in specific field

    Do Not select records if duplication in specific field Hi. I have a table with several fields. Some records will have the same information in certain fields but different info in other fields. Three fields in question are: [CaseID], [Batch], and [Trip]. Suppose there are 3 records in the table...
  7. C

    SQL Append Query

    Hey guys. Would someone be able to please point me in the right direction? Here's my sql: strSql = "INSERT INTO t_EmployeeData ( PayrollID )" & _ " SELECT t_employees AS t_employees.ID " & _ " FROM t_employees LEFT JOIN t_EmployeeData ON t_employees.ID = t_EmployeeData.PayrollID " & _ " WHERE...
  8. C

    Poor Performance in Recordset Loop

    Hi. I'm wondering if someone would please let me know if there is a better way to run the loop in the following code. My code is extremely slow on a core 2 duo 3.16GHz cpu with 2G RAM. My goal is to loop through a table of approx 5000 records, perform a calculation for a field and update that...
Back
Top Bottom