Search results for query: *

Can I define data definition to show drop down list of 2 columns ? I am uing Define name and would like to show 2 column user drop down listing. Please advice, Thank you dré

This should be simple. I am importing outside data to a spreadsheet SheetOrg, then based on some criteria I distribute data from SheetOrg to sheetA,sheetB, sheetC... After All done I want to erase sheetOrg if nothing is in it or Display a warning message for data failure if data exists in...

There must be a simpler command to find match for a numerous conditions. I have the following code: if ws.name = sSheet1 Or ws.name=sSheet2 or Ws.name=sSheet3.... there must be something like this: if ws.name in (sSheet1, sSheet2..) then .... Please advice, Thank you. Dré

Is it possible to copy a specific sheet(SheetPrice) in excel without opening the file to another workbook. (this workbook is open) This is what I am trying to do: Dim WB1 As Workbook, WB2 As Workbook Set WB1 = ActiveWorkbook 'Current One Set WB2 =...

I am using a long macro to process the steps. However I need to inform the user the steps via window that Are taken. (ie: Step 1 of 5....) I am using a Form to show the steps while executing Macro: MyForm.show vbModeless Myform.Caption = "Download" MyForm.lblmessage = "Please Wait - Step 1 of 5"...

I have a long macro that keeps on shifting between one sheet select copy.....to another sheet. I need the process to be invisble to the user and instead place a message msgbox "Please Wait - Processing" until the pocess is done. Please advice, Thank you. Dré

Is there a command in Excel to copy all the rows that it meets a find criteria (similar to find All) and copy/paste them to another sheet. I have it coded in a loop to find one by one then copy paste... My pseudo code is somthing like this: (pseudocoded) Do sheet(1).select...

This is what I am trying to accomplish: --- pseudocode Define RangeRate Where ColumnA = Rate1 (next loop Rate2..) Range("A6").select Set the validation List based on RangeRate ---- Column1,Column2 Rate1, 5/1, 4 Rate1, 5/2, 4.5 Rate1, 15 , 5.8 ... might have more column with Rate1 ... Rate2...

I am trying to get this formula works inside a macro: I need to set columnD, currentRow = Column E, Current Row + Column K, Current Row ie: Cell D2 = Cell E2 + Cell K2 Cell D3 = Cell E3 + Cell K3 .... Please advice, Thank you. Dré

This should be simple. I am trying to get formula in one cell based on the contents of a column (same row) ColumnA, ColumnB, ColumnC, ColumnD(get formula) --------------------------------------------------------- Score A , 5 , 1.1 , NewFormula Score A , 5.6 , 2.2 , NewFormula...

Ineed to go to next cell down: Application.Goto Reference:="R65000C1" Selection.End(xlUp).Select 'need code to go next cell down 1 row Please advice, Thank you. Dré

I have 2 excel sheets: Sheet1: Y/N,item,price,code,desc... Sheet2: item All I want to do is compare sheet1 to sheet2 and have Y-yes found and n-Not found in Sheet1 Please help Dré

Sql: TableToUpdate = sitem, sdescription, nprice, dtdate, nver TableToLoad = item, desc,nprice I need to insert items From TableToload into TableToUpdate with set dtdate=#4/14/2005# ad nver=1 for the matched ones. I am using: Insert into TabletoUpdate (sItem,sdescription,nprice) select item...

I have a form that I included my own navigation button. top, previous,..., Add, delete,... I like the Access default Navigation but I would like to restrict some of them. such as the add navigation defaulted by Access. I am aware of the property the allow addition, but if set to no I will not...

OrderTable: id, name, orderdate, qty, unitP, .... I have a simple reports that I would like to ask to list a range of order: beginning date and ending date. a) How can I introduce the paramter to be linked to the report. b) If the user enter no date I would like to get all Please advice, Dré

I have a form that has a button to excecute a smple query. Can I control the query caption table: It display <Query Name>: Select Query How can I control the display if possible. Please advice, Thank you. Dré

Table1: orderid, cust, date,notes Table2: orderid, item, qty, price,.... Table1.orderid -> table2.orderid How can I have a report to list order in table2 that do not exists in table1. I clikc on the link option and the Not equal sign but it is not working. Please advice, Thank you. Dré

I would like to know how to pass a parameter from a form to a query when user click a button. ie: Form (order entry): id, custno, address,..... subform for the order detail In addition I would like a button: to list all orders for the custno via query. Please advice, Thank you. Dré

I am trying to have a subform filterd via user entry request. For example: Main form: id, employee, name, datehired subform : id, empName, empAddress.... Is there a way to have a subform to list all employee for a specific datehired entered by the user. Please advice, Dré

This is what I am trying to accomplish. It is to have a subform list all orders for a specific employeeid and specific date via tabs. I do not know how to filter a subform based on a parent entry form ??? Table used: Table1: orderno (primarykey), employee, entrydate....,notes Table2: orderno...