Search results

Hello, In Access 2000 : I have a custom search form with a ListBox. The ListBox gets it's records from a Query where the MainTable and RelatedTable is linked. On the DoubleClick event of the ListBox (ListInstruments) I have the following code: (This works perfectly as it should)...

Hello, (not sure if this post belongs in the Reports forum, sorry) From 2 Tables: In the Query I have these fields: LogID | UserID | TimeIn | TimeOut | with an additional column where I have this: TotalTime: Int([TimeOut]-[TimeIn]) & " day " & Format([Timeout]-[TimeIn],"h"" hr ""n""...

in the qry design grid i have 2 columns: totfield1: (Nz([field1],0)) | totfield2: (Nz([field2],0)) then in a 3rd column i have grndtot: [totfield1]+[totfield2] all works okay except: if field1 value is 2 and field2 value is 3 i get grndtot as 23 instead of 5 ! i could do it before...

Hello, I have searched the forums for help and got several references to what i think i need but i still just can't make it work. I think it's to do with recordset clone : On the MAINFORM is a Tabcontrol with 5 tabs. Each tab(page) has a subform. >Each subform's property is set to SINGLE FORM...

Hello, I HAVE searched the forums for many days but I could not find a solution. Maybe I'm not sure what to look for... The MAINFORM_1(single form view) is based on a Query and has a cbo named 'cbo_client'. This cbo is for a field named [client_id]. The AfterUpdate [event] of 'cbo_client' does...

have searched forum for this but not getting what i want (or maybe i just don't understand very well) but here's my question anyway: the table is related to several other tables and the cascade delete property is on. on a master form (with subfrm for related tbls) i want cmdbutton to do this...

i guess this is a dumb question (although no question is ever a dumb question) can java scripts be used in access ? if so where ? (on a access [web]page)? and can i then generate reports from the results of the java forms ? just a simple yes or no will do and i'll fight my own battle from...

hi all, please help with this: my db runs on a WAN. i got this vb from here: http://www.microsoft-accesssolutions.co.uk/get_username_or_computername.htm it gives username and machinename. ok. question: can i also get the the DOMAIN name in the same way as above ? how? any help appreciated...

see this thread... http://www.access-programmers.co.uk/forums/showthread.php?t=69237 hi everyone, can we please start this thread again... - since may'04 (when we started this thread), i have tried many of the suggestions in the replies to this thread, and as i am no expert in access i...

hi, i have 2 seperate db's that has no relation to each other. i have a module in db1 which i want to use in db2. - i have imported the module from DB1 into DB2. - in the access window (modules) the module name displays, and in vba window it displays the module name also. - this is all ok. -...

hi all, please help with this: on a form i have a Hyperlink to a MSWord template. so the msword window opens but when the user close the msword window, access is minimized. i want my access Form/Window to stay Restored behind MSWord window. how ? thanks, Piet.

advice please! the db will be hosted on a local file server and i don't want to mess with windows users/passwords etc. - the db has Password Protection. - in dbase window I changed all objects to HIDDEN. - in Tools/Startup, I disabled 'Show Database Window'. - in Tools/Options I disabled 'Show...

(sorry, not sure which post to submit to) - the Table 'Jobcard' has a (text)field named PLACE. - on the Form 'Jobcard', the user enters any! description into the PLACE field. - many 'Jobcards' can have the same PLACE; so the Table records many 'duplicates' of the PLACE Field, as it should...

Quote: Originally Posted by Rich Use the HasData method, search the archives here for examples Got it. Thank you. But now this: 1. In MainReport's GROUP FOOTER section I have 3 sub-Reports. 2. In MainReport's GROUP FOOTER section I now also have a textbox (name 'text123') with the...

Please help, (a2k) Can I do this ?.... 1. I have Main Report (data from a Query) with Group Header/Footer. In the GrpFooter section i have "TOTAL_1" (sumofvalue from detail section) 2. I have 3 sub-reports (data from Tables). Sub-reports are in MainReport's GroupFooter section. Sub-rpt1 have...

please help. access error: access cannot make mde file. why not ? (i think because i messed up with the security settings in my db) never got the security issues to work anyway. how do i fix my db to make mde file again ? any help will be appreciated. thanks, piet.

please help, (using a2k) I have a small db to manage a Pest Control Store room. In the attached db you will find the applicable tables, queries, and a form. In the PRODUCTS table I have field (value) STOCK(current). See Form JOBCARD ! : When I ISSUE and amount of Pest Control Poison...

please help (using a2k) I have a Main Report with 2 sub-reports. Sub-Report 1 displayes some info from a table. Sub-Report 2 (based on a Query) displays a Date, Description and a Currency VALUE. In sub-Report 2's footer section I have unbound textbox to calculate the TOTAL(sum) of the...

please help (again) don't know if this belongs in forms or general forum. sorry. on mainfrm i have cmdbutton to (hyperlink) open a msword template (*.dot) file. on click of cmdbutton, a2k db MINIMIZEs to taskbar and opens msword tmplt. this is ok. but when user closes msword doc, a2k db does...

please help, i have mainfrm with cmdbutton. on click cmdbutton: opens pop-up (modal) frm. in the popup frm is cmdbutton to printpreview report. (rep based on query) problem: when report opens, the popup frm stays on top of report (has focus ?) this i don't want. so in vba i changed visible...