Recent content by ideafixer

The service I am talking about is StreamHoster.com It looks like a good service for a one time deal.

I want to broadcast my wedding over the Internet live. I am over average technically, so I don't think this would be hard for me to achieve. What I need to know: 1) Best camera for the price. Preferably wireless. What do I look for? Trying to be under 150 in price. 2) Bandwidth for...

I can create a sub report on a main report both using pass though queries as a record source when a child/master link does not exist. I cannot use the link when using pass a pass through query. Is there a way to make a sub report on a main report with field linking using pass through queries...

I have a report hooked to a pass though query. When I print the report, the records spools much slower than if I print a report linked to a table. It shows the report printing and the pages 1.2.3.4....10 cycle slower than when using a linked table. I assume this is because the record set is...

Yeah but you have to add a text box, and then set the control source to ="City " & [CITY] assuming city is part of your record source. Also be sure the text box name is not CITY... you need to change that to txtCity or something. You will get an error if you name the text box the same thing as...

I have the following code: ========= Start Code ========== Dim rpt As Report Dim ctl As Control Dim Test As String Test = ReportName_Actual 'DoCmd.OpenReport DLookup("[ReportName]", "tbl_reports", "[ID] = " & pubreport), acViewDesign DoCmd.OpenReport ReportName_Actual, acViewDesign Set rpt =...

Possibly a RAM issue. It may be caching the label. Try hooking it up to another machine or steal some ram and upgrade the PC to see if that helps

Is it in the control source? Make sure it starts with the = sign!

There is a required field and allow nulls property on the table.

Yeah.. thanks much!

How are the colors getting set. Must be in the detail events somewhere. Change that to display a shape instead.

Yes.. crosstabs can be used for one table.

Sorry read something wrong. You are right, when opening a query this way from a form you get that problem. Try the guys solutions above. I was answering as if your query name was on the form.

Just pop a message box up displaying that value before the open command kicks off. If the table name is not right or the box is empty, there is nothing in that variable. Do you typically set exclusive on. Sometimes tyypos can get ya when assigning variable names. Anyway I think this is the...

I don't know how to do a mathmatically formula. You may be better off just storing the SSN and an ID as autonumber in a table. Use the ID generated as your customer number and you can allways refer back to the primary key. I am sure you database has some basic customer table. Make that...