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 derfloh 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: *

  1. NvrSaDi

    Cut from Access and Paste to Excel

    Excel has a tendency to interpret data as text which cannot be formatted. You can test by going to an adjacent cell and adding a value of zero to the cell in question. You will get a result in the new cell that is a numeric value.
  2. NvrSaDi

    Unexpected error from external database driver(10019)

    We have a similar problem with loading Paradox files into Access. If any programs are open and linked to the tables in any way, we get a similar message.
  3. NvrSaDi

    Users cannot open Access database

    If that does not work, check your ADOBE Acrobat installation(previous Tek-Tip thread saved my behind and my sanity on this one). If ADOBE Acrobat is installed with an option to load icons in MS Access on startup for Access, Access apparently interprets as a design change and locks out all...
  4. NvrSaDi

    error when trying to view 2 subforms

    I left out some code when I copied and pasted Dim strsql as string dim db as database set db = currentdb dim rs as recordset
  5. NvrSaDi

    Multiple user access (at the same time)

    I would add a few more comments. Once the program goes online, there is possibility of code and data issues. Some just give error messages, some corrupt the database and others crash the program. It is important that you create a login table or some other method that identifies users if there...
  6. NvrSaDi

    error when trying to view 2 subforms

    Attached code sample populates textboxes on a form without causing a conflict. Haven't tried it with a subform, but should work. 'Create a query with fields and copy the SQL code to a procedure in a module. This creates a "virtual table" that you can use as a record source for your second...
  7. NvrSaDi

    Database Closes Unexpectedly

    My experience has generally been identified as an MSAccess.exe error that results either from a code conflict or use of a reserved word in the wrong place.
  8. NvrSaDi

    Multiple user access (at the same time)

    Critical issue is avoiding conflicts in a multi-user database after splitting. I have had great difficulty finding help and would be open to any suggestions. I have just finished debugging a 50 user database on Citrix which has similar issues. My experience is... Tables in a split database...
  9. NvrSaDi

    Sorting text field into numeric values

    Not sure that I follow the former Texan, being a former Texan myself, but assuming that the appended letters do not wrap to AA, BB, etc, I would convert the letters to decimals and append to get values 989.1 989.2 989.3 Then sort, adding a second field with numeric IDS, and convert the decimal...
  10. NvrSaDi

    track form open and close events by workstation

    Simple approach to tracking users or computers: 1) Create a log table with fields -- ID, user or computer name, form name, In date, Out date. 2) Assuming a switchboard, on selecting a form from switchboard, use dmax function to identify highest ID # in table, add value of one and pass value to...
  11. NvrSaDi

    Import an Access table from a different Access database

    You can use a 3-step process with macros or code. 1) import the new table using macros which comes thru(hopefully) with a number 1 added if there is an existing table with the same name. 2) delete the first table 3) rename the imported table. First potential problem is that if the macro...
  12. NvrSaDi

    Select records to update on continuous form

    This is code that I use on a continuous form. As the focus moves from record to record, you can copy, paste, whatever to the active record. Private sub Whatever Dim n as integer 'CountEm is function that counts displayed records on a continuous form For n = 1 To CountEm 'Cycle thru...
  13. NvrSaDi

    More than one person writing to a record. Need Serious HELP!!!

    To ItIsHardToProgram. If you take a simple form with a table as a record source. Add the button with the code "DoCmd.GoToRecord , , acNewRec" and if there are no conflicts, it works fine. Add code such as "me.allowadditions = false" in a procedure such as form_open and you will get the same...
  14. NvrSaDi

    More than one person writing to a record. Need Serious HELP!!!

    The code that you used should work if there are no conflicts. You will get that message, however, if you have code such as "me.allowadditions = false" in a form open function
  15. NvrSaDi

    execute a query per code

    PHV is absolutely correct. I focus too much on the SQL code for action queries.
  16. NvrSaDi

    execute a query per code

    As additional comments, the docmd.openquery works for "select" queries. You can use the RunSql code for action queries such as update, append and make table queries. I insert the debug.print function so that if the SQL string has bugs, I can go to the immediate window and copy the SQL string...
  17. NvrSaDi

    Aligning data in a listbox

    To EarthandFire. Thanks.
  18. NvrSaDi

    Aligning data in a listbox

    To CautionMP Thanks, Think I can make that work.
  19. NvrSaDi

    Aligning data in a listbox

    I have an Access 2000 list box on a form with 5 fields - 3 string and 2 numeric. Data source is a query combining 2 tables. Default alignment is left. I need to retain left alignment of the string data and right align the numbers.
  20. NvrSaDi

    Ignore Outlook security warning when sending email

    Thanks PHV for the input. This has been a major headache at our end.

Part and Inventory Search

Back
Top