Search results

I have an Access application that I want to run by itself after hours. I've gotten it to the point where the application opens on schedule, and then goes to the macro. The macro opens the necessary form, fills in the values the form needs, and gives focus to the Submit button. The only step I...

I have some text boxes where the user types in information, and I would like the user to be able to go down a line when hitting Enter. When Enter is hit, though, focus just skips to the next object on the form. Can someone tell me how to send a Ctrl + Enter (soft return) keystroke when the...

Ernie: Thank you for the advice. It works just fine (Sorry for the delay in thanking you, but I've never used subforms before, and it took me a while to figure it out.) Steve

I have a form which has a recordset as its datasource. The recordset varies in length (sometimes more records, sometimes less), so I need a way to have the number of text boxes on the form change dynamically to match the recordset length each time the form is opened. If anyone knows how to do...

Thank you for your help. Once I set the RowSourceType for the drop-down, it worked like a charm. Steve

I am using VBScript behind a form, and want to populate a drop-down box with one of the recordsets I create in the form. I am trying to add it like this (AppObj is the rs), cmbApplication is the dropdown): Do While Not AppObj.EOF cmbApplication.AddItem(AppObj("Name")) AppObj.MoveNext...

I am doing an application where I want to display several rows of related data (Invoice ID, amount due, etc.) and allow the user to change data (which excludes reports). Right now I have to explicitly name each label and text box (eg. lblInvoiceID1, lblInvoiceID2, etc.). Is there a way to use...

Chris: Thank you for your advice. I thought that I couldn't use a combo and a query at the same time, but talked to someone else who showed me how. Steve

I want a report based on my tables and a name selected from a combo box. I have two ways of doing this: 1) I have an SQL query in a form that takes the name from the list box and generates a recordset (the recordset is global, so both the form and report can use it). I want the report to use...

Chris: Thank you as well. I'll have to consider which method works best for the client I'm working for. Steve

Carol: Thank you so much! I was tearing my hair out trying to get something so irritating out of my program. It's now runs much smoother. Steve

I'm using SQL for DELETE, INSERT, and UPDATE in my database from a button in my form. The SQL works fine. The problem is that every time I delete, insert, or update a row, a message box pops up asking "You are about to <name of operation> <number of rows affected> rows. Are you sure you want...

I have a form I am using as a password screen. What I want is for the user to type in an ID in the txtID field, run SQL to compare txtID to the primary key field of one of my tables, and put any output in a recordset object. I am trying to start with this: Dim CustObj As Recordset Set...