Search:

Type: Posts; User: cid

Page 1 of 13 1 2 3 4

Search: Search took 0.30 seconds.

  1. Replies
    0
    Views
    304

    [RESOLVED] Forms not linking to Tables

    I have created this simple database and out of no where my forms stopped linking to my tables. I have double checked the record sources and removed all relationships. I don't understand.

    Could...
  2. Replies
    18
    Views
    1,274

    Re: building a computer?

    Read Tom's Hardware Guide... a lot.
  3. Thread: Post Race!

    by cid
    Replies
    68,909
    Views
    18,143,172

    Re: Post Race!

    I have been doing a little research... this might be the longest ongoing forum thread in the world. :eek2:
  4. Replies
    4
    Views
    1,900

    Re: Convert Access Database to VB.Net

    I understand that the converter is not going to get me through the complete process, but it could potentially save me a lot of time. This application is very vast, and I would need to have it...
  5. Replies
    4
    Views
    1,900

    Convert Access Database to VB.Net

    My boss wants to convert our access database to VB.NET, for web publishing capabilities.


    Can anyone recommend some good converters, in order to streamline this process?

    Thanks
    :afrog:
  6. Replies
    0
    Views
    335

    Count Excel Spreadsheet Records

    I have setup an import feature for my database using the TransferSpreadsheet import method. I would like for a msgbox to come up and display how many records are being imported, so the user is aware...
  7. Thread: Validation Rule

    by cid
    Replies
    2
    Views
    337

    Validation Rule

    This expression doesn't work as a Validation Rule:
    ([ProjectID]="3" And [NetAcres] Is Null Or Round([NetAcres],3)) Or ([ProjectID]<>"3" And [NetAcres] Is Null Or Round([NetAcres],12))

    But this...
  8. Replies
    1
    Views
    805

    Re: Limit Textbox To 3 Decimal Places

    Resolved:

    In design view of my table, I setup a validation rule for my field.
    Round([Field],3)

    Then I replaced the default error message with this, in my actual form.



    Private Sub...
  9. Replies
    1
    Views
    805

    [RESOLVED] Limit Textbox To 3 Decimal Places

    I need the user to be limited to only three places after the decimal.

    I tried the following, but they all failed:

    FormatNumber([NetAcres], 3) *Doesnt work because a user can not enter 3,001.22...
  10. Thread: Hard drive HELL

    by cid
    Replies
    23
    Views
    1,390

    Re: Hard drive HELL

    I suggest a Seagate Barracude Hard Drive.

    http://www.newegg.com/Product/Product.aspx?Item=N82E16822148445

    That seems to be the best deal around. I am about to pick one up for myself.
  11. Thread: Online Database

    by cid
    Replies
    2
    Views
    432

    Re: Online Database

    Nope... no reasoning. Haha


    Our backend surely will be MySQL. I suppose I need more help with chosing a front end application.
  12. Thread: Mendhak!!!

    by cid
    Replies
    3
    Views
    450

    Mendhak!!!

    When is the last time we really hugged it out? I know it has been a while.

    Ready for your hug?
  13. Thread: Online Database

    by cid
    Replies
    2
    Views
    432

    Online Database

    I researching the best practices in order to create an online database. I need this database to be multi-user, create aesthetically pleasing reports, hold more than 100,00 records, be searchable,...
  14. Replies
    69
    Views
    15,236

    Poll: Re: On the patch - how long will I last?

    You will probably last until something really pisses you off. In your case, a baby will start crying at the supermarket and force you to spark up. When it comes to quitting cigarettes, I prefer the...
  15. Replies
    3
    Views
    519

    Re: Motherboard Replacement

    Becareful with purchasing economic boards, I would stay with brands you can trust... MSI, ASUS, Gigabyte, etc...

    Also, I would pay the extra money and upgrade to a quad-core...
  16. Re: USB Mouse / USB Ports Suddenly Stop Working

    The front usb ports were shorted, and in turn were disabling all of my usb ports. I un-plugged my front USB jumpers and everything is working fine.
  17. Re: USB Mouse / USB Ports Suddenly Stop Working

    Didnt work in the Live CD Linux Distro.

    System restore failed...

    I guess the next step is to buy a PCI USB card?

    Any other ideas?
  18. Re: USB Mouse / USB Ports Suddenly Stop Working

    I am about to boot up a Live CD of Linux to test my USB ports, if it doesnt work then I know it is a hardware problem.
  19. [RESOLVED] USB Mouse / USB Ports Suddenly Stop Working

    My USB ports have suddenly stopped working... I think the problem started when I removed my friends jump drive, but I am not sure.

    Here are some of the solutions that I have already tried:

    1:...
  20. Re: Merge / Append / Consolidate Excel Files

    Found a solution:


    Sub CopyFromWorksheets()
    Dim wrk As Workbook 'Workbook object - Always good to work with object variables
    Dim sht As Worksheet 'Object for handling worksheets in...
  21. [RESOLVED] Merge / Append / Consolidate Excel Files

    I have a single .xls file with 124 sheets inside, every sheet is in the same format with the same column names. I want to comine all the sheets into a single sheet. I have looked into numerous...
  22. Replies
    5
    Views
    3,202

    Re: Populate Combobox with Table Names

    Nevermind, I found a solution. I am going to use a Listbox, and this piece of code as my record source:
    "SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND
    (Left$([Name],4)...
  23. Replies
    5
    Views
    3,202

    Re: Populate Combobox with Table Names

    I am using Access 2003 / vba.
  24. Replies
    5
    Views
    3,202

    Populate Combobox with Table Names

    I have done alot searching on this forum and online, and I can not find any help on populating a combobox with Table names.

    Any help?
  25. Replies
    6
    Views
    531

    Re: Field Definitions *sql / vba

    Thanks guys, that was the problem. Sometimes I look at something for soo long and never find the simplest solution.
  26. Replies
    6
    Views
    531

    Re: Field Definitions *sql / vba

    Could you elaborate on the invalid data types.
    What data types would you use?

    Thank You
  27. Replies
    6
    Views
    531

    [RESOLVED] Field Definitions *sql / vba

    Here is my current code for creating a table:

    DoCmd.RunSQL "CREATE TABLE " & strClient & "_" & strProject & "(Landman Text, Abstract Text, Survey Text, Tract_Number Text, City Text, County Text,...
  28. Replies
    3
    Views
    767

    Re: Oracle .dat to .xls / .mdb

    I am not very familiar with Oracle, but come to find out... The .dat file is simple Oracle export and doesnt pertain to any of the data I actually wanted.
  29. Replies
    3
    Views
    767

    Oracle .dat to .xls / .mdb

    An assessor office that uses Oracle exported some data for me in a .dat form. Does anyone know of an easy way to convert those .dat files to .xls without installing an oracle client / server myself?
  30. Replies
    15
    Views
    1,459

    Re: Auto-Capitalize Field Names

    That makes me sad.
  31. Replies
    15
    Views
    1,459

    Re: Auto-Capitalize Field Names

    Know about what? The people who work at the appraisal district are no help at all.

    Basically ArcIMS is online mapping software, equivalent to mapquest.

    All i need, is some vba code that will...
  32. Replies
    15
    Views
    1,459

    Re: Auto-Capitalize Field Names

    ArcIMS requires it so queries work online.... I didnt create the database i received it from the county.
  33. Replies
    15
    Views
    1,459

    Re: Auto-Capitalize Field Names

    I have no clue what to do here.
  34. Replies
    15
    Views
    1,459

    Re: Auto-Capitalize Field Names

    I am building an ArcIMS server and in order for the server to query, all field names need to be in capital letters.
  35. Replies
    15
    Views
    1,459

    Auto-Capitalize Field Names

    I have about 100 fields and i need them to be in all caps. I need to re-format them, anyone have any ideas?
  36. Replies
    63
    Views
    2,516

    Poll: Re: Why people use dual OS systems

    Alot of people dual OS with windows xp and open source. But for beta testing programs I have always used virtual machine, you can run windows xp 98 me 95 all at the same time.
  37. Replies
    2
    Views
    582

    Looking for a good vb programmer(In Texas)

    I am looking for a good vb programmer in the dallas/fort worth area. I will pay them a flat fee upon completing the simple project. The flat fee is negotiable.

    Any takers?
  38. Replies
    1
    Views
    415

    Online Video Conferencing

    Any one know of any good online video conferencing software? I have tried a few online html based ones, and they are all garbage.

    I need to be able to allow at least 8 people video conferencing...
  39. Thread: Query Criteria

    by cid
    Replies
    1
    Views
    327

    Query Criteria

    If you create a query in access and go into design view, directly under your field name it says "Criteria".
    I need a way to set the criteria of a query through vba. Anyone have any ideas for me?
  40. Thread: Date Query

    by cid
    Replies
    1
    Views
    381

    Date Query

    I want to run a date query between two forms. One form opens, they select the two dates and then queries a second form.

    Is an ADO connection native in access? I know in VB you goto set up the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width