Search results

Well all I can say is a big THANK YOU! You saved me. It's people like You (and I try to do the same for anyone that I can help) who make it possible for others to be successful by passing along your knowledge which I am sure has come from years of hard work and or training. You are the first and...

Thanks Minty. I understand the concept and appreciate your assistance. That's not what I am trying to do though.

Awesome going to do tit right now. Thanks VERY much I really appreciate your guidance. The only thing I haven't trued is making a form and subform so this is something that I haven't tried. Thanks for taking the time to type it up for me!!! I will post back results.

I checked out the links that you posted for me. Thanks again. Still no luck. I never thought this would be such a tough one and something that a lot of other people haven't tried to do over the years. One thing that I did learn a few years ago while crating the inventory program that we use is...

Awesome, thanks very much. I will check it out right now. I'll be sure to post any information that I have if I am able to get to this work eventually. Thanks again! Jim

Hey! Thanks for the fast reply... Yes, I've scoured through that page and many, many others. They all lead me to the same place. I can tab through records and have images appear but I can't create a form that I type a number into and have an item photo appear. I appreciate your help though...

Hi, I'm new and know very little apparently. I have a form based on a simple two column table. The table has an Item Number Column and a Attachment column which I have loaded with an image for each item number. I need to have the image of an item appear when I TYPE in an item number into a...

Finally! I was able to use the code you provided in a select query then use DLookup to call the query as the control source for the text box. It appears to be working. I could not have done it without you. Thanks my friend! You saved my A$$ today! And possibly my job! Thank You again CazB!

I guess You can't use a select query to update a text box. The code works when run as a select query, but I can't figure out how to make it run and display in the text box and update after every new record is added. I thought I had it there for a minute. :(

oh MAN, I AM NOT HAVING A GODO DAY. I can't figure out what to do with this code. I have plugged in all of the correct table an field names and I thought I would just add it to the onclick event for testing so that when I clicked the text box, it would give me the results, but nope. I am all...

Ahh Thank You! I am going to try this now, but I'm confident now that I found someone who understands what I need and knows what they are doing such as yourself, that it's going to work. I knew it wasn't all that confusing because there are not a lot of variables for lack of a better word...

All of the records. The database is only used for one day, then the data is pulled and it starts from a blank the next time it is used. I have a date/time column so that each entry gets stamped. Table and column are physical_count.dttm_counted.

Thanks again. I wish I had never included the words User ID as that has nothing to do with what I need. I just simply need to know how many records have been entered into the database and then average it per hour. I never thought I'd have this much trouble given what I was able to do with the...

Thank You! I am sure this will get me started. I appreciate your help very much and your time.

Thanks I know. I have those columns in my table as I have described above. Thanks again. I know it can be done. I just don't know how to do it. :confused: I don't want to create and run a report. That, I can do myself. Never mind. I'll find someone, somewhere else who can understand the...

HI, Thanks for your reply. Honestly I'm not sure what to post. Basically I have a form (names frmMain) that does a lookup from a table called tblItem_master. An item is selected from that table, the details of which are pasted into a separate table along with things like the Quantity counted...

HI, I am in dire need of help. I attempted to do this myself and I just can't wrap my brain around it. Can someone please help me? I would be very grateful. I am trying to display on a form the average number of lines/records per hour that a person is adding to the database. After hearing...

Awesome Thank You!!! I actually just need it down to the minute and second. I plan to have a box with a label that says something like. "That item took 1 minute and 19 seconds to count" The Minutes and Seconds would each be in a control and reflect the actual time that it took obviously...

After reading your reply again, I wanted to say "Thanks" again. This is the best answer yet in terms of a good solution. I think this is a great and fairly easy way to do exactly what I need to do without having it get too messy. This is exactly why I come to AWF. The smartest people hang...

Thank you for your input. I appreciate your comments. We've been in this business for over a decade, so I have a fairly good handle on our staff and what they are capable of. We have other methods of ensuring accuracy. Thanks