Recent content by Diplomat

Thanks x1; that was very helpful. I re-did my form and it works. However, I still have the problem of &quot;<font color=red>invisibility</font>&quot;!!!. First it was an entire form that would not show in form view, and now it is the header of the new form that I just made; it's in there in the...

I used the form wizard to make a form with data from four different tables. I think I&nbsp;&nbsp;followed all instructions correctly, but when I tried to view the form only the header section showed; the detail area was blank. If I look at the form in design view, everything is there, or so it...

I did look it up in the help files, but I get info on what access does to my db when I replicate.<br>When I try to add fields to my query from an additional table, I get this <font color=red>s_GUID</font> to appear in the list of fields, and the query will return no records. Otherwise the query...

I tried them all including the DateDiff expression in a textbox, but nothing worked. I'll let you know what I was doing wrong if I ever figure out.&nbsp;&nbsp;Thanks

Sorry bfamaous, I am not following you. Let me clarify the structure of my Query. Perhaps this will make it easier to explain to me what I need to do:<br><br>AgeQuery1 consists of three fields:<br><br>Field #1 is <font color=red>CIC</font> (or Customer Identification Code) comes from the table...

Hi Doug,<br><br>In the <b>textbox</b> I have <font color=red><br>= [AgeQuery1]![Age] </font><br><br>In the <b>query</b> I have:<font color=red><br>Age: Int((Date()-([CustomerID]![DOB]))/365.25)</font><br><br>CustomerID is a table containing a field for DOB.<br><br>Thanks!!!

I created a <b>query</b> to calculate the age of my customers. I ran the query and it worked. I want to add to my data entry form a textbox with an <b>expression</b> based on that query to get the age calculated and displayed when the date of birth is entered. I added the expression using the...

I first made a <b>query</b> and then I designed a <b>report</b> based on this query. The way I set the query I should have only a certain kind of order included in the report. I have many of these records in my db, but I got <FONT FACE=monospace>nothing</font> in the report. I must be doing...