Search results

Hi, I have created an ODBC connection through excel using the code below. I am a beginner at this so therefore used a macro to create this. The main problem i have is that i cannot change the output data format. For example the column a.transaction_amt is displayed as a two digit number but...

hi not sure if this is possible but i only want certain options to be made visible in a combobox when the user selects the relevant options. Therefore i want to be able to make certain items in my combobox invisible, while some are visible and when the user sets the other values the invisible...

hi i have a button that loads a report. If i then close the report the form, which is set with no border/no max/min/close/non movable and opens maximised, places itself off centre. I want it to stay maximised full screen. The only work around i currently have is when the use moves the mouse...

my form works fine on the first record of the database but now i have added a 2nd record some of the functionallity form the first record is applied to the second. At the moment in my table for each record i have a status field which speifies whether certain data is visible to the user or not...

i have a combo box from a table with id(autonumber) and status(option 1, 2 and 3) as the col names. I want the default value to equal option 1 and when you load the form this default value be displayed in the combobox. I do not want the form to be loaded and set the value again if option 2 and...

I have been wresting with populating my list box and now its working however the layout isnt quite what i want. So far the layout is below 1234 jones 5678 smith i want it to be 1234 jones 5678 smith so each row of associated date is on one line the code im current using is below...

hi again seems after half a day searching im back here again. Basically want to load a listbox from a query that is based on the input from a text box. Its gettin late and iv got myself confused over dao,ado recordsets to name but a few. I think i am in the right area just dont know how to...

Hi im tying to create a search function that will find all the details of a customer when i enter there account number. So far i can return the name of the customer when i enter in a valid account number but am unsure how to solve the problem when an invalid account is entered. Also this only...