Recent content by rew2009

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