Search results

Stupid access! All i want to do is make the background of my form a nice gradient like this.... http://www.peterssoftware.com/bcg2.htm i just don't have an unzip program cause i am at work i was gonna code it like this dim i as single for i = 1 to me.insidewidth...

Can I just draw a line on a form??? i.e in VB i would code Line (0,0)-(100,100),vbRed i need the VBA version (if there is one) does anyone know of this... surley it can't be that hard

Is it possible to change the size of the Access window using VBA I generally write applications that run alongside other software. At the moment I make all of my forms as Popups so they can be placed outside the Access window. It would be nice however if I could shrink the application...

cheers, thats the way I do it at the moment although i was thinking of creating a single msgbox form that I can just copy and use from database to database.

How easy it it to pass a variable back from a form for example i want to make my own Msgbox and I will need to return the correct response. so i can code like this (or almost) Dim I as integer i = docmd.openform "frmMyMsgbox" if i = vbyes then msgbox "You pushed the yes button"...

how do you set the default value of a field in a form using VBA? My database is split so the table is linked. I tried table.defaultvalue = "THIS IS A DEFAULT VALUE" guess what :-) it didn't work. Has anyone any ideas on how to do this?

I'm trying to make a (really simple ) query, but i'm having trouble filtering a date field the date field is a Long Date (i.e #01/01/2001 6:35:02#) To find all records corresponsing to a single date is proving tricky. I need the query set up to ask for a date. I tried [Enter Date] this...

Thanks Can I just append the SQL in a query then?? you see i'm creating on the fly querys, this time round the query may be an IN statement, but it could be somthing completly different next time. I really need the values passed in this way. (i also don't know how many paramaters would be...

Can I pass a parameter into a query using code i have tried with this approach.... PUBLIC FUNCTION SomeCriterea() as string SomeCriterea = "In('A',B','C')" end FUNCTION ...and then in the criterea section of a query SomeCriterea() (hoping this would put In('A',B','C') into the...

on a form i fancy writing a little array based animation (kinda like qix (the game). with a load of lines bounching around the screen. this is of no importance ... i just have no life and i enjoy it :-) p.s i know VB would be better but i have access at work (not that i would waste my...

I want to draw a line in VBA somthing like Drawline(0,0,100,100) to draw a line from 0,0 to 100,100 but it needs to be coded in VBA and not drawn in design time. thanks

ok heres an insight i'm writing a little sub that will allow me to make a multi select list box, click on some values and then pass these out to an array. because I want to keep my code nice and neat i want to redim an array to the right size (amount of values selected), e.g if I select 3...

i am trying to write a little procedure that redims a variable. I need this procedure to take a variable name and then use that to redim the variable to somthing usefull e.g. ______________________________________________ sub RedimTheVariable(VariabletoBeRidimmed as ?????) redim preserve...

Hi i need back the 1 Hello 1 Goodbye I'm checking for duplicate figures but across different files the first field holds an account number and the second holds the filename, so I need to only find duplicates across different filenames. I need to weed out duplicates that are in the...

I'm trying to find duplicated numbers in a table pretending the table has only two fields (cause they are the ones i'm interested in) Field 1 is a number field 2 is a text field i need to find duplicates in the number field, but only when the text fields information doesnt match. e.g...

Can anyone enlighten me into exactly how I reference a text box in a subform? i have [Account Notes subform1]. and thats as far as I can get. I can't find where I can refenence it from. Thanks in advance

cause the people using it still think they have to feed the mouse that sits by their computer :-) btw I sorted it now. Made a couple of routines to mark active records and used a filter to not display any record that was active. Cheers though.

using the DCOUNT function can I count empty text field on a table i.e. DCOUNT ([fieldname],"Tablename","[fieldname] is Null") (where fieldname is a field of type text) cause i am dumb and I can't get this to work :-)

I'm making a multi user database (funny that on an access board) i need to stop 2 people viewing the same record at the same time on a form. I realise I can't use record locks as they lock a series of records, but is there a way to stop a user accessing a record is it is already opened for...

you wanna try explaining it to begin with :-)