Recent content by 50ld13r

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...

thanks for your replys. My problem is slightly to do with cascade combos i think. i have a number of yes/no selections for different options. I then have 1 main combo list with a row source from a table. In my main combo i have 8 options but initially for example i only want the first 4...

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...

thats spot on thanks for your help

sorry bit of a stupid question whats the syntax to refer to the form in the report on close command, something like [myformname]!docmd.maximise()

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...

i think he means me.yourtextboxname - etc

yes i understand where to put the information but i dont know what to put in the field, i have a similair prob to the post above i will go into more detail. I have a field called accStatus which looks up another table called tblStatus this has 2 fields:id and status. The accStatus field has a...

hi whats the syntax for assigning it in the field in design view. i HAVE TRIED [cboMYCOMBO].[ItemData](1) but still is blank

this code never seems 2 envoke the else section of the code. In essence what the program should do is if option1 is selected make details visible else make them invisible, i removed the end part from the if else stmt you gave as this made it freeze for some reason. What i put was: if...

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...

You want the notinlist function below is a website that runs through it - to be honest if u run a search with notinlist there is loads of info on this http://www.fontstuff.com/access/acctut20.htm

sorry you will have to dumb it down a little im new to access. Where do u put the dlookup? in the default valuefield? if its not i dont really want to cycle through all my records - really i want it to work like the default value so when you create a new record its set to option1.

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...