Search results for query: *

Thank you PHV, the new code worked.

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...

Thanks guys, it worked! rew2009

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...

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...

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

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...

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

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...

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$...

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”...

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...

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...

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...

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...

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...

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...

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...

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...

This worked fine, Thanks