Search:

Type: Posts; User: APATTO03; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replace a set of characters (Access 2003)

    Hello all,

    I have a text string that includes dashes, numbers, alphas, and other special characters. What I want to do is strip out (or replace with "") any character that is not an alpha from...
  2. Replies
    2
    Views
    1,189

    Re: Using VBA to Print .MDI file (Access 2003)

    Instead of printing an .mdi, I ended up outputing the report to a .snp file which worked perfect. I did not realize that this output was available when I wrote the original post.
    Thanks anyway for...
  3. Replies
    2
    Views
    1,189

    Using VBA to Print .MDI file (Access 2003)

    Hello,
    I
  4. Re: Create Multiple Indexes using an SQL (Access 2003)

    Ahhhhh...Thank you
    What's the difference between having composite verses separate indexes? I will be running multiple SQL's against this table and the two field (Val and FlagTw) will be used in my...
  5. Re: Create Multiple Indexes using an SQL (Access 2003)

    I don't get an error message. When I 'Design' on the table that was created (T_XStatBX), the 'Indexed' field/property indicates 'No'.

    Thanks,
    Drew
  6. Create Multiple Indexes using an SQL (Access 2003)

    I'm attempting to create a table and indexes against certain fields in the table with the following.

    'Create T_XStatB
    CurrentDb.Execute "CREATE TABLE T_XStatBX ( " & _
    ...
  7. Replies
    2
    Views
    701

    Re: Progress Bar Freezes (Access 2003)

    Works perfect. Thank you!
  8. Replies
    2
    Views
    701

    Progress Bar Freezes (Access 2003)

    I've setup a common form (F_ProgressBar) that includes a text box and a Progress Bar (add-in from 'More Controls'). When I run a piece of code, I call this form and set the progress bar to the...
  9. Re: Replacing double-quote with empty string (Access 2003)

    Hans,

    After posting this, I had found that I could use...
    CurrentDb.Execute "UPDATE TLoc_Agile_MPN SET TLoc_Agile_MPN.MPNStripped = Replace([MPNStripped],'""','')"

    However, your approach is...
  10. Replacing double-quote with empty string (Access 2003)

    Hello,

    I have the following SQL that updates a field containing a single double-quote with an empty string. I can get this to work in a query window, however when I try doing the SQL in VBA, it...
  11. Re: Opening a file and saving in Native application (Access 2003)

    Unfortunately, we are a small division of a large corporation. Requesting a fix is painful and takes a long time to complete, sometimes over a year. However, now that you have pointed out one of...
  12. Re: Opening a file and saving in Native application (Access 2003)

    Hans,

    The file I used for a test was from our manufacture table, which included approximately 2370 records. I let the code run for around 3 minutes before I stopped it. The new file was created,...
  13. Re: Opening a file and saving in Native application (Access 2003)

    Hans,

    Does Notepad fall into the same category as Wordpad?
    Attached is a zip file which includes a raw export from our PDM system.

    Thanks,
    Drew
  14. Opening a file and saving in Native application (Access 2003)

    (Edited by HansV to provide link to post. It is very easy - see <!help=19>Help 19<!/help>)

    Hello,

    Currently I have an import sub that takes a .txt or .csv files and loads the data into Access...
  15. Search string in SQL contains brackets (Access 2003)

    Hello,

    I have the following SQL/Query setup. When running this, the query returns no results even though I know their is 1 record in my table that includes this string. I know that it has to do...
  16. Re: Getting Active Subdatasheet (Access 2003)

    Worked perfect...Thanks
  17. Getting Active Subdatasheet (Access 2003)

    I'm have a main form that has multiple subdatasheets in it. I also have an 'AutoKeys' macro setup to run a function that updates certain fields when F9 is pressed in a certain subdatasheet . My...
  18. Re: Select Query using tables from different databases (Access 2003)

    Hans,

    I guess I'm trying to keep the local version of this database as small and stripped as possible and I was thinking that bringing more data from the network version to the local version may...
  19. Select Query using tables from different databases (Access 2003)

    I have a table called T_Parsed located on my hard drive that contain fields Item_ID, Rev, MFR, and a few others. I also have a table called T_MFRAlias on our network drive that contains fields MFR,...
  20. Re: Move data from one table to another (different DB) (Access 2003)

    Works perfect and is easier than I had expected.
    Thanks
  21. Move data from one table to another (different DB) (Access 2003)

    I have two separate databases. One on our network drive and the other on my local drive. The network drive includes tables that have large amounts of data in each and the local drive contains the...
  22. Replies
    4
    Views
    359

    Re: For Each Field in a Form (Office 2003)

    The form I am using is an Access form.
    I see what I was doing wrong based on what you have indicated.
    Thank you
  23. Replies
    4
    Views
    359

    For Each Field in a Form (Office 2003)

    I'm attempting to write a function that will return a text string with all field names in a given form. I've tried using For Each [control] in [form], but I can't get it to work. Does anyone have...
  24. Re: Error 3052 (File sharing lock count exceeded) (Access 2003)

    Hans,
    I can't seem to get this to work...

    Dim qdfSeq as DAO.QueryDef
    Set qdfSeq = dbs.CreateQueryDef("", "SELECT TStudio_Layout_Bom.Seq FROM TStudio_Layout_Bom ORDER BY...
  25. Re: Error 3052 (File sharing lock count exceeded) (Access 2003)

    Wow!!! This worked perfect and the speed is unreal. Maybe it took a second, if that. Compared to ~30 seconds with the recordset object.
    This is great, however I would prefer to have the query...
Results 1 to 25 of 138
Page 1 of 6 1 2 3 4