Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rew2009

    Having problems with DLookup

    Thank you PHV, the new code worked.
  2. rew2009

    Having problems with DLookup

    I am using an Access form that has a text box called – “Me.txtboxOwner_Addr” which displays owner information from a field called “Owner_Addr“ in a MS SQL database table “Apts”. This same record has another field “PRIMARYOWNERRECORD” that is "false". I want to pull out the “ID” number for...
  3. rew2009

    Calculate a sum in a forms column

    Thanks guys, it worked! rew2009
  4. rew2009

    Calculate a sum in a forms column

    I am trying to calculate a sum of values in column in an access form but can’t figure out the syntax. The access form displays the records from a table called “Apts” in a Microsoft SQL database and works fine. However, I tried to add a calculate button in the form to sum a numeric field called...
  5. rew2009

    Code not working in setting conditional formatting

    I have field that I want to change the formatting of when the condition is met whereby a separate field named “Street” has the value “MAIN ST”. All the records with this content are between ID = 49934 and ID = 50575. The conditional formatting works when I use [ID]>49933 And [ID]<50528 in the...
  6. rew2009

    How to store a picture in a Public global variable

    You guys are right. I decided to use a picture table to accomplish the same thing. Thanks
  7. rew2009

    How to store a picture in a Public global variable

    I have a form that has a data source ‘APTS’ and I am trying to store a field value directly into a Public global variable ‘sale.Picture’ and then transfer it into a second form controlled by a different table. When I do this with text fields with text boxes it works fine using code like...
  8. rew2009

    Storing a table field value directly to a public variable

    Thanks MajP and the Aceman1, that was the code that I was looking for. I have another question about storing OLE Objects in Public Variable but I will start a new thread. Thanks
  9. rew2009

    Storing a table field value directly to a public variable

    I have table named “APTS” and a field named ‘Owner_Lname1_Corp’. I have a form where the record source is the ‘APTS’ table. I also have a public variable named ‘owner’ I want to store the value from ‘Owner_Lname1_Corp’ in the public variable ‘owner’. I know that I can bind a text box (such as...
  10. rew2009

    Trying to go to a record with the current date in the date field

    Thanks Darrylle, I looked at my QRY and I had 'DATE111' in it twice. I removed one and do not get that error now. However, the form does not go to the record with the current date. Again I am using the following code on open: Me.Text227.VALUE = date$...
  11. rew2009

    Trying to go to a record with the current date in the date field

    I have a table set up for a todo list with a date field “DATE111”. Records with dates run through the year 2010. When I open the form I want it to pull up and display the record for the current date. I have the following code in the “On Open” event for the form “OrganizerToDoList”...
  12. rew2009

    How to carry a public variable value set in a form into a query

    I combined dhookom ‘s and PHV ‘s method and it works for filtering the main Form: DoCmd.OpenForm "MAIN_POPUP_FORM1", , , "APTS.MetroAreaCode=GetAreaCode() " However, I have a number embedded subforms in the main form but there is no “DoCmd.OpenForn” for opening the subforms so I tried to filter...
  13. rew2009

    How to carry a public variable value set in a form into a query

    I need to pass the variable to the query. The following is the code for opening the second form. Isn't the the fourth parameter the "stLinkCriteria"? How would that pass to the query? I was thinking that my syntax was wrong in the "Where" statement for the query. Again, I was using - WHERE...
  14. rew2009

    How to carry a public variable value set in a form into a query

    I use a query called ClientQRY with a field called “MetroAreaCode” which needs a value of 1 thru 10 to filter geographic regions. I use this query in my forms. I open my forms with a switch board form currently with different control buttons to open identical second forms with different...
  15. rew2009

    How to use global variable to return to same place in a reopened form

    How are you doing TheAceMan.... This is a very interesting way to skin the cat!! When I first saw your code I thought "no way am I going to understand this". But as I re-read the code it began to dawn on me what you are doing. It certainly is a better way of doing it than I was originally...
  16. rew2009

    Where and how do I declare a public a variable to pass between forms

    TheAceMan1, I knew it had to be easy and that it was something that I was doing wrong in applying your solution in my application. Global variables was something that I used regularly in dBase and was only frustrated that I couldn’t figure out how to use it in Access. I know Tek-tips is the...
  17. rew2009

    How to use global variable to return to same place in a reopened form

    I know how to define global variables but what kind of code would you use to save the record info in a global variable, say "strA1" and how would you write the code to "goto" a specific record on open? Also, how do you hide a form? I can see that these methods should work, but how do you do it...
  18. rew2009

    How to use global variable to return to same place in a reopened form

    Now that I understand Global variables I would like to apply it to another problem that I want to solve. I have recast the form of my application from one that had 16 tabbed pages into one that has one main page which acts as a switchboard and 15 popup forms replacing those other tabbed pages...
  19. rew2009

    Where and how do I declare a public a variable to pass between forms

    TheAceMan, after reading your offer to stick with me as my frustration levels were rising, I went back to try it again in the simplest method that I could. I created a simple two form database and on each form I had a text box and then realized that I needed two command buttons on each form, one...

Part and Inventory Search

Back
Top