Search results

Try... ? Forms![frm_AssetAllocation].Form.lbl_A1.backcolor

Hit CTRL G and hit Enter. This will bring up your immediate window. From there you can type commands to check things. if you type the ? it means print so..... if you did something like ? YourForm.Form.Name ... it would return the name of your form.

From the form, set the backcolor property to the color you want. Then go to the immediate window and type ? YourForm.form.backcolor It will tell you the number that corresponds to the color you've selected. Then use that number in your vba. hth, ..bob

Reporting should really be done on the front end side but.. if you wanted to create a view to be used in a form.... I use SQL for everything but in the qbe grid you could build 3 queries. You can use a union query. Have one query that aggregates the totals, and one query that shows the...

>>I've got a table, with analysis types and values in two columns. I want to write a query that looks at values for each type, and if it finds a certain value, returns all values for that analysis type.<< Create and save query 1 as qryTypes. (paste this into SQL view, then after puting in the...

I typically use the acViewPreview The problem, as you've stated does not surface in that scenario. How about.... When you click the button to open the report, ...check if the query def exists... If it does, delete and recreate. This way you know that the query is available at least untill the...

Again... b.Column1YouActuallyNeed, b.Column2YouActuallyNeed Create the dataset you want to work with.

>>The query is created, the report is opened based off the query and then the query is deleted. How about killing the query def in the OnClose event of the report.

Looks like David's reply answered your question. Instead of using select * from Benchmark c order by (select p.BenchmarkCategoryName from BenchmarkCategory p where p.BenchmarkCategoryID = c.BenchmarkCategoryID) desc USE something Like.... Select b.Column1YouActuallyNeed...

If it's the PK, it's already indexed. Not sure why your performance is slow. Are your returning a large amount of rows? If you do a ctrl G to jump to the immediate window and ? any of the date strings you've posted you see they return immediately. IF you open the query from vba you can get...

just saw that you got it going... Glad you figured it out. ..bob

Go to the design tab and click the icon to insert hyperlink. You will be able to use in in report view but not in print preview. hth, ..bob

there is no info about the "template" you are using but.... Aside from using record locking.... From what you've described, I would think you would have an "issues" table. The foreign key for the table would be joined to whatever the issues are related to or even by userID. This way each user...

can you try using Forms!yourForm.lst_filter_option1.Column(n) where n is the column you want to use. Then, after changing the value in your list, in the OnChange event, requery the other listbox. Then in the query, reference the values in the columns you want to reference from lst_Filter in...

Is the column you are using to check for this indexed?

Chris, I know you posted this 6+ years ago. I had to jump into some old applications ( still running in 97 believe it or not ). I don't too much with vba anymore and could not remember how to check for a table. It was great to google for it and hit this piece posted way back then. Just...

Gray.. we are not on the same page. Is your control truly an unbound control? If it is.... the only way for it to get updated is if you have code updating it. I NEVER use timers. I use events to populate controls and events to refresh subforms that are in datasheet view. I use only .adp...

They probably set the objects to hidden. In 2007 go to Access Options / Current Database / Navigation Options / Show Hidden objects . hth, bob

if the access front end is an .adp and you are using sql as the back end... it should be LIKE 'A%' as opposed to LIKE 'A*' HTH, ..BOB