Search results

I don't know much about the WIA function, but i did read a little into this http://msdn.microsoft.com/en-us/library/ms630826#SharedSample001 There is a part where they process images.. which i guess is all well and good but in another part they have a "Take Picture" example. I believe this is...

quite welcome :) glad to help.

If you want to keep your text field, you can create a reference table that associates each three letter month with a number. Then you would simly query based on those 2 tables and sort according to your number field (just hide it with an uncheck) Generally i keep full dates in my actual tables...

yes, being that it is a text field, it wont be able to convert that to a number. your 3 letter date field needs to be a date field.

obj0.value = -1 'Means checked or marked obj0.value = 0 'Means unchecked or unmarked, When a form loads, by default the option buttons are set to <Null> In your code your not accepting user input but rather telling the object what it's value should be. If you wish for your user input then you...

Do your sorting in a query. First you select your field that holds your 3 letter month. then you create another field in the query manually. Sort by that second field because it's a number. you can create a field: Expr: FORMAT([Tablename]![Date],"mm") This will give you your month value...

I'll assume that you have a database set up where the table that holds the values for this subform has a unique ID. If that Unique ID is on the subform (even hidden) then you can create a delete query. Set the delete query to delete a record for your table where the criteria is...

You can index using multiple fields, so you would index using the subassemply ID and the subassembly part ID. This way, any given part can have multiple records in your join table, and any sub assembly can have multiple records in the join table, but they can't duplicate the exact relationship...

Do you use the same form for Data input?

If the form pops up, and their are fields on that form linked to a given table, the field where a person would enter a description would be populated already. are you concerned with the user overwriting that existing data?

I actually use the find and replace function function (common in all MS office products) I search for a given value/character, and replace it with nothing. Make sure you set the Match: to "Any part of field" then just hit replace all.. it only takes a second. The only other way i can think of...

As Per discussed in our PM's I have created a small example database of what i was discussing in my previous posts.

LOL, fair enough! thank you.

hmmm.. Problem being it's not always a simple 1-30 issue... i.e Munic --- Concession --- Lot A -------- 1 ---------- 1 A -------- 2 ---------- 1 B -------- 2ERS ------- 10 (Doesn't have a 1 - 9) ect....

For our planners here at my office I have created a database that creates a Folder related to a given record... Every time a new record is created, a new folder on the computer is created and a hyperlink right in my database is created. on the form they have basic information. If they wish to...

OK well the way i see it is this: An access database could be created to track your progress on a given report. There would be a table that holds all the facts of the case, Another table with a one to many relationship that holds one or many investigation summaries. One record would have...

If you are Sending this out to people which is the impression i'm getting from the above comment, how do you manage conflict? I.E Person 1 fills in column 1 with the response "Blue" and Person 2 fills in column 1 with Response "Red"??

What about a stacked Column? would that be esier to read? It's basically the same thing minus the pie? If not then i'm perhaps not understanding the problem your having with your current bar/pie chart. Perhaps an example attachment?

I don't have 2007 so unfortunatly i can't see the data, but i know with mine it used a table of given Municipalities, lots and concessions. (All from one table) The drop downs would filter, Concessions 1-10 may exist in many municipalities, and lots 1-30 may exist for each concession, so i have...

Oh, I've always kicked people off the backend when i make changes just for fear of data loss/corruption, so i suppose that's why i've never had an issue. :) Thanks!