Recent content by GregoryWest

  1. G

    VBA Code is recursive calls allowed?

    I need to write some code that will call itself. Is this allowed in Access. Basically traversing a tree structure and need to go down each branch to the bottom.
  2. G

    Access VBA DAO records need to know ID field

    I have a few tables, I am running Access with multiple people accessing at the same time from different Workstations. What I need to do if execute the command: rec_dao.AddNew Then be able to find out the value of rec_dao.ID (Which is an AutoNum field) There are no unique fields other...
  3. G

    Access Web DB running on Linux... Possible??

    I will be developing on a windows WS. I would like to deploy to the mass the Web version. That way I do not need to deal with the BE DB interface on individual computers, nor the setup on Access Runtime. Access is a good quick front end, as for being a BE is is very limited. Greg
  4. G

    Access Web DB running on Linux... Possible??

    Would like to 'front end' to be a web based front end. That is the end goal.
  5. G

    Access Web DB running on Linux... Possible??

    It is possible to get an Access WEB front end to run on a Linux server? The back-end database will be PostgreSQL. If it is not possible to get access to run on Linux, can you recommend some other 'Access' like front-ends that can be deployed on Apache/Tomcat on a Linux server.
  6. G

    Changing the Caption of a Label inside nested VBA

    Thank you thanks you thank you. That worked GREAT! I am still tripping all over keywords like FORM or FORMS and is it a . between works or a ! Your solution worked great!
  7. G

    Changing the Caption of a Label inside nested VBA

    OK I thought this would be easy, go figure it isn't. I need to change a label of a VBA form. There are a few check boxes for work to be done a big label box Named 'CompMsg' (this is what I want to change). and a button to get the whole batch running..... When I press the button the called...
  8. G

    Using the most current data in VBA

    Looks like opening the form as a Dialog works! Did not even know about this. Guess you learn something every day!
  9. G

    Using the most current data in VBA

    That explains a lot of the issues I am having. How do I open the form as a popup instead of just a window like I have now.
  10. G

    Using the most current data in VBA

    Sorry about the lack of code tags. It is not a case of being lazy, it is a case of not knowing how..... How do I use code tags?
  11. G

    Using the most current data in VBA

    Tries doing a requery. Did not seem to change much. Here is the code: Private Sub Command14_Click() Dim rs_in As dao.Recordset Dim strSql_in As String Dim rs_out As dao.Recordset Dim strSql_out As String DoCmd.OpenForm FormName:="GetClient", View:=acNormal, WindowMode:=acWindowNormal...
  12. G

    Using the most current data in VBA

    I have some VBA code that opens a form gets some user information from the user (this is all working great) and returns to VBA. Here is where I am having problems! I need to make sure VBA is looking at the most current data available, NOT the data when VBA started. On the query on the...
  13. G

    Opening a form inside a loop in Access VBA

    AH I see what you are saying. If I get this right, when a new record comes along. Put all the data up on the screen for the user to tweek, When the user is finished, have them click on the button that run script on form to do the updates, not have the calling program try and deal with them...
  14. G

    Opening a form inside a loop in Access VBA

    No problem, here is what I am dealing with. I have a huge file that comes from the government once a quarter. It contains property onership information. There are 7 records types all stored together is a CSV flat file. Now on one of the record types is the name an address information about...
  15. G

    Opening a form inside a loop in Access VBA

    Good afternoon. Quick question, is what I am trying to do even possible? I did your suggestion, works sort of, I get the form up, the fields are populated but when I return from the form the TempVars!chaddr1 contains the data from the calling function, not what I typed into the form...
Top Bottom