Search results for query: *

jklo, But the issue afterwards is I need to set focus to Me.yourtextbox to copy the content to the clipboard. And you cant do that unless its visible and you can set focus to it. ANyways, I just left the text box visible, just set the background and foreground colors same as the color of my...

hey randall, thanks for the reply. I know its not the best, but it works great kin my situation. Mucho Appreciato! Richard

What I mean is this... I have an unbound text box that is hidden on a form called txtcaresMemo. What I am doing is on a click of a button, I am selecting certain data on my form and stringing it together and placing it into the unbound text box called txtcaresMemo. What I then want to do is...

Hey Ace, Thanks for the feedback. I have also two otehr locked text boxes that depending on what make and model are selected, two other boxes auto fill will information related to that make and model. for example, I do cell-phone repairs, and if the Make is Nokia, then each model has a Nokia...

Hey Ace, I was wondering also about the use of DLookup. I am experimenting by adding a yes/no column titled "alternate" in my Model table, where the items on the alternate drop list are checked, and the rest aren't. Basically, the difference maker is the customerID field. If the custoemr ID...

hey guys, Not sure if this is something that can be done, but hopefully I can explain what it is I want to try. Right now I have two combo boxes; "Make" and "Model". depending on the value I select in "Make", the "Model" combo box displays only the items associated with that particular...

Golom, The only purpose of sending the data to an Excel sheet, is to email the file to our inventory person. I believe they she can do it because all our order forms are in excel, and each order form has 7 columns across: ID, Quantity, Price each, Description, Mfg Part #, Suplier #, and Total...

Hey all, I am working on something and was wondering what you guys thought would be the best way of doing this. I have a "OrderEntry" order form, and on the form there is info entered on the form itself, and there is info entered in a subform on the "OrderEntry" form. On the main part of...

PS: This was the code I tried to have the text box return the phone number based on that customer id record: =DLookUp("[txtCTN]","Customers","[CustomerID]=forms!frmWorkorders-NRC![CustomerID]") All I get is #error in the box. Thanks again!!

Hey guys, I am so confused right now, I really need help from you guys. I have two tables, Customers and Workorders. They are linked by a record id of "CustomerID" On my workorder form, all the data on the form comes from the Workorders table. I do have the CustomerID saved and displayed. But...

Golom, Thanks again for the assistance. I used rthe first code in your last replay and it worked exactly like I needed. Thank you again! Richard

Golom, Thanks for the assistance. But is there a way to run that query without having to enter in the date? I would like it broken down by month, so I could just enter in "8" for august and have it automatically select all records with a DateTakenIn for august. Then again, I would probably...

Not sure if this is simple or difficult because I really am not sure how to go about this. So, the best way for me to explain is by the example below. I track repair work for multiple locations. This is tracked by the field "StoreID". I also track the date a repair is first taken in by that...

oops, Golom.. sorry about that

Thank you very much Golon!! Richard

I have this code which allows me to enter the month, and the query will give me the data I need. But, I found that since I have data from september 2005, it pulls from that september as well as the current september. The code is listed below... is there any way I can do this so only the...

PHV, Superman to the rescue once again. thanks!!!! worked like a charm! Richard

IT4Ever, thanks a bunch for the help. I almost have it exactly where I need it. Your code and info helped out tremendously. One last question, if you dont mind. I want the report to select all the records based on that txtDatetoRepair field. Basically, I want to enter in a start date of 7/1...

Hey everyone, I serched around and found a couple of threads but being so new at this part of access, I am completely confused in adding in a date range selection. Here is what I have for my cross-tab, which is a fairly simple one. TRANSFORM Count(Workorders.WorkOrderID) AS...

DITTO!!. I cannot thank each and every one who have helped out with my questions in the past and hopefully future. You guys are the best and thank you all once again!!! Richard