Search results

  1. Randomblink

    Question concerning FORMS(Index)

    ...grins... chuckle... I panicked so bad on this code that I posted places I don't even remember... sorry...
  2. Randomblink

    Got It!

    Got the answer... Private Sub Command0_Click() Dim intIndex As Integer For intIndex = 0 To Forms.Count - 1 If Forms(intIndex) Is Me Then MsgBox "My Index is = " & CStr(intIndex) Exit For End If Next intIndex End Sub Got it from another...
  3. Randomblink

    Question concerning FORMS(Index)

    I had a couple questions for whomever can help... How would I get the Index of the Current Form Is is true that as I open a Form it is assigned an Index Number ONE greater than the last opened form? I am trying to setup my buttons to do the following: 1) You are in a form 2) You click...
  4. Randomblink

    FORCE Next Primary Key Autonumber Generation

    THANKS! THANK YOU SO MUCH! Excellent!
  5. Randomblink

    Exporting to a CSV file

    Quick Function Here... I put this together... It will run through it for you... Click Here For A Link To A Function I Created That Does What You Are Looking For Enjoy... Yeah, you CAN Import/Export? But this is more fun... ...Chuckle... Enjoy
  6. Randomblink

    FORCE Next Primary Key Autonumber Generation

    Ok... I have a form based off of a table. The table has a primary key called rpt_ID The Primary key is an Autonumber. While in a NEW Record, I need to grab the rpt_ID number... However, since it is a BRAND NEW RECORD... the rpt_ID is not set yet? What can I do to get the rpt_ID WHILE in a NEW...
  7. Randomblink

    ZipCode: Address Field Completion

    ??? Hmmmm... Ok... Trying to put your plan in motion... Having problems... I am seeing it tho... Thanks Pat... You da greatest...
  8. Randomblink

    ZipCode: Address Field Completion

    Ok. I have a table with three fields... [fld_City] [fld_State] [fld_ZipCode] I have a combo-box on my Entry Form IN the ZipCode field. The User types in a ZipCode. At this point... I want the City and State fields to auto-fill... I tried a couple functions similar to: Public Function...
  9. Randomblink

    Textbox SELECTS Listbox Entry

    Changed it... Question for ya... WHY? I mean I can understand that it works, but.. I can't wrap my head around why? Of course, I did go home after work without touching the computer... watched TV, ate, went to bed early and am JUST NOW touching the computer... so it has been too long since I...
  10. Randomblink

    Textbox SELECTS Listbox Entry

    FOLLOW UP: Completed COde / Reusable Code Fornation... Thank you... I took what you gave me... Modified it for reusability... Commented the Living Hell out of it... And am dropping it here for anyone who could use it... Public Function ListSelector(TextToSearch As String, lst As ListBox) On...
  11. Randomblink

    Textbox SELECTS Listbox Entry

    Ok... I have seen this done and am HIGHLY irritated that I can't find it on this board... Heck, I have DONE this, and I can't remember... What I want is: I have a textbox. Unbound. I have a listbox. RowSource = SQL Code I wrote I want the listbox to JUMP to the first entry that matches the...
  12. Randomblink

    UINT32 / UINT16 Parsing

    Donkey Shins Shadez, I meant to say Thanks... I really appreciate the help on this one... Well, I suppose I will have to wait to get my little bro's VB.NET package to check it out... I am NOT finding ANYTHING on the UINT32 that is NOT linked to .NET crap... If you go to Microsofts Developer...
  13. Randomblink

    UINT32 / UINT16 Parsing

    UINT32 / UINT16 Still Can't Parse Here is a link to the PDF Document Concerning the File Structure So yes, I do have the struct. However, since I have never imported files and stripped them... I am unsure of what to do with UINT32 or 16 style of data types... I just don't know how to convert...
  14. Randomblink

    UINT32 / UINT16 Parsing

    Question... I am working on a data-app for a game I play. Alot of the Files use UINT32 formatting for structures of data. What I would like is to create a Form in Access that will open up a file, parse through, drop data from the file into Fields in Various Tables, and then I can work with the...
  15. Randomblink

    Curious: Table Field Color

    I play a game called Neverwinter Nights. It is a video role-playing game. It allows you to script and design entire worlds. I am trying at this moment to build a database to track the MANY MANY objects and articles that a builder needs to keep track of. Well, one of the apps in the game allows...
  16. Randomblink

    FE:BE - Linked Tables - New Folders

    ALL OpenGrave, It is ALL of them... Pat, I went to that link and it was a post about Access Charts and Graphs... There were links there, but they didn't seem to cover my question... OpenGrave... can you help me? Thanks both of you...
  17. Randomblink

    FE:BE - Linked Tables - New Folders

    Static: Locations Well... At home AND at work I ALWAYS have the two folders... And they are ALWAYS in a single folder... For instance... << - Folder Hierarchy - >> Databases -> Back_End -> -> Back_End.mdb -> Front_End -> -> Front_End.mdb Does that make sense... The ABOVE setup is true on...
  18. Randomblink

    FE:BE - Linked Tables - New Folders

    Ok... I have a folder called: Front_End I have a folder called: Back_End Inside the Front_End folder I have a Front End DB. Inside the Back_End folder I have a Back End DB. The Front End DB has LINKED TABLES to the Back End DB. How can I link the tables so they stay linked even if the two...
  19. Randomblink

    SubReport.Can Shrink

    Ok... I have a report. It has several subreports. One subreport is about Grant information for the client on the main report... One subreport is about Lien information for the client on the main report... One subreport is about Financing information for the client on the main report... Each...
  20. Randomblink

    Enter ZIP CODE Get CITY, STATE

    Ok... I did some searching, and after 10 different posts that asked similar questions, but didn't give what I was looking for... I decided to ask... So here goes... I have a db already setup and running. TO make it easier for end users, I want to setup the ZIP CODE field to grab the City and...
Back
Top Bottom