Search results

Hi, Sometime when I delete a record on a form using the wizard delete button and I move between records, #Deleted record shows up. Can anyone help me in getting rid of it? or why is it ocurring? Also, I am getting error "2455 : You entered an expression that has an invalid reference to the...

hi, I am trying to work out which Tab is current been viewed/opened. My button does differrent thing depending if Tab 1 or Tab 2 etc is current been viewed. thanks. My idea so far (which doesn't work is): The first statement is also true. Private Sub cmdPrintModule_Click() Dim tbtab...

I am having trouble return the result when I code the SQL statement in VBA, but if I copy and paste the SQL straight to Query design it return the correct return. Using ADODB, it gives me "S0" but Query Design gives me "01" My table is SiteCC 1921001 19210S0 and I want to return "01"...

Hi, My SQL is not really good, I have a table with Name AC01 AC02 AC03 ACS0 ACS1 I would like contruct a SQL such that it returns the highest number excluding the S*. I thinking along the line of Max(Right(Name,2)) and using Not Like "S*" and maybe using a subquery? any help will be...

Thanks Liv, it worked! (my SQL is not that strong!)

thanks for the help Rich, finally got it working, I used me.openargs to trap the argument being passed in.

Sorry, I don't understand. Cross tab is new to me. which heading for row heading and which one for column heading? and which one is for value?

Hi, I have a problem, and I am not sure what's the best way. My query using Sum, and GroupBy that produce a result of Name, Quantity, Price, Type AC32, 755.95,13698, LM AC32, 320.89, 1736,EA but I would like it such that, Name, Quantity(LM), SumOf LM+EA, AC32, 755.95, 15434, Is that...

thanks for your answer, but which window events of the parent window do I trap this when it has passed back? It is not OnOpen or OnLoad because the parent window is already open and loaded, docmd.open will just brings the parent window to the front.

Hi, I am wondering if anyone has worked on a reporting form which allows the user to save it as a custome report form for future re-use? For example, the user has selected certain criteria for printing from the reporting form and would like to save this setting for future re-use. So they do...

Hi, I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window. How does one...

Hi, I am a newbie to SQL and MS access, and from I can tell, it's a simple join question. Can anyone please help me with this question? Table1: Name, Type, CurrentWeight,CurrentAmount AC31,Air Coolers,141.606, 299,721.44 AC32, Air Coolers, 338.494, 52,117.57 AC34, Air Coolers,90.238, ,765.439...