Recent content by simonjarvis

i posted this question in April 06 originally in thread401-1216400 & have eventually found the answer to this abnnoying issue - (so if you are still out there Hank) Answer from a cognos support guy below Simon From: Sent: 18 April 2007 15:29 To: Subject: Case: 1217127 Hi, I've just...

Thanks Henk - but you are right it doesn't make me feel any better! I suspect the query is still runing against the database even though I have closed the report, and the catalog - but I don't know how to check it. Will let you know if i find a solution. Simon

Does anyone know why Impromtu (sometimes) won't close. You click on the top right X and nothing. Can crash it out using the task manager. Is it possible that it thinks it is still retreiving data from the database? I have tried closing the catalog first but that doesn't work either. Thanks...

i would like to delay delivery of messages i send in outlook - pop account, outlook 2000 in workgroup email mode. Apparently you can create a rule to delay delivery but it doesn't work. I presume it thinks i'm connected to exchange and it will sit in the queue there. Is there any way of doing...

thanks, works 100% now no idea how I posted that same comment twice cheers for all your help Simon

OK, in that case in VBA how do you: delete the contents of the table "order_items" run the query "orders_query_prompt" open the report "label" thanks

OK, in that case in VBA how do you: delete the contents of the table "order_items" run the query "orders_query_prompt" open the report "label" thanks

Stupid question The code works perfectly, but how can I call it from a macro that I have setup to clear the old table, fill a drop down to select from, then generate the labels based on the resulting table? Cheers Simon

thank you, thank you, that's perfect. Cheers Simon

the recorsets are called that now - i changed them so they were. My data is in a table called YourTable, fields ItemCode and Quantity, created an empty table called NewTable field called ItemCode Cheers Simon

still getting the same error. This is the code i have: Private Sub Command0_Click() ' On Error GoTo Err_Command0_Click Dim db As DAO.Database Dim rsSource As DAO.Recordset Dim rsDest As DAO.Recordset Dim lngCounter As Long Set db = CurrentDb Set rsSource = db.OpenRecordset("YourTable") Set...

i have created a form & a button that links to your code & renamed my existing table YourTable. Do I need to create the NewTable? As I am getting an error: compile error invalid use of property at the line: .Fields ("ItemCode") Simon

Stewart Thanks but that just concatenates the 2 fields. I would like the query to create new rows for the multiple items. Your query returns shelf2 fridge3 instead of shelf shelf fridge fridge fridge Cheers Simon

I have a table with 2 columns: item_code and quantity. eg: shelf 2 fridge 3 I'm trying to create a query that combines the 2 columns so i get a result: shelf shelf fridge fridge fridge ie. the item is repeated by the number that appears in the quantity column. I want to do this so I can base...

I know this is probably a silly question but does anyone know how you change the font size used by outlook (2003 running with win xp) in the navigation pane (ie. the folder list that you can show and hide by pressing alt+f1). Is it a windows appearance thing or a setting in outlook? I can't...