Search results

Thanks for the quick reply Namliam, I must have missed that one in my search results.. I will have a read through and come back and shower you with praise when I get it working

Hi all, In the spirit of santa I will just preclude this thread with "I have searched this forum, I have searched it twice and only found stuff that was naughty not nice" Ok with that out of the way. I am trying to run a query and display the results in a report (the report side of it...

o.k i have used dlookup to select a record, i now want (VIA code) to update a selected record in a table which is not my record source for the form.

that looks great, cant get it working at home, it is my work machine that is configured for it.. the code in the text box looks like what i was after.. Thanks very much for taking the time to help... what did you think of the program as a whole as my first time?.... will try the new code...

o.k here is a copy, warning though my code is poorly presented, and it is my first attempt at a database, there are lots of lose ends. in it, if you load up the main form, and on the tabs go to tab Enforcement requests its the bottom 4 text boxs file attached

and data type mismatch in criteria expression is what i get when trying to run the query independantly

No the query is not the record source of the form!, i didnt know that would make such a difference. can you give me some tips on the workaround or point me in the right direction

O.k not working yet, i have created the function which is producing a test msgbox with the correct value in it.. the query is set up with what seems to be the correct code,. I have a text box on a form whose control source is the query and the variable e.g vb code = txtstreet.controlsource =...

(RESOLVED)Reference VB variable in script builder o.k i would like to reference a vb variable stored within a module, within the script builder. that is to say i have a number stored in a module that i need to check that reference in a query using the script builder.

i would just treat the leaves and holidays as attendence, for the purpose of calculating days absent

The problem i have got is that it is not the form window i want maximized, its the access window.

Hi all anyone able to tell me how to make main access form a maximized only view.. of course the ability to shrink but no resize allowed.

Learning how to use access Hi there, learning access is the same as learning any programming language. I have taught students on a one to one basis with a few languages. The best way to learn is to just jump stright in. imagine a program you would like to build and just started working on it...

Hi all, i have a list box (well three), and none of them will let me click them when populated with data. I have written a small piece of code to display a messagebox e.g msgbox me.list33.value anyone have any ideas why list boxs cant be clicked.? blu

O.k the candle is getting burnt at both ends tonight, its 00:30 on the clock here and i will be up all night..:). This promotion better be worth it.lol Blu

like bob says you dont need the .value bit.. i still use it though a remenant of my C++ days and i program code for other people to edit so it helps them understand

well i dont know how to do that yet, so instead of wasting anyones time here i will go away and experiment..lol

you should be right there, in the "on change" event of the text box, click CODE builder then in the code builder type "cc_in.value = true" if of course the check box is called cc_in

if you are wanting to get from ameture to expert you will need at least two courses as there is no speciality course (hmmmm niche in the market). I recommend taking a small basic computer course but opt out of all the other sections like word, excel. that should give you something comparable to...

O.k this may sound really stupid but how. i tried a few things including the apply filter meathod.