dcsimg

Search:

Type: Posts; User: Zephaneas

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    646

    Re: MS Access Data Types

    I'm working on a tool that manages data from multiple sources. It can read in the structure of an Access table, the recreate it in SQL or other DBs.

    I have found some type conversion charts out...
  2. Re: MS Access 2013 & 365 - App Version and Build Date

    In Visual Studio you can auto-increment a version number that is set each time the app is built. I was looking for something like this. If I have to set it myself each time I build then it's only a...
  3. Replies
    3
    Views
    646

    MS Access Data Types

    Does anyone know of a reference for converting Access data types to .Net and MS SQL?

    Thank you
  4. MS Access 2013 & 365 - App Version and Build Date

    How can I display the app version and build date/time in an Access 2013/365 app?

    I'm NOT looking for the Version and DateTime of Access, rather the info for my app.

    Thanks
  5. MS Access Report Calculations - #error and #Type! In Preview Mode

    I'm working on an Access 2013 Change Order report.

    The Details section contains 4 sub reports, Labor, Hardware, Lumber, and Equipment. Each of the four sub-reports is designed the same - A detail...
  6. Replies
    2
    Views
    536

    MS Access Select ComboBox Ite

    What's the right way to select a combobox item in code? I've tried both of these and neither works. The desired item isn't selected.


    cboLumberGrade.Value = selectedLumberItem.Grade...
  7. Replies
    8
    Views
    1,156

    Re: MS Access Multi User Development

    Just curious, do you know if it's possible for me to pull the content of the code file out of Access using C#?
  8. Replies
    8
    Views
    1,156

    Re: MS Access Multi User Development

    I do C# in Visual Studio full time. This Access project is a side gig. My client keeps changing code on his desk while I'm working on it at home. It's becoming a real pain to figure out who did what.
  9. Replies
    8
    Views
    1,156

    Re: MS Access Multi User Development

    Yes, I meant multiple developers working on an Access app together.
  10. Replies
    3
    Views
    563

    Re: MS Access Diff Tool

    http://lmgtfy.com/?q=MS+Access+Diff+Tools
  11. Replies
    8
    Views
    1,156

    MS Access Multi User Development

    What's involved in multi-user development in Access?

    How can multiple developers work on the same Access code at the same time?

    Thanks
  12. Replies
    3
    Views
    563

    MS Access Diff Tool

    Can anyone recommend an Access Diff tool?

    Thanks
  13. Re: MS Access Tab Control - Prevent Tab Change

    Thanks!
  14. Re: MS Access Tab Control - Prevent Tab Change

    Right. That's why I posted VB6 code
  15. Replies
    2
    Views
    557

    MS Access Report

    I've got a Change Order report that has a 3-table joined query as its Record Source:

    tblCompanies join tblProjects joined into tblChangeOrders



    When I open the report I pass in the WHERE...
  16. MS Access Tab Control - Prevent Tab Change

    I want to prevent the user from changing the tab page in a tab control. Setting the tab control's Enabled state to false disables everything inside the tabs.

    So far I have this


    Private Sub...
  17. Replies
    5
    Views
    453

    Re: Select ComboBox Item

    OK, so I tried what you gave me


    LoadPhases
    For C = 0 To cboPhases.ListCount - 1
    If cboPhases.ItemData(C) = selectedChangeOrder.JobID Then
    cboPhases.ListIndex = C
    Exit For...
  18. Replies
    5
    Views
    453

    Select ComboBox Item

    I'm loading a combo box like this


    Private Sub LoadProjectInfos()

    Set projectInfos = GetProjectInfosForChangeOrder()

    For Each projectInfo In projectInfos

    ...
  19. Replies
    4
    Views
    419

    Re: Strange ListView Effect

    This fixed it


    lvLabor.Visible = False
    lvLabor.Enabled = Not IsEnabledState
    lvLabor.Visible = True


    Toggle visible on/off
  20. Replies
    4
    Views
    419

    Re: Strange ListView Effect

    Standard Listview. No subclassing
  21. Replies
    4
    Views
    419

    Strange ListView Effect

    I have a ListView with one row in it

    When I set the Enabled property of a listview to False, all the column headers disappear, and the number 177 appears in the top left corner of the control. ...
  22. Replies
    5
    Views
    488

    Re: Query In Code Not Working

    Ya, Im a dumba$$

    I wasn't clearing the list each time I load
  23. Replies
    5
    Views
    488

    Query In Code Not Working

    I have the following code:



    If projectId = 0 Then
    command = "SELECT * FROM tblChangeOrders"
    Else
    command = "SELECT * FROM tblChangeOrders WHERE ProjectId = " +...
  24. Thread: SComboBox

    by Zephaneas
    Replies
    5
    Views
    596

    Re: SComboBox

    Turns out that this works


    cboProject.Value = currentChangeOrder.ProjectID
  25. Thread: SComboBox

    by Zephaneas
    Replies
    5
    Views
    596

    Re: SComboBox

    Yes, I tried it. SelectedIndex isn't even a property.
  26. Thread: SComboBox

    by Zephaneas
    Replies
    5
    Views
    596

    Re: SComboBox

    Isn't SelectedIndex readonly?
  27. Thread: SComboBox

    by Zephaneas
    Replies
    5
    Views
    596

    SComboBox

    Working on an Access 365 app.

    I want to programmatically select an item in a combo box. Here's what I have so far


    Dim index As Integer
    For Each projectInfo In projectInfos

    If...
  28. Replies
    6
    Views
    3,886

    Re: 5 Minute Timer

    Thanks
  29. Replies
    6
    Views
    3,886

    Re: 5 Minute Timer

    Sorry, using MS Access 365.

    What I'm trying to do is create a locking table. When a user clicks an Edit button I will write out the User Id and Form Name. When the user clicks Save I'll delete the...
  30. Replies
    6
    Views
    3,886

    Re: 5 Minute Timer

    Thanks. I'm not trying to SET the active form, I'm trying to GET the active form.

    So assuming the active form is not null, how would I call a sub on it? This would be a sub that I created....
  31. Replies
    6
    Views
    3,886

    5 Minute Timer

    I want to run a timer every 5 minutes. In the Form_Timer event I want to call into the active form. My AutoExec opens a form:


    Private Sub Form_Load()

    Me.TimerInterval = 1000 * 60 * 5 ' 5...
  32. Replies
    10
    Views
    3,238

    Re: Relink Tables Programmatically

    Thanks!
  33. Replies
    10
    Views
    3,238

    Re: Relink Tables Programmatically

    The path I'm using is the actual path, including the database file - "E:\Projects\MyApp\MyDb.accdb"
  34. Replies
    10
    Views
    3,238

    Re: Relink Tables Programmatically

    Can you please provide an example of relinking? I know very little about VBA programming (I'm a C#.Net guy) and I need to get this working. I tried plugging in the command you provided but it doesn't...
  35. Replies
    10
    Views
    3,238

    Re: Relink Tables Programmatically

    Thank you
  36. Replies
    7
    Views
    2,374

    Re: Write To Log File

    Your code worked great. Thank you!

    "This smells like VBA, not true VB. You have posted in the wrong forum."

    Yes, it's VBA. I'm working in MS Access, and this is the Office Dev forum.
  37. Replies
    10
    Views
    3,238

    Re: Relink Tables Programmatically

    What does My approach is to DoCmd.DeleteObject acTable, Table do? Delete the table??

    If so, why would I want to delete the table?
  38. Replies
    10
    Views
    3,238

    Relink Tables Programmatically

    I'm working on an Access 365 app for a client. At their office their tables are linked to a back end database. When I copy the app to my PC I need to relink the tables to the DB on my PC.

    I have...
  39. Replies
    7
    Views
    2,374

    Write To Log File

    I'm trying to create a sub that writes to a log file. If the file exists, append to it, otherwise create it:


    Option Compare Database
    Const ForReading = 1, ForWriting = 2, ForAppending = 8
    ...
  40. Replies
    5
    Views
    1,029

    Re: Strange Access Behavior

    I open it that way every time. behavior still exists
Results 1 to 40 of 46
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width