Search results for query: *

I have a form in which I would like a list box (or similar object) to be poplulated based on a letter entered in a text box. The user enters a letter in "txtFirstLetter" textbox. That letter should trigger a query that is something like ... SELELCT CustCode FROM tblCustomer WHERE...

Greetings! I have embedded a subform in a form, and would like a couple of field's values to repeat when a new record gets added. The values are coming from the parent form (basically a couple of ID fields relating back to the parent). How would I go about doing that? thanks in advance

Greetings! I have an Access database in which I am going to allow users to import data into a table from an Excel spreadsheet. The first question I have is how do I allow the user to "explore" to the proper path (in a text box or drop box)on a form so that user can locate the file...

I would like to prompt users after they change/create a record on a form to verify that they really want the changes. Here is the code I have... Private Sub Form_AfterUpdate() Dim s As Byte s = MsgBox("Do you want to save your changes?", vbYesNo, "Save") If s =...

Greetings. I am working on a database that gives me information on railcar status. An identifier is a field called MarknUnitNo (it is a combination of the Mark and UnitNo fields). A railcar is given a mark and unit number as an identifier with the owner. The number can change many times...

I am using a table to temporarily store records that can be accessed in a form to show data that has been recently entered (into a permanent table). I want the records to clear when the form is closed (or when a clear command button is pushed). What do I need to do?

I have an unbound form that I enter a range of numbers (and other data) to populate a table. I use a command button to populate the data. When the button is pushed, how do I get the form to clear, so I can enter the next range of data? I used to write code for another command button to clear...

I usually use the following code on a "clear" button to remove data entered on a normal, bound form.. Private Sub cmdClear_Click() If Me.Dirty Then Me.Undo End Sub The problem is I have an unbound form I am trying to do the same thing with and I get the following error when pushing...

How would I go about setting criteria on a query if I want to seperate either text or numbers? I have a couple of fields that need to be stricktly numeric, but have text in them (and possible numbers as well). How do I set the criteria to show (or delete) only text and/or numbers? thanks in...

I am trying to delete records from Table A that don't match records in Table B. I run an unmatched records query from the query wizard to get the results. I then change it to a delete query. It basically shows all records (*) from Table A (delete:from) and the field from Table B as the...

I am building a form to enter data on railcars. If I have to enter data on 100 cars, it gets tedious. What I want to be able to do is enter the data once, and have it copy "x" number of times to the table. In addition, each entry needs to have a unique identifier which will be...

I have a field called "UnitNo" that I have combined with another field called "Mark" into one field called "MarknUnit". These are identifiers to rail cars that I am tracking. I need to relate these records to another table. The problem is that quite a bit of the...

I have a field called "UnitNo" that I have combined with another field called "Mark" into one field called "MarknUnit". These are identifiers to rail cars that I am tracking. I need to relate these records to another table. The problem is that quite a bit of the...

I am creating a database and in some instances I will need to move records from one table to another. It would be similar to a cut and paste of the record. What I want to do is have a button on a form and when necessary, push the button to have that particular record deleted in its original...

I am creating a database and need to be notified when a record is entered that is a duplicate (from a form). I can't make this partiular field the key field. Any advice on how to get notified of a duplicate record would be greatly appreciated. Thanks in advance.