Search results

  1. A

    Strange combobox behavior

    I have a form with a subform which contains a combobox in one of its fields. What's buggin me about this subform is that when I enter two records in it, successively, the first record seems to save without problem, but the second one will not allow me to select any item from the combobox. The...
  2. A

    Why Access suddenly ignores these codes

    I have a module which contains file functions like exploring the disk to select a folder or to select a file, etc. written by Terry Kreft. It worked well for me for the past three years but suddenly today all of our PCs are exhibiting a similar behavior of doing nothing when the code goes...
  3. A

    Why is this so?

    When I am importing xls files into Access new table, there is no error but when I do it into an existing table, the process always end up in an error message that says : "An error occured trying to import file....The file was not imported." Has anybody encountered this before? Thanks.
  4. A

    Run-time error 2046

    I have a macro that works that calls the RunCommand Import menu and it works fine when the database is displayed but fails when the database is hidden. The error message is Run-time error '2046': The command or action 'Import' isn't available now. I tried converting the macro to a module and...
  5. A

    Moving reports

    I have a bloated frontend mdb (165MB and growing) that I want to breakup into smaller mdbs. Has anybody got some code that I can use to do this quickly, say reports in one mdb, forms in another, etc. Are there restrictions that I need to consider, like after the breakup, will I be able to simply...
  6. A

    Relative path for linked tables

    Hi, I am using separate/split databases for my interfaces (forms, reports, modules) and data but both mdbs reside in the same folder. This folder happens to be in a network drive with a letter different that the local drive of my user. I do the modifications on the network files and copy the...
  7. A

    another way aside from ODBC

    I have a form that needs to have an SQL table as its recordsource. Is there a better way to connect the form to the table without using ODBC? I have tried the ODBC approach but it seems that the form's data manipulation response time is too slow. Or it is just wishful thinking on my part to...
  8. A

    Updating parent table from values in child table

    I have a parent table with an amount column that stores the total amount of one or more child records' amount column. I created an aggregate query to total the amount on the child table per record in the parent. Then I created an update query to set the parent table's amount to the agregate...
  9. A

    Strange form inconsistency

    I have a form/subform data entry screen for a loan monitoring system. Each employee record in the main form can have one or more loan records in the subform. I have a bound textbox in the main form that shows the total amount of the line items on the subform but bound to the main forms data...
  10. A

    How to edit a text file from vba

    I need to edit a text file by reading it line by line and replacing certain strings with "". How do I setup the i/o section of my code? Pls. help.
  11. A

    help pls! weird table behavior

    i have a mdb using an attached dbf table. for some strange reason, the dbf table is read only when opened in my user's pc using winme and access xp but is editable when opened in my win2k access xp laptop. this behavior is consistent even when the mdb and the dbf files are copied on the user's...
  12. A

    Why -1?

    Can anybody please tell me why the RecordCount property returns a -1 in th last line of this code? There are two records in the 'CA' table and I'm using Access 2002. strCnn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & CurrentDb.Name Set cnn1 = New ADODB.Connection...
Back
Top Bottom