Search results

Solution discovered I discovered that the unbound textbox was the cause of the problem. Thank you, Wayne for pushing me in the right direction! Michael

Excel I would recommend approaching this with Excel. There are a variety of ways in which you can automate/make user freindly an excel document. Then when the responses come rolling in, you can upload them into your database, etc. Hope this helps.

Attached is a sample form/db that demonstrates the situation with which I would like to employ the DMax function. Description of circumstance: User makes selection from combobox. The onChange event for this combobox inserts an abreviation of the selection into another text box [NameAbrev]...

Hi - I am having trouble implementing the code sample below (located here within the forums) and I was hoping you all wouldn't mind assisting me. My emplID is a text value, (the code below works with a numeric value). How would I alter the code to accomodate this? Also, could you help me to...

Hi - I have a 'Query By Form' (QBF) approach to calling up records for the purposes of editing. Below I have pasted the tag information for each field and the function code. My problem is that sometimes this will work and sometimes the Parent form comes up blank? I am wondering if there are...

Almost got it! My remaining question would be: How do I handle/format the serial number field? Thank you!

Hi - Upon my form in question are three elements that I am attempting to devise a relationship between with the intent of generating a unique ID for the record they will pertain to: This relationship would proceed as follows: 1. Combo Box (user makes a selection) The on change event for this...

Phewwww! we did have a system back up that stored copies of the files that I deleted. Thanks.

system.mdw was not a part of the files I deleted - yet when I ran a search on my machine, it did not show up? How might I recreate the system.mdw file Please advise, and thanks.

Hi - I've made the mistake of deleting my database's security files (thinking they would be in the trash should I need recover them - and they weren't there) and now I cannot open the database. Any idea on how I can get around this? Please advise, Thanks, Michael

Hi - I am not sure if this is the apropriate place to ask my question - please suggest more appropriate place if necessary. Question: I am looking for link-code that will allow for movement from one webpage to a specific place (anchor) on another webpage? For example: I would like to allow my...

Further explaination. . . It would be only when the report references an 8 digit MaterialNumber that I would like this functionality activated. When the report references an 11 digit material number I would NOT want the 'above defined' functionality to occur. Here’s some FYIs (sorry I...

Hi - I have a unique record identifier within the records I report known as "MaterialNumber" MaterialNumbers can be of two distinct types, for example: M0001.01 (8 digits in length total) M0001.01.01 (11 digits in length total) The question I would like to ask of the query from which the...

I figured it out. . . All I needed do was to query the field with a unique query and reference that query/field in a text box on the form. Thank you any way, WF

Hi - I have an access 2000 form / list box that users can drag and drop entries into. each entry is uniquely identified by the contents found in column 1. each entry has a number/time association found in column 2. why I am writing is to try and find out how I can add up the number/times...

Any ideas. . . Pdx_ Man Any ideas on how I would integrate the Nz Function my code? I ask because I've done an extensive search and cannot come up with anything that seems appropriate for my intent: [Forms]![FormNameA]![SubFormNameA]![FieldName1] Or [Forms]![FormNameB]![FieldName1] Thanks!

Sorry - this was intended as a reply - not a new thread.

One more thing. . . then take the reult of the above query and build a new query expression that divides this result by whatever number you would like. [#cases]/12

then take the reult of the above query and build a new query expression that divides this result by whatever number you would like. [#cases]/12

OK. . . Are you using a crosstab query? If so, use this crosstab query within a select query and create the following: Create a new Field for : Sum([#cases]) with Criteria: Between #1# And #12# 'or what ever time period you are after If a crosstab query is not involved here - the above...