dcsimg

Search:

Type: Posts; User: dataempress

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Re: Excel problems with autofilter and data accuracy

    I think the zero-height buttons might have been causing the problem. I was unable to reproduce the issue with the smaller buttons. Everything works just as it should. Yay!

    Thank you so much for...
  2. Re: Excel problems with autofilter and data accuracy

    I gave you some bad advice on the "ChangedCodeEnabled" variable placement.

    That's okay. I appreciate you taking the time. I'm learning a lot. I'm just curious as to what ChangedCodeEnabled means....
  3. Re: Excel problems with autofilter and data accuracy

    Thank you, thank you!

    It's working so much better now. I am noticing, however, that my first row of data (that isn't the header) is not being let through the filter even when it should be. To test...
  4. Re: Excel problems with autofilter and data accuracy

    Found it and uploaded the workbook. Thank you. I thing I'm fairly close to achieving my goal for the spreadsheet (hope so anyway). Thank you for your time.
  5. Re: Excel problems with autofilter and data accuracy

    Thank you both for responding. I was looking for a place to attach the workbook, but I don't see any option that lets me do that. So I'll try to explain a bit better and hope that I can find and...
  6. [RESOLVED] Excel problems with autofilter and data accuracy

    Hi

    I have command buttons at the end of each row on my spreadsheet, which basically function to copy the data from that row and paste it into another worksheet. I'm now working on including a form...
  7. Re: Problems Accessing Database on Shared Network Drive (VBA glitch?)

    So sorry, I replied to you before I took a look at the link, which did answer most of my questions :).
  8. Re: Problems Accessing Database on Shared Network Drive (VBA glitch?)

    I know. That's something I've wrestled with. I make a lot of changes to the database, and I simply don't have the know-how to deploy a new front end to all my users, and make sure they use the new...
  9. Re: Problems Accessing Database on Shared Network Drive (VBA glitch?)

    That's a good idea. I will post it in the Database development forum. Thank you!
  10. Problems Accessing Database on Shared Network Drive (VBA glitch?)

    Hi,

    I built an Access 2010 database and it lives on a shared network drive. For some reason I can get onto it fine, as can other people in my office. People offsite (who still have access to the...
  11. Re: Access Option Buttons and Counter Loop

    Thanks for all your help!
  12. Re: Access Option Buttons and Counter Loop

    I started using Access 2010 very recently. Before that I was using 2007. Thank you!
  13. Re: Access Option Buttons and Counter Loop

    Thank you for your input. I really feel like I'm moving to a different level of understanding. Unfortunately, my time for this project is very limited (ie before I leave today), so I'm just going to...
  14. Re: Access Option Buttons and Counter Loop

    You've just given me a whole new way to look at this database. Instead of mapping out every possible scenario with the preferences, I could just indicate what workshops are available and the user...
  15. Re: Access Option Buttons and Counter Loop

    Thank you so much for your reply!

    Yes, each participant goes to 1 workshop, and they get to choose between the 7. They give us their #1 preference and #2 preference and #3 preference and so on. I...
  16. [RESOLVED] Access Option Buttons and Counter Loop

    Hi,

    I was working in Access 2007, but was recently upgraded to 2010. I'm sure any advice given would be okay for either version.

    I was asked to make a scheduling database for a conference....
  17. Replies
    0
    Views
    1,843

    Access 2007 Append Query by Form

    Hi,

    I'm working with Access 2007 at the advanced beginner/very low intermediate level. I know how to do all the things I will be asking separately, but I'm not sure how put them together into a...
  18. Re: Access 2007 Append Continuous form with VBA

    Thank you so much for all your help!
  19. Re: Access 2007 Append Continuous form with VBA

    dmaruca,

    I can't thank you enough. I spent some time going over your advice and following the sample database you sent, and that was exactly what I needed. It works perfectly now and will offer a...
  20. Re: Access 2007 Append Continuous form with VBA

    Thank you so much for responding! What you're saying does make sense. I'd just like to understand it more fully. Would the year be the only column in the split table you're suggesting? Would the...
  21. [RESOLVED] Access 2007 Append Continuous form with VBA

    Hi,


    I'm working with Access 2007 at a high beginner/low intermediate level. I have a parent form called frmStudent and a continuous subform called frmStatus. The purpose of the subform is to...
  22. Re: Access 2007 Issue with Junction Table and Data Entry

    That's good information. Thank you Si!
  23. Re: Access 2007 Issue with Junction Table and Data Entry

    Hello my friends,

    I've noticed that I got 56 looks on this question and no replies. This leads me to believe that I absolutely messed up the way I asked this question. It's a confusing topic for...
  24. Access 2007 Issue with Junction Table and Data Entry

    Hi All,

    I'm working with Access 2007. I've designed a subform based on a junction table. The subform is not embedded on the main form. It's called from a command button on the main form. I put...
  25. Re: Requesting advice on Linking Access Databases

    Thank you for your answer!

    I've heard of ADO and DAO, but I'm not sure what they are. I'm trying to look up tutorials so I can practice. The first tutorial I clicked on was ADO in web development,...
  26. Requesting advice on Linking Access Databases

    Hi All,

    Here's my situation: I have an Access database for one specific program at my school. I have two other programs that I would like to enter information for into this database. To complicate...
  27. Re: General Development Advice, Backend Frontend Questions

    Is SQL server something that I could learn in a reasonable amount of time. Do you know of any step by step tutorials? I need the step by step as I get lost very easily. Would the SQL server Express...
  28. General Development Advice, Backend Frontend Questions

    Hi All,

    I've been charged with the task of exploring database options for one of our programs. I asked for advice on this board, and from what I heard I decided a VB.Net Express front end/SQL...
  29. Re: Database Software Advice Needed

    You've all been very generous with your feedback. I am going to research a VBNet/SQL Server Express combo and see where that leads me. I'm sure I'll have many more questions along the way. Thanks...
  30. Re: Database Software Advice Needed

    From what I'm hearing a VB6/SQL combo might be the best option. That gives me a starting point to research. Thanks so much for the input!

    I just have a couple of questions. I took one class in...
  31. Re: Database Software Advice Needed

    Thanks Koolsid,

    I'd just like to pick your brain a little further if that's okay. Did you have 100 users entering data at the same time on your access database? If so, that's amazing to me. I...
  32. [RESOLVED] Database Software Advice Needed

    Hi All,

    One of my program databases is a proprietary web-based database written in C#. I'm in the process of researching alternatives. I think a database that I can build myself would be...
  33. Replies
    2
    Views
    1,330

    Access Macro Advice

    Hi All,

    I've had an ongoing challenge in trying to send an automatic email from an Access database. After researching various solutions, including some recommended on this board, I found a very...
  34. Replies
    5
    Views
    10,036

    Re: Access VBA and Outlook Security Warning

    Hi Again,

    After researching various solutions, including the ones recommended on this board, I found a very easy one. I was able to compile the necessary information into a report and set up a...
  35. Replies
    5
    Views
    10,036

    Re: Access VBA and Outlook Security Warning

    Thank you,

    I really appreciate the reply. I looked at the first article, and my concern was that I don't think I'll be able to lower my security on outlook. I'm not sure our network admin would...
  36. Replies
    5
    Views
    10,036

    Access VBA and Outlook Security Warning

    Hi,

    I've researched this question on quite a few sites, and was able to put together a few ideas, but I'm still having trouble. I'm hoping someone will be able to help me.

    Here's the...
  37. Replies
    1
    Views
    1,414

    VBA Module Not Being Passed to Query

    Hi All,

    I've just learned how to create some very simple custom functions in Access VBA. I'm using Access 2007. My dilemma is our program has three possible Entry and Exit dates, set up that way...
  38. Replies
    10
    Views
    2,765

    Re: Access VBA Events

    Hi All,

    Thank you so much for your help. I really appreciate you taking the time to give such detailed replies. I have a better understanding of looping and that seems like a good solution. I will...
  39. Replies
    10
    Views
    2,765

    Re: Access VBA Events

    With Access 2007, I'm not sure whether to use ADO or DAO. Do I have to set any references?

    Set DB99 = Workspaces(0).OpenDatabase("c:\my stuff\myMDB.mdb")
    With this line of code, do I have to...
  40. Replies
    10
    Views
    2,765

    Re: Access VBA Events

    Hi All,

    Thank you so much for responding. I was away from my desk for a few days so I'm just catching up with the replies.

    To answer Spoo's questions:

    1. Do you have a form that displays...
Results 1 to 40 of 65
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width