Search results

Hello, I have a form with two listboxes on it. The first list box displays all the orders. When a user clicks on a certain order in the listbox, I need the 2nd listbox to display all the associated items on that order. My linked field is an ID field that I have in in the query of easch...

I have my database setup off of access tables with a Visual Basic front end. What I am having problems with is that I am getting an error that says: "error number -2147217887; error description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value. If available, No...

Hello, I want to be able to pass a recordset as a parameter within a function, and to be able to alter and perform operations on that passed recordset. Here is the code that I am using that is currently giving me an "error #13 type mismatch": Public SubCloseifNeeded(rsRecordset as...

I am trying to pass values entered from one form into the text box of another form. I have one form where I record payments from clients, and I would like the information displayed in a textbox of my main form, but I keep getting the error that "(my database) cannot find the field XXX referred...

Hello, I am working on a database for a rental agency and need to increment a 'Balance' text box(unbounded)field with the rental amount(say $300.00) on the 15th of each month. In pseudocode it would be something like: balance.setfocus if system date = XX/15/XXXX and date isbetween (lease...

Hello, I have a main form that I record payement records in a text box each month. For certain months there are notes worth recording with the payment. I have a seperate 'Notes' form that opens with a text box that I use to enter notes. What I need is to copy and insert the values from...

I wanted to make a text box to display late fees for my customers for non-payment. The late fee schedule is as follows. -Payments due on the 15th of each month. -$25.00 fee if not paid by that day. -$50.00 at the end of the month. -$100.00 by the 15th of the following month. I'd like to...

I have a field where I enter customers e-mail address. Later, I would like to use the mail address as a link from my main form to open up Outlook and automatically insert the name into the Address field. I have a text box whose control source is on the email field of my table, but it treats...

I have a form that I created off an query that pulls information from multiple tables. Specifically, I have a table that has first and last name field, when I run the 'add function', it adds the user to the table, but, when I search for the name from the text box on the main form, it says it...

I have a list box set so I can highlight multiple entries in the list box. Is there a way that I can send the highlighted entries to a report and display all the relevent data associated with each entry? (I want to pass the ID's from the list box to the report so I can display other information...

I have a second form that acts as my search form where I can double click on the name and return that value to my main form. My trouble is transferring this value to my main form, my main database cannot find the field in my database, any suggestions?

Hey, I have a main form(frmInfo) with a subform(frmHistory), and then I have links to other forms for each of the twelve months(frmJanuary-frmDecember). Basically, I store a running total of the values of text boxes in each of the twelve forms and then display the value in a text box that is...