Search results for query: *

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 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...

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...

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...

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...

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...

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...

Hey there everyone, I've run into this and for the life of me can't figure it out. I have a record to which I want to add a copy button to. I use the standard Button tool and select Duplicate record. But whenever I try this, I get an error stating "Object does not support this property or...

hey everyone, I was wondering if anyone would have a suggestion on doing the following. In my database, I have a button on a form which prints a letter which one of the techs would sign and mail to a customer. Because we have multiple tech's, and the person who entered the work order info...

Hey guys, Got a stumper and can't figure it out. I have a search form that allows me to find a record, and then double click on it to open the form with that record. The actual code is: DoCmd.OpenForm "Workorders by Customer", , , " customers.customerID = " & Me.lstCustInfo, , acDialog The...

I am in the beginning stages of remaking a database app that I use. The one I use now works but stoes all data in one table. granted that isnt the best way but I knew just enough to be dangerous <G> I track repairs I do for customers. And right now, I redid my tables and broke it down to 3...

hey everyone, Was working on something and was curious as to what you all would suggest. I am setting up a simple table with the following: customer first, last, company name, and phone. I also have a second table to which I want to link together with the above table, which has equipment...

Was trying to see if I could do this and if it would be very dificult or not. I have a form which allows me to enter up to 6 parts for one customer record. on the form itself, they are partdesc1, partdesc2, pqartdesc3... partdesc6. Occasionally, some of the partdesc fields may have the...

I ran into this and was wondering if someone could shed some light. I have a parts list table, which has 4 basic columns: Make, Model, Description, and partnumber. On my form, I have a combo box which I select a Make (cboMake), and a second one that lists the models (cboModels) based on the...

Hello folks! I currently have a print button that will print a "invoice" (actually a report) when I click a button on my form for that particular record. Here is the code for that: On Error GoTo Err_btnWorkOrder_Click If Me.Dirty Then 'Save any edits. Me.Dirty = False End...

Hey everyone, First, is I do not want to disable the mouse scrolling. But because of that, I ran into something and was wondering if anyone could shed some light. I have a form, which has a tab control. The control has 2 pages on it, and they are only visible depending on a combo box...

Here is what I have thus far: 1) A form which allows me to enter a record which includes Make, Mode, and ID number. form is called "frmPhoneUpdate". 2) Data is stored in a table called "tblModels". Its PK = "LngModelID" 3) On the form, frmPhoneUpdate", I have it broken into to segments. The top...

I have this code which converts a 11 digit number into an 8 digit hex number. left3 = Left([txtESNdec], 3) right8 = Right([txtESNdec], 8) hexleft = Hex(left3) hexright = Hex(right8) hex_number = hexleft & Format(hexright, "000000")...

Hey there... I have a form which I use for a switch board. The form as a button which when selected, opens a new form that is called frmToDoListing. This form has a list box which displays all my open todo items, based on a query. From this form, I can then select one of the todo items or...

I'm trying to do something and am not sure if you can do it. So, if anyone has a suggestion, I'd appreciate the input. I made a simple form and table where I create a To-Do list. I created a query which lists "open" or to-do items not yet completed. I then created another form which displays...